Extreme Excel Excellence for Search Marketers

80 %
20 %
Information about Extreme Excel Excellence for Search Marketers
Marketing

Published on March 13, 2014

Author: SearchMarketingExpo

Source: slideshare.net

Description

Smx West 2014 Session #Smx #34C - Extreme Excel Excellencepresentation Extreme Excel Excellence For Search Marketers By Josh Dreller @Kenshoo Of Kenshoo

2 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Extreme Excel Excellence for Search Marketers

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

4 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Need a Random Number? • Try random between

5 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Can’t Remember Pivot Table Calculations? • Use List Formulas

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

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

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

9 © 2014 Kenshoo, Inc. Confidential and Proprietary Information What-If Analysis? Goal Seek • Use Goal Seek to calculate complex questions

10 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Named Ranges • Functionality from early versions of Excel • But many still don’t use them

11 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Name Manager • Remind yourself of named ranges

12 © 2014 Kenshoo, Inc. Confidential and Proprietary Information See Which Cells Affect Others • Trace back to precedents or dependents

13 © 2014 Kenshoo, Inc. Confidential and Proprietary Information What Was That Formula Again?

14 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Custom Views

15 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Custom Lists • Add your own lists to utilize the drag option

16 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Use Sliders to Try Out New Values • Found in the Developer ribbon • You may need to unhide from Options menu

17 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Customize Quick Access Toolbar

18 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: General

19 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: Formulas

20 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: Proofing

21 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: Save

22 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: Advanced

23 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Options: Customize the Ribbon

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

#smx presentations

Add a comment

Related presentations

Related pages

use extreme Excel excellence for search marketers

Extreme Excel Excellence for Search Marketers ... Persistent Format Painter: -double click the Format Painter to paint away -click it again to turn it off
Read more

Use extreme Excel excellence for search marketers

Use extreme Excel excellence for search marketers Made with Peoplbrain - www.peoplbrain.com Use extreme Excel excellence for search marketers Created by : Josh
Read more

Extreme Excel Excellence for Search Marketers - documents

Presentation from the SMX West 2014 panel "Extreme Excel Excellence" full of power-user tactics ... Share Extreme Excel Excellence for Search Marketers ...
Read more

Excel Excellence | LinkedIn

View 59 Excel Excellence posts, ... Excel Excellence (Microsoft Excel training that "sticks"): ... Extreme Excel Excellence for Search Marketers ...
Read more

Live from SMX Advanced: Extreme Excel Excellence ...

Live from SMX Advanced: Extreme Excel Excellence. By Janet Driscoll Miller | Jun 13, 2013 More Articles by Janet. Excel is a key tool for search marketers ...
Read more

Utiliser Excel en search-marketing - data.peoplbrain.com

Utiliser Excel en search-marketing Créé avec Peoplbrain - fr.peoplbrain.com Utiliser Excel en search-marketing Créé par : Josh Ce guide est ...
Read more

use extreme Excel excellence for search marketers

Comment utiliser Excel en search-marketing ... Persistent Format Painter: -double click the Format Painter to paint away -click it again to turn it off
Read more