MO-220 exam prep: Microsoft Excel for Accounting

Learn the skills for the new MO-220 Excel certification. Use Data Validation, Formula Auditing, create charts and more!

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:

We'll start by preparing accounting data for analysis. We'll import and export data, clean data, verify accounting data integrity, and transform accounting data.

We'll then Prepare a Trial Balance and Prepare and Analyze Financial Statements. These are Balance Sheets and Income Statements, also known as Profit and Loss Statements (P&L) or Statements of Earning. We'll organize accounting transactions and financial data using Excel functions, prepare and analyze financial statements, correct errors, and present information visually using PivotTables, dashboards and charts.

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"
- This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.
More Info