This is a very hands-on, non-intimidating, course – delegates work through various exercises under the supervision, and with the help, of the facilitator to get to grips with Excel’s advanced capabilities.
Excel users who need to develop and produce quality reporting on a regular basis.
Good understanding of Excel and excel formulas.
Note: information may change without notice.
Excel Productivity Training is a training courses focused on building on your existing skills learning to develop sophisticated and automated reports that will substantially reduce the time spent working on spreadsheets.
This practical 3 day course leads delegates through a structured method of building sophisticated spreadsheet templates where the data is separated from the Excel template. The latest data will be imported automatically from external sources ensuring that the latest and most up to data is being used. This approach eliminates all the manual effort which can drastically reduce the time to produce reports and simulations thereby drastically reducing the time to transpose data into information and information into knowledge. This training will build on the skills obtained from the Basic and Advanced Excel courses.
MORNING: Overview of Excel Integration with Databases and External sources
AFTERNOON: Practical exercises with pulling data from External Sources
MORNING: Building a simple model with external data from external sources
AFTERNOON: Practical exercises - pulling data from External Sources
Building a complex Excel Template using multiple data sources
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. Light finger meals are supplied for part time courses.
There are currently no up and coming Excel Productivity courses scheduled.You may request that the course be scheduled. If you are interested please click here to fill out an enquiry form.
For clients who want to enjoy the convenience of public transport, consider the Gautrain. Our training premises in Woodmead is located near the Morning Glenn Mall Bus Stop. If organised by prior arrangement we will collect delegates from the afore mentioned bus stop at no extra charge. Direction to the bus stop are as follows:
Take the Gautrain to the Sandton station.
Take the S2 Bus to Morning Glenn Mall.
We will collect you at 8:30 directly from the bus stop.
Please submit a query on the course page and we will be able to advise you on hotels and guest houses close to the training facility.