Computer Tutoring Logo
Est. 2002
Menu Button

Excel Accounts Tutorials

Accounts Tutorial Pt.1

Topics Covered:

In this Excel accounts tutorial you will see how to set up a spreadsheet to do simple accounts in Excel. So regardless of what profession you are in or if you want to add basic book keeping to your skills, in 15 minutes you will see the best way to set up an excel spreadsheet for book keeping.

  • Introduction to Basic Excel Terminology
  • How to Correctly Enter Dates in Excel?
  • Changing Numbers into Currency
  • How to Enter and Add up Expenses?
  • How to Enter and Add up Receipts?
  • How to Work out your Balance?
  • How to Work out a Running Total?

After you've watched see how much you can remember by taking quiz below.

Accounts Tutorial Pt.2

Topics Covered:

Exercise File Download - Should you want to follow along.

Want to know how to make your acccounts look good in Excel? This tutorial will show you how to format an Excel spreadsheet. You will learn:

  • Merge and Centre Cells
  • Change Background Colour
  • How to Change Font in Excel Sheet
  • Change Width in Excel for Multiple Columns
  • Drawing Lines in Excel
  • How to Freeze Panes in Excel
  • Excel Format Painter Multiple Cells

Step by Step written instructions

After you've watched the above tutorial see how much your remember.

Accounts Tutorial Pt.3

Topics Covered:

Released: Monday 11th January @11am

This simple short accounts tutorial will show you how to calculate VAT in Excel. You will see the formula you need to use to work out the net from the Gross and the Gross from the net.

  • How to Calculate the Gross from the Net
  • Working out the Net from the Gross
  • Referring to Cells so that you can update the VAT rate

Next - Integrating VAT into Accounts

Topics Covered:

In this Excel Accounts tutorial you will see how to integrate the VAT formula into the accounts spreadsheet you have been developing throughout this course.

Join mailing list!

Sign up to receive our monthly newsletter including special promotions, hints & tips, and the latest Computer Tutoring news! (we promises not to bombard you with emails, just 1 per month!)