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

Very easy company to work with and great customer service. S Tracy

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