Lawrence is a training instructor at Leading Edge Business Solutions (formerly Intoweb Academy)
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 and Swaziland.
Operating Systems and Application Software
Windows 95 â€“Windows 7, Office 97/2000/XP/2003/2007/2010
Microsoft Word, Excel, PowerPoint, Outlook, Access, Project, Visio
Open /Libre Office Writer, Calc, Impress, Base
Wordpress and Joomla Content management systems
Soft skill/ Business Skills
Selling, Presentation, Communication, Time Management, Anger Management.
Certified Technical Trainer Exam
N5 Electrical Engineering
Installation Liaison Officer (Telecommunication)
Microsoft Office Specialist, Word, Excel, PowerPoint
Hardware and Networking from City & Guilds of London
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
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.
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.
To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft Office Excel 2013 Basic and Microsoft Office Excel 2007 Intermediate
Note: information may change without notice.
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.
Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.
For clients who want to enjoy the convenience of public transport, consider the Gautrain.
For more information you can download the official Gautrain brochure.
This course has been replaced by Microsoft Excel 2013: Advanced
Please follow the link above to view the updated course
The PC hire charge is not applicable if you bring your own notebook.
It is very important that you have full administrator rights to your computer so that any software needed for the course can be installed correctly.
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 computer.