Target Student: This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets. Who wish to begin taking advantage of some of the higher-level functionality in Excel. Who would like to learn more about creating macros, working with shared documents, analyzing data, and auditing worksheets.

 

Schedule:

Saturday 9: 00am - 5 pm

 

Overview


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.

Prerequisites 
Intermediate level of Excel.

Course Outline

Module 1: Using Pivot Tables

Lab : Using Pivot Tables

Module 2: Auditing Worksheets

Lab : Auditing Worksheets

Module 3: Data Tools

Lab : Data Tools

Module 4: Working with Others

Lab : Working with Others

Module 5: Recording and Using Macros

Lab : Recording and Using Macros

Module 6: Random Useful Items

Lab : Random Useful Items

Module 7: Microsoft Excel Features that Were New in 2013

Lab : Microsoft Excel Features that Were New in 2013

Module 8: Features New in 2016

 


 Also available Excel 2013

  Call Us Today!
(787) 998 0602
(787) 998 0720
Email: info@iatpr.com
 


Choose your best option:
• Classroom Training
• Online Training
• Onsite Training

VISIT OUR CALENDAR OF COURSES

Jobs Opportunities 

If you are a Microsoft Excel Power Users you could choose for the following job positions:

Investment Banking Analyst
Starting Salary: $58,386/year (does not include bonus)1
Management Consultant
Starting Salary: $70,676/year
Accountant
Starting Salary: $44,965/year
Marketing
Starting Salary: $50,232/year
Business Intelligence Analyst
Starting Salary: $55,591/year
Management
Starting Salary: $41,168/year

Salary figures used in this article are national
averages from Salary.com.[*]

Onsite Classes and TEST Administrator Available at Your Location

Most of our classes are available to be taught onsite at your location. There is a minimum number of students required to have the class onsite. Pricing is discounted based upon the number of students attending. Call and schedule your onsite training class today. We can also provide an onsite test administrator to administer the exam on the last day of the class for all of your students.

We have provided onsite training and we look forward to providing training onsite for you this year.