Excel 2016 Expert

Your participants will learn how to use the advanced features of Excel 2016. This course is designed to provide an in-depth understanding of Excel 2016. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in Excel 2016.

Excel 2016 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2016 you are provided with a new landing screen which makes launching and creating documents easier than previous versions of Excel.

Learning Objectives:

• Recognize permissions, versions, and Excel Options
• Describe how to track changes and share workbooks
• Perform advanced formula auditing and calculation
• Create arrays
• Create additional ways to run a macro
• Create a form using a variety of controls
• Use trend lines, secondary axes, and chart templates
• Work with slicers in PivotTables
• Create and manipulate a PowerView sheet
• Analyze data using multiple tables

How You Will Benefit:

• Become an expert in excel
• Improve efficiency and effectiveness
• Improve data visualization skills
• Enhance data management skills

Who Should Attend:

Any intermediate excel user who is looking to advance their skills

Prerequisites: None

Course Format: Live instructor led (synchronous)

Course Duration: 8 hours