MS Excel - Working with Data and Lists
Venue Online - Microsoft Teams
Date Thursday 14th July 2022
Time 09:30 - 12:30
  • 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.

  • Presenter
    CPD Units 3 units on full attendance
    Seats Left 14
    Price Rs 4000
    Booking Deadline Thursday 14th July 2022
    Map View Map