Microsoft Office 2016: Excel Part 3 (Advanced)

Course Overview

Would you like to become an Excel specialist and use the enormous functionality of Excel 2016 to your advantage? In this expert course, you will get to know especially helpful features, such as collaborative editing of workbooks and management of more complex Excel documents, through the implementation of tools such as formula tracking and reference functions.

Target Audience

This course is designed for those, who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Learning Objectives

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will learn how to:

• 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

Business Outcomes

Increase your office productivity.