Extreme Excel Excellence for Search Marketers - SMX West 2014
•
3 likes•1,198 views
Presentation from the SMX West 2014 panel "Extreme Excel Excellence" full of power-user tactics and tips to get the most from Excel from Kenshoo's Director of Marketing Research & Content, Josh Dreller
Extreme Excel Excellence for Search Marketers - SMX West 2014
- 1. 2 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Extreme Excel Excellence for Search Marketers
- 2. 3 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Persistent Format Painter • Double click the Format Painter to paint away • Click it again to turn it off
- 3. 4 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Need a Random Number? • Try random between
- 4. 5 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Can’t Remember Pivot Table Calculations? • Use List Formulas
- 5. 6 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Pivot Your Pivot Tables Faster • Use Slicers • Very helpful for when others view your tables • Shift and CTRL work to select multiple slices
- 6. 7 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Simple, Powerful Charts • Embed sparklines in a cell to easily see trends • 3 types • Line • Column • Win/Loss • Many different design options
- 7. 8 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Keep Your Eyes on the Prize • Watch Windows can let you keep track of any cells across your workbooks • See how they change • Make sure they don’t change
- 8. 9 © 2014 Kenshoo, Inc. Confidential and Proprietary Information What-If Analysis? Goal Seek • Use Goal Seek to calculate complex questions
- 9. 10 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Named Ranges • Functionality from early versions of Excel • But many still don’t use them
- 10. 11 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Name Manager • Remind yourself of named ranges
- 11. 12 © 2014 Kenshoo, Inc. Confidential and Proprietary Information See Which Cells Affect Others • Trace back to precedents or dependents
- 12. 13 © 2014 Kenshoo, Inc. Confidential and Proprietary Information What Was That Formula Again?
- 13. 14 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Custom Views
- 14. 15 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Custom Lists • Add your own lists to utilize the drag option
- 15. 16 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Use ºÝºÝߣrs to Try Out New Values • Found in the Developer ribbon • You may need to unhide from Options menu
- 16. 17 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Customize Quick Access Toolbar
- 17. 18 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: General
- 18. 19 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: Formulas
- 19. 20 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: Proofing
- 20. 21 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: Save
- 21. 22 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: Advanced
- 22. 23 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: Customize the Ribbon
- 23. T H A N K Y O U J o s h . D r e l l e r @ k e n s h o o . c o m