1 GSC – Sort and Filter 2 SUM – Variations 3 COUNT – Variations 4 Tables and Calculated Columns 5 Pivot Tables – Set Up – Sheets 6 Pivot Tables – Set Up – Excel 7 Pivot Tables – Calculated Fields 8 Pivot Tables – Filters, Slicers, and Timeline – Excel 9 Pivot Tables – Filters, Slicers, and Timeline – Sheets 10 Power Tips for Pivot Tables – Excel 11 De-Dup & Text To Columns 12 Vlookup 13 Index and Match 14 XLookup – Excel 15 Sparklines 16 Conditional Formatting 17 String Functions 18 Error Trapping 19 Additional Resources
Access our library of thousands of marketing playbooks, each showing you how to do a specific marketing task in 10 steps or less, with real-time peer support. Join our community of marketing experts, ready to support you in getting that promotion or master new strategies, skills, and channels. Network with some of the world’s best marketers and companies and get noticed, hired, or endorsed.
You should have at least a basic and introductory familiarity with spreadsheets e.g. how to create formulas, import files, possibly create some simple graphs, etc. More importantly, you should have an understanding of your data and what type of information you want to draw out of it.
|Who is this course for?||
Your daily work includes working with data across multiple tools (e.g. Google Analytics, Google Search Console, SEMRush, Moz, AdWords. Keyword Planner, etc.) You are sometimes stymied by the data analysis capabilities of those tools, and would like to dive deeper or dive more broadly Your success and future growth depends on being able to discover the links between data sets
$173.09 per seat 1 + 1 seat free Billed per month All prices in USD + tax, where applicable
Annual $ 897.81 per seat 1 + 1 seat free Billed per year All prices in USD + tax, where applicable Quarterly $ 316.84 per seat 1 + 1 seat free Billed per quarter All prices in USD + tax, where applicable
All plans come with a 7-day refund period. Certain refund requests for Subscriptions may be considered by ConversionXL LLC on a case-by-case basis and granted in sole discretion of ConversionXL LLC. Serial refunders – people who sign up with different email accounts and request refunds for each – will be banned for life.