Online Session: MS Excel - Working with data and lists
Venue Online - Microsoft Teams
Date Tuesday 13th April 2021
Time 11:00 - 14:00
  • Excel Lists: How to structure lists for analysis

  • Sorting and Filtering Data: Sorting custom sorting custom lists filtering advanced filters remove duplicates

  • Summarising Data: Using Consolidation and automatic SubTotals

  • Excel Tables: Creating an Excel table summarising calculating formatting converting to a range

  • Working with PivotTables: Create a PivotTable change summary function show number as filter subtotals report layout format PivotChart

  • Conditional Calculations: SUMIF(S) AVERAGEIF(S) COUNTIF(S)

  • Conditional Formatting: Automatically highlight data based on logical conditions

    Note: This course is not refundable by the HRDC as it is being broadcasted from our Johannesburg office.
  • Presenter
    CPD Units 3 units on full attendance
    Seats Left 42
    Price Rs 1500
    Booking Deadline Tuesday 13th April 2021
    Map View Map