In this course, the participant will be introduced to the more advanced features of Microsoft Excel 2016. The participant will learn how to manage, filter, and generate reports from Excel data. The course also shows the participant how to summarize and analyze data using tools such as Pivot Tables, Scenarios and Goal Seek. Additionally, participants will learn how to create macros to automate some repetitive tasks, as well as how to protect worksheets and workbooks. At the end of the course, the participant will be able to demonstrate the ability to manage and analyze data efficiently with Microsoft Excel 2016.
- Students who have intermediate skills with Microsoft Excel 2016 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2016 interface.