Word Lesson 10: PDF, Sharing and Co-authoring
Finish and share documents properly: inspect and remove hidden data, save as PDF with bookmarks, restrict editing, protect with a password, share OneDrive links…
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.
586articles
529practice files
10free tools
637wacky facts
🤯 Wacky fact
A blue whale’s heart can weigh about as much as a small car’s engine.
Measurements of a blue whale heart preserved in Canada put it at around 180 kg. Blue whales are the largest animals known to have ever lived, up to about 30 m long.
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
Word Lesson 9: Word Shortcuts That Matter
Word Lesson 9: Word Shortcuts That Matter
The keyboard shortcuts that make a real difference in Word: selecting text, formatting, styles, Find and Replace, change case, repeat last action, navigation and…
Read article →Word Lesson 8: Templates and Quick Parts
Word Lesson 8: Templates and Quick Parts
Stop rebuilding the same letter: create a company letterhead template (.dotx), start new documents from it, save reusable blocks with Quick Parts and AutoText,…
Read article →Word Lesson 7: Track Changes and Comments
Word Lesson 7: Track Changes and Comments
Review documents without losing anyone’s edits: turn on Track Changes, choose markup views, accept or reject edits, reply to and resolve comments, lock tracking…
Read article →Word Lesson 6: Mail Merge — Letters and Labels From Excel
Word Lesson 6: Mail Merge — Letters and Labels From Excel
Send the same letter to many people with their own details: connect Word to an Excel list, insert merge fields, format amounts and dates,…
Read article →Word Lesson 5: Images, Shapes and Text Wrapping
Word Lesson 5: Images, Shapes and Text Wrapping
Insert pictures and icons, compress them, control text wrapping and position so images stop jumping around, anchor and lock them, add captions, and use…
Read article →Word Lesson 4: Tables in Word
Word Lesson 4: Tables in Word
Insert and convert tables, apply table styles, repeat header rows, align numbers, merge and split cells, simple formulas like =SUM(ABOVE), sort a table, and…
Read article →Word Lesson 3: Page Layout — Margins, Orientation, Breaks and Sections
Word Lesson 3: Page Layout — Margins, Orientation, Breaks and Sections
Control how pages look: margins and paper size, page breaks instead of repeated Enter, section breaks for a landscape page in a portrait document,…
Read article →Word Lesson 2: Headings, Navigation Pane and Table of Contents
Word Lesson 2: Headings, Navigation Pane and Table of Contents
Use heading levels to structure a document, jump and reorganise sections with the Navigation Pane, insert an automatic table of contents, update it, and…
Read article →Word Lesson 1: Styles — The One Word Skill That Saves Hours
Word Lesson 1: Styles — The One Word Skill That Saves Hours
Stop formatting text by hand. Use Word styles for headings and body text, modify a style once to change the whole document, clear manual…
Read article →Excel Lesson 18: Final Project — Build a Monthly Sales Report
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 →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 →