Microsoft® Excel – Intermediate


SCHEDULED

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.

SAMPLE COURSE CONTENT

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

Perform Calculations on Data
  • Naming Groups of Data
  • Creating Formulas to Calculate Values
  • Summarizing Data That Meets Specific Conditions
  • Finding and Correcting Errors in Calculations
Create Styles and Format Data
  • Defining Styles
  • Making Numbers Easier to Read
  • Changing the Appearance of Data Based on Its Value
Focus on Specific Data by Using Filters
  • Defining Valid Sets of Values for Ranges of Cells
  • Manipulating Worksheet Data
  • Limiting Data that Appears on Your Screen
Reorder and Summarise Data
  • Sorting Worksheet Data
  • Organizing Data into Levels
  • Looking Up Information in a Worksheet
Combine Data from Multiple Sources
  • Using Workbooks as Templates for Other Workbooks
  • Linking to Data in Other Worksheets and Workbooks
  • Consolidating Multiple Sets of Data into a Single Workbook
  • Grouping Multiple Sets of Data

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