Free Microsoft Office Training Resources
All resources on this page are free. You’re welcome!Can’t find what you’re looking for? Search here.
For premium e-courses, designed to get you from Zero to Confident or from Average to Legendary in the quickest way possible, check out the Office Legends Academy. Each e-course in the Academy contains an organised library of useful, practical videos, written training guides, examples to follow and practice exercises (with solutions). You get instant, lifetime access. And best of all, you can choose what you pay!
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?
How big is a point when looking at font size?
Which computer should I buy? A buyers guide
Tour of the Word screen. Getting started
Keyboard shortcuts & mouse techniques to navigate, select & edit text in you Word document
Word formatting tools to make your text look fantastic
7 ways to use Word’s paragraph formatting tools to enhance your document design
How to create custom bullets in Word
How to use pictures in Word to add visual interest
How to create and manipulate tables in Word
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
Where to find help in Microsoft Word
Multilevel numbering in Word that works perfectly, 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
15 proven ways to enhance your Word tables
Make sure to use these powerful auditing tools BEFORE you publish or distribute your Word document
How to create a Master Word doc form multiple sub-docs
How to use the INCLUDETEXT field to create a master document
Hidden secrets of the Backstage View in Word
How to inspect a Word document for flaws and omissions
5 simple ways to protect the intellectual IP in your Word doc
How to password-protect Word documents like professional writers do
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
How to create custom watermarks in Microsoft Word
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
How to use Superscript and Subscript in Microsoft Word
Advanced text effects to add a professional finish in Microsoft Word
Slide design tips for professional PowerPoint slide decks
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
How to select cells, rows, columns or the worksheet and how to get around quickly
How to resize, insert and delete rows and columns
5 simple Excel functions to simplify your formulas
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
Budgeting 101: Your easy guide to creating a business budget
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
Time Functions, Time Formats and Time Calculations
Box Plot (Box and Whisker) Chart
Histogram (Standard Chart Method)
Histogram (Data Analysis Method)
Leading zeros in Excel: How to stop zeros from dropping off your numbers
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 Frmatting 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
How to create your own custom date format in Excel
If you use Merge & Centre, you must read this !
I hope you got plenty of value from these free Microsoft Office training resources. Take things to the next level with a premium course (you can choose what you pay).