RELATED COURSES
Analysing Data with Excel
Data Modelling with M and Power Query
DAX Programming
Excel Boot Camp
Excel Dashboards and Power Pivot
Excel for Statistical Analysis
Excel Productivity
Excel VBA
Microsoft Access
Microsoft Excel For Human Resources Analytics
Microsoft Excel Fundamentals
Microsoft Excel: Advanced
Microsoft Office 365 Overview
Microsoft OneNote Fundamentals
Microsoft Outlook Level 1
Microsoft Power Automate
Microsoft Power BI Boot Camp
Microsoft Power BI Desktop Advanced
Microsoft PowerApps
Microsoft PowerBI Dashboard User Course
Microsoft PowerPoint Level 1
Microsoft PowerPoint Level 2
Microsoft Project
Microsoft SharePoint User
Microsoft Teams
Microsoft Visio
Microsoft Word Level 1
Microsoft Word Level 2
MS Office Level 1
OneDrive Training
OpenOffice Writer
Training using Microsoft Teams
Windows 10 Basic Computer Course
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:
Customer Testimonials
World Vision International
Learning new staff like Pivot Table charts, Conditional Formatting and Data Validation
South African Insurance Crime Bureau
I liked that the facilitator Lawrence was vey patient with us and answered helped us where we struggled. I also enjoyed mostly doing the pivot table and sorting data.
Cambridge Assessment International Education
Friendly staff, knowledgeable trainers.
World Vision International
I lent some new formulas and how to present data on graphs.
Small Enterprise Development Agency
The trainer was very good, he interacted with us which made the course interesting.
Gauteng Provincial Treasury
working with columns and charts
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
There are currently no scheduled dates.
Please note that this course needs a minimum of 6 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below, and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.
Should you need this course urgently, the following options are available:
- Pay for 6 delegates (whether you have them or not) and we will schedule the course as soon as possible.
- If you have fewer delegates and cannot pay for 6, we can negotiate a shortened course where some of the time will be spent in blended learning - watching videos and doing tutorials and exercises with some contact time with the trainer. We would want to discuss what your core needs are so that we cover those aspects. You need to have paid for 3 delegates at least.