Event Details
MS EXCEL ADVANCED โ LEVEL 2
TRAINER: Nomcebo Shabalala โ IT Certification Academy
ABOUT THE TRAINER
Nomcebo is a Certified Microsoft Office Specialist. She has also obtained a Higher Certificate in Adult Basic Education & Training and is currently pursuing her Degree in Computer Application Technology (year 2).
OVERVIEW
This course is designed for students who already have foundational knowledge and skills in Excel 2019 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
This course will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that can compete at a high level.
Course Outline
Module 1: Working with Functions
โข Work with ranges
โข Use specialized functions
โข Work with Logical Functions
โข Work with data and time functions
โข Work with text functions
Module 2: Working with Lists
โข Sort data
โข Filter data
โข Query data with database functions
โข Outline and subtotal data
Module 3: Analyzing Data
โข Create and modify tables
โข Apply intermediate conditional formatting
โข Apply advanced conditional formatting
Module 4: Using PivotTables with PivotCharts
โข Create a PivotTable
โข Analyze PivotTable data
โข Present data with PivotCharts
โข Filter data by using timelines and slicers
Module 5: Managing Workbooks
โข Manage worksheets
โข Manage workbook and worksheet views
โข Manage workbook properties
๏ปฟWHO SHOULD ATTEND?
Office & business administration, anyone using and working with spreadsheets and formulas. PA's, CA's, Business analysts.
Attendees will receive a certificate of attendance.
DETAILS OF THE TRAINING
Date: 6 June 2024
Time: 08:30 โ 16:30
Venue: PMCB Office, 1 Parkhaven, 55 MacLeroy Road, Northern Park, Pietermaritzburg
COST (includes vat and lunch)
PMCB Members: R1 490 p/p, R1 450 p/p for 3/more, R1 375 p/p for 5/more
Non-members: R1 765 p/p, R1 710 p/p for 3/more, R1 655 p/p for 5/more
BOOK NOW
Via our online event management system (Glue-up - click on register or I will attend below) or contact Thabisile Ngidi - info@pmcb.org.za, 033 345 2747.