fbpx

Excel for Marketers Course

Organize and present marketing data with Spreadsheets

3h 40min | 20 lessons

In this course, you will learn how to:

  • Use advanced Excel skills specifically tailored for marketers.
  • Quickly analyze marketing data to inform smarter decisions.
  • Create clear, insightful dashboards to track and communicate performance.
  • Automate repetitive tasks, saving hours of manual work each week.
  • Confidently interpret data and clearly present actionable insights.

Sign up to All-Access Buy just this course

English subtitles Certificate included
CXL-Rating-Transparent
Trusted by marketers at

Master Excel and Google Sheets to supercharge your marketing data and identify growth opportunities

Course Length:
3h 40min. 20 lessons.

In this course, you’ll gain Excel expertise focused solely on tasks marketers actually do, tracking campaigns, measuring ROI, and communicating performance effectively. No fluff or irrelevant theory, just actionable techniques to make you indispensable to your team and company. Learn to blend data from various sources, apply advanced formulas, troubleshoot common issues, and master functions like pivot tables and vlookups, to create accurate data reports.

After completing this online course on Excel and Google Sheets for marketers you will be able to assist your team and company with:

  • Analyzing complex marketing data quickly and clearly.
  • Automating routine tasks to significantly speed up reporting.
  • Creating dashboards that visually communicate marketing performance.
  • Identifying trends and insights from campaign data efficiently.
  • Ensuring marketing decisions are always backed by reliable, clearly presented data.

This course is for you if you are responsible for:

  • Analyzing and reporting marketing data regularly.
  • Optimizing campaign performance through data-driven insights.
  • Streamlining reporting processes for your marketing team.
  • Communicating clear, actionable data insights to leadership.
  • Saving time by automating repetitive marketing data tasks.

Look no further than CXL, this is the best and most recommended course you will find on Excel and Google Sheets for Marketers.

Subscribe now and get access

See Pricing

Course Curriculum

Excel and sheets for marketers

GSC – Sort and Filter

Topics covered: Download data from Google search Console (GSC)Initial Analysis – Sort and Filter Resources Resources Sheets: SAS GSC Data Sample data Excel: SAS GSC data Sample data Sheets Lesson 1 resource Excel SAS GSC data Lesson slide deck

SUM – Variations

Topics covered: SUM CommandsVariables in formulasAbsolute versus Relative cell references Resources Resources Excel: SAS GSC data Sample data Sheets: SAS GSC Data Sample data Sheets resources lesson 2 Excel sheet – lesson 2 Lesson slide deck

COUNT – Variations

Topics covered: All the different COUNT commands. Resources Resources Excel: SAS GSC data Sample data Sheets: SAS GSC Data Sample data SAS GSC Data Sample data Sheets resource lesson 3 Excel sheet – lesson 3 Lesson slide deck

Tables and Calculated Columns

Topics covered: Formatting HeadersExcel Tables and Calculated Columns Resources Resources Excel: SAS GSC data Sample data SAS GSC Data Sample data Excel sheet – lesson 4 Lesson slide deck

Pivot Tables – Set Up – Sheets

Topics covered: Set up a basic pivot table in Google Sheets Resources Resources Sheets: SAS GSC Data Sample data Sheets resource – lesson 5 Excel sheet – lesson 5 Lesson slide deck

Pivot Tables – Set Up – Excel

Topics covered: Set up a basic pivot table in Excel Resources Resources Excel: SAS GSC data Sample data Lesson slide deck

Pivot Tables – Calculated Fields

Topics covered: How to create a calculated field in a pivot tableWhy create it? Resources Resources Excel: SAS GSC data Sample data Sheets: SAS GSC Data Sample data Sheets resource – lesson 6 Excel sheet – lesson 6 Lesson slide deck

Pivot Tables – Filters, Slicers, and Timeline – Excel

Topics covered: Segmenting your pivot table:FiltersSlicersTimeline Resources Resources Excel: SAS GSC data Sample data Excel sheet – lesson 7 Lesson slide deck

Pivot Tables – Filters, Slicers, and Timeline – Sheets

Topics covered: Segmenting your pivot tableFiltersSlicers Resources Resources Sheets: SAS GSC Data Sample data Sheets resource – Lesson 7 Lesson slide deck

Power Tips for Pivot Tables – Excel

Topics covered: Power Tips for Pivot TablesTables and Named RangesRefresh the Data SourceDetailed viewPage per Filter Item“Show Values As” in Field SettingsTurn off “Autofit Columns”Pivot Charts Resources Resources Excel: SAS GSC data Sample data Excel …

De-Dup & Text To Columns

Topics covered: Google Analytics DataRemove DuplicatesText to Column Resources Resources Excel: Adjusted Data GA Merch Store Sample data Sheets: Adjusted Data GA Merch Store Sample data Sheets resource – lesson 9 Excel sheet – lesson 9 Lesson slide dec …

