Online Session: MS Excel - Working with data and lists
| |
Venue | Online - Microsoft Teams |
Date | Tuesday 13th April 2021 |
Time | 11:00 - 14:00 |
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
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 |
|
|
|