Microsoft Excel® – Advanced


SCHEDULED

December 16 to December 17 Abu Dhabi, United Arab Emirates Register

SAMPLE COURSE CONTENT

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

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