Microsoft Excel 2016 Data Analysis and Power Tools Part 1, 2 days

Lesson 1: Getting the Data to your Workbook

Import or Connection
Data from other Excel Sources
Retrieving Data from other Applications
Using Web Based Data
Lesson 2: Preparing Data for Analysis

Data Cleansing and Manipulation Tools
Introduction to Data Tables
Creating Data Models and Data Relationships
Workbook Analysis with Inquire
Lesson 3: Using Data Tables, Slicers and Functions

Use Data Table and Slicers
Analysis with Excel Functions and Data Validation
Lesson 4: Working with Data Visually

Quick Data Analysis
Conditional Formatting
Visualise Trends with Sparklines
Using Charts, Exploring Chart Types and Options
Lines, Up/Down Bars, Error Bars and Trendlines
Create a Forecast Sheet
Lesson 5: PivotCharts

Introduction to PivotTable Principles
Create PivotCharts from a Table
Creating Decoupled PivotCharts from a Connection or Data Model
Filtering the Data using Slicers and Timelines
Lesson 6: Power View Reports

Creating Power View Reports
Using Tables, Cards and Matrices
Charting in Power View Reports
Mapping Geo-Data

Each participant will leave with a recognised certificate

Complete the below form to enquire about having this course delivered at your office where discounts may apply

Mike was an excellent trainer and explained things very well. He listened to everything we needed to go through and addressed this. C Bowe

Instructor was good and I think there are multiple practical applications of the course content. B Clarke