Category
ICT
Course Type
Microsoft
Price Per Delegate
£245 +VAT
Public Scheduled Course
Price Per Course
£745 +VAT
On-Site at Customer Premises, Max 10 Delegates
Duration
1 Day
Full/Part Time
Part Time
Provider
Book courseThis 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.
- Creating & Formatting Tables
- Summarising Data & Table Calculations
- Interactive Filter Slicers
- Accessing Power Query
- Creating Queries & Connecting to Data Sources
- External Data Sources
- Producing Excel Table Outputs
- Working with the Query Editor
- Importing & Loading Data
- Managing Columns
- Reducing Rows & Applying Filters
- Transposing Tables
- Unpivot Columns
- Replacing Values
- Cleansing Values (Text, Numbers & Dates)
- Creating New Columns
- Sorting & Grouping Data
- Query Step Settings
- Editing Query Steps
- Refreshing Query Data
- Power Query Formulas
- Modifying Query Functions
- Advanced Query Editing
- 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.
