Advanced Microsoft Excel Training Course: Advanced Excel Course

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: excel courses : advanced excel course

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

advanced excel training course

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:

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:

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:

2018 Public Course Calendar

<