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: Intermediate
Microsoft Office 365 Overview
Microsoft OneNote Fundamentals
Microsoft Outlook Level 1
Microsoft Power Automate
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 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
Windows 7 Basic Computer Course
Windows 8 Basic Computer Course
COURSE TRAINERS
Avril Petersen
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
Details
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.
In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
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,750.00 | Get a Quote | |
| Live Virtual Training | 1 Day | ZAR 2,250.00 | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Audience
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data.
Pre-Requisites
To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft Office Excel Basic and Microsoft Office Excel Intermediate
Course Outline / Curriculum
Lesson 1:Working with Multiple Worksheets and Workbooks
-
- Use Links and External References
- Use 3-D References
- Consolidate Data
Lesson 2: Using Lookup Functions and Formula Auditing
-
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
Lesson 3: Sharing and Protecting Workbooks
-
- Collaborate on a Workbook
- Protect Worksheets and Workbooks
Lesson 4: Automating Workbook Functionality
-
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
Lesson 5: Creating Sparklines and Mapping Data
-
- Create Sparklines
- Map Data
Lesson 6: Forecasting Data
-
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecasting Data Trends
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 2 Oct 2024 | Wed 2 Oct 2024 | Fourways | Scheduled | |
| Wed 30 Oct 2024 | Wed 30 Oct 2024 | Fourways | Provisional | Enquire |
| Wed 27 Nov 2024 | Wed 27 Nov 2024 | Fourways | Provisional | Enquire |