Advanced Microsoft Excel (3 Saturdays)
Starts: Saturday, 22 March, 2014 12:00am
Ends: Saturday, 5 April, 2014 12:00am
In general, MS Excel is an essential working tool to any discipline that
requires the use of numbers. In the specialised field of Business improvement, spread
sheets are of prime importance in analysing and displaying performance data.
What You Will Learn:
- Excel Functions in-depth
- Pivot Tables
- Advanced Analysis with Pivot Tables
- Analysing Data
- Data Validation
- Managing Multiple Worksheets and workbooks
- Introduction to Excel Dashboard Creation
- Excel Pivot Tables in Depth
- Excel Macros in Depth
- Excel VBA in Depth
- Excel Charts in Depth (Dashboards)
- Synchronizing Excel with other DBMS tools
Who Should Attend:
This course is designed to help Excel users who want to delve
deeper into the functionalities of the Excel Application.
This course functions as a stand-alone course, however, you are required
to have a Laptop PC with MS Excel installed on it. You should also have basic MS Excel
knowledge to attend this course.
You will receive a course binder containing copies of presentation slides, case
studies, templates, exercises, and suggested solutions.