Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Course overview

Create queries to interrogate data from data sources. 

Course duration

1 day

Delivery method

Flexible (Online/Classroom)

Costs

Open participant course: £195 per person - maximum 10 people

Closed company course: £1,000 per course - maximum 10 people

Suitable for

Those who need to interrogate, analyse and present data from a variety of external data sources in Microsoft Excel spreadsheets.

Learning outcomes

By the end of the course, you will be able to import data into Microsoft Excel using queries and manipulate the fields and tables produced.

Course content

Excel Table Revision:

  • Creating and formatting tables.
  • Summarising data and table calculations.
  • Interactive filter slicers.

Getting Started with Power Query:

  • Accessing power query.
  • Creating queries and connecting to data sources.
  • External data sources.
  • Producing Excel table outputs.
  • Working with the query editor.
  • Importing and loading data.

Transforming Data:

  • Managing columns.
  • Reducing rows and applying filters.
  • Transposing tables.
  • Unpivot columns.
  • Replacing values.
  • Cleansing values (text, numbers and dates).
  • Creating new columns.
  • Sorting and 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 and Relationships:

  • Related data sources.
  • Creating additional queries.
  • Merge and append queries.
  • Producing related data outputs.
  • Adding queries to the data model.
  • Using the data model.

Course requirements

This course can be delivered remotely or in a classroom environment, to suit your requirements.

Attendees should have an advanced understanding of working with data tables to arrange and present data, including working with pivot tables and creating functions in Microsoft Excel. 

Attendees must have the following equipment to attend this training remotely:

  • PC or laptop with a microphone and speakers (webcam is preferred but not essential).
  • Access to the internet and web browser application (e.g. Google Chrome).
  • Microsoft Excel installed on the PC or laptop.
  • An email account for file sharing.
  • A second screen is ideal but not essential.

 


For more information about this course please contact us.


Queens Court Regent Street Barnsley South Yorkshire S70 2EG
Tel: 01226 216760 | Email: info@ind-training.co.uk | www.independenttrainingservices.co.uk

These course details were downloaded on 22/06/2021

https://www.independenttrainingservices.co.uk/courses-new/it-and-digital-skills/other/microsoft-excel-power-query/

Enquire Now