MS Excel - Working with Data and Lists
| |
| Venue | Online Live Stream |
| Date | Tuesday 4th November 2025 |
| Time | 09:00 - 12:00 GMT+2 |
| Information | Excel Working with Data and Lists
1. Excel Lists How to structure lists for analysis.
2. Sorting and Filtering Data: Sorting, custom sort, custom lists, filtering, advanced filters, remove duplicates.
3. Summarising Data Consolidating and automatic Sub Totals.
4. Excel Tables Creating an Excel table, summarising, calculating, formatting, converting to a range.
5. Working with PivotTables Create a PivotTable, change summary function and show number as, filters, subtotals, report layout and formatting, PivotCharts.
6. Some useful functions when working with lists.
7. Conditional Formatting: Automatically highlight data based on logical conditions.
Course prerequisites A good working knowledge of Excel including simple formulas and functions. Attending the Excel Fundamentals course would be an advantage.
|
| Presenter |
Vickie Watt
Vickie has an extensive background in communication and training consulting in various industries which include manufacturing, mining, insurance, retail, media, and ICT.
As a Microsoft Certified Professional and Microsoft Certified Trainer, Vickie has achieved Microsoft Office Specialist Expert status, and is an advanced user in Microsoft Excel, Word, Project, PowerPoint, and Outlook, with extensive experience in a number of other software applications.
She is a registered Assessor with the ETDP and MICT SETAs.
Close this popup
|
| CPD Units | 3 Hours verifiable CPD on full attendance |
| Price | R 500 |
| Booking Deadline | Tuesday 4th November 2025 |
|
|
|
