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
Excel is a great tool for creating and analysing dashboards.
In This course you will learn how to create dash boards using Excel
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.
Save up to 10% by booking and paying
10 business days before the course.
Information may change without notice.
Course Outline / Curriculum
Dashboard Do’s and Don’t’s
Data Layout Creating Dynamic Dashboards
Merging and Consolidating Data Using Shapes to make Charts more attractive
Using Alerts to draw attention to dashboards
Creating KPI Dashboards
Dashboards Publishing Excel Dashboards to the Web
Working with your Data
Understanding Data Quality issues
Gathering data from different sources
Merging and Consolidating Data
Excel Hints and Tips when working with data
Using the dashboards with Excel Pivot Tables
Using external data sources such as The Web
Dashboarding with Microsoft Access information
Build Your Own Dashboard
This last session will be used to build some relevant Dashboards. Delegates are encouraged to bring examples of the dashboarding they would like to create during the training.
Creating Calculated Columns and Calculated Measures
Creating Basic formulas and functions using Dax
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