Master Excel
From Zero to
Advanced
40 structured lessons covering every Excel skill — from your very first cell to VBA macros, Power Query, and professional dashboards.
Excel Fundamentals
Interface, cells, basic formulas, formatting, charts, and file management.
Functions & Data Tools
VLOOKUP, IF logic, Pivot Tables, conditional formatting, and data validation.
Power Features
XLOOKUP, Dynamic Arrays, Power Query, Macros, VBA, and Dashboards.
Excel Fundamentals
Introduction to Excel
What Excel is, why it matters, and a complete tour of the interface.
Cells, Rows & Columns
Understand cell addresses, select ranges, and resize rows and columns.
Entering & Editing Data
Type text and numbers, edit existing data, and use undo/redo effectively.
Basic Formatting
Bold, italic, cell colors, borders, and number format styles.
Basic Formulas
Write your first formulas with SUM, AVERAGE, MIN, MAX, and COUNT.
AutoFill & Flash Fill
Drag to fill series and let Excel detect patterns automatically.
Sorting & Filtering
Sort data A–Z, apply multi-level sorts, and use AutoFilter.
Basic Charts
Create bar, column, and pie charts with proper titles and labels.
Print & Page Setup
Set print areas, control page breaks, and add headers and footers.
Save, Share & File Formats
XLSX vs CSV, saving to OneDrive, and sharing your workbook.
Cell References
Relative, absolute ($), and mixed references — the key to powerful formulas.
Named Ranges
Define and use named ranges in formulas with the Name Manager.
Functions & Data Tools
IF & Logical Functions
Build decision logic with IF, AND, OR, NOT, and nested conditions.
VLOOKUP & HLOOKUP
Look up data across tables with exact and approximate matching.
INDEX & MATCH
The powerful VLOOKUP alternative for two-way lookups.
Text Functions
Manipulate text with LEFT, RIGHT, MID, TRIM, CONCATENATE, and more.
Date & Time Functions
Work with dates using TODAY, NOW, DATEDIF, and WORKDAY.
COUNTIF / SUMIF / AVERAGEIF
Count, sum, and average data based on conditions.
Pivot Tables
Summarize thousands of rows of data instantly with Pivot Tables.
Conditional Formatting
Highlight cells automatically with rules, data bars, and color scales.
Data Validation
Control what users can enter with dropdown lists and custom rules.
Advanced Charts
Combo charts, sparklines, and dynamic chart techniques.
Tables & Structured References
Format data as Tables and use structured column references.
Error Handling
Handle Excel errors gracefully with IFERROR, IFNA, and error types.
Protect Sheets & Workbooks
Lock cells, password-protect sheets, and secure your workbooks.
What-If Analysis
Use Goal Seek, Scenario Manager, and Data Tables for forecasting.
Power Features & Automation
XLOOKUP
The modern replacement for VLOOKUP with wildcards and reverse search.
Dynamic Array Functions
FILTER, SORT, SORTBY, UNIQUE — functions that spill results automatically.
Power Query
Import, clean, and transform data from any source without formulas.
Power Pivot & Data Model
Build relationships between tables and write DAX measures.
Macros (Recording)
Record, run, and assign macros to buttons to automate repetitive tasks.
Introduction to VBA
Open the VBA Editor and write your first Sub and Function procedures.
VBA Loops & Conditions
Write For/Next loops, If/Then/Else branches, and Do While loops.
Advanced Pivot Tables
Calculated fields, group by date, and pivot charts.
Array Formulas (CSE)
Enter Ctrl+Shift+Enter formulas for multi-cell calculations.
Financial Functions
Calculate loans, investments, and depreciation with PMT, FV, NPV, IRR.
Statistical Functions
Analyze data distributions with STDEV, PERCENTILE, and FREQUENCY.
Dashboards in Excel
Design professional interactive dashboards with KPI cards and slicers.
Excel & External Data
Import live data from the web, SQL databases, and JSON files.
Excel Best Practices
File structure, formula auditing, and speed optimization tips.
Ready to Excel at Excel?
Start with Lesson 1 — no sign-up, no cost. Just clear, practical tutorials.
Begin Lesson 1 — Free 40 lessons · Beginner to Advanced · Always freeAll 40 Lesson Permalinks
Use these exact URLs when creating each WordPress post
| # | Lesson Title | Level | Permalink (post slug) |
|---|---|---|---|
| 01 | Introduction to Excel | Beginner | /excel-tutorial/introduction-to-excel/ |
| 02 | Cells, Rows & Columns | Beginner | /excel-tutorial/cells-rows-and-columns/ |
| 03 | Entering & Editing Data | Beginner | /excel-tutorial/entering-and-editing-data/ |
| 04 | Basic Formatting | Beginner | /excel-tutorial/basic-formatting/ |
| 05 | Basic Formulas | Beginner | /excel-tutorial/basic-formulas/ |
| 06 | AutoFill & Flash Fill | Beginner | /excel-tutorial/autofill-and-flash-fill/ |
| 07 | Sorting & Filtering | Beginner | /excel-tutorial/sorting-and-filtering/ |
| 08 | Basic Charts | Beginner | /excel-tutorial/basic-charts/ |
| 09 | Print & Page Setup | Beginner | /excel-tutorial/print-and-page-setup/ |
| 10 | Save, Share & File Formats | Beginner | /excel-tutorial/save-share-and-file-formats/ |
| 11 | Cell References | Beginner | /excel-tutorial/cell-references/ |
| 12 | Named Ranges | Beginner | /excel-tutorial/named-ranges/ |
| 13 | IF & Logical Functions | Intermediate | /excel-tutorial/if-and-logical-functions/ |
| 14 | VLOOKUP & HLOOKUP | Intermediate | /excel-tutorial/vlookup-and-hlookup/ |
| 15 | INDEX & MATCH | Intermediate | /excel-tutorial/index-and-match/ |
| 16 | Text Functions | Intermediate | /excel-tutorial/text-functions/ |
| 17 | Date & Time Functions | Intermediate | /excel-tutorial/date-and-time-functions/ |
| 18 | COUNTIF / SUMIF / AVERAGEIF | Intermediate | /excel-tutorial/countif-sumif-averageif/ |
| 19 | Pivot Tables | Intermediate | /excel-tutorial/pivot-tables/ |
| 20 | Conditional Formatting | Intermediate | /excel-tutorial/conditional-formatting/ |
| 21 | Data Validation | Intermediate | /excel-tutorial/data-validation/ |
| 22 | Advanced Charts | Intermediate | /excel-tutorial/advanced-charts/ |
| 23 | Tables & Structured References | Intermediate | /excel-tutorial/tables-and-structured-references/ |
| 24 | Error Handling (IFERROR/IFNA) | Intermediate | /excel-tutorial/error-handling-iferror-ifna/ |
| 25 | Protect Sheets & Workbooks | Intermediate | /excel-tutorial/protect-sheets-and-workbooks/ |
| 26 | What-If Analysis | Intermediate | /excel-tutorial/what-if-analysis/ |
| 27 | XLOOKUP | Advanced | /excel-tutorial/xlookup/ |
| 28 | Dynamic Array Functions | Advanced | /excel-tutorial/dynamic-array-functions/ |
| 29 | Power Query | Advanced | /excel-tutorial/power-query/ |
| 30 | Power Pivot & Data Model | Advanced | /excel-tutorial/power-pivot-and-data-model/ |
| 31 | Macros (Recording) | Advanced | /excel-tutorial/macros-recording/ |
| 32 | Introduction to VBA | Advanced | /excel-tutorial/introduction-to-vba/ |
| 33 | VBA Loops & Conditions | Advanced | /excel-tutorial/vba-loops-and-conditions/ |
| 34 | Advanced Pivot Tables | Advanced | /excel-tutorial/advanced-pivot-tables/ |
| 35 | Array Formulas (CSE) | Advanced | /excel-tutorial/array-formulas-cse/ |
| 36 | Financial Functions | Advanced | /excel-tutorial/financial-functions/ |
| 37 | Statistical Functions | Advanced | /excel-tutorial/statistical-functions/ |
| 38 | Dashboards in Excel | Advanced | /excel-tutorial/dashboards-in-excel/ |
| 39 | Excel & External Data | Advanced | /excel-tutorial/excel-and-external-data/ |
| 40 | Excel Best Practices | Advanced | /excel-tutorial/excel-best-practices/ |