MICROSOFT EXCEL INTERMEDIATE Training (LEVEL 2)

Microsoft Intermediate Excel training course facilitated by Certified Excel trainers.

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.

INTERMEDIATE EXCEL TRAINING: COURSE CONTENT

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

Other Microsoft 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 Advanced (Level 3)

This course is suitable for people working in Finance, HR and senior management positions who have a lot of reporting to do.

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 Microsoft excel intermediate level 2 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 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. 

Ready to maximise your software investment?

Our Services