

While working in finance in 2010, she noticed a skills gap among accountants in the area of Excel. This motivated her to produce her first Excel course, which was aimed at accounting professionals looking to upskill. This desire to teach soon grew into the enormously successful Excel Club, which now caters to over 90,000 students across 168 different countries. In 2020 and 2021, her expe

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
- Describe how to replenish the petty cash
- Describe how to close the cash book and calculate the balance carried down
- Recall how to reconcile the petty cash
- Recognize how to check remittance advice
- Explain about entering payments and receipts to the 3 column and analysis cash book
- 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
- 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
- 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

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
- Explain the role of a miner
- Explain smart contracts
- 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
- Classify wallets as hot, cold, custodial and non-custodial
- Identify and recognise transactions on a blockchain explorer
- Describe Decentralised Finance and Non-Fungible tokens






Frequently Asked Questions
Once you have completed your purchase, your Digital Certificate/Digital Diploma and Transcript can be downloaded from the Dashboard of your Alison Account.
I access Alison via my computer:
Expand the Your Completed Courses & Claimed Certificates widget in your dashboard as shown below:
You will then be able to download your Digital Certificate/Diploma and Transcript. 
I access Alison via my Mobile Browser:
Expand the Your Completed Courses & Claimed Certificates widget in your Dashboard as shown below:
You will then be able to download your Digital Certificate/Diploma and Transcript. 
I access Alison via App:
Open My Certificates in your Dashboard, as shown in the example below:

You will then be able to download your Digital Certificate/Diploma and Transcript.

Continuing Professional Development, or CPD, is the process of continually developing or maintaining your professional skills. CPD helps individuals focus on how they can become a more competent and effective professional. Due to our rigorous publishing review process, courses on Alison are now being accredited by CPD UK, an independent organisation. Accredited CPD training means the learning activity has reached the required Continuing Professional Development standards and benchmarks, and the learning value has been scrutinised to ensure integrity and quality. This CPD Certification Service provides recognised independent CPD accreditation compatible with global CPD requirements. This means a certificate from a course on Alison can now be used as part of your CPD requirements (please check with your organisation’s guidelines). You can find out more about Alison accreditation here.
Users can pay a nominal fee to automatically download Digital Certificates or purchase paper or framed Certificates that are shipped via mail. For a more detailed list of the costs, visit the Shop page.













