Excel - Lists and PivotTables
Grasp the critical rules and useful tools required to manage your lists in Excel.
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.
Location
Online Live with a trainer
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.
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!
Price in Australian Dollars
Only $250 per person + 10% GST = $275
Early Bird Seat = $200 per person + 10% GST = $220
Additional Fees:
- Card, transaction, and currency conversion fees may apply where applicable.
Payment Methods:
- Multiple currencies accepted.
- Pay easily with debit or credit including with and more.
- We recommend checking the current exchange rate if you are paying in a different currency.
Important Notes:
- Prices may change without notice.
- All course fees are non-refundable. This means no refunds will be given for cancellations, withdrawals, or non-attendance. This policy helps us maintain high standards and session integrity, and manage costs for our global participants. Please book carefully and make sure you can attend the session(s).
Book on this session
- Please use the Register button at the top of the page to book yourself, someone else or a group.
- Create a new account during registration to easily manage your bookings, or log in to your existing account.
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.