excel in excel for digital marketers
DESCRIPTION
Why is a Bing Ads Evangelist talking about Excel? Bing Ads wants to help you be a smart digital marketer. And digital marketers who master PivotTables, big data visualization and other Excel beauties gain insights that help them create better messaging, better targeting and better ROI. We’re all about better ROI. Leave with 7 productivity tips which you can use almost every time you open Excel, and see the power of the latest add-ins of Excel to handle big data. Big data is now is your grasp. Save time. Uncover more insights. Impress your boss. Let's Excel.TRANSCRIPT
John Gagnon, Bing Ads Evangelist
Maximum # of Cells in Excel
Excel BrainSearch Brain
10
Productivity
Productivity
Productivity
Productivity
SHIFT 4
SHIFT 5
SHIFT =
Productivity
Productivity
Productivity
Productivity
=TEXT( )this value, formatted this way
“m”“mmmm”“ddd”“dddd”
“mmmm-dd”
10/1/2012 10OctoberMonMonday
October-01
TEXT( 10/1/2012 ,”dddd”) Monday
TEXT( 10/1/2012 ,”mmmm”) October
Productivity
Productivity
Productivity
Productivity
Productivity
2
Pivot Tables on Steroids
Power
Maximum # of Cells in Excel?
Power
Bing Maps + Excel Charting on Steroids
Power
Save Time with Keyboard Shortcuts & Mouse Tricks
Better Insights from Strategy > just keywords
Impress your Boss with PowerMap & PowerPivot
@jmgagnon
Thank you!