50
LESSONS
ALL
SKILL LEVEL
4:51 hr
DURATION
ENGLISH
AUDIO
TBA
SUBTITLES
OVERVIEW
This course takes you through the skills required for the new Microsoft Excel MO-230 exam.
WHO IS THE COURSE FOR?
This course is for anybody who wants to develop Microsoft Excel skills with business finance. No prior knowledge is required.
This course covers the skills requirements for the official Microsoft certification MO-230.
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
PERFORM FINANCIAL ANALYSIS
- Horizontal and vertical analysis
- Calculate budget/actual variance
- Financial metrics and pricing analysis
- Financial ratios
- Time value of money calculations
- Formula Auditing features
PERFORM LOAN AND INVESTMENT ANALYSIS
- Create amortization schedules
- Analyze loan scenarios
- Calculate bond prices and yields
- Create stock valuation models
CREATE FINANCIAL FORECASTS
- Predict future performance using a Forecast Sheet
- Prepare financial projects
- Apply What-If Analysis
- Create dashboards and charts
