@yang_ers | @bingads

10 Must Know Excel Tips to Power Charge your PPC CampaignsAndrew Yang, Bing Ads Evangelist

@yang_ers | @bingads

Save you time.

More Insights.

Impress co-workers.

@yang_ers | @bingads

2 Areas of Excel AwesomenessProductivityGeneral Excel Wizardry using Keyboard shortcuts, tips, and mouse tricks save you time & impress co-workers.

PowerMore insight. Handle big data in Excel and uncover new insights from beautiful visualizations.

@yang_ers | @bingads

ProductivitySave time. Impress co-workers.

Tips for Digital Marketers

10

@yang_ers | @bingads

= SHIFT + 4$ = SHIFT + 5%= SHIFT + !0.

0

@yang_ers | @bingads

Actually Remember Shortcuts

@yang_ers | @bingads

CTRL + SHIFT… What? Logic Number Formatting

Productivity

Goal: Format as Currency

CTRL + $1

So: CTRL + SHIFT + 42

1

@yang_ers | @bingads

Logic Number Formatting Productivit

y

1

@yang_ers | @bingads

SUM( )

@yang_ers | @bingads

Simple Shortcut for SUM( )

Press: ALT + =

Productivity

2

@yang_ers | @bingads

Format Painter

@yang_ers | @bingads

Productivity

Quick & Easy FormattingDouble-Click Format Painter

3

@yang_ers | @bingads

1. Ctrl + C

2. Ctrl + V

3. Ctrl

4. s

Combo Copy and PasteProductivity

4

@yang_ers | @bingads

What is that?

@yang_ers | @bingads

Repeat a Formula to Multiple Cells Productivit

y

5

@yang_ers | @bingads

Grouping + Pivots

@yang_ers | @bingads

Easy Grouping in Pivot Tables Productivit

y

6

@yang_ers | @bingads

Cont’dProductivity

6

@yang_ers | @bingads

Power Tables Productivity

7

@yang_ers | @bingads

Power visualization and power functions

3

PowerMore insight. Handle data in Excel and uncover new insights from beautiful visualizations.

@yang_ers | @bingads

Charts: Use 2nd Axis & Combos

12

Data Visualization Clicks & % Lift by Position

Secondary Axis

Bar + Line Chart

1

Power

@yang_ers | @bingads

VLOOKUP: Matching a List of Items

2

Power

@yang_ers | @bingads

VLOOKUP: Cont’d2

Power

@yang_ers | @bingads

F2: Edit the Cell3

Power

@yang_ers | @bingads

Save Time with Keyboard Shortcuts & Mouse Tricks1Better Insights from Strategy > just keywords2Impress your Boss with faster turnaround time3

Takeaways

@yang_ers

Have fun!

@yang_ers | @bingads

Pivot Table BreakdownPower

@yang_ers | @bingads

Great Resources for Excel Tips

If you've made it this far, here is a reward: 100 Excel tips to dive into from one of my favorite Excel resources. And for your reference, here are a few blogs and Twitter feeds from Excel experts to keep track of:

Chandoo on Twitter @r1c1 or at his great website Chandoo.org

Bill Jelen, "Mr. Excel," on Twitter or his website

Rob Collie on Twitter @PowerPivotPro

Tom Urtis on Twitter @TomUrtis

Heiko Heimrath on Twitter @exceltricks

@yang_ers | @bingads

1,048,576Maximum # of Rows in

Excel

@yang_ers | @bingads

CTRL + Arrows

@yang_ers | @bingads

Jump to the Start or End of a Column Keyboard Shortcut

Productivity

CTRL + ArrowsCombine with SHIFT to select multiple cells

A

@yang_ers | @bingads

@yang_ers | @bingads

Double-Click: Adjust Column Width Productivit

y

B

@yang_ers | @bingads

Wildcards*

@yang_ers | @bingads

Searches which “free”

@yang_ers | @bingads

free**free

*free*

startsendscontains

@yang_ers | @bingads

The Power of Wildcards and COUNTIF( ) Productivit

y

C

@yang_ers | @bingads

The Power of Wildcards and COUNTIF( ) Productivit

y

C