MS Excel - Working with Data and Lists Venue Online - Microsoft Teams Date Thursday 14th July 2022 Time 09:30 - 12:30 Information 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 Vickie Watt CPD Units 3 units on full attendance Seats Left 14 Price Rs 4000 Booking Deadline Thursday 14th July 2022 Map View Map