Microsoft® Excel – Intermediate

SCHEDULE

January 28 to January 29 Dubai, United Arab Emirates Register
March 7 to March 8 Abu Dhabi, United Arab Emirates Register
April 15 to April 16 Dubai, United Arab Emirates Register
July 25 to July 26 Dubai, United Arab Emirates Register
September 19 to September 20 Abu Dhabi, United Arab Emirates Register
October 28 to October 29 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

Recent Post

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