Give Your Data an Extreme Makeover in Under 5 Minutes (SMX Advanced)
20 likes8,919 views
In this presentation I demonstrate some quick and easy steps you can do to sexy up your data and also delve into why this is important.
![LEARN HOW
My Annielytics post on creating charts [VIDE0]
My Search Engine Land post on making your charts sexy
My Moz post on charting and creating chart templates
Bill Jelen’s Charts and Graphs book (< $25)
My Search Engine Land post on custom number formatting](https://image.slidesharecdn.com/extreme-20excel-20excellence-20smx-20advanced-130613133809-phpapp01/85/Give-Your-Data-an-Extreme-Makeover-in-Under-5-Minutes-SMX-Advanced-78-320.jpg)
![LEARN HOW
My tutorial on how to use pivot tables [VIDEO]
My Search Engine Land post on how to use pivot tables
My Search Engine Land post on combination charts
My Annielytics tutorial on how to use pivot charts [VIDEO]
My Marketing Land tutorial on scrolling charts [VIDEO]
My Marketing Land tutorial on charts with drop-downs [VIDEO]](https://image.slidesharecdn.com/extreme-20excel-20excellence-20smx-20advanced-130613133809-phpapp01/85/Give-Your-Data-an-Extreme-Makeover-in-Under-5-Minutes-SMX-Advanced-103-320.jpg)
More Related Content
What's hot (11)
More from Annie Cushing (7)
Recently uploaded (20)
Give Your Data an Extreme Makeover in Under 5 Minutes (SMX Advanced)
- 2. MY DAY JOB 1. CONSULTING FOR SEO, ANALYTICS 2. SITE AUDITS 3. ANALYTICS AUDITS 4. DASHBOARDS 5. TRAINING
- 3. I TALK ABOUT MAKING DATA SEXY A LOT
- 4. BUT WHY?
- 5. Great book! H/t, Rand Fishkin
- 8. a preference for the CURRENT STATE OF AFFAIRS
- 11. Gain =
- 12. Gain = Loss =
- 13. Gain = Loss = x2
- 14. EXPERIMENT
- 19. NOW LET’S TALK BRAIN
- 21. TWO SYSTEMS
- 25. 1. FAST
- 27. 1. FAST 2. UNCONSCIOUS 3. MULTI-TASKING
- 28. 1. FAST 2. UNCONSCIOUS 3. MULTI-TASKING 4. ASSOCIATIVE
- 29. 1. FAST 2. UNCONSCIOUS 3. MULTI-TASKING 4. ASSOCIATIVE 5. REQUIRES LITTLE ENERGY
- 30. GO “D’AWWW”
- 32. REACT TO IMMINENT DANGER
- 34. 1. SLOW
- 36. 1. SLOW 2. CONSCIOUS 3. SERIAL
- 37. 1. SLOW 2. CONSCIOUS 3. SERIAL 4. ANALYTICAL
- 38. 1. SLOW 2. CONSCIOUS 3. SERIAL 4. ANALYTICAL 5. CONSUMES A LOT OF ENERGY
- 39. SOLVE PUZZLES
- 42. when your client or boss sees THIS …
- 44. or perhaps like THIS …
- 46. or (brace yourself) THIS …
- 48. Continued 3 more screens!
- 49. it forces people to use their REFLECTIVE SYSTEM
- 50. WHICH SLOWS THEM DOWN
- 51. AND MAKES IT EASY TO MAINTAIN THE STATUS QUO
- 52. SO HOW DO WE INSPIRE ACTION?
- 53. BY MAKING YOUR DATA SEXY
- 54. CRAWL
- 56. for when you just have to TABULAR DATA …
- 57. HIGHLIGHT TRENDS
- 58. COMPARE VALUES
- 59. COMPARE VALUES PICK ONE, ANY ONE (unless you want to look like the Honey Boo Boo of analysts)
- 61. LEARN HOW My Search Engine Land post on conditional formatting Mike Girvin’s hour-long video tutorial Awesome ebook by Sharon Parq ($20)
- 62. WALK
- 63. BASIC CHARTING
- 65. 0 50 100 150 200 05/01 05/03 05/05 05/07 05/09 05/11 05/13 05/15 05/17 05/19 05/21 05/23 05/25 05/27 05/29 05/31 AdWords Clicks for May
- 66. 0 50 100 150 200 05/01 05/03 05/05 05/07 05/09 05/11 05/13 05/15 05/17 05/19 05/21 05/23 05/25 05/27 05/29 05/31 AdWords Clicks for May
- 67. 0 50 100 150 200 05/01 05/03 05/05 05/07 05/09 05/11 05/13 05/15 05/17 05/19 05/21 05/23 05/25 05/27 05/29 05/31 AdWords Clicks for May
- 70. 0 50 100 150 200 05/01 05/03 05/05 05/07 05/09 05/11 05/13 05/15 05/17 05/19 05/21 05/23 05/25 05/27 05/29 05/31 AdWords Clicks for May
- 71. OR GO TOTALLY MINIMALIST
- 72. TO ACHIEVE MINIMALIST PERFECTION ? Delete vertical axis ? Delete gridlines ? Delete tick marks ? Add data labels to inside end ? Change font to white ? Get rid of decimals ? Reduce gap width of columns (to make fatter)
- 73. 0 50 100 150 200 05/01 05/03 05/05 05/07 05/09 05/11 05/13 05/15 05/17 05/19 05/21 05/23 05/25 05/27 05/29 05/31 AdWords Clicks for May
- 78. LEARN HOW My Annielytics post on creating charts [VIDE0] My Search Engine Land post on making your charts sexy My Moz post on charting and creating chart templates Bill Jelen’s Charts and Graphs book (< $25) My Search Engine Land post on custom number formatting
- 79. RUN
- 84. CALL TO ACTION
- 85. $6801 $377 $106 CHECK OUT THESE COSTS
- 86. 1 4 4 COMPARED TO THESE RESULTS
- 87. 8 xs more jobs for 1/10TH the $
- 88. WOULD TAKE A TO SEE THAT!
- 90. PROMOTES INERTIA
- 91. Not bad! Not bad at all. Carry on …
- 93. Move more money over to Bing! Pronto!
- 95. PIVOT CHART
- 97. there is one major MICROSOFT OVERSIGHT
- 98. PIVOT CHARTS ARE PC SWIM ONLY!
- 99. AND I SEEM TO BE THE ONLY MAC USER WHO CARES
- 100. CORRELATION ANALYSIS
- 101. INTERACTIVE CHARTS
- 102. AMAZING DASHBOARD COURSE Link to course
- 103. LEARN HOW My tutorial on how to use pivot tables [VIDEO] My Search Engine Land post on how to use pivot tables My Search Engine Land post on combination charts My Annielytics tutorial on how to use pivot charts [VIDEO] My Marketing Land tutorial on scrolling charts [VIDEO] My Marketing Land tutorial on charts with drop-downs [VIDEO]
- 105. E: ANNIE@ANNIELYTICS.COM T: @ANNIECUSHING L: LINKEDIN.COM/IN/ANNIECUSHING