Learning Objectives:

Participants will learn how to keep proper ‘Books’ on their computer and demonstrate and practice setting up bookkeeping spread-sheets and using basic Excel formula for greater efficiency.

Participants will also be shown how to calculate VAT and a Profit and Loss account by linking to the bookkeeping spreadsheets.

Course Content:

• Management of folders for saving the spreadsheets
• Spreadsheet set-up for bookkeeping
• Setting Templates
• Recording Sales, Purchases, VAT and Bank transactions
• Using Excel formula – Auto-sum, adding ranges, multiply, divide, percentages etc
• Managing, formatting & linking sheets
• Page set-up for reporting and printing
• Protecting sheets with passwords

 Note:- participants must be familiar with the Excel package and bring a laptop each morning.