Let our team create a custom Excel learning journey for you and your team. We are able to assess your training needs so that employees learn practical skills which can be applied in the workplace.
1 Day
SAQA US ID: 116940: Use a graphical user interface (GUI)-based spreadsheet application to solve a given problem
The student must have attended a beginner’s course in Excel and/or work with Microsoft Excel on a daily basis.
Office personnel that need to work with spreadsheets on a regular basis and need to improve their productivity.
Students will learn how to:
Topic A: Work with Ranges
Topic B: Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date and Time Functions
Topic E: Work with Text Functions
Topic A: Sort Data
Topic B: Filter Data
Topic C: Query Data with Database Functions
Topic D: Outline and Subtotal Data
Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers
We offer the full spectrum of Microsoft Excel training at our head office in Westville, Durban. Our trainers are Microsoft Certified and constantly stay updated on software enhancements and changes so you get the highest and most current Microsoft Office training.
Our entry level Excel course where students learn to create, edit, format and print a spreadsheet.
This course is suitable for people working in Finance, HR and senior management positions who have a lot of reporting to do.
Customised and personal training of over 1000 people. Training is held at our offices in Westville, client offices or online.
Learning needs to be fun so we always ensure we create an environment that is relaxed and friendly so that learners don’t feel intimidated or nervous.
We cater for lunch, teas & coffees so learners stay hydrated and are able to focus throughout the training!
Our training is offered in groups or if preferred on a one-on-one basis.
You are able to choose to receive either an Attendance Certificate or a Certificate of Competency. Choosing the latter will require you to be tested on what we cover in the Excel Basics Course.
Our courseware is aligned to SAQA Unit Standards.
Our training centre is designed to let in lots of natural light which helps make the learning experience more comfortable.