Excel Pivot Table 101 LIVE at 18 May 21 16:00 EET

Excel Pivot Table 101 LIVE at 18 May 21 16:00 EET

  • R 250.00
    Unit price per 
  • Save R 130
Tax included.


Description

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 Masterclass will be held in a Zoom session, LIVE online, with our Excel Expert at Stellietech in an intimate setting of fewer than 6 participants. 

The training is designed to teach you all you need to know to use your pivot tables at a high level, without taking much time off your hands.

 

What you will cover

  1. What on earth is a PivotTable?
  2. How will a PivotTable help me?
  3. Create an Excel PivotTable
  4. Use PivotTable Fields
  5. Modify PivotTable Calculations
  6. Change formatting in PivotTables
  7. Change views in PivotTables
  8. Change values in PivotTables
  9. Apply changes in PivotTables
  10. Filter PivotTable data
  11. Sort fields in PivotTables
  12. Drill down into PivotTable data
  13. Group PivotTable data

 

What to expect

  1. When signing up you will automatically be added to the training event register and sent a link to join the meeting.
  2. We run smaller intimate classes, approximately 5-10 students so that you are able to interact with the trainer and ask questions through the program.
  3. Our trainers have a vast amount of experience and will be delighted to train you or your team.

 

Technical

  • Download Zoom and have a microphone and webcam available (The camera and Mic are optional, if you want to just listen in that's also 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