Excel: Foundations to Workplace Analysis — 24-module course

Author

Workbook navigation and file management

Data types and reliable entry

Formatting and accessible worksheets

Relative and absolute references

Core formulas and functions

Tables and structured data

Sorting and filtering

Printing and exporting useful reports

IF and logical decisions

Conditional totals and counts

Lookups and matching records

Dates and time calculations

Text cleanup and extraction

Data validation and entry controls

Formula errors and auditing

Charts and PivotTables

Importing and cleaning datasets

Power Query foundations and availability

Combining data and model concepts

Building a useful dashboard

What-if and scenario analysis

Collaboration, permissions and protection

Repeatable reports and refresh checks

Workplace analysis capstone