About this course

      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.

Audience profile

     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.

At course completion

      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.

Excel with VBA

      VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft. Excel, along with the other members of Microsoft Office, includes the VBA language. In a nutshell, VBA is the tool that people use to develop programs that control Excel.This Excel 2013 VBA course is meant to for experienced Excel users who would like to gain expertise in creating procedures with respect to different events, understanding control structures, creating user forms, validating the data, and debugging and handling errors.

Prerequisites

      Intermediate level of Excel.