Extreme Excel Excellence for Search Marketers

67 %
33 %
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

Extreme Excel Excellence for Search Marketers ...

2 © 2014 Kenshoo, Inc. Confidential and Proprietary Information Extreme Excel Excellence for Search Marketers
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

Excel Excellence for Search Marketers - slidesearchengine.com

Related pages Use extreme Excel excellence for search marketers. Use extreme Excel excellence for search marketers Made with Peoplbrain - www.peoplbrain ...
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