Microsoft® Excel – Intermediate

SCHEDULE

November 15 to November 16 Abu Dhabi, United Arab Emirates Register
December 3 to December 4 Dubai, United Arab Emirates Register

COURSE AIMS

Discover how to build on your basic Excel skills and learn more complex formula and build formula across worksheets, linking data and charting your data. We also explore how you can protect your sheets and workbooks.

SAMPLE COURSE CONTENT

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

Visualizing Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Trend line
  • Create Advanced Chart
Creating Advanced Formulas
  • Apply Range Names
  • Use Specialized Functions
  • Organizing Worksheet Data with Tables
  • Create and Modify Tables
  • Summary and Database Functions to Calculate Data
Analyzing Data with Logical
  • Lookup Functions
  • Leverage Questions and Testing to Write Formulas
  • Use Logical and Lookup Functions to Find Answers to Questions
Workbooks
  • Enhancing
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
  • Protect Files
Analyzing Data with PivotTables
  • Create a PivotTable
  • Filter Data Using Slicers
  • Analyze Data Using Pivot Charts
Inserting Graphics
  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Incorporate Smart Art
callback request
Your Name

Contact Number

Company

Location

Email

How did you hear about us?


Follow us on:

Abu Dhabi

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

Dubai

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