Free Microsoft 365 Training Resources
All resources on this page are free. To go next level, my premium Academy resources (which focus on the core Microsoft 365 apps you use every day) will help you become a Legend in your own office. Gain instant access to practical micro-lessons packaged into videos, downloadable PDF guides, examples you can follow and exercises you can practice on (complete with solutions).
Beginner / Technophobe
The Geek-Speak: Computer terminology explained
What do the buttons on a mouse do?
What are WINDOWS and DIALOG BOXES?
Everything you need to know about USB
What’s the difference between SAVE AS and SAVE?
How to avoid cyber attacks, viruses, scams and phishing
What do the function keys (F1 to F12) on the top row of your keyboard do?
Kilobytes (Kb), megabytes (Mb) and gigabytes (Gb)
How can I fix a slow computer?
Microsoft Word (Basics)
Tour of the Word screen. Getting started
Keyboard shortcuts & mouse techniques to navigate, select & edit text in you Word document
Text formatting in Word: 11 tools to make your text look fantastic
7 paragraph formatting tools to enhance your Word document
How to create custom bullets in Word
How to use pictures in Word to add visual interest
Create tables in Word fast (with handy time-saving tips)
How to print your Word document: A quick rundown of all the print options
How to create, save, update, close & find files and how to switch between multiple Word docs
Microsoft Word (Pro)
Multilevel numbering in Word: Perfect the first time
How to set up a dual multilevel numbering system in Word
How to construct a Table of Contents in Word that self-updates and doesn’t break
2 ways to build a dynamic Word index page
The easy way to create a Table of Figures in Word
Display your document’s quotes sources (citations) by building a dynamic Table of Authorities
2 easy ways to navigate a large Word document
How to use the Index field switches in Word
A simple macro to copy styles from one doc to another
How to start content on a new page or the next ODD page without using Section Breaks
Microsoft Word tables: Advanced settings & features
Make sure to use these powerful auditing tools BEFORE you publish or distribute your Word document
Subdocuments & master documents in Word: Good document management
Create master document Word files using INCLUDETEXT fields
Hidden secrets of the Backstage View in Word
How to inspect a Word document for flaws and omissions
Lock Word document access with strong security to protect your IP
Encrypt or password protect Word documents
Managing your Word headers and footers properly
How to build a Word index using the ‘Mark & Index’ method
How to build a dynamic Word index using a Concordance File
Add or remove watermarks in Word – Here’s how
How to quickly add funky horizontal dividers in Microsoft Word
How to add a Drop Cap in Microsoft Word
Ligatures and Stylistic Effects in Microsoft Word
Kerning fonts in Microsoft Word
How and why to use raised text and lowered text in Word
Stretching and spacing text in Microsoft Word
Superscript and Subscript in Microsoft Word (Step-by-Step)
How to add drop caps, kerning and other text effects in Word
Microsoft PowerPoint
Excel Basics
Excel Screen: A Beginners Tour
How to save Excel files: A beginners guide.
How many rows and columns does Excel have?
Text, numbers, percentages, currency and dates
Navigate and select cells, rows, columns or the entire worksheet
How to resize, insert and delete rows and columns
5 simple Excel functions to simplify your formulas
How to count cells in Excel using 4 super-easy COUNT functions
How to find the biggest or smallest number in a list
14 ways to format your spreadsheet for a professional finish
How to calculate (rather than format) a percentage
Using images to add visual interest
Cut and Paste: What you don’t know
3 places to find help in Excel
Budgeting 101: Your easy guide to creating a business budget
Excel Formulas
Excel formulas quick start guide (part 1 of 4)
Excel formulas quick start guide: (part 2 of 4): SUM and AUTOSUM
Excel formulas quick start guide: (part 3 of 4): AVERAGE, MAX, MIN and COUNT
Excel formulas quick start guide: (part 4 of 4): Order of Operations
When to use COUNT vs SUM vs COUNTA vs COUNTBLANK vs COUNTIF
3 ways to calculate an AVERAGE in Excel
How to manipulate TEXT and clean up your Excel data
21 Fatal Formula Fails (and how to avoid & fix them)
How to calculate the row number of the last populated cell or first populated cell in a range
Excel Charts
Excel Pro Tips
Leading zeros in Excel: How to stop zeros from dropping off your numbers
How to link Excel workbooks: Reference data across multiple files
How to analyse sales performance in Excel
SOS-Click: The easy automated backup tool for home users
6 Excel templates for organbising your daily activities
3 Ways to Build an Absolute Reference Into Excel Formulas
How to create a new Excel template
10 ways Excel consultants can leverage your business spreadsheets
Perfect printing with Auto-Repeat headings and controlled page breaks
2 Ways to create Excel dates like 3rd June 2022 (1st, 2nd, 3rd, 4th etc.)
Best Excel Templates for Project Management and Tracking
Data Validation: Ensure your data is clean and your reporting is accurate
Database functions: 5 old-school reporting functions
How to protect workbooks, worksheets and cells PLUS 3 ways to restrict access to important data
3 big advantages of named cells in formulas
2 ways to share workbooks using co-authoring or the legacy sharing tool
How to create links (hyperlinks)
Paste Special: The hidden secrets within
2 easy ways to consolidate data in Excel
When to use Automatic vs Manual calculations in Excel
Useful ALT codes to insert special characters in Excel
9 Excel sorting secrets revealed
How to use Conditional Formatting to dynamically highlight data rows (automatically)
Goal Seek: A simple tool to reverse engineer an answer
The 3D (cross-sheet) Excel formulas that nobody tells you about
3 ways to insert a degree symbol in Excel
How to find, manage and remove duplicates in Excel
Hide gridlines in Excel (for a clean, professional finish)
Navigate worksheets quickly using this forgotten tool
These are my free resources.
Imagine how much more you’ll get out of my premium resources.