Details

This course offers expert training in intermediate skills for Microsoft Excel 365. Learners who have completed our Excel Fundamentals course that are looking to expand their skillset into using data analysis tools like tables and charts will find this course most rewarding.

Learners will gain essential Excel skills such as using logical functions, working with date and time functions and organising cell data using lists. The course also teaches learners to create, populate, edit and format fundamental data analysis tools like tables and charts, including PivotTables and PivotCharts.

Learners can take this course as a 1-day class led by an expert instructor, either online or in a classroom.

The material covered in this course assumes knowledge of the Excel basic skills learned in our Excel Fundamentals course. Learners who complete this course who wish to learn more advanced Microsoft Excel skills such as Lookup functions or Sparkline creation will want to sign up for our Advanced Excel Training Course. All three of these courses are available as a discounted bundle in our Excel Bootcamp. Professionals who want to gain Excel skills centered on data analysis and high-level usage of Excel Power-Query functions should sign-up for our Excel Data Analysis course.

Objectives:

Gain essential intermediate Excel skills for organising, presenting and analysing data within an Excel Workbook.
Learn to work with ranges and use intermediate functions and formulas such as IF statements and Date & Time functions.
Learn to create tables to organise Data and format them for readability and maximise aesthetic quality. Learn about using PivotTables to easily organise and analyse data.
Learn how to use Excel data to create charts to present and analyse that data. Learn about different chart types and when to use them, as well as how to label and format them. Learn about using PivotCharts to present sub-sections of data.

Delivery Methods

Delivery Method	Duration
Classroom Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm. Classroom	1 Day	Get a Quote
Live Virtual Training This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office. Live Virtual Training	1 Day	Get a Quote

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Information may change without notice.

Customer Testimonials

Schaeffler South Africa (Pty) Ltd

Favourite part was learning how to convert data into a table as well choosecols functions that will come in very handy on my day-today.

Shaeffler South Africa (Pty) Ltd

I really liked everything about this course. I learned new things that will really be helpful on mu daily tasks. Very good course.

Broll Property Group (Pty) Ltd

yes, the excel training was very informative particularly in learning how to create pivot tables and also learning about excel formulars and shortcuts calculation. this will assist in being more efficient when working on any calculation in excel

Pact World

Everything taught was very clear because the instructor gave us time to understand and actually pose questions with ease.

United Exports South Africa (Pty) Ltd

A star for Lawrence for being patient with the group. And time management was on point. We have covered everything in the time frame. So thank you.

Gauteng Provincial Treasury

I think overall, the training experience was excellent. I do not have any regrets.

Audience

This Intermediate Excel course is for anyone who has a basic understanding of Excel and wants to expand their expertise into more advanced data organisation, analysis and presentation. People whose work requires them to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web.

Pre-Requisites

Microsoft Office Excel Fundamentals

Course Outline / Curriculum

Lesson 1: Working with Functions

Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date & Time Functions
Work with Text Functions

Lesson 2: Working with Lists

Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data

Lesson 3: Analyzing Data

Create and Modify Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

Create Charts
Modify and Format Charts
Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers

Schedule Dates and Booking

There are currently no scheduled dates.

Add me to the waiting list

Submit Enquiry

Name

Email

Telephone

Query