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 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