By the end of this course, you will be able to:

• Outline the importance of bookkeeping and its links to accounting
• Define ‘assets’, ‘liabilities’, ‘revenue and ‘expenditure’
• Explain the principles of the sales tax
• Outline the importance of an invoice and identify its important details
• Describe the purpose and primary data information offered by a financial statement
• State the role of the Accounts Receivable (AR) department
• Outline the purpose of ‘cross totting’ and ‘creditor reconciliation’
• Discuss the process of recording sales, credits, purchases and returns in daybooks
• Describe the purchasing process and the documents involved
• Discuss the process for approving a purchase invoice

By the end of this course, you will be able to:

• Describe how to raise petty cash vouchers
• Explain how to enter petty cash transactions to the petty cash daybook
• Describe how to close the daybook and calculate the balance carried down
• Recall how to reconcile the petty cash
• Describe how to replenish the petty cash
• Recognize how to check remittance advice
• Explain about entering payments and receipts to the 3 column and analysis cash book
• Describe how to close the cash book and calculate the balance carried down
• Identify how to reconcile the bank

By the end of this course, you will be able to:

• Explain how double-entry transactions work
• Describe the process for preparing and recording transactions in T-accounts
• Identify the steps involved in transferring sales and sales return transactions from the daybooks
• List the steps to transfer purchase and purchase returns transactions to the general ledger and control accounts
• Discuss the reason for transferring the left and the right side of the cash books to the general ledgers
• Explain what happened when you close the control accounts

By the end of this course, you will be able to:

• Describe the process used to manage the journal day books
• Discuss the need to collect taxes
• Outline how to prepare a payroll journal from gross and net pay
• Explain what control accounts are used for
• Describe the process for creating and maintaining control accounts
• List the steps needed to prepare a trial balance
• Identify possible issues when the trial balance does not balance

By the end of this course, you will be able to:

• Explain how to open, save and navigate a workbook
• Discuss why you would edit the quick access toolbar
• Explain how to copy, cut and paste your data
• List the different Autofill options available and their uses
• Discuss the use of Freeze panes
• List the different elements that can be inserted into a workbook and how they can be presented
• Discuss the use of different views when using worksheets
• Outline the purpose and process of sorting and filtering data
• Outline the steps involved in previewing and printing a table

Distinguish between different chart types in Excel

• Explain the use of the different chart types in Excel
• Identify and format chart elements
• Summarize data with common charts
• Summarize data with less common charts
• Recognize the differences between good and bad chart design

By the end of this course, you will be able to:

• Solve problems and carry out logical tests and ‘IF’ statements
• Explain and carry out different types of lookups
• Calculate ‘SUM’ with multiple criteria
• Explain and demonstrate the benefits of working with tables
• Analyze data with pivot tables

By the end of this course, you will be able to:

• Distinguish between Web1, Web2 and Web3
• Describe how a blockchain works
• Classify wallets as hot, cold, custodial and non-custodial
• Explain the role of a miner
• Identify and recognise transactions on a blockchain explorer
• Explain smart contracts
• Describe Decentralised Finance and Non-Fungible tokens
• Distinguish between Fungible and Non-Fungible assets
• Discuss how to buy and sell cryptocurrency with fiat (traditional currency)
• Describe the difference between a swap or DEX and a central exchange
• Explain how to use a swap