What You’ll Learn
Microsoft Excel 2016 Level 3 covers key advanced Excel skills. Among others, topics in Level 3 include tables, financial functions, what-if analyses, PivotTables and PivotCharts, workbook protection, collaboration, and much more.
The Microsoft Office Specialist (MOS) Certification: Excel 2016 training series prepares individuals to support business information operations by using computer equipment to enter, process, and retrieve data for a wide variety of administrative purposes. Students enrolled in this program become proficient in Microsoft Excel 2016 application which provides an in-depth understanding of worksheet design, charting, what-if analysis, worksheet database creation and manipulation, and OLE. Knowledge and use of a spreadsheet will be applied to various business applications as well as integration of spreadsheets in other applications.
This course is the final in a 3-course series that will prepare students for Exam 77-727: Microsoft Excel (Office 2016).
Knowledge of Excel is a game changer in many industries, including business, customer service, project management, and finance.
Typically this course runs for three days, in person. Students should have intermediate skills with Excel or have taken Levels 1 and 2 of this course series.
- Working in multiple worksheets within a workbook
- Building and formatting simple tables
- Using more advanced formulas
- Using more advanced function tools