Excel Boot Camp

Many Excel users hear terms like XLOOKUP, PivotTables, and conditional formatting and envision features reserved only for power users. Not so! These powerful functions are simple, once you know the steps involved. Each concise course in this learning path walks you step-by-step through the basics.

Manage and analyze data with Excel features and functions.
Get started with features like XLOOKUP and macros.
Save time and do more in Excel.

Syllabus

Courses under this program:
Course 1: Excel: VLOOKUP and XLOOKUP for Beginners
-Get a beginner-friendly introduction to VLOOKUP and XLOOKUP, two of Excel’s most powerful functions.

Course 2: Excel: Filtering Data for Beginners
-Learn how to unleash the full potential of Excel filters. Explore basic and advanced filters, slicers, Power Query, crucial shortcut keys, and more.

Course 3: Excel: PivotTables for Beginners
-Get a short and simple beginner's guide to Excel PivotTables. Follow along and learn how to create a basic PivotTable to analyze and present spreadsheet data.

Course 4: Excel: Conditional Formatting for Beginners
-Learn how to use conditional formatting to spot trends and emphasize key results in Microsoft Excel.

Course 5: Excel: Macros and VBA for Beginners
-Learn how to automate Excel tasks by creating macros.

Course 6: Excel: Power Query for Beginners
-Get up to speed quickly with Power Query in Excel to import and clean data.

Course 7: Excel: Power Pivot for Beginners
-Demystify Power Pivot in Excel and harness its data analysis potential with this short course taught by Excel expert Josh Rischin.