Vlookup

Topics covered: Vlookup Resources Resources Excel: Adjusted Data GA Merch Store Sample data Sheets: Adjusted Data GA Merch Store Sample data Sheets resource – lesson 10 Lesson slide deck

Index and Match

Topics covered: Index and Match Resources Resources Excel: Adjusted Data GA Merch Store Sample data Sheets: Adjusted Data GA Merch Store Sample data Sheets resource – lesson 11 Lesson slide deck

XLookup – Excel

Topics covered: XLOOKUPDo you have it?Shortcomings of VLOOKUP Resources Resources Excel: Adjusted Data GA Merch Store Sample data Excel sheet – lesson 12 Lesson slide deck

Sparklines

Topics covered: Sparklines Resources Resources Excel: Adjusted Data GA Merch Store Sample data Sheets: Adjusted Data GA Merch Store Sample data Sheets resource – lesson 13 Excel sheet – lesson 13 Lesson slide deck

Conditional Formatting

Topics covered: Conditional formatting Resources Resources Excel: Adjusted Data GA Merch Store Sample data Sheets: Adjusted Data GA Merch Store Sample data Sheets resource – lesson 14 Excel sheet – lesson 14 Lesson slide deck

String Functions

Topics covered: More FunctionsLenSubstituteFindSearchMidLeftRight Resources Resources Excel String (text) Functions Template Excel sheet – lesson 15 Lesson slide deck

Error Trapping

Topics covered: Data Validation- Numbers- ListsIF Function (cross-footing)Locking a Spreadsheet Resources Google Sheets resource – lesson 16E4M-Lesson-16-Error-TrappingExcel Error TrappingGoogle Sheets Error Trapping Lesson slide deck

Additional Resources

Topics covered: Some of Fred’s favorite resources Resources Resources Google Sheets Developer Blog Blog post/article Google Sheets Blog post/article Excel Help & Learning Blog post/article Analytics Edge Tool Supermetrics Tool G Suite Marketplace …

Fred Pike

Managing Director / COO @ Northwoods Software

Fred Pike is a Managing Director at Northwoods Software and leads their GA/GTM Practice Area.

A sought-after educator, he has spoken multiple times at such events as MeasureSummit, SuperWeek, GA4Ward, MN Search, etc. “GA4 Intermediate” was his fifth CXL course, making “Strategic Analytics Framework for GA4” his sixth.

At any time, you can find Fred digging into the intricacies of GA4, walking his beloved Pekingese Xuxa, or playing mandolin with the Milwaukee Mandolin Orchestra.

This online course
comes with a
Certificate

Completing this course earns you an official CXL Excel and Google Sheets for Marketers Course Certificate to prove your achievement. CXL is recognized as an industry-leading qualification by employers worldwide, and it is an official qualification on Linkedin that can be added to your profile.

Here’s why marketers choose CXL

Old playbooks are burning your budget.
Discover the new ones filling the pipeline.

Subscribe to our weekly, expert-led newsletter.
We find and report on case studies, success stories, and playbooks that are working out there right now.

  • Hidden
  • This field is for validation purposes and should be left unchanged.
Subscribe

Join 150,000+ marketers | Subscribe to our educational newsletter

Frequently asked questions

Plans

What is the difference between the monthly, quarterly and annual plans?

We offer three types of billing lengths to choose from: Monthly, Quarterly, or Annual. The longer the billing length, the cheaper the monthly cost becomes.

Typically annual plans are 40% cheaper per year than paying month-to-month.
What is the difference between the individual and teams plans?

Personal or Individual plans are meant for one person where teams have 2 or more people.

A team account has a few extras:
– Invite and manage people learning on your team.
– Create roadmaps for each individual.
– Access team learning engagement reports.
– Assign members to your team as managers to assign content and view reports.
What is included in the all-access plan?

You’ll get:
– Access to 90+ online courses.
– Earn certificates and add them to LinkedIn.
– Thousands of playbooks and resources.
– All minidegrees
– Roadmapping and progress tracking
– Premium Support
Can I switch plans later if I want to?

Yes. You can switch between different billing lengths at any time (Ex: Switch from a Monthly Plan to Annual).

If you’d like to switch from a individual plan to a team plan (or vice versa), please reach out to customer success via live chat.

Billing

What are the payment options available?

Most major credit cards and Paypal are accepted. If you need an invoice to pay by wire, please message our customer success team via chat for options.
What is parity pricing?

All of our products are priced in USD currency. In order to make our products more affordable, we have established a system where you can pay in your local currency using a special metric that adjusts the price you pay according to the purchasing power of your country.
Is there a discount available?

One of CXL’s company policies is that we don’t discount. Our focus is on the product – providing the best, highest quality content with our courses.

The listed price on the site shows the best price – you can buy with confidence.

We offer pricing based on your local currency, you’ll see this reflected on the pricing and checkout pages.