Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost per individual

£195 +VAT
Public course

Cost per course

£550 +VAT
Client site, max 10 individuals

Duration

1 Day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Book course

This course is intended for users who need to interrogate, analyse and present data from a variety of external data sources in Excel spreadsheets.

Objectives:

At the end of the course users will be able to import data into Excel using queries and manipulate the fields and tables produced.

Prerequisites:

An advanced understanding of working with data tables to arrange and present data, including working with pivot tables and creating functions in Excel.

Download Outline (PDF)

Excel Table Revision
  • Creating & Formatting Tables
  • Summarising Data & Table Calculations
  • Interactive Filter Slicers
Getting Started with Power Query
  • Accessing Power Query
  • Creating Queries & Connecting to Data Sources
  • External Data Sources
  • Producing Excel Table Outputs
  • Working with the Query Editor
  • Importing & Loading Data
Transforming Data
  • Managing Columns
  • Reducing Rows & Applying Filters
  • Transposing Tables
  • Unpivot Columns
  • Replacing Values
  • Cleansing Values (Text, Numbers & Dates)
  • Creating New Columns
  • Sorting & Grouping Data
Working with the Query Editor
  • Query Step Settings
  • Editing Query Steps
  • Refreshing Query Data
Advanced Queries
  • Power Query Formulas
  • Modifying Query Functions
  • Advanced Query Editing
Multiple Data Sources & Relationships
  • Related Data Sources
  • Creating Additional Queries
  • Merge & Append Queries
  • Producing Related Data Outputs
  • Adding Queries to the Data Model
  • Using the Data Model

Enquire about a course

Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.