top of page

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

Excel 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

Excel Basics Part 2
Excel Basics Part 3

Part 4: Formulas

Module overview:

​

  • Excel formula essentials

  • Totalling

  • Averaging

  • And more

Excel Basics Course Part 5

Part 3: Creating Tables

Module overview:

​

  • Table basics

  • Filtering and sorting

  • And more

Exel Basics Part 4

Part 5: Other Essentials

Module overview:

​

  • Merge and Centre

  • Charts

  • Tabs

  • And more

How to Create a Bookkeeping Spreadsheet Using Excel

Basic Bookkeeping Spreadsheet Thumbnail

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

Double Entry Bookkeeping Spreadsheet

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 

Excel Cash Flow Forecast YouTube Thumbnail.png

Download My Free Excel Cash Flow Forecast

How to Create a Business Plan in Excel

Business Plan Course

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

Xero link
  • Facebook
  • Youtube
  • Twitter
  • Instagram
  • Pinterest
  • TikTok

Visit SM Accounting - The Official Accounting Practice of The Bookkeeping Master

Other Pages: Privacy Policy - Testimonials - Website Directory
Email: info@bpfs-online.com

​

© 2015-2027 FreeBookkeepingAccounting.com, The Bookkeeping Master, SM Web Capital Ltd

download.png

Disclaimer

These tutorials are designed to help you understand bookkeeping and accounting principles. We review our educational materials periodically to maintain their accuracy. For individual accounting or tax advice, please consult a qualified professional.

Qualified with the AAT and ICB. See other accounting bodies: AICPA, CPA Canada, CPA Australia, AICPA & CIMA, ACCA, ICAEW.

​

This website and The Bookkeeping Master are professionals in accounting and bookkeeping.

bottom of page