Excel Intermediate course - Joburg, Pretoria South Africa-Midrand, Sandton, Johannesburg, South Africa

Microsoft Excel: Intermediate

Details

You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

This course is designed for students who already have foundation knowledge and skills in Microsoft Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

Delivery Methods

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.

Delivery Method	Duration	Price (excl. VAT)
Classroom	1 Day	ZAR 2,050.00	Get a Quote
Live Virtual Training	1 Day	ZAR 1,850.00	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

Worldsview Technologies

This was my first time using Leading Edge as a training provider

BMW SA

I like that the course was very practical but that I still have the ebook to refer to.

J-Pak (Pty) Ltd

Lawrence was very patient and understanding. During this particular training i had a medical scare that had me sitting in a doctors office for a while, and i asked if it were possible to connect on my phone as to not miss training, Lawrence understood and occasionally would check to see if i am there and after if everything was okay. The trainer did not need to be sympathetic yet showed it completely and still was checking to see if i was following the training. Very impressed. Thank you

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.

COGTA

Improve and excited to learn.

FNB

This was a great training experience during the lockdown. Lawrence was very professional and helpful throughout the day.

Audience

The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse 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

To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

Start Date	End Date	Branch	Status
Thu 31 Oct 2024	Thu 31 Oct 2024	Fourways	Scheduled	Book Live Virtual Training

Submit Enquiry