Advanced Microsoft Excel Training Course

Master Advanced Microsoft Excel Training Course TODAY!

The intensive and highly practical course Advanced Microsoft Excel Training Course will show you how to make Excel work for you and your organization. The course 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

Advanced Microsoft Excel Training Course – The Challenge Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa

A course about our 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 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  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 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 course include:

All delegates (for Advanced Microsoft Excel Training Course: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)

Course Schedule and Costs

Please click on links below for price and venue of the courses:

Advanced Microsoft Excel Training Course  is an essential skill.

 Book Now! View Calendar for the latest course