Excel Course: Manage Complex Data with Advanced Skills

Skill	Pre-assess	Lesson	Post-assess	Learning mode

Excel Advanced Course Outline

Verified Learning

Skill	Pre-assess	Lesson	Post-assess
PivotTables
Create PivotTables Turn raw data into insights with Excel Pivot Table	Not Started	Not Started	Not Started
Add Multiple PivotTable Fields Excel Pivot Table from multiple columns	Not Started	Not Started	Not Started
Change a PivotTable's Calculation Adjust how your value fields calculate data	Not Started	Not Started	Not Started
Add Calculated Fields Excel Pivot Table Calculated Field tips	Not Started	Not Started	Not Started
The GETPIVOTDATA Function Pull pivot values with GETPIVOTDATA	Not Started	Not Started	Not Started
Filter PivotTables Learn how to filter an Excel Pivot Table	Not Started	Not Started	Not Started
Timelines Use a pivot table timeline to filter dates	Not Started	Not Started	Not Started
PivotTable Layout Change layout form to customise your Pivot Table view	Not Started	Not Started	Not Started
Group Values Use Pivot Table grouping to organize values	Not Started	Not Started	Not Started
Refresh a PivotTable Refresh pivot table data in Excel	Not Started	Not Started	Not Started
Format a PivotTable Format your Pivot Table for a cleaner look	Not Started	Not Started	Not Started

Skill	Pre-assess	Lesson	Post-assess	Learning mode
PivotCharts			Account Required
Create PivotCharts Create dynamic charts from Pivot Table data
PivotChart Options Keep your Pivot Chart up to date with new data
PivotChart Styles Apply a built-in visual style for instant clarity
Drill-Down Data Reveal insights with drill down Excel charts

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Troubleshoot Formulas			Account Required
Formula Errors Identify and correct Excel formula errors
The Watch Window Monitor key cells with Watch Window
Evaluate Formulas Use Excel evaluate formula to check each step

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Advanced Formatting			Account Required
Customize Conditional Formatting Use custom formatting to spotlight data
Conditional Formatting with Formulas Apply formula rules to spotlight key values
Manage Conditional Formatting Edit conditional formatting rules in Excel
International Currency and Formats Use Excel international formats for global data
Body and Heading Options Switch theme fonts to polish your workbook look
Color Formats Pick and apply workbook color palettes with ease
Custom Themes Apply brand-ready styles with Excel themes
Form Controls Add interactive elements with Excel forms
Save Form Templates Save an Excel forms template for reuse

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Advanced Formulas			Account Required
IF Function Use IF to check conditions in Excel
Nested Functions Resize and move charts for a perfect layout
AND, OR, and NOT Functions Combine data logic with Excel formulas
SUMIF, AVERAGEIF, and COUNTIF Functions Do conditional totals with the SUMIF function
VLOOKUP Find matches with VLOOKUP in Excel
HLOOKUP Find values across rows in Excel
INDEX and MATCH Use INDEX and MATCH in excel for precise lookups
UPPER, LOWER, and PROPER Change text case in Excel UPPER LOWER PROPER
RIGHT, LEFT, and MID Pull text with LEFT RIGHT MID in Excel
Formula Calculation Options Control when Excel auto-calculates formulas

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Analyze Data			Account Required
Goal Seek Let Excel goal seek solve for the right value
Scenario Manager Compare what if scenarios in Excel
Consolidate Data Combine and summarize data across sheets

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Macros			Account Required
Enable Macros Turn on macros in Excel to use automation
Create Macros Automate your workflow by recording custom tasks
Modify Macros Edit macros in Excel to update automation
Copy Macros Copy macros to reuse your automation anywhere

Student Downloads

Concise, easy-to-use guide for quick learning and reference.

Step-by-step illustrated reference guide.

Practice files for hands-on exercises.

Instructor Downloads

Lesson plans, instructions, and tips for delivering great classes.

Get a Completion Certificate

Share your certificate with prospective employers and your professional network.

Your Name

For verified skills in: Excel Advanced

Issued on December 04, 2025