
Course duration
(we will customise to your learning requirements and timeframe)
Target audience
This course is designed for those who need to know how to use Pivot Tables in Microsoft Excel to report on data. Participants should have completed the Excel Introduction training course or have a good understanding of Microsoft Excel.
Course Objectives
At the end of the course participants will be able to:
- Create databases in Microsoft Excel
- Do’s and Do nots of creating databases in Excel
- Work with Pivot Tables to generate calculations
- Create Pivot Charts
Formulas
- Elements of a Database
- Create an Excel Database
- Do’s & Don’ts
- Modifying the Database Structure
PivotCharts
- Create PivotCharts
- Format PivotCharts
PivotTables
- What is a PivotTable?
- Understand how PivotTables summarise data
- Create a PivotTable
- Work with the Pivot Table layout
- Change designs
- Sort and filter a PivotTable
- Refresh a PivotTable
- Change the data source
- Group data by row labels
- Format numbers within a Pivot Table
- Create calculated fields
Other Excel Training Courses
Excel Introduction
Excel Intermediate
Excel Advanced
Excel Formulas and Functions
StressLess Learning, Microsoft Excel Training Experts