Excel & Spreadsheet Mastery
From first formula to PivotTables, Power Query, dashboards and financial models.
A complete 12-module professional course in Microsoft Excel 365 with Google Sheets notes. Master formulas, logical, text, date and lookup functions (XLOOKUP, INDEX/MATCH), Tables, data validation, conditional formatting, dynamic arrays, LET and LAMBDA, PivotTables, charts and dashboards, Power Query, financial modelling, What-If Analysis and Solver, macros and collaboration — and prepare for the Microsoft Office Specialist (MOS) Excel exams. Every lesson has a hands-on spreadsheet lab, exercises and a quiz you must pass at 80%, followed by a pooled final exam.
Curriculum
One complete track with its own final exam and certificate.
Twelve modules from spreadsheet basics to advanced analysis, automation and certification readiness.
Navigate Excel and Google Sheets confidently and build clean, well-structured workbooks.
- 1.1 The Excel and Google Sheets interface: ribbon, menus, grid and Name Box Lab75 min
- 1.2 Cells, ranges, rows, columns and worksheets Lab75 min
- 1.3 Entering and editing data: text, numbers, dates and times Lab75 min
- 1.4 AutoFill, Flash Fill and series Lab75 min
- 1.5 Number formats, custom formats and why values differ from display Lab75 min
- 1.6 Cell styles, alignment, borders and themes Lab75 min
- 1.7 Saving, file formats, version history and sharing Lab75 min
- 1.8 Designing a well-structured workbook: inputs, calculations and outputs Lab75 min
Careers this prepares you for
- Data Analyst
- Financial Analyst
- Operations Analyst
- Administrative Specialist
- Business Analyst