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.
|CPD Units ||3 units on full attendance|
|Seats Left ||14|
|Price ||Rs 4000 |
|Booking Deadline ||Thursday 14th July 2022|
|Map ||View Map|