Course Library
54 lessons across four skill levels.
Beginner
Essential shortcuts and your first formulas.
Navigate Quickly
Ctrl + Arrow KeysJump to the edge of your data in any direction instantly. The fastest way to move around large spreadsheets without scrolling.
Select Entire Row
Shift + SpaceHighlight the full row of the active cell with one keystroke — perfect for formatting, deleting, or moving rows.
Select Entire Column
Ctrl + SpaceSelect the full column of the active cell. Combine with Shift+Space to select an entire region instantly.
AutoSum
Alt + =Insert a SUM formula automatically over the adjacent range. The fastest way to total a column or row.
Undo & Redo Actions
Ctrl + Z / Ctrl + YMade a mistake? Reverse it. Changed your mind? Bring it back. Essential for fearless editing.
Format Cells Dialog
Ctrl + 1Open the full Format Cells dialog to control number, alignment, font, border, fill and protection in one place.
Insert Today's Date
Ctrl + ;Stamp the current date into a cell as a static value (it won't update). Great for logs and timesheets.
Insert Current Time
Ctrl + Shift + ;Stamp the current time into a cell. Combine with the date shortcut for a full timestamp.
Wrap Text
Alt + H + WToggle text wrapping on the selected cells without leaving the keyboard. Long text fits cleanly inside the cell width.
Bold, Italic, Underline
Ctrl + B / I / UApply or remove the three core text styles. The same shortcuts you know from Word work everywhere in Excel.
Intermediate
Lookups, conditional logic and selection mastery.
Apply Filters
Ctrl + Shift + LToggle filter dropdowns on your data range. The fastest way to slice and explore tabular data.
Find & Replace
Ctrl + HFind values across a sheet or workbook and replace them in bulk. Supports wildcards and case-sensitive search.
Create a Table
Ctrl + TConvert a plain range into a structured Excel Table — adds filters, banded rows, and structured references automatically.
Flash Fill
Ctrl + EExcel detects patterns in your data and fills the rest automatically. Perfect for splitting names, formatting phones, and more.
Remove Duplicates
Data → Remove Duplicates (Alt + A + M)Strip duplicate rows from a range or table based on selected columns. A one-click data cleanup essential.
Conditional Formatting
Home → Conditional FormattingHighlight cells based on rules — top values, data bars, color scales, or custom formulas. Make patterns visible at a glance.
Freeze Panes
Alt + W + F + FLock rows or columns in place while you scroll. Essential for keeping headers visible in long datasets.
Sort Data
Data → Sort (Alt + A + S + S)Order your data by one or multiple columns, ascending or descending — critical for analysis and reporting.
Pivot Table Basics
Insert → PivotTable (Alt + N + V)Summarize thousands of rows into compact reports by dragging fields into Rows, Columns, Values, and Filters.
VLOOKUP — Find Anything
=VLOOKUP(value, table, col, FALSE)Search for a value in the first column of a table and return data from another column. The classic lookup function.
Professional
Modern formulas and pro-level workflows.
XLOOKUP — Modern Lookup
=XLOOKUP(value, lookup_array, return_array)The modern replacement for VLOOKUP. Cleaner syntax, default exact match, looks left or right, handles errors gracefully.
INDEX + MATCH Combo
=INDEX(range, MATCH(value, lookup_range, 0))The pro alternative to VLOOKUP. More flexible, faster on large datasets, and works in any direction.
Handle Errors with IFERROR
=IFERROR(formula, value_if_error)Wrap any formula to return a friendly value (or blank) when it errors. Keeps your reports clean and professional.
Data Validation Dropdowns
Data → Data Validation (Alt + A + V + V)Restrict cell input to a list, number range, or custom rule. Build dropdowns that prevent bad data at the source.
Power Query Basics
Data → Get & Transform DataConnect to files, databases, and APIs, then transform the data with a repeatable, refreshable pipeline. No formulas needed.
Data Transformation
Power Query EditorClean, reshape, split, pivot and unpivot data inside the Power Query editor. Every step is recorded and rerunnable.
Merge Tables
Power Query → Merge QueriesJoin two tables on one or more columns — like SQL JOIN, but visual. Inner, left, right, full and anti joins all supported.
Pivot Charts
Insert → PivotChartVisualize a PivotTable instantly. Charts stay synced with slicers and filters for interactive dashboards.
Dashboard Basics
Pivot + Slicers + ChartsCombine PivotTables, slicers, and charts on one sheet to build interactive dashboards stakeholders can explore themselves.
Goal Seek
Data → What-If Analysis → Goal SeekTell Excel the result you want and which input to change — it solves backwards. Perfect for break-even and target calculations.
Professional+ Excel Systems
Eight advanced courses with structured lessons, hands-on exercises and real-world accounting projects. Finish the track to earn your certificate.
Advanced Dashboards with Slicers
Design interactive executive dashboards with slicers, timelines and KPI cards.
Build a monthly sales dashboard with regional slicers and KPI sparklines.
Excel Automation with Macros & VBA
Automate repetitive accounting and reporting tasks with the macro recorder and VBA.
Automate a month-end closing workbook that posts journals and emails the report.
ActiveX Controls & Forms
Turn worksheets into interactive apps with ActiveX controls and UserForms.
Ship an invoice entry UserForm that writes structured journal lines on submit.
Power Query Data Transformation
Connect, clean and combine data from many sources with refreshable pipelines.
Consolidate 12 monthly bank statements into a single reconciled ledger.
Advanced Formulas & Logic
Master LET, LAMBDA and dynamic arrays to write professional, auditable formulas.
Build a reusable LAMBDA library for amortization, depreciation and tax calculations.
Scenario Analysis & Forecasting
Model best / base / worst scenarios and project seasonal forecasts.
Build a 3-scenario annual P&L forecast with sensitivity tables.
Full Accounting System in Excel
Build a complete ledger, trial balance and financial statements from scratch.
Ship a fully working SME accounting workbook: COA → Journal → Ledger → Statements.
Spreadsheet Audit & Error Checking
Audit, debug and lock down spreadsheets so they don't break in production.
Audit and harden a 30-tab budgeting model — find every broken reference and lock it down.
Real-world projects
Apply your skills on full workflows: month-end close, executive dashboards, VBA invoice apps and budget audits.
Want everything?
Upgrade to Premium for the Professional+ track, projects and your certificate.
See plans