Excel Lesson 18: Final Project — Build a Monthly Sales Report
Put the whole course together: turn raw orders into a one-page quarterly sales report with KPIs, region vs target with Met/Missed, a monthly chart,…
Read article →Practical tutorials since 2016, by Atul Vij
Learn Excel, automation & code — the practical way
Step-by-step tutorials with downloadable practice files, free browser tools and a daily dose of wacky facts.
576articles
518practice files
10free tools
637wacky facts
🤯 Wacky fact
The word “nerd” first appeared in a Dr. Seuss book.
Its earliest known printed use is in Dr. Seuss’s “If I Ran the Zoo” (1950), as the name of a small, grumpy creature. Within a year it was being used as slang for a boring or square person.
Free course
Excel VBA in 15 lessons
From your first variable to UserForms, with a practice workbook that has every macro on a button.
15 of 15 lessons published
Start lesson 1 →Latest articles
Excel Lesson 17: Pivot Table Basics
Excel Lesson 17: Pivot Table Basics
Summarise thousands of rows in seconds: create a pivot table, drag fields into Rows, Columns, Values and Filters, change Sum to Count or Average,…
Read article →Excel Lesson 16: Conditional Formatting
Excel Lesson 16: Conditional Formatting
Make important cells stand out automatically: highlight rules, top/bottom, data bars, colour scales and icon sets, formula rules that colour whole rows, managing rule…
Read article →Excel Lesson 15: Data Validation and Drop-Down Lists
Excel Lesson 15: Data Validation and Drop-Down Lists
Stop typing mistakes before they happen: drop-down lists from a range or Table, whole-number and date limits, custom rules for PAN and mobile numbers,…
Read article →Excel Lesson 14: Lookups — VLOOKUP and XLOOKUP
Excel Lesson 14: Lookups — VLOOKUP and XLOOKUP
Fetch a price, name or rate from another table: VLOOKUP exact match step by step, XLOOKUP (easier and more flexible), handling codes that aren’t…
Read article →Excel Lesson 13: Dates — TODAY, EOMONTH, DATEDIF and Date Maths
Excel Lesson 13: Dates — TODAY, EOMONTH, DATEDIF and Date Maths
How Excel stores dates, adding days and months, due dates, month-end with EOMONTH, age and service with DATEDIF, working days with NETWORKDAYS, YEAR/MONTH/WEEKDAY, and…
Read article →Excel Lesson 12: Text Functions — LEFT, RIGHT, MID, TRIM, PROPER and More
Excel Lesson 12: Text Functions — LEFT, RIGHT, MID, TRIM, PROPER and More
Clean and split messy text: TRIM extra spaces, fix case with PROPER/UPPER/LOWER, cut pieces with LEFT, RIGHT and MID, find positions with FIND, replace…
Read article →Excel Lesson 11: Absolute vs Relative References ($)
Excel Lesson 11: Absolute vs Relative References ($)
Why formulas break when copied, and how the $ sign fixes it: relative, absolute ($B$8) and mixed ($A2, B$1) references, the F4 shortcut, named…
Read article →Excel Lesson 10: Printing and Page Setup
Excel Lesson 10: Printing and Page Setup
Print Excel sheets that fit: Print Preview, orientation, Fit to page width, print area, repeating header rows, headers and footers with page numbers, page…
Read article →Excel Lesson 9: Your First Charts
Excel Lesson 9: Your First Charts
Pick the right chart for the job, build column, line, pie and combo charts in seconds, add titles and data labels, change the chart…
Read article →Excel Lesson 8: Excel Tables (Ctrl+T) for Every List
Excel Lesson 8: Excel Tables (Ctrl+T) for Every List
Turn any list into an Excel Table with Ctrl+T: banded rows, filters, automatic expansion, calculated columns, the Total Row, slicers, and formulas that use…
Read article →Excel Lesson 7: Sorting and Filtering Data
Excel Lesson 7: Sorting and Filtering Data
Sort by one or several columns, sort by date or a custom order, filter by values, numbers, dates, text and colour, read totals of…
Read article →