Microsoft Excel® – Advanced

SCHEDULE

No schedule at the moment

If you have three or more candidates or you would like to run this course as an in-house programme, please contact us.

Course Pre-requisites

This programmes is designed for delegates who has completed the first two levels of our Microsoft® Excel programme, or has equivalent knowledge of using the various parts of the Microsoft Excel interface, can customise the excel environment, create advanced formulas, organise and analyse datasets and tables, and understand financial, data and time functions.

Overview

This programme is intended to help all users get up to speed on the different aspects of Excel, including its advanced features. We will cover how to automate worksheet functionality, audit worksheets, analyse data, work with multiple workbooks, export Excel data, import and export XML data, and create Excel forms.

Objectives

  • Learn how to update workbook properties
  • Practice creating and editing a macro
  • Know how to apply conditional formatting
  • Learn how to troubleshoot invalid data and fix errors
  • Understand the functions of PivotTables
  • Learn how to analyse data using statistical analysis tools
  • Know how to import and export Excel data

Course content

Below is an example of the course content. The content can be ‘tailored’ to meet the exact requirements of the client.

Day One

Automating worksheet functionality
  • Update workbook properties
  • Enable and examine macros
  • Create and edit a macro
  • Apply conditional formatting
  • Add data validation criteria
Auditing worksheets
  • Trace cells
  • Troubleshoot invalid data and formula errors
  • Watch and evaluate formulas
  • Create a data list outline
Create dynamic worksheets by using PivotTables
  • Analysing data dynamically by using PivotTables
  • Filtering, showing and hiding PivotTables data
  • Editing PivotTables
  • Formatting PivotTables
  • Creating PivotTables from external data

Day Two

Analysing data
  • Create Sparkline
  • Create scenarios
  • Perform a what-if analysis
  • Perform statistical analysis
  • Defining an alternative data set
  • Defining multiple alternative data sets
Working with multiple workbooks
  • Create a workspace
  • Consolidate data
  • Link cells in different workbooks
  • Merge workbooks
Importing and exporting Excel data
  • Export Excel data
  • Import a delimited text file
  • Integrate Excel data with the web
  • Create a web query
  • Import and export XML data
  • Creating Excel forms

METHODOLOGY OF TRAINING

The foundation of our training is anchored in activity-based experiential learning. This methodology takes into consideration different learning and communication styles, and more importantly language and cultural differences. It is through active participation that the adoption and application of theory is expedited.

Our training team pays careful attention to planning and designing effective instructional methods essential for the transfer of knowledge. It is the creative skill of our management trainers and consultants that reveal untapped skills of the delegates through:

    • Practical sessions
    • Individual and syndicate activities
    • Individual and group tasks
    • Case studies
    • Role plays
    • Audio and video evaluation
    • Action planning
    • Experiential learning games
    • Presentations
    • Assessments

 

Recent Post

callback request

Your Name

Contact Number

Company

Location

Email

How did you hear about us?


Abu Dhabi

P.O. Box 44705, Abu Dhabi,
United Arab Emirates
Phone: +971 2 6740340
Fax: +971 2 6743554

Tax Registration Number:
100003031000003
for VAT purposes, only in the UAE

Dubai

P.O. Box 334058, Dubai,
United Arab Emirates
Phone: +971 4 2566414
Fax: +971 4 2566424

Tax Registration Number:
100003031000003
for VAT purposes, only in the UAE