- Self-Paced Online learning
- 24/7 Online Support
- 14 Days Money Back Guarantee
- Fully Accredited Courses
Professional Bookkeeper Training & MS Excel Mastery
Overview
UK finance recruitment remains active: Hays says it registers over 1,500 new finance roles monthly, showing demand for accounts support. Many beginners understand numbers, but weak bookkeeping systems, Excel confidence and transaction records can make workplace finance feel stressful.
The Professional Bookkeeper Training Course UK turns that challenge into online learning. This CPD bookkeeping and MS Excel course covers bookkeeping basics, accounts organisation, spreadsheets, formulas, data entry, transaction tracking, invoice records, payroll awareness, financial reporting, reconciliation and business finance support. With voice-over lessons, visual content, quick assessments and instant feedback, it suits beginners, office staff, finance learners, small business owners, admin workers and career changers.
Study flexibly from any internet-connected device and prepare for Bookkeeper, Accounts Assistant, Finance Assistant, Payroll Administrator and Accounting Technician roles.
Key Benefits Included
► Accredited by CPD
► Endorsed by QLS (Quality Licence Scheme)
► Instant Access
► 24/7 Learning Assistance
► Self-paced learning and laptop, tablet, smartphone-friendly
► Fully online, interactive course with audio voiceover
► Developed by qualified professionals in the field
Learning Outcomes
This course builds bookkeeping, MS Excel, financial record, spreadsheet and accounting support knowledge for learners entering finance admin roles online.
By the end of this course, learners will be able to:
► Explain basic bookkeeping tasks used in business finance support roles.
► Use MS Excel to organise financial records and simple spreadsheets.
► Record transactions, invoices and payments with better accuracy online.
► Apply spreadsheet formulas to support bookkeeping and finance admin tasks.
► Recognise payroll, reconciliation and reporting concepts in workplace accounts.
► Build confidence for bookkeeping, accounts and finance assistant career routes.
Who is This Course For?
This course suits learners who want online bookkeeping and MS Excel training for finance support, admin work or small business records.
► Beginners wanting to learn bookkeeping and Excel basics from home.
► Office administrators managing records, invoices and simple finance tasks online.
► Small business owners organising income, expenses and spreadsheet records confidently.
► Finance learners preparing for accounts assistant or bookkeeping support roles.
► Career changers entering finance admin, payroll or accounts office routes.
► Excel users improving spreadsheet confidence for bookkeeping and reporting tasks.
Certification
CPD Certification
After successfully completing the assessment of this Professional Bookkeeper Training & MS Excel Mastery course, you can apply for the CPD accredited certificates.
PDF certificate: £9.99
Hardcopy certificate: £15.99
Endorsed Certificate of Achievement from the Quality Licence Scheme
Upon successful completion of the Professional Bookkeeper Training & MS Excel Mastery course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of —
►129 GBP within UK
► 139 GBP for International Delivery — Postal Fees Included
Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses
Career Opportunities
This course supports UK bookkeeping, accounting, payroll and finance admin routes where Excel knowledge, record keeping and accounts support can support career growth.
► Bookkeeper — Average UK salary: £24,000–£35,000 per year
► Accounts Assistant — Average UK salary: £27,500–£32,500 per year
► Finance Assistant — Average UK salary: £22,000–£32,000 per year
► Payroll Administrator — Average UK salary: £22,000–£35,000 per year
► Accounting Technician — Average UK salary: £24,000–£35,000 per year
► Credit Controller — Average UK salary: £21,000–£32,000 per year
► Purchase Ledger Clerk — Average UK salary: £26,000–£32,750 per year
Course Curriculum
The course covers a wide range of essential topics, including:
QuickBooks
► The Structure of the Course – First Things First!
► Set Up Free Trial
► Starting a New Company File
► Set Up Nominal Accounts
► Enter Opening Balances
► Reverse Opening Balances – Accruals and Prepayments
► Report Journal
► Amend the Nominal Ledger
► Report Listing the Nominal Ledgers
► Enter Customers
► Report on Customer Contact Information
► Enter Suppliers
► Supplier Contact List
► Enter Invoices
► Invoice Entering
► Invoice Batch
► Post Sales Credit Notes
► Report Showing Customer Activity
► Aged Debtors
► Post Supplier Invoices
► Entering a Batch of Supplier Bills
► Credit Notes Suppliers
► Reclassify Supplier Bills – Flash Bulbs Purchased
► Supplier Account Activity Report
► Post Cheques
► Report Showing Supplier Payments
► Receipts from Customers
► Report Showing Customer Receipts
► 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 Return
► Reconcile the Bank
► Provide a Report Showing Any Unreconciled Transaction
► Post the Wages Journal
► Posting Journal Adjustments
► Month End Adjustments
► Month End Reports
► Task – Clearing the Accounts
► Task – Customer Report
► Course Paper
► Further Reading – QuickBooks Online 2014: The Handbook
Xero Accounting
► Introduction to the Course and Your Tutor
► Activating Your Free Trial with Xero
► Signing Up for the Free Trial
► Create the Organisation
► The Fictitious Scenario
► Add Bank Accounts to the System
► Enter Opening Balances
► Opening Trial Balance
► Amend the Nominal Ledger
► Chart of Accounts Report
► Enter Customers
► Reporting Customer and Supplier Information
► 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 Supplier Invoices 6028 Onwards
► Enter More Supplier Invoices No. 4308 Onwards
► Credit Notes Suppliers
► Supplier Activity Report
► Aged Creditors Info
► Receipts from Customers
► Apply Customer Credit Notes
► Post Supplier Cheques
► Apply Supplier Credit Notes
► Print List of Bank Receipts and Payments
► Post Sundry Payments
► Make a Credit Card Payment
► 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
► Writing Off a Bad Debt – Print Customer Statement
► Write Off a Bad Debt
► Reconcile the Credit Card Statement
► Bank Statement as a CSV File
► Bank Statement Closing Balances
► Reconcile the Petty Cash
► Wages and Salaries
► Post the Wages Journal
► Report Wages Journal
► Payday
► Pay the Two Staff
► Depreciation
► VAT Return
► Month End Reports – PnL, BS, TB
► Using Payroll
► Setting Up Employees
► Running Payroll – An Example
► Recap and Next Steps
► What Happens Next
Microsoft Excel 2016
► Navigate the Excel User Interface
► Use Excel Commands
► Create and Save a Basic Workbook
► Enter Cell Data
► Use Excel Help
► Create Worksheet Formulas
► Insert Functions
► Reuse Formulas and Functions
► Insert, Delete and Adjust Cells, Columns and Rows
► Search for and Replace Data
► Use Proofing and Research Tools
► Apply Text Formats
► Apply Number Format
► Align Cell Contents
► Apply Styles and Themes
► Apply Basic Conditional Formatting
► Create and Use Templates
► Preview and Print a Workbook
► Set Up the Page Layout
► Configure Headers and Footers
► Manage Worksheets
► Manage Workbook and Worksheet Views
► Manage Workbook Properties
► Work with Ranges
► Use Specialised Functions
► Work with Logical Functions
► Work with Date and Time Functions
► Work with Text Functions
► Sort Data
► Filter Data
► Query Data with Database Functions
► Outline and Subtotal Data
► Welcome to the Course
► Apply Intermediate Conditional Formatting
► Apply Advanced Conditional Formatting
► Create Charts
► Modify and Format Charts
► Use Advanced Chart Features
► Create a PivotTable
► Analyse PivotTable Data
► Present Data with PivotCharts
► Filter Data by Using Timelines and Slicers
► Use Links and External References
► Use 3-D References
► Consolidate Data
► Use Lookup Functions
► Trace Cells
► Watch and Evaluate Formulas
► Collaborate on a Workbook
► Protect Worksheets and Workbooks
► Apply Data Validation
► Search for Invalid Data and Formulas with Errors
► Work with Macros
Module 51: Creating Sparklines and Mapping Data
► Create Sparklines
► Map Data
► Determine Potential Outcomes Using Data Tables
► Determine Potential Outcomes Using Scenarios
► Use the Goal Seek Feature
► Forecasting Data Trends
Excellent
4.8 Average - 15 Reviews
Course Curriculum
| **Quickbook** | |||
| Getting prepared - access the software and course materials | |||
| The structure of the course – first things first! | 00:05:00 | ||
| Set up free trial | 00:03:00 | ||
| Getting started | |||
| Starting A New Company File | 00:11:00 | ||
| Setting up the system | |||
| set up nominal accounts | 00:11:00 | ||
| Enter opening balances | 00:02:00 | ||
| Reverse opening balances – accruals and prepayments | 00:06:00 | ||
| Report Journal | 00:05:00 | ||
| Nominal ledger | |||
| Amend The Nominal Ledger | 00:07:00 | ||
| Report listing the nominal ledgers | 00:02:00 | ||
| Customers | |||
| Enter customers | 00:09:00 | ||
| Report on customer contact information | 00:01:00 | ||
| Suppliers | |||
| Enter Suppliers | 00:05:00 | ||
| Supplier Contact List | 00:02:00 | ||
| Sales ledger | |||
| Enter Invoices | 00:09:00 | ||
| Invoice Entering | 00:03:00 | ||
| Invoice batch | 00:06:00 | ||
| Post Sales Credit Notes | 00:08:00 | ||
| Report showing Customer Activity | 00:03:00 | ||
| Aged Debtors | 00:02:00 | ||
| Purchases ledger | |||
| Post Supplier Invoices | 00:03:00 | ||
| Entering a Batch of Supplier Bills | 00:09:00 | ||
| Credit Notes Suppliers | 00:05:00 | ||
| Reclassify Supplier Bills – Flash Bulbs Purchased | 00:04:00 | ||
| Supplier Account Activity Report | 00:04:00 | ||
| Sundry payments | |||
| Post Cheques | 00:07:00 | ||
| Report showing supplier payments | 00:01:00 | ||
| Sundry receipts | |||
| Receipts from customers | 00:07:00 | ||
| Report showing customer receipts | 00:02:00 | ||
| Petty cash | |||
| Post Petty Cash Transactions and Report | 00:04:00 | ||
| Post cash payments to ledgers | 00:02:00 | ||
| Enter petty cash items | 00:14:00 | ||
| Report on Petty Cash Payments Proper | 00:05:00 | ||
| Post Sundry Payments | 00:05:00 | ||
| Report Bank Payments | 00:03:00 | ||
| VAT - Value Added Tax | |||
| VAT Return | 00:03:00 | ||
| Bank reconciliation | |||
| Reconcile The Bank | 00:10:00 | ||
| Provide A Report Showing Any Unreconnciled Transaction | 00:02:00 | ||
| Payroll / Wages | |||
| Post the Wages Journal | 00:08:00 | ||
| Posting Journal Adjustments | 00:02:00 | ||
| Reports | |||
| Month end adjustments | 00:03:00 | ||
| Month end reports | 00:06:00 | ||
| Tasks | |||
| Task- Crearing the accounts | 00:06:00 | ||
| Task – Customer report | 00:01:00 | ||
| Additional Resources | |||
| Course Paper | 00:00:00 | ||
| Further Reading – QuickBooks Online 2014 The Handbook | 00:00:00 | ||
| **Xero Accounting** | |||
| Getting Prepared - Access the software and course materials | |||
| Introduction To The Course And Your Tutor | 00:04:00 | ||
| Activating Your Free Trial With Xero | 00:02:00 | ||
| Getting started | |||
| Signing Up For The Free Trial | 00:04:00 | ||
| Create The Organisation | 00:08:00 | ||
| The Ficticious Scenario | 00:02:00 | ||
| Setting up the system | |||
| Add Bank Accounts To The System | 00:14:00 | ||
| Enter Opening Balances | 00:07:00 | ||
| Opening Trial Balance | 00:01:00 | ||
| Nominal ledger | |||
| Amend The Nominal Ledger | 00:06:00 | ||
| Chart Of Accounts Report | 00:01:00 | ||
| Customers & Suppliers | |||
| Enter customers | 00:07:00 | ||
| Reporting Customer And Supplier Information | 00:02:00 | ||
| Sales ledger | |||
| Enter Invoices | 00:07:00 | ||
| Invoicing tips – adding logo, repeat billing | 00:09:00 | ||
| Entering Invoices 6574 to 6610 | 00:16:00 | ||
| Post Credit Notes | 00:03:00 | ||
| Report Showing Customer Activity | 00:08:00 | ||
| Aged Debtors | 00:02:00 | ||
| Suppliers | |||
| Post supplier invoices | 00:09:00 | ||
| Enter suppliers invoices 6028 onwards | 00:14:00 | ||
| Enter More Supplier Invoices No 4308 Onwards | 00:06:00 | ||
| Credit Notes Suppliers | 00:02:00 | ||
| Supplier Activity Report | 00:04:00 | ||
| Aged Creditors Info | 00:01:00 | ||
| Reciepts from Customers | 00:10:00 | ||
| Apply Customer Credit Notes | 00:05:00 | ||
| Purchases ledger | |||
| Post Supplier Cheques | 00:08:00 | ||
| Apply Supplier Credit Notes | 00:03:00 | ||
| Print List Of Bank Receipts And Payments | 00:01:00 | ||
| Sundry payments | |||
| Post Sundry Payments | 00:07:00 | ||
| Make a credit card payment | 00:08:00 | ||
| Sundry payments | |||
| Post Sundry Payments | 00:07:00 | ||
| Make a credit card payment | 00:08:00 | ||
| Petty Cash | |||
| Add Petty Cash Transactions – Week 1 | 00:16:00 | ||
| Add Petty Cash Transactions – Week 2 | 00:12:00 | ||
| Add Petty Cash Transactions – Week 3 | 00:07:00 | ||
| Add Petty Cash Transactions – Week 4 | 00:09:00 | ||
| Imprest System on Petty Cash | 00:04:00 | ||
| Print a Copy of Petty Cash Receipts and Payments | 00:01:00 | ||
| Bad Debt | |||
| Writing Off A Bad Debt – Print Customer Statement | 00:02:00 | ||
| Write Off A Bad Debt | 00:09:00 | ||
| Credit Card | |||
| Reconcile The Credit Card Statement | 00:09:00 | ||
| Bank Reconciliation | |||
| Bank Statement As A CSV File | 00:27:00 | ||
| Bank Statement Closing Balances | 00:11:00 | ||
| Reconcile The Petty Cash | 00:05:00 | ||
| Payroll / Wages | |||
| Wages And Salaries | 00:09:00 | ||
| Post the Wages Journal | 00:07:00 | ||
| Report Wages Journal | 00:02:00 | ||
| Payday | 00:11:00 | ||
| Pay The Two Staff | 00:05:00 | ||
| VAT - Value Added Tax | |||
| Depreciation | 00:04:00 | ||
| VAT Return | 00:03:00 | ||
| Reports | |||
| Month End Reports PnL, BS, TB | 00:05:00 | ||
| Payroll unit | |||
| Using Payroll | 00:12:00 | ||
| Setting Up Employees | 00:10:00 | ||
| Running Payroll – An Example | 00:14:00 | ||
| Conclude | |||
| Recap And Next Steps | 00:06:00 | ||
| What happens next | 00:02:00 | ||
| **Microsoft Excel 2016** | |||
| Getting Started with Microsoft Office Excel 2016 | |||
| Navigate the Excel User Interface | 00:28:00 | ||
| Use Excel Commands | 00:10:00 | ||
| Create and Save a Basic Workbook | 00:19:00 | ||
| Enter Cell Data | 00:12:00 | ||
| Use Excel Help | 00:05:00 | ||
| Performing Calculations | |||
| Create Worksheet Formulas | 00:15:00 | ||
| Insert Functions | 00:17:00 | ||
| Reuse Formulas and Functions | 00:17:00 | ||
| Modifying a Worksheet | |||
| Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
| Search for and Replace Data | 00:09:00 | ||
| Use Proofing and Research Tools | 00:07:00 | ||
| Formatting a Worksheet | |||
| Apply Text Formats | 00:16:00 | ||
| Apply Number Format | 00:07:00 | ||
| Align Cell Contents | 00:09:00 | ||
| Apply Styles and Themes | 00:12:00 | ||
| Apply Basic Conditional Formatting | 00:11:00 | ||
| Create and Use Templates | 00:08:00 | ||
| Printing Workbooks | |||
| Preview and Print a Workbook | 00:10:00 | ||
| Set Up the Page Layout | 00:09:00 | ||
| Configure Headers and Footers | 00:07:00 | ||
| Managing Workbooks | |||
| Manage Worksheets | 00:05:00 | ||
| Manage Workbook and Worksheet Views | 00:07:00 | ||
| Manage Workbook Properties | 00:06:00 | ||
| Working with Functions | |||
| Work with Ranges | 00:18:00 | ||
| Use Specialized Functions | 00:11:00 | ||
| Work with Logical Functions | 00:23:00 | ||
| Work with Date & Time Functions | 00:08:00 | ||
| Work with Text Functions | 00:11:00 | ||
| Working with Lists | |||
| Sort Data | 00:10:00 | ||
| Filter Data | 00:10:00 | ||
| Query Data with Database Functions | 00:09:00 | ||
| Outline and Subtotal Data | 00:09:00 | ||
| Analyzing Data | |||
| Welcome to the Course | FREE | 00:03:00 | |
| Apply Intermediate Conditional Formatting | 00:07:00 | ||
| Apply Advanced Conditional Formatting | 00:05:00 | ||
| Visualizing Data with Charts | |||
| Create Charts | 00:13:00 | ||
| Modify and Format Charts | 00:12:00 | ||
| Use Advanced Chart Features | 00:12:00 | ||
| Using PivotTables and PivotCharts | |||
| Create a PivotTable | 00:13:00 | ||
| Analyze PivotTable Data | 00:12:00 | ||
| Present Data with PivotCharts | 00:07:00 | ||
| Filter Data by Using Timelines and Slicers | 00:11:00 | ||
| Working with Multiple Worksheets and Workbooks | |||
| Use Links and External References | 00:12:00 | ||
| Use 3-D References | 00:06:00 | ||
| Consolidate Data | 00:05:00 | ||
| Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | 00:12:00 | ||
| Trace Cells | 00:09:00 | ||
| Watch and Evaluate Formulas | 00:08:00 | ||
| Sharing and Protecting Workbooks | |||
| Collaborate on a Workbook | 00:19:00 | ||
| Protect Worksheets and Workbooks | 00:08:00 | ||
| Automating Workbook Functionality | |||
| Apply Data Validation | 00:13:00 | ||
| Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
| Work with Macros | 00:18:00 | ||
| Creating Sparklines and Mapping Data | |||
| Create Sparklines | 00:07:00 | ||
| MapData | 00:07:00 | ||
| Forecasting Data | |||
| Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
| Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
| Use the Goal Seek Feature | 00:04:00 | ||
| Forecasting Data Trends | 00:05:00 | ||
Certificate of Achievement
Upon completion, you will receive a CPD-accredited certificate recognised globally. Choose from:
Pdf Certificate & Transcript £7.99
Hardcopy Certificate & Transcript £17.99
This certification validates your knowledge and skills, boosting your employability in healthcare.
Course Reviews
No Reviews found for this course.
The Professional Bookkeeper Training Course UK is an online CPD course covering bookkeeping, accounting software and Microsoft Excel. Learners can study financial records, invoices, payments, VAT, payroll awareness, reconciliation and spreadsheets for accounts support and office finance roles.
The Professional Bookkeeper Training Course UK is an online CPD course covering bookkeeping, accounting software and Microsoft Excel. Learners can study financial records, invoices, payments, VAT, payroll awareness, reconciliation and spreadsheets for accounts support and office finance roles.
Yes, this course is suitable for beginners who want to learn bookkeeping from the start. It explains key finance tasks through QuickBooks, Xero Accounting and Excel lessons, making it useful for office staff, small business owners and career changers.
You will learn customer and supplier records, sales invoices, supplier bills, petty cash, VAT returns, payroll journals, bank reconciliation and month-end reporting. The course also covers Excel formulas, functions, PivotTables, charts and workbook management for finance tasks.
Yes, the course includes Microsoft Excel training for bookkeeping and finance support. Learners can study formulas, functions, data sorting, filtering, charts, PivotTables, lookup functions, worksheet protection, macros, data validation and forecasting tools.
This course can support learning for roles such as Bookkeeper, Accounts Assistant, Finance Assistant, Payroll Administrator, Purchase Ledger Clerk, Credit Controller and Accounting Technician. Career progress depends on practical experience, wider qualifications and employer expectations.
Access
Level
Number of Units
Duration
Course Type