Excel Pivot Tables

This course aims to introduce delegates to the use of Pivot Tables in Excel.

Topics Covered:-

• Source - Lists or Tables

• Recommended Pivot Tables – Samples

Create a Blank Pivot Table

• Hide/Display the Pivot Table Field List

• Pivot Table fields- Assigning Fields

• Modifying Field Settings – Number Formatting (right-click/Field Settings)

• Change Summary Calculations (Field Value Settings/Right Click)

• Tables Rules, Format, Names, Summary Calculations

• Sorting Pivot Columns and Rows

• Pivoting a Pivot Table

• Include Multiple Field Groupings, Multiple Summaries

• Custom List in a Pivot Table

Filtering a Pivot Table

• Row, Column and Value Filters

• Add/Clear Filters

• Multiple Filters – Or

• Slicers and Timelines – Visual Filters

Grouping Data

• Automatic (Date) and Manual (ad-hoc grouping)

• Pivot by Grouping

Calculated Fields

• Show Values As

• Summarise By

• Editing a Calculated Field

Pivot Table Options

• Naming Pivot Tables

• Report Layout

• Compact/Outline/Tabular Form

• Pivot Table Themes and Styles

• Pivot Table Style Options

• Duration: 3 hours

Date: Wednesday 13th November 2024, 9.30am - 12.30pm

Cost: Free to attend for those living or working in Powys

Venue: Online

Course Delivery: This course will be delivered by BPI

Book online using the booking form below, call 01686 628778 or email sam@mwmg.org

If there are no spots available and you wish to be added to the reserve list in case of cancellation please email sam@mwmg.org

‘This project is funded by the UK government through the UK Shared Prosperity Fund.’