RELATED COURSES
Advanced Excel Saturdays
Analysing Data with Excel
Basic Excel : Saturdays
Computer Orientation
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
Intermediate Excel Saturdays
Microsoft Access 2007
Microsoft Excel Assessment
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 BI Boot Camp
Microsoft Power BI Desktop Advanced Course
Microsoft PowerApps
Microsoft PowerBI Dashboard User Course
Microsoft PowerPoint Level 1
Microsoft PowerPoint Level 2
Microsoft Project
Microsoft Visio
Microsoft Word Level 1
Microsoft Word Level 2
MS Office Level 1
OpenOffice Writer
Spreadsheet Assessment US116937
Training using Microsoft Teams
Windows 10 Basic Computer Course
Windows 7 Basic Computer Course
Windows 8 Basic Computer Course
COURSE TRAINERS
Billy Katekwe
Bruce Sabada
Lawrence Maoka
Lawrence Maoka
Lawrence is a Sales Manager and Training instructor at Leading Edge Business Solutions (Pty) Ltd since April 2008 and has been a technical instructor since 2004. Lawrence combines technical knowledge with good communications skills and consistently receives enthusiastic reviews from his students. Lawrence has trained in all 9 provinces of South Africa as well as in the DRC, Botswana, and Swaziland.
Operating Systems and Application Software
Windows 95 – Windows 10, Office 97/2000/XP/2003/2007/2010/2013/2016
Linux
PowerBI
Microsoft Word, Excel, PowerPoint, Outlook, Access, Project, Visio, Microsoft Excel Dashboards
Open /Libre Office Writer, Calc, Impress, Base
Thunderbird
Google Apps
Gimp, Scribus
Wordpress and Joomla Content Management Systems
Soft skills / Business Skills
Selling, Presentation, Communication, Time Management & Anger Management.
Certified
Certified Technical Trainer (Ctt+)
N5 Electrical Engineering
Installation Liaison Officer (Telecommunication)
Business Communication
Entrepreneurship
Microsoft Office Specialist, Word, Excel, PowerPoint
ICDL
Network+
I-Net+Hardware and Networking from City & Guilds of London
IC3
Google AdWords
Google Analytics
Mark Badham
Mark is the Managing Director of Leading Edge Business Solutions. Mark has been programming since the age of 10 when he wrote his fist Basic Program on an Apple IIe. He has always been passionate about computers and education and started tutoring matric students in 1994. Mark has been training advanced Linux courses, installing, configuring and maintaining Linux servers since November 1999. In 2002 Mark began training Perl courses. Mark was among the first group to write the LPI level 2 Certification in South Africa in 2004. Since March 2006 Mark has been training PHP, MySQL and JavaScript. Since 2009 Mark has started training Java and Python.
Mark's formal qualifications include:
Bsc (Engineering) Electrical
Institution: University of the Witwatersrand.
Final Subjects IncludedComputer Engineering
Certification: Level 2 Certification
Institution: Linux Professional Institute
Xolisile Maleko
Xolisile Maleko
CUSTOMERS
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 Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
On completion of the Excel Basic, Intermediate and Advanced Courses, delegates may also write the Microsoft Office Specialist Exam, 2016 Exam 77-727 online.
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) | ||
|---|---|---|---|---|
| Fulltime | 1 Day | R 2,649.00 | Get a Quote | |
| Webinar | 1 Day | R 2,250.00 | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
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 Basic
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.
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.
| Start Date | End Date | Branch | Status | |
|---|---|---|---|---|
| Wed 13 Dec 2023 | Wed 13 Dec 2023 | Fourways | Scheduled | |
| Tue 16 Jan 2024 | Tue 16 Jan 2024 | Fourways | Scheduled | |
| Tue 20 Feb 2024 | Tue 20 Feb 2024 | Fourways | Scheduled | |
| Tue 19 Mar 2024 | Tue 19 Mar 2024 | Fourways | Scheduled | |
| Tue 16 Apr 2024 | Tue 16 Apr 2024 | Fourways | Scheduled | |
| Tue 14 May 2024 | Tue 14 May 2024 | Fourways | Provisional | Enquire |
| Tue 11 Jun 2024 | Tue 11 Jun 2024 | Fourways | Provisional | Enquire |
| Tue 9 Jul 2024 | Tue 9 Jul 2024 | Fourways | Provisional | Enquire |
| Tue 6 Aug 2024 | Tue 6 Aug 2024 | Fourways | Provisional | Enquire |
| Tue 3 Sep 2024 | Tue 3 Sep 2024 | Fourways | Provisional | Enquire |
| Tue 1 Oct 2024 | Tue 1 Oct 2024 | Fourways | Provisional | Enquire |
| Tue 29 Oct 2024 | Tue 29 Oct 2024 | Fourways | Provisional | Enquire |
| Tue 26 Nov 2024 | Tue 26 Nov 2024 | Fourways | Provisional | Enquire |