Guided Excel Course

Learn Excel from foundations to reporting.

What is Excel? — Understand what Excel is, why people use it, and how spreadsheets turn information into useful results.

The Excel Screen — Get familiar with the main parts of the Excel window before changing data or writing formulas.

Workbook vs Worksheet — A workbook is the Excel file; a worksheet is a sheet/tab inside that file.

Rows and Columns — Rows run horizontally and use numbers; columns run vertically and use letters.

Cells and Cell Addresses — A cell is where a row and column meet. Its address tells Excel exactly where the value lives.

Ranges — A range is a group of cells such as B2:B10 or A1:C5.

Entering Data — Enter text, numbers, dates, percentages and other values into cells.

Editing and Clearing Data — Change or remove cell contents without disturbing the rest of the worksheet.

Copy, Paste and Fill — Use copy/paste and the fill handle to repeat values and extend patterns.

Ribbon Overview — Understand why the Ribbon exists and how tabs and groups organize Excel commands.

Home Tab Masterclass — Learn the main Home-tab groups: Clipboard, Font, Alignment, Number, Styles, Cells and Editing.

Insert, Data and View Tabs — Understand the most useful tools in Insert, Data and View for everyday Excel work.

Basic Formatting — Format information so a worksheet is easier to scan without changing the underlying values.

Number Formats — Use number, currency, accounting, percentage and date formats to present values correctly.

Dates and Times — Enter and recognize dates and times so Excel can sort and calculate with them correctly.

Formula Fundamentals — Create formulas using =, arithmetic operators, parentheses and cell references.

The Formula Bar — Use the Formula Bar to inspect, edit and understand the contents of the selected cell.

Relative References — Understand why A1 changes when a formula is copied to another location.

Absolute References — Use $A$1 to lock both row and column when a formula is copied.

Mixed References — Use A$1 and $A1 when only the row or only the column should remain fixed.

Core calculations — SUM, AVERAGE, COUNT, COUNTA, COUNTBLANK, MIN and MAX.

Logical decisions — IF, IFS, AND, OR, NOT and IFERROR.

Conditional calculations — COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF and AVERAGEIFS.

Lookups — VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH and XMATCH.

Text cleaning — TRIM, CLEAN, SUBSTITUTE, LEFT, RIGHT, MID and text joining.

Dates and workdays — TODAY, NOW, DATE, YEAR, MONTH, DAY, EOMONTH and NETWORKDAYS.

Tables and validation — Excel Tables, sorting, filtering and data validation.

Conditional formatting — Use rules to highlight exceptions and performance.

Charts — Choose charts that answer a business question.

PivotTables — Summarize large tables using Rows, Columns, Values and Filters.

Dynamic arrays — FILTER, SORT, SORTBY, UNIQUE and SEQUENCE.

Modern array shaping — TAKE, DROP, CHOOSECOLS, CHOOSEROWS, TOCOL, TOROW, VSTACK and HSTACK.

LET — Give names to intermediate calculations and make complex formulas easier to read.

LAMBDA — Create reusable custom worksheet functions.

Advanced lookups — Combine XLOOKUP, INDEX, MATCH and XMATCH for robust retrieval.

Date analysis — Build ageing, month, quarter and financial-year logic.

Financial analysis — PMT, PV, FV, RATE, NPV, IRR and related functions.

Power Query — Import, clean, combine and refresh data.

Power Pivot — Create relationships and a reusable data model.

DAX fundamentals — Measures, CALCULATE, FILTER, DIVIDE and DISTINCTCOUNT.

Daily Sales Report — Build a reliable daily business report from raw transactions.

Collection Report — Track target, collection, achievement and status by branch and employee.

Branch Performance — Compare branches across target, collection and achievement %.

Employee Performance — Measure employee productivity and target achievement.

Target vs Achievement — Build KPI logic and management-friendly visuals.

MIS Dashboard — Combine KPIs, PivotTables, charts and filters.

Loan Ageing — Turn due dates and payment information into ageing buckets.

Monthly Business Report — Create a repeatable monthly reporting workflow.

Expense Tracker — Track categories, budgets, actuals and variance.

Management Dashboard — Present a concise executive view of performance.

Interactive practice runs in your browser.