Excel - Lists and PivotTables
Grasp the critical rules and useful tools required to manage your lists in Excel.
Timezone:
Melbourne Australia
18 February 2025
12:00 pm to 2:30 pm
Then learn to transfer your data collection into data analysis by converting your lists into PivotTables and PivotCharts.
Prerequisites
Participants are expected to have a basic understanding of Excel and its core functionalities or have attended the Excel Calculation Basic training. Familiarity with basic calculations, spreadsheet navigation, data entry, and basic formatting will be beneficial. This course is designed for users of all levels, making it suitable for beginners eager to learn, or long time Excel users looking to work better with their lists of information and grasp how to create PivotTables and PivotCharts.
Topics
Duration: Approx. 2.5 hours
Lists
- What is a List?
- Lists Creation Rules
- Sort Data in Lists
- Filter Data in Lists
- Add Subtotals to Data in Lists
- Apply Conditional Formatting
- Why and when to use the Format Table feature
- How and when to unFormat as Table
PivotTables
- What is a PivotTable and when to use them
- Create a PivotTable
- Filter a PivotTable
- Modify a PivotTable
- Refresh a PivotTable
- Change a PivotTable’s Data Source
- PivotTable Format Options
- Insert and Format PivotTable Slicers
- Link Slicers to Multiple PivotTables
- Create a PivotChart
Don't miss out - boost your Microsoft Excel skills today!
Location
Online Live with a trainer
Date and Time ( Melbourne 🇦🇺 Australia time)
18 February 2025
12:00 pm 2:30 pm
With World Time Buddy, you can easily convert times across different timezones, helping you determine if you can join this live online session from anywhere in the world.
Duration
Approx 2.5 Hours
Session may end sooner or later depending on various factors in the session like interactions, questions, pacing of the attendees, etc.
Price in New Zealand Dollars
Only $250 per person + 15% GST = $287.50
Early Bird Seat = $200 per person + 15% GST = $230
This is an online training session open to the public.
Contact us if you would like to arrange this as a private online training session for your team instead, or for it to conducted in-person at your location.