Course Description

Language of Instruction:English|Category: Accounting: Business & Professional

Learning how to use Excel for Bookkeeping and Accounts is an excellent addition to your existing knowledge. It opens up the world of creativity and innovation on a spreadsheet.

This course is designed for professionals and business people, and will help them use Microsoft Excel for Bookkeeping and Accounts. Microsoft Excel is shipped with Microsoft Office and most computers in the world would have it installed by default. Microsoft Excel is also very cheap to buy if you do not have it already. Further, Excel is the leading spreadsheet software in the world with option to export/ import data in multiple formats. In addition, you would know the basics of Excel anyways. Hence, using Excel for Bookkeeping and Accounts not only saves you money and time, it also keeps your accounts and books that can be exported in other formats easily.

Excel, is one tool which you as a Bookkeeper or Accountants cannot do without.

It is a very fast recording tool in straight forward Accounting scenarios for Sole Traders, Partnerships and Limited Companies.

Excel can even do double entry and most of the time, when the conventional software people fails, Bookkeepers and Accountants resort to Excel.

This course exposes working environment practices, reports automation and provides a deeper understanding of Bookkeeping and Accounting, and Practical Experience is acquired.

What you will learn in this course:

• The use of excel for Bookkeeping and Accounts, as a cheaper substitute to commercial Bookkeeping and Account software.
• The formatting of excel for recording and automatic summarised reports.
• Faster Bookkeeping, where accounts are balanced by the spreadsheet.
• The different verification methods using Analysis Sheets, Row Error Search, Trial Balance, Big Change Review, Bank Reconciliation, Profitability Ratios, Annual Comparisons, Liquidity Ratios and Balance Sheet.
• The skills to format a spreadsheet and to automate the preparation of a VAT Return, Trial Balance, Profit and Loss Account, and Balance Sheet.
• Preparing opening balances and year end procedures.
• You will also be able to program a spreadsheet and get practical insights into how to manage accounts.

This is the only course teaching the comprehensive formatting of a spreadsheet, to produce a comprehensive list of Basic Reports.

This course is ideal for people who have just completed a Bookkeeping or Accounting course or know the basics of Bookkeeping and Accounting, and needs extra skills to process and analysis some tasks faster. This course gives them a competitive edge over others.

What’s in the box:

• 6 LIVE online classes
• 1 hour per class
• PDF tutorials available for review
• Assessment: submit a formatted spreadsheet
• Classes cannot be held after 7 PM GMT or before 7 AM GMT

Learn the following in Excel for Bookkeeping and Accounting Course:

• Opening Balances
• Income and Receipts Analysis
• Purchases and Payments Analysis
• Income and Receipts Summary
• Purchases and Payments Summary
• The Vat Sheet
• The Assets Summary
• Liabilities and Drawings Summary
• The Trial Balance
• The Profit And Loss Account
• The Balance Sheet
• Hyperlinks and Guides
• Recording Opening Balances
• Recording Income and Receipts
• Recording Purchases and Payments
• Verification and Correction
• The Year End

About the teacher:

Moses is a ACCA member and holds a Bachelors Degree in Education, and Diploma in Business Administration. He is currently developing the Practical Bookkeeping and Accounting Courses after having worked in the Accounting Practice for the past 7 years. He has been teaching for over 20 years. He is also a published author of 3 books, available on Amazon:

1. The Practical Accounting Processes, by Moses Bakaluba,
2. Practical & Computerised Accounts Training, by Moses Bakaluba,
3. Excel Bookkeeping & Accounting, by Moses Bakaluba