Learn the skills for the new MO-220 Excel certification. Use Data Validation, Formula Auditing, create charts and more!
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 a Microsoft Office Specialist: Excel for Accounting Associate certification.
What you’ll learn
- Perform Accounting Data for Analysis.
- Prepare a Trial Balance.
- Prepare and Analyze Financial Statements.
- Perform Routine Accounting Activities.
Course Content
- Introduction –> 6 lectures • 13min.
- Importing/exporting data, and cleaning accounting data –> 9 lectures • 1hr 4min.
- Verify accounting data integrity, and transform accounting data –> 6 lectures • 31min.
- Using text and date functions –> 6 lectures • 34min.
- Manipulating accounting data –> 11 lectures • 1hr 7min.
- Preparing and analyzing financial statements in Excel –> 11 lectures • 1hr 5min.
- Correct errors and presenting information visually –> 9 lectures • 59min.
- Preparing amortization and depreciation schedules –> 8 lectures • 35min.
- Payroll activities, bank reconciliations, managing accounts receivable/payable –> 10 lectures • 48min.
- Well done for finishing the Excel course –> 2 lectures • 3min.
Requirements
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 a Microsoft Office Specialist: Excel for Accounting Associate certification.
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. This course completes with practice activities, so you can be sure that you are learning.
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.