Microsoft Excel® – Advanced


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.


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

Analyse Alternative Data Sets
  • Defining an Alternative Data Set
  • Defining Multiple Alternative Data Sets
  • Varying Your Data to Get a Desired Result by Using Goal Seek
  • Finding Optimal Solutions by Using Solver
  • Analysing Data by Using Descriptive Statistics
Create Dynamic Worksheets by Using PivotTables
  • Analysing Data Dynamically by Using PivotTables
  • Filtering, Showing, and Hiding PivotTable Data
  • Editing PivotTables
  • Formatting PivotTables
  • Creating PivotTables from External Data
Create Charts and Graphics
  • Creating Charts
  • Customising the Appearance of Charts
  • Finding Trends in Your Data
  • Summarizing Your Data by Using Sparklines
  • Creating Dynamic Charts by Using PivotCharts
  • Creating Diagrams by Using SmartArt
  • Creating Shapes and Mathematical Equations
Automate Repetitive Tasks by Using Macros
  • Enabling and Examining Macros
  • Creating and Modifying Macros
  • Running Macros When a Button is Clicked
  • Running Macros When a Workbook is Opened
Work with Other Microsoft Office Programs
  • Including Office Documents in Workbooks
  • Storing Workbooks as Parts of Other Office Documents
  • Creating Hyperlinks
  • Pasting Charts into Other Documents
Collaborate with Colleagues
  • Sharing Workbooks
  • Managing Comments
  • Tracking and Managing Colleagues’ Changes
  • Protecting Workbooks and Worksheets
  • Authenticating Workbooks
  • Saving Workbooks for the Web

callback request

Your Name

Contact Number




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:
for VAT purposes, only in the UAE


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

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