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
Save up to 10% by booking and paying
10 business days before the course.
Information may change without notice.
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
Course Outline / Curriculum
Lesson 1: Creating Advanced Formulas
Apply Range Names
Use Specialized Functions
Lesson 2: Analyzing Data with Logical and Lookup Functions
Leverage Questions and Testing to Write Formulas
Use Logical and Lookup Functions to Find Answers to Questions
Lesson 3:Organizing Worksheet Data with Tables
Create and Modify Tables
Sort and Filter Data
Use Summary and Database Functions to Calculate Data
Lesson 4: Analyzing Data with Pivot Tables, Slicers, and PivotCharts
Create a PivotTable Report
Filter Data by Using Slicers
Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic
Insert and Modify Graphic Objects
Layer and Group Graphics Objects
Lesson 6: Enhancing Workbooks
Create and Use Templates
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
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.
For clients who want to enjoy the convenience of public transport,
consider the Gautrain.
Take the Gautrain to the Malboro station.
Purchace a R15 ticket for the Woodlands Office Park Shuttle Service.
The shuttle will come directly down Western Service road.
Ask to be dropped at the entrace to Western Woods Office Park.
For more information you can download
the official Gautrain brochure.
Bringing your own PC
It is very important that you have full administrator rights to your
computer so that any software needed for the course can be installed
Please ensure that you arrive at least 30min early on the first day
of training in order to get your PC setup correctly.
If this is not possible then it will be better to make use of our