📊

Excel 2019

Master Excel from spreadsheet fundamentals to advanced data analysis, PivotTables, dashboards, and MOS certification readiness.

7
Modules
1
Assessment
8+
Hours
MOS
Cert Prep

Excel Foundations (Modules 1–4)

Build strong spreadsheet fundamentals used in every office environment.

Module 1

Excel Fundamentals

Interface navigation, workbook basics, formatting, and spreadsheet setup.

Available →

Module 2

Cells, Formatting & Basic Formulas

Cell formatting, number formats, worksheet structure and basic formulas.

Available →

Module 3

Workbook Management, Printing & Basic Calculations

Multiple worksheets, find & replace, spell check, view tools, professional printing, intro to formulas.

Available →

Module 4

Complex Formulas, Functions & Cell References

Complex formulas, intro to functions, and absolute and relative cell references.

Available →

Advanced Analysis (Modules 5–8)

Develop professional-level Excel skills for reporting and certification.

Module 5

Working with Data

Sorting, filtering, tables, charts, and conditional formatting.

Available →

Module 6

Tables, Charts & PivotTables

Structure data with tables, visualize insights with charts, and summarize information using PivotTables.

Available →

Module 7

Data Analysis Tools

Learn advanced PivotTable techniques, What-If Analysis tools, and reference styles used for deeper data analysis.

Available →

Module 8

Modern Excel Features

Explore Microsoft 365 features, Intelligent Services, drawing tools, and icons to enhance modern Excel workflows.

Available →

🏆 Excel Certification Assessment

Covers Modules 1–7. MOS-style simulation and project-based evaluation.

Prerequisites

  • • Basic computer literacy
  • • Microsoft Excel 2019 or Microsoft 365 installed
  • • Willingness to practice with real datasets