Bookkeeper Training and MS Excel Course - CPD Accredited

Learn Bookkeeping and MS Excel Skills In 1 Course | Full Tutor Support | Instant Result | No Hidden Fees

One Education


Save 91%
£17 inc VAT (was £199)
Offer ends 11 April 2020
Study method
Online, self-paced
20 Hours
Access to content
12 Months
No formal qualification
12 CPD hours / points
Additional info
  • Tutor is available to students

2 students purchased this course


This comprehensive bundle course is specially designed to give our learners a more in-depth understanding of bookkeeping and equip them with the core skills required to fast track their career. By combining these CPD courses, we are ensuring our learners get the best out of their online studies and are fully prepared for the next step in their profession.

The Bookkeeper Training Course is for those who are new to the field and wish to gain a full understanding of the principles of bookkeeping and the role of a bookkeeper. This training certification covers the essential elements of managing financial transactions such as the purchase ledger, setting up nominal accounts, entering invoices and opening balances. This course also includes practical training on how to use QuickBooks accounting software. There are no entry requirements for this course.

Boost your efficiency in managing data and master everyday office tasks with The Microsoft Excel 2016 certification. Through this comprehensive training course, you will be a confident user of Microsoft Excel in no time, and no previous experience is required! This course covers all the basics, from navigating the interface, to modifying worksheets. Our instructor-led training units are suitable for beginners and those who want to improve their basic knowledge of this leading Office 365 program.

Highlights of The Bookkeeper Training and MS Excel Course:

  • Get step-by-step training on QuickBooks accounting software
  • Learn how to set up nominal accounts, enter opening balances and amend the nominal ledger
  • Understand the process for entering customer and supplier details
  • Familiarise with the functions of the purchase and sales ledger
  • Learn how to enter invoices and post sale credit notes
  • Be able to navigate the Excel user interface confidently
  • Familiarise with the fundamental functions and features of Microsoft Excel
  • Discover tips, tricks and shortcuts for managing administrative tasks in Excel
  • Learn how to perform basic calculations, analyse and forecast numerical data
  • Be able to work with multiple worksheets and modify them for your business’s needs


12 CPD hours / points
Accredited by CPD Accreditation Group

Course media


Course Curriculum

We’ve taken this comprehensive Bookkeeper Training and MS Excel Course and broken it down into 162 manageable units which we believe will assist you to easily grasp each concept – from the fundamental to the most advanced aspects of the accounts skills. It really is a sure pathway to success.

This course is designed with the following modules:


Getting prepared - access the software and course materials

  • The structure of the course – first things first!
  • Set up free trial

Getting started

  • Starting A New Company File

Setting up the system

  • set up nominal accounts
  • Enter opening balances
  • Reverse opening balances – accruals and prepayments
  • Report Journal

Nominal ledger

  • Amend The Nominal Ledger
  • Report listing the nominal ledgers


  • Enter customers
  • Report on customer contact information


  • Enter Suppliers
  • Supplier Contact List

Sales ledger

  • Enter Invoices
  • Invoice Entering
  • Invoice batch
  • Post Sales Credit Notes
  • Report showing Customer Activity
  • Aged Debtors

Purchases ledger

  • Post Supplier Invoices
  • Entering a Batch of Supplier Bills
  • Credit Notes Suppliers
  • Reclassify Supplier Bills – Flash Bulbs Purchased
  • Supplier Account Activity Report

Sundry payments

  • Post Cheques
  • Report showing supplier payments

Sundry receipts

  • Receipts from customers
  • Report showing customer receipts

Petty cash

  • Post Petty Cash Transactions and Report
  • Post cash payments to ledgers
  • Enter petty cash items
  • Report on Petty Cash Payments Proper
  • Post Sundry Payments
  • Report Bank Payments

VAT - Value Added Tax

  • VAT Return

Bank reconciliation

  • Reconcile The Bank
  • Provide A Report Showing Any Unreconnciled Transaction

Payroll / Wages

  • Post the Wages Journal
  • Posting Journal Adjustments


  • Month end adjustments
  • Month end reports


  • Task- Crearing the accounts
  • Task – Customer report

Additional Resources

  • Course Paper
  • Further Reading – QuickBooks Online 2014 The Handbook

**Xero Accounting**

Getting Prepared - Access the software and course materials

  • Introduction To The Course And Your Tutor
  • Activating Your Free Trial With Xero

Getting started

  • Signing Up For The Free Trial
  • Create The Organisation
  • The Ficticious Scenario

Setting up the system

  • Add Bank Accounts To The System
  • Enter Opening Balances
  • Opening Trial Balance

Nominal ledger

  • Amend The Nominal Ledger
  • Chart Of Accounts Report

Customers & Suppliers

  • Enter customers
  • Reporting Customer And Supplier Information

Sales ledger

  • Enter Invoices
  • Invoicing tips – adding logo, repeat billing
  • Entering Invoices 6574 to 6610
  • Post Credit Notes
  • Report Showing Customer Activity
  • Aged Debtors


  • Post supplier invoices
  • Enter suppliers invoices 6028 onwards
  • Enter More Supplier Invoices No 4308 Onwards
  • Credit Notes Suppliers
  • Supplier Activity Report
  • Aged Creditors Info
  • Reciepts from Customers
  • Apply Customer Credit Notes

Purchases ledger

  • Post Supplier Cheques
  • Apply Supplier Credit Notes
  • Print List Of Bank Receipts And Payments

Sundry payments

  • Post Sundry Payments
  • Make a credit card payment

Sundry payments

  • Post Sundry Payments
  • Make a credit card payment

Petty Cash

  • Add Petty Cash Transactions – Week 1
  • Add Petty Cash Transactions – Week 2
  • Add Petty Cash Transactions – Week 3
  • Add Petty Cash Transactions – Week 4
  • Imprest System on Petty Cash
  • Print a Copy of Petty Cash Receipts and Payments

Bad Debt

  • Writing Off A Bad Debt – Print Customer Statement
  • Write Off A Bad Debt

Credit Card

  • Reconcile The Credit Card Statement

Bank Reconciliation

  • Bank Statement As A CSV File
  • Bank Statement Closing Balances
  • Reconcile The Petty Cash

Payroll / Wages

  • Wages And Salaries
  • Post the Wages Journal
  • Report Wages Journal
  • Payday
  • Pay The Two Staff

VAT - Value Added Tax

  • Depreciation
  • VAT Return


  • Month End Reports PnL, BS, TB

Payroll unit

  • Using Payroll
  • Setting Up Employees
  • Running Payroll – An Example


  • Recap And Next Steps
  • What happens next

**Microsoft Excel 2016**

Getting Started with Microsoft Office Excel 2016

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help

Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions

Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

Formatting a Worksheet

  • Apply Text Formats
  • Apply Number Format
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

Printing Workbooks

  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers

Managing Workbooks

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

Working with Functions

  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions

Working with Lists

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

Analyzing Data

  • Welcome to the Course
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features

Using PivotTables and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers

Working with Multiple Worksheets and Workbooks

  • Use Links and External References
  • Use 3-D References
  • Consolidate Data

Using Lookup Functions and Formula Auditing

  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas

Sharing and Protecting Workbooks

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

Automating Workbook Functionality

  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros

Creating Sparklines and Mapping Data

  • Create Sparklines
  • MapData

Forecasting Data

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Who is this course for?

This course is suitable for aspiring bookkeepers who wish to gain relevant skills and practical knowledge to accelerate their professional development. It is also ideal for those who already work in this field but wish to develop their proficiency in Excel or test their general bookkeeping knowledge.


This course is compatible with all kinds of devices and the age requirement for this Bookkeeper Training and MS Excel Course is 16. So, basically, everyone can take this course to acquire this skills that are necessary.

Career path

On successful completion, learners will have the practical knowledge to explore relevant roles in this industry such as:

  • Junior Bookkeeper
  • Xero Bookkeeper
  • Accounting Manager
  • Accounts Assistant

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.


Currently there are no reviews for this course. Be the first to leave a review.


Mobile Navigation