MO220 exam prep: Microsoft Excel for Accounting

MO-220 exam prep: Microsoft Excel for Accounting
Published 10/2025
Duration: 5h 48m | .MP4 1920×1080 30 fps(r) | AAC, 44100 Hz, 2ch | 3.57 GB

What you’ll learn
– Perform Accounting Data for Analysis
– Prepare a Trial Balance
– Prepare and Analyze Financial Statements
– Perform Routine Accounting Activities

Requirements
– Before beginning, you will need to know how to use a Windows computer, including a mouse.
– It would be good if you have used Microsoft Excel before, but this is not essential.
– You should have MS Excel (or Office) 2021 or later installed on your PC computer. This program is also known as a Microsoft 365 App.

Description
The Microsoft MO-220 certification is the new certification for Excel for Accounting. Microsoft says that this certification demonstrates that you have the skills needed to get the most out of Excel by earning aMicrosoft Office Specialist: Excel for Accounting Associatecertification.

In this course, we will look at all of the topics in the MO-220 certification.

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.

Please note: I will not be able to comment on accounting rules to your specific situation, as they can vary from country to country and from state to state. If you want any comments about accounting for your specific situation, please contact an accounting professional near you.

In this MO-220 exam preparation course:

Finally, we’ll perform accounting activities. We’ll prepare amortization schedules and bank reconciliations, manage accounts receivable and payable, perform payroll activities, and create depreciation schedules.

No prior knowledge is required.

Once you have completed this course, you will have an expanded knowledge of Microsoft Excel. With some practice, you could even take the official Microsoft MO-220 exam, which gives you the "Microsoft Office Specialist: Excel for Accounting Associate" certificate.This would look good on your CV or resume.

Who this course is for:
– This course is for you if you want to develop your Microsoft Excel skills with regards to accounting data.
– This course will use the latest version of Excel, but is also for you if you use any modern version – Excel 2007, 2010, 2013, 2016 or 2019.
– This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft specialist with accounting data, if you wish to do so.
– You will cover the content tested in the Microsoft Office Specialist Exam MO-220 "Excel for Accounting Associate"
More Info