80
LESSONS
ALL
SKILL LEVEL
7:04 hr
DURATION
ENGLISH
AUDIO
TBA
SUBTITLES
OVERVIEW
This course takes you through the skills required for the new Microsoft Excel MO-220 exam.
We will be preparing financial statements – these are trial balances, balance sheets, and income statements (also known as Profit and Loss Statements or P&L, and Statement of Earnings).
There are plenty of Practice Activities throughout this course, so you can be sure that you are learning.
WHO IS THE COURSE FOR?
This course is for anybody who wants to develop Microsoft Excel skills with accounting. No prior knowledge is required.
This course covers the skills requirements for the official Microsoft certification MO-220.
This course will use Excel version 2509, but is also accessible with any modern version – Excel 2007, 2010, 2013, 2016, 2019, 2022.
This course is NOT for you if you want to learn Excel for Mac.
LEARNING PATH
PREPARE ACCOUNTING DATA FOR ANALYSIS
- Import and export data
- Clean data
- Verify data integrity, including using Data Validation rules
- Transform data, including using text and date functions
PREPARE A TRIAL BALANCE
- Organize transactions
- Organize data using math, logical and lookup functions
PREPARE AND ANALYZE FINANCIAL STATEMENTS
- Aggregating data
- Calculating ratios
PRESENTING DATA
- Conditional Formatting
- Formula Auditing
- PivotTables
- Dashboards and charts
LOANS AND DEPRECIATION
- Create amortization schedules
- Calculate periodic depreciation
- Project future depreciation
PERFORM ROUTINE ACCOUNTING ACTIVITIES
- Prepare bank reconciliations
- Manage accounts receivable and payable
- Create payable aging reports
- Perform payroll activities
