Excel Pivot Table 101 LIVE Class (6 May '21 - 18:00 SAST)
This LIVE crash course on pivot tables is an excellent way to learn how to work with your data in the most powerful tool in Microsoft Excel, Pivot Tables. This will be held in a live online Zoom session with our Excel Expert at Stellietech in an intimate setting.
The training is designed to teach you all you need to know to use your tables at a high level, without taking much time off your hands.
What you will cover
- What on earth is a PivotTable?
- How will a PivotTable help me?
- Create an Excel PivotTable
- Use PivotTable Fields
- Modify PivotTable Calculations
- Change formatting in PivotTables
- Change views in PivotTables
- Change values in PivotTables
- Apply changes in PivotTables
- Filter PivotTable data
- Sort fields in PivotTables
- Drill down into PivotTable data
- Group PivotTable data
What to expect
- When signing up you will automatically be added to the training event register and sent a link to join the meeting.
- We run smaller intimate classes, approximately 5-10 students so that you are able to interact with the trainer and ask questions at the end.
- Have Excel ready and open, your trainer will be sending you an Excel spreadsheet prior to the training which you will be encouraged to follow along with.
- Our trainers have a vast amount of experience and will be delighted to train you or your team.
- Download Zoom and have a microphone and webcam available (The camera and Mic are optional, if you want to just listen in that's fine).
- The trainer will be working on Microsoft Office Excel 2019, however, if you have another version, you will still be able to follow along just fine.
Do you want a session just for your team?
Stellietech offers this style of live online Excel training for any and all topics which can be specific to your organisation’s needs.
Just let us know what you need here: Contact Form
Can't make this session?
If you can not make this session and would like to join our next, let us know here: Contact Form