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 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
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.
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 four 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 | |
| Webinar | 1 Day | R 2,050.00 |
Save up to 10% by booking and paying 10 business days before the course.
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
Microsoft Office Excel Basic
Lesson 1: Working with Functions
Lesson 2: Working with Lists
Lesson 3: Analyzing Data
Lesson 4: Visualizing Data with Charts
Lesson 5: Using PivotTables and PivotCharts
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 four delegates. We remain committed to offering training that is fast, focused and effective.
| Start Date | End Date | Branch | Status | |
|---|---|---|---|---|
| Tue 7 Jun 2022 | Tue 7 Jun 2022 | Not Applicable | Scheduled | |
| Tue 21 Jun 2022 | Tue 21 Jun 2022 | Not Applicable | Scheduled | |
| Tue 5 Jul 2022 | Tue 5 Jul 2022 | Not Applicable | Scheduled | |
| Tue 19 Jul 2022 | Tue 19 Jul 2022 | Not Applicable | Scheduled | |
| Tue 2 Aug 2022 | Tue 2 Aug 2022 | Not Applicable | Provisional | |
| Tue 16 Aug 2022 | Tue 16 Aug 2022 | Not Applicable | Provisional | |
| Tue 30 Aug 2022 | Tue 30 Aug 2022 | Not Applicable | Provisional | |
| Tue 13 Sep 2022 | Tue 13 Sep 2022 | Not Applicable | Provisional | |
| Tue 27 Sep 2022 | Tue 27 Sep 2022 | Not Applicable | Provisional | |
| Tue 11 Oct 2022 | Tue 11 Oct 2022 | Not Applicable | Provisional | |
| Tue 25 Oct 2022 | Tue 25 Oct 2022 | Not Applicable | Provisional | |
| Tue 8 Nov 2022 | Tue 8 Nov 2022 | Not Applicable | Provisional | |
| Tue 22 Nov 2022 | Tue 22 Nov 2022 | Not Applicable | Provisional | |
| Tue 6 Dec 2022 | Tue 6 Dec 2022 | Not Applicable | Provisional |