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

from £772

This is the first of a two part series of courses examining the data tools and features found in Microsoft Excel 2016 Professional and Pro Plus*. The course is designed to examine a combination of new and revised features which are available to help you work with data in Microsoft Excel 2016. Features covered range from data importing to analysis leading to subsequent output in Excel. Analysis and outputs include data and graphical tools available in Microsoft Excel 2016.

Check prices, dates and availability

Make an enquiry

Key features
- Live instructor led course
  with 12 hours of training
- Session runs from 9.30–5pm with normal breaks included
- Fully certified trainer
- Get key skills and practical knowledge
- This course is available for delivery at your office, 1-1 and groups – contact us
- Course materials included
- Recognised course certificate

What will I learn?

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

Certification

Have this course at your office

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

Your name Your phone number Your email address

Reviews

Trainer was very knowledgeable and explained things clearly so everyone understood. The trainer adapted the materials to our audience to ensure everyone was getting what they needed. Our audience had different knowledge levels for different reasons in their jobs, the trainer managed to engaged all these different learnings. Thank You. S Clipston

Professional and competitively priced. D Harries