Master Advanced Microsoft Excel Training Course TODAY!
Some benefits of attending an advanced Excel Course include: Use Excel Table Feature like a Pro, Automate tasks with marvelous macros, become a Chart Wizard! Intensive and highly practical course Advanced Microsoft Excel Training Course (excel courses) will show you how to make Excel work for you and your organization. The advanced excel training will give you the tools and techniques needed to design models to suit a wide range of purposes. The course is practical and focused. Each of the modules presented will include step-by step explanations and hands on examples.
Advanced Microsoft Excel Training Course will teach delegates how to design, construct and then effectively use robust financial spreadsheets across a range of potential uses and applications.
Advanced Microsoft Excel Training Course – The Challenge Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa
A course about our advanced excel course is shown below:
Managers are often faced with the difficult tasks of analyzing high volumes of data in order to provide useful data for decision making. Microsoft Excel (especially with an advanced excel course) is a very powerful tool in the hands of those who know how to use it effectively. On the other hand it can cause many problems for those who do not know how to use it effectively.
Advanced Microsoft Excel Training Course – The Solution (Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa)
Advanced Microsoft Excel Training Course (excel courses) will enable the learner to:
- Understand and use advanced functions such as logical and lookup functions.
- Consolidate data from multiple workbooks.
- Protect a Microsoft Excel Workbook & save with a backup
- Create and modify Pivot Tables and Pivot Charts.
- Protect workbooks, worksheets & cells within worksheets.
- Work with calculated fields and summary tools.
- Analyse multiple data sources with the Power Pivot ad-in.
- Automate Pivot Tables with macros.
- Create & Modify Macros.
- Use advanced functions.
- Export and import data.
- Use conditional formatting.
Advanced Microsoft Excel Training Course is designed specifically for individuals who work within top management. And key skills learnt include the ability to:
- Auto Calculate
- Cell edit
- Multiple worksheets
- Understand data entry ranges
- Calculate across worksheets
- Worksheet and workbook linking
- Data Consolidation, Analysis, Management
- Exporting and Importing
- Querying external databases
- Importing Data
- Importing CSV files
- Text import wizard
- Exporting Data
- Choosing a specific format
- Exporting to word
- Pasting data with a link
- Copying a graph with a link
- Subtotals and Summarizing
- Manipulating display of totals
- Advanced value field settings
- Advanced data management
- Validating cell entries
- Pivot Table Reports and layout
- Refreshing data
- Pivot Chart Reports
- Macros
- Conditional Formatting & Smart Art
- Conditional formatting with graphics
- Smart Art graphic
Training Approach (Advanced Microsoft Excel Training Course)
Our advanced excel training course is designed so that the knowledge acquired is applied practically, so that the business environment can be enhanced.
The course has a strong focus on an outcomes based approach and is presented to encourage group participation and involvement. Key mechanisms used include:
- Practical relevant Exercises
- Speeches and Presentations
- Team sessions
- Practical Demonstrations
- Role-plays
- Questionnaires
- Discussions and
- Case examples
Related excel courses include:
- Beyond Advanced Excel 2010 Training Course
- Ms Office Excel Beginners 2013 Training Course
- Ms Office Excel Intermediate 2013 Training Course
All delegates (for Advanced Microsoft Excel Training Course – excel courses :Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa) will receive:
- Material, refreshments (lunch, tea) (Advanced Microsoft Excel Training Course)
- Memory stick (with relevant tools and models that can be easily accessed when applied back at work) (Advanced Microsoft Excel Training Course)
Advanced Excel Quiz
Free test of your Advanced Excel knowledge- click below:
Public Course Schedule and Costs
Please click on link below for our closely linked public course:
Solving Problems with Writing Excel Macros with VBA Course, Johannesburg
May 9 @ 8:30 am - May 11 @ 5:00 pm SAST Solving Problems with Writing Excel Macros with VBA Course, Cape Town
June 20 @ 8:30 am - June 22 @ 5:00 pm SAST Solving Problems with Writing Excel Macros with VBA Course, Johannesburg
June 27 @ 8:30 am - June 29 @ 5:00 pm SAST Solving Problems with Writing Excel Macros with VBA Course, Johannesburg
August 20 @ 8:30 am - August 22 @ 5:00 pm SAST Solving Problems with Writing Excel Macros with VBA Course, Johannesburg
October 31 @ 8:30 am - November 2 @ 5:00 pm SAST Solving Problems with Writing Excel Macros with VBA Course, Cape Town
November 26 @ 8:30 am - November 28 @ 5:00 pm SAST
Customized Courses – Book or Obtain Instant Quote
We also offer the above course across the country: Anytime, Anywhere. Click on the link to get an instant proposal or book your course NOW:
Book Course, Anytime, Anywhere
Or alternatively click on the button below to view our full Public Course Calendar of close to 100 events: