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! 

ABSOLUTE BEGINNERS

The Geek-Speak: Computer terminology explained

What do the buttons on a mouse do?

What is the CLOUD?

What is a BROWSER?

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

BEGINNERS WORD

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

ADVANCED 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

POWERPOINT

Slide design tips for professional PowerPoint slide decks

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

How to select cells, rows, columns or the worksheet and how to get around quickly

How to resize, insert and delete rows and columns

Excel formulas for beginners

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

Spellcheck and Find & Replace

Cut and Paste: What you don't know

3 paces 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)

VLOOKUP

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

EXCEL CHARTS

Combo Chart

Chart Options

Map Chart

2D or 3D Surface Chart

Radar Chart

Treemap Chart

Sunburst Chart

4 Different Stock Charts

Box Plot (Box and Whisker) Chart

XY Scatter Chart

Waterfall Chart

Funnel Chart

Renko Chart

Histogram (Standard Chart Method)

Histogram (Data Analysis Method)

EXCEL POWER TIPS

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

The best way to create drop-down lists in Excel that are easy to maintain, re-use and put YOU in full control

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).

CHECK OUT THE OFFICE LEGENDS ACADEMY
>