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 Basics & Formatting
Introduction to Excel
Navigate the Excel interface, Ribbon, worksheets, and workbook structures.
Cells, Rows & Columns
Master grid navigation, row/column resizing, insertion, and selection tips.
Entering & Editing Data
Input, edit, and delete numbers, text, dates, and clear formatting.
Basic Formatting
Apply font styles, cell fills, borders, alignments, and the Format Painter.
Save, Share & Formats
Explore XLSX, CSV, and PDF formats, file saving, auto-recover, and sharing.
AutoFill & Flash Fill
Instantly populate lists, dates, and patterns, and perform data extraction.
Basic Formulas
Perform basic math calculations with SUM, AVERAGE, COUNT, MAX, and MIN.
Cell References
Understand the critical difference between relative, absolute ($), and mixed references.
Named Ranges
Assign descriptive names to cells and arrays for cleaner, readable formulas.
Sorting & Filtering
Organize tables alphabetically or numerically and filter for specific datasets.
Basic Charts
Build visual column, bar, line, and pie charts from raw table data.
Print & Page Setup
Configure margins, set print areas, scale fit pages, and print gridlines.
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.
Automation, VBA & Expert Tools
XLOOKUP Function
Master the powerful, flexible successor to VLOOKUP for modern lookups.
Dynamic Arrays
Build dynamic worksheets using FILTER, SORT, UNIQUE, and spill ranges.
Power Query
Connect to, clean, transform, and merge external data automatically.
Power Pivot & Data Models
Model relational databases and summarize millions of rows of datasets.
Macros Recording
Record, manage, and play back actions to automate repetitive tasks.
Introduction to VBA
Write your first sub-procedures and explore the Visual Basic Editor (VBE).
VBA Loops & Conditions
Add logic and loop through tables using For loops and If-Then conditions.
Advanced Pivot Tables
Utilize Calculated Fields, grouping options, and complex slicing.
Array Formulas (CSE)
Understand legacy Ctrl + Shift + Enter array math and multi-cell formulas.
Financial Functions
Compute PMT loan payments, Net Present Value (NPV), and IRR return rates.
Statistical Functions
Analyze data with standard deviations (STDEV), percentiles, and multi-criteria counts.
KPI Dashboards
Build dynamic, interactive dashboards using KPI charts, sparklines, and slicers.
External Data Imports
Connect and pull live data into your spreadsheet from SQL, JSON, and Web URLs.
Excel Best Practices
Master the formatting, planning, and structure habits that set professionals apart.
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.
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/ |