extremely useful & powerful excel tips by john gagnon
DESCRIPTION
From SMX East 2013 - Extreme Excel Excellence - Extremely Useful & Powerful Excel Tips by John GagnonTRANSCRIPT
![Page 1: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/1.jpg)
EXTREMELY
USEFUL &
POWERFUL
EXCEL
#
John Gagnon
Bing
@jmgagnon
#SMX #22A
October 2, 2013
#
![Page 2: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/2.jpg)
![Page 3: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/3.jpg)
Excel BrainSearch Brain
![Page 4: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/4.jpg)
![Page 5: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/5.jpg)
Extremely Useful
Extremely Powerful
![Page 6: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/6.jpg)
5
![Page 7: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/7.jpg)
SHIFT 4
SHIFT 5
SHIFT =
![Page 8: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/8.jpg)
![Page 9: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/9.jpg)
Productivity
![Page 10: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/10.jpg)
Productivity
![Page 11: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/11.jpg)
![Page 12: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/12.jpg)
Productivity
![Page 13: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/13.jpg)
![Page 14: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/14.jpg)
Productivity
![Page 15: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/15.jpg)
![Page 16: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/16.jpg)
![Page 17: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/17.jpg)
=TEXT( )this value, formatted this way
“m”“mmmm”“ddd”“dddd”
“mmmm-dd”
10/1/2012 10OctoberMonMonday
October-01
TEXT( 10/1/2012 ,”dddd”) Monday
TEXT( 10/1/2012 ,”mmmm”) October
Productivity
![Page 18: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/18.jpg)
Productivity
![Page 19: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/19.jpg)
![Page 20: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/20.jpg)
Productivity
![Page 21: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/21.jpg)
2
![Page 22: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/22.jpg)
Maximum # of Rows in Excel
Power
![Page 23: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/23.jpg)
versus
![Page 24: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/24.jpg)
Maximum # of Rows in PowerPivot
![Page 25: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/25.jpg)
![Page 26: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/26.jpg)
@jmgagnon | @bingads
1Power Pivot
![Page 27: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/27.jpg)
Power
![Page 28: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/28.jpg)
Power
![Page 29: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/29.jpg)
Power
![Page 30: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/30.jpg)
Power
![Page 31: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/31.jpg)
Power
![Page 32: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/32.jpg)
PredictivePublic Data + Consumer Behavior
![Page 33: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/33.jpg)
September 9th 20131,000,000+ Students
![Page 34: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/34.jpg)
$72.5B2nd Most, Only behind Winter Holidays
NRF July 2013: 2013 BTS Survey
![Page 35: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/35.jpg)
When Parents Will Shop for Back-to-School
![Page 36: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/36.jpg)
When does the 1st Day of School really start?
![Page 37: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/37.jpg)
What does this look like in Excel?
2.4M Illinois 856k Wisconsin
7.2M California 3.8M New York
![Page 38: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/38.jpg)
What does this look like in Excel?
Number of Students Going Back to School by 1st Day
![Page 39: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/39.jpg)
Back-to-School Visualization
Texas
Great Lakes
New York
Arkansas
![Page 40: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/40.jpg)
![Page 41: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/41.jpg)
See Changes Overtime
![Page 42: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/42.jpg)
Save Time with Keyboard Shortcuts & Mouse Tricks
Better Insights from more data using tools you know
Impress your Boss with Power Map & Power Pivot
![Page 43: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/43.jpg)
100 Excel tips
@r1c1 Chandoo.org
Twitter website
@PowerPivotPro
@TomUrtis
@exceltricks
![Page 44: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/44.jpg)
@jmgagnon
Thank you! Enjoy.
![Page 45: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/45.jpg)
Power
![Page 46: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/46.jpg)
*
![Page 47: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/47.jpg)
![Page 48: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/48.jpg)
*
*
* *
![Page 49: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/49.jpg)
Productivity
![Page 50: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/50.jpg)
Productivity
![Page 51: Extremely Useful & Powerful Excel Tips by John Gagnon](https://reader033.vdocuments.us/reader033/viewer/2022052523/556261ded8b42ae87d8b4cdf/html5/thumbnails/51.jpg)
http://www.slideshare.net/SearchMarketingExpo
#
see more presentations at:
#