COURSE INFORMATION
The aim of the course is to enable you to understand the tools available in Excel to summarise and present data. The course covers a variety of tools you can use to summarised list data. The course shows the different options available.
This session looks at these frequently used list features:
- Importing data
- Subtotal
- Tables
- Pivot Tables
- Slicers
- Power Query
Importing data from
- Different File formats that can be imported
- Import CSV, TXT files
Subtotalling
- Creating Subtotals
- Use Outlining
Tables
- Creating Tables
- Adding data to tables
- Table Total Row
Pivot Tables
- Creating a pivot table
- Adding Fields to create Row and Column headings
- Rearranging fields in a pivot table
- Number formatting of the data area vs Formula
- Managing subtotals and grand totals
- Changing the data field calculation (Sum, Count, Average etc.)
- Building and using Report Pages with the Filter field
- Use the Analyse Data tool
Pivot Charts
- Building Pivot Charts
- Editing Pivot Chart Layouts
- Using the built in chart filter buttons for presentation
Slicers and Timelines
- Building Slicers for easy and interactive filtering in Tables and Pivot Tables
- Formatting Slicers
- Timelines in Pivot tables
Introduction to Power Query
- Query concepts
- Get & Transform data
- Launching the Power Query Editor
- Data tools
- Use transformation tools in the Editor
- A good knowledge of using simple Sorting, Filtering and Absolute cell references is required for this course.
- £145
- Half day trainer led or virtual