Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel for Marketers 1
Module 1: Course Introduction
Lesson 1: Course Overview (7:58)
Lesson 2: Download Course Materials
Module 2: Excel Basics
Lesson 1: Objective (1:40)
Lesson 2: References, SUMIF and SUMIFs (10:32)
Lesson 3: Copy/Paste, Formatting and Merges (2:43)
Lesson 4: Navigation, Selection, Panes & Naming Sheets (7:46)
Lesson 5: Text Wrapping, Ranges (3:07)
Lesson 6: Handling Duplicates, COUNTIFs, Unique Value Lists (13:32)
Lesson 7: Handling Dates, Filters, Helper Columns (11:48)
Lesson 8: Pivot Table Basics (10:18)
Lesson 9: Quiz
Module 3: Using Excel
Lesson 1: Dynamic Named Ranges (8:38)
Lesson 2: VLookUp, CLV Calculations and Checksums (15:47)
Lesson 3: Preparing Data for Import (9:33)
Lesson 4: Data Validation (5:53)
Lesson 5: Parsing Text and String Data (4:20)
Lesson 6: Google Analytics Data, Extracting Text Data (9:14)
Lesson 7: Parsing Survey Data (4:18)
Lesson 8: Quiz
Module 4: Excel Charts
Lesson 1: Introducing Charts in Excel (7:29)
Lesson 2: Charting Samples and Settings (3:51)
Lesson 3: Creating Customer Data (11:46)
Lesson 4: Creating Email Report Charts (4:23)
Lesson 5: Creating Lead Scoring Charts (4:56)
Lesson 6: Connecting Charts to PowerPoint (4:39)
Lesson 7: Quiz
Module 5: Shortcuts, Tips & Tricks
Lesson 1: IFs, Nested IFs, SUMPRODUCT, HYPERLINK, CONCATENATION (7:23)
Lesson 2: Checkboxes and Radio Buttons (7:28)
Lesson 3: INDIRECT, Search and Replace (8:36)
Lesson 4: SUBTOTAL, Conditional Formatting (7:40)
Lesson 5: Quiz
Module 6: Robustness in Excel
Lesson 1: Robustness, Locking Cells & Sheet Protection (6:42)
Lesson 2: Alternative to vlookup - INDEX, MATCH, EXACT (7:41)
Lesson 3: Quiz
Module 7: Conclusion
Closing Thoughts (3:42)
How to Use the Workbook
Lesson 1: Course Overview
Complete and Continue