Microsoft Excel 2016 – Level 3
About this course:
You likely use Excel a lot in your role; otherwise, you wouldn’t be taking this course. By now, you’re familiar with Excel 2016, including its functions, formulas, features, and powerful data analysis tools. Often, you analyze and report on data, collaborate with others, and maintain workbooks for various purposes. At this level, however, you’ve likely faced several challenges and issues.
However, you don’t have time to waste searching through workbooks to fix issues or perform repetitive tasks. Therefore, you need Excel to work smarter for you, so you can focus on staying ahead of the competition. This course aims to help you achieve just that.
Building on the foundational and intermediate knowledge from the Microsoft® Office Excel 2016: Level 1 and Level 2 courses, this course enhances your Excel experience. You’ll learn to collaborate, automate tasks, and use conditional logic to create complex formulas and functions. As a result, the more you understand Excel’s capabilities, the more you can focus on extracting valuable insights from your data.
Additionally, this course aligns with the Microsoft Office Specialist exam objectives, preparing students for the Excel 2016 Exam and the Excel 2016 Expert Exam.
Audience:
This course is for experienced Excel 2016 users who want to advance their skills in using advanced features. You may need to troubleshoot large workbooks, automate tasks, collaborate on workbook data, and perform advanced analysis using complex Excel functions.
At Course Completion:
Upon completing this course, you will be able to perform advanced data analysis, collaborate on workbooks, and automate tasks:
- Work with multiple worksheets and workbooks.
- Use Lookup functions and formula auditing.
- Share and protect workbooks.
- Automate workbook functionality.
- Create Sparklines and map data.
- Forecast data.
Prerequisites:
Students should have experience creating and analyzing datasets in Excel 2016. Specifically, you should know how to create formulas, use functions, sort and filter data, and present data using charts and PivotTables. Students can meet these prerequisites by taking:
- Microsoft Office Excel 2016: Level 1
- Microsoft Office Excel 2016: Level 2
Or by having equivalent skills and experience.
