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.
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.
Save up to 10% by booking and paying
10 business days before the course.
Brochure:
Information may change without notice.
Audience
Excel users who need to develop and produce quality reporting on a regular basis.
Pre-Requisites
Good understanding of Excel and excel formulas.
Course Outline / Curriculum
MORNING: Overview of Excel Integration with Databases and External sources
Overview of Databases and other external data sources
Excel Ranges vs Excel Tables
Tools and techniques for importing data from various external sources
Demonstrations on Microsoft Access and Excel integration
Demonstrations on Microsoft sql Server and Excel integration
AFTERNOON: Practical exercises with pulling data from External Sources
Web site to Excel
Microsoft Access to Excel
Microsoft sql Server to Excel
Updating Access Tables and SQL Server Tables
Day 2
MORNING: Building a simple model with external data from external sources
Exercise with using Microsoft query
Exercise with Importing from Access
Exercise with data from sql server
Generating Pivot Tables with external data
AFTERNOON: Practical exercises - pulling data from External Sources
Web site to Excel integration
Microsoft Access to Excel integration
Microsoft Sql Server to Excel integration
Updating Access Tables and SQL Server Tables
Modifying import options
Adding Buttons to the Spreadsheet to manually refresh data
Day 3
Building a complex Excel Template using multiple data sources
Explanation of the scenario and data sources for the template
Explanation of Database Schema for SQL Server demo database
Building a customised sql server view with complex calculations and filters
Importing the required data for the chosen scenario being built
Building required Pivot Tables and Graphs for management reporting
Adding slicers to filter data for customised views
Adding buttons to automate data refresh
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
available:
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.
Gautrain
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
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.