Learn Excel (for bookkeepers and accountants)
This page offers several free courses on learning Microsoft Excel.
No fee or registration is required.
To start the free courses and tutorials, please use the links below.
Learn Excel: FREE Basics Course
Part 1: An Introduction to Excel
Module overview:
-
An introduction to Excel
-
Course Content
-
Why use Excel
-
Excel essentials
1.1 What is Excel?
Microsoft Excel is a software package. It is a powerful, grid-based spreadsheet with a variety of uses.
1.2 What can Excel do?
In general, Excel is used to store, organise, calculate, and analyse data.
In a day-to-day, more specific sense, Excel is used to create tables, charts, dashboards, task tracking, budgets, loan calculators, to-do lists, vacation and trip planners, lists, questionnaires, stock portfolio trackers, and much more.
As an accountant, I use Excel for bookkeeping, management accounting, final accounts compilation, cash flow forecasts, business planning, client management, credit control and more.
1.3 Why use Excel?
Excel is cost-effective, user-friendly, and widely recognised.
1.4 Course Content
In this course, I will teach all the basics of Excel. This will include:
-
The Essentials. Opening and closing Excel. Saving and loading files.
-
Spreadsheet Basics. Cells. Columns. Rows. Widths and heights. Entering text.
-
Cell Formatting. Text. Borders. Colouring. Auto data.
-
Formulas. Basic formulas for totalling and averaging.
-
Creating tables and charts.
1.5 Excel Essentials
Part 1 will teach:
-
How to open Excel
-
How to save Excel
-
Spreadsheet basics
-
Rows explained
-
Columns explained
-
Cells explained
Part 2: Editing and Formatting Cells
Module overview:
-
Adding and editing text
-
Editing cells
-
Widths and heights
-
Borders
-
And more
Part 4: Formulas
Module overview:
-
Excel formula essentials
-
Totalling
-
Averaging
-
And more
Part 3: Creating Tables
Module overview:
-
Table basics
-
Filtering and sorting
-
And more
Part 5: Other Essentials
Module overview:
-
Merge and Centre
-
Charts
-
Tabs
-
And more
How to Create a Bookkeeping Spreadsheet Using Excel
Create a Basic Bookkeeping Spreadsheet
Content:
-
How to create a basic bookkeeping spreadsheet
-
How to use the spreadsheet
-
And more
Using a Double-Entry Bookkeeping Spreadsheet
Content:
-
How to use my advanced bookkeeping spreadsheet
-
Double-entry, profit and loss, and balance sheet
-
Automated
Download My Free Bookkeeping Spreadsheets
Want to try accounting software? Get 90% off Xero
How to Create a Cash Flow Forecast in Excel
Using an Excel Cash Flow Forecast
Content:
-
How to use my automated cash flow forecast
-
Project cash flow with sales and expenses
-
Free spreadsheet
Download My Free Excel Cash Flow Forecast
How to Create a Business Plan in Excel
The Course Covers:
The basics of business planning
Fundamental documents and terminology
How to create business plan forecasts & financials
Deep business planning insights and tips
Free business plan templates
Everything you need to obtain financing
And much more



