Excel Expert for the MOS Exam (MO-211)
Advanced Excel skills: workbook options, advanced data management, advanced formulas and macros, and advanced charts and PivotTables.
MSBA-175 12 lessons planned ▶ Video lessons coming soon
Offered by HSM University · Microsoft Certification Prep
Course content
- 1Workbook options and protectionComing
- 2Managing and preparing dataComing
- 3Advanced conditional formattingComing
- 4Data validationComing
- 5Logical functions: IFS, SWITCH and nested formulasComing
- 6Lookup functions: XLOOKUP and INDEX/MATCHComing
- 7Dynamic arrays and LETComing
- 8Date, financial and statistical functionsComing
- 9What-if analysis and Goal SeekComing
- 10PivotTables and PivotChartsComing
- 11Advanced charts and macros basicsComing
- 12Practice project: a budget modelComing
Requirements
Recommended background. You can start any course at any time.
Description
Advanced Excel skills: workbook options, advanced data management, advanced formulas and macros, and advanced charts and PivotTables.