- General Information, Microsoft, Tips and Tricks
ADVANCED EXCEL Training (LEVEL 3)
Advanced Excel training courses are facilitated by Certified Microsoft trainers.
Excel training courses for intermediate-level students is held at our training centre in Durban. Excel training facilitated by a Microsoft Certified Trainer. 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.
The advanced course helps you to automate spreadsheets, and work with advanced functions and reports using pivot tables and pivot charts. This course is suitable for people working in Finance, HR, and senior management positions who have a lot of reporting to do.
DURATION
UNIT STANDARDS
PRE-REQUISITES
SUITABLE FOR
OUTCOMES
DURATION
1 Day
UNIT STANDARDS
SAQA US ID: 116943: Using a graphical user interface (GUI)-based spreadsheet application, enhance the functionality and apply graph /charts to a spreadsheet
PRE-REQUISITES
The advanced course assumes that you have worked with Excel on a daily basis for some period of time and have used most of the features covered in the Beginners and Intermediate courses.
SUITABLE FOR
This course is suitable for people working in Finance, HR and senior management positions who have a lot of reporting to do.
OUTCOMES
The student will be able to analyse, manage and report on large spreadsheets using advanced functions and data commands.
ADVANCED EXCEL TRAINING: COURSE CONTENT
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros
Topic A: Use Lookup Functions
Topic B: Use Dynamic Arrays and Dynamic Array Functions
Topic C: Trace Cells
Topic D: Watch and Evaluate Formulas
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecast Data Trends
Topic A: Create Sparklines
Other Excel Training Courses
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.
Microsoft Excel Basic (Level 1)
Our entry level Excel course where students learn to create, edit, format and print a spreadsheet.
Microsoft Excel Intermediate (Level 2)
This course focuses on the tools needed to work with large spreadsheets, clean up data, sort and filter, pivot tables and charts.
Meet Keshnie, our certified Microsoft Trainer with over 10 years of qualified experience.
Customised and personal training of over 1000 people. Training is held at our offices in Westville, client offices or online.
What you can expect from our Advanced Microsoft course
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 Advanced 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.
Ready to maximise your software investment?
Featured Insights
Unlocking the potential in people so that businesses can thrive.
- Business and IT, Cloud, General Information, Tips and Tricks
- Business and IT, General Information, Tips and Tricks
