Microsoft Excel 2016 Advanced

Course Objectives

This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

After completing this course, students will be able to: Insert the course objectives in a bulleted list with periods. For example:
  • Create pivot tables and charts.
  • Learn to trace precedents and dependents.
  • Convert text and validate and consolidate data.
  • Collaborate with others by protecting worksheets and workbooks.
  • Create, use, edit, and manage macros.
  • Import and export data.




Contents Who should attend Course benefits Additional information Certificates Trainers background