Excel 2016 Level 3 (Advanced)


 
Course Length: 6hrs (1 Day)
Excel 2016 has many new features that can be used to quickly analyze large amounts of financial information. Power Pivot enables users to combine data from multiple sources; Power View allows users to generate professional looking maps that indicate the location of data. Excel’s use of the VBA language enables users to create simple yet effective commands that enhance functionality, improve performance and perform repetitive tasks for you.

Learning Objectives:
In this course you will combine, analyze, and display data using Excel’s powerful features, and learn the basics of how to use macros to further extend Excel’s capabilities. You will:
  • Perform What-If analysis by creating scenarios and using data analysis tools such as Goal Seek, Input Tables and Solver
  • Use outlining tools to group and subtotal your data
  • Audit your formulas to help track down any errors
  • Analyze data with Pivot Tables
  • Record and delete macros
  • Edit basic macros using the Visual Basic Editor
  • Link and consolidate data across multiple workbooks
Target Student:
This course is for users who are familiar with Excel, and who wish to expand their knowledge and use of advanced data analysis and time-saving features.

Course Outline:
Section 1: Automating Worksheet Functionality
Update Workbook Properties
Create and Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria

Section 2: Analyzing and Presenting Data
Create Sparklines
Create Scenarios
Perform a What-If Analysis
Perform a Statistical Analysis with the Analysis ToolPak
Create Interactive Data with Power View

Section 3: Working with Multiple Workbooks
Consolidate Data
Link Cells in Different Workbooks
Merge Workbooks

Section 4: Analyzing Data with Pivot Tables, Slicers, and Pivot Charts
Create a Pivot Table
Filter Data by Using Slicers
Analyze Data with Pivot Charts

Section 5: Exporting Excel Data
Export Excel Data
Import a Delimited Text File
Integrate Excel Data with the Web
Create a Web Query

Section 6: Enhancing Workbooks
Customize Workbooks
Manage Themes
Create and Use Templates
Level 3 (Advanced)

Register for this class

Switch version:
2007 2010 2013

This Course Comes With


PDF Manual

Take the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices

After Training Support

Get 30 days of live 24/7 after training support via phone, email and online chat to help apply what you’ve learned

Customize Your Course

Tailored Training

Your manual will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Custom Manual

Purchase the customization option and receive a custom manual with objectives you’ve selected from our different courses

Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!

Also Available With This Course

Printed Manual

Instead of the PDF that comes with your course, purchase a printed paper manual for use during your class and future reference

Quick Reference Cards

Receive durable, full-color reference cards with helpful hints and tips for use after your course is completed

Video Library

Sign up to our video library subscription and review an extensive selection of training videos to refresh your memory
Register for this class here
Learn more about each course here
Contact us for more information here