Coming Soon!


Course Objectives

Master advanced formatting skills, protect your workbook, use functions to analyse data and build reports and graphically present your data. Every video will have its own supporting files for practice.

Learning Outcomes

  • Select and highlight cells and sheets in excel.
  • Protect cells , rows, columns, worksheets and multiple worksheets in excel.
  • Validate cells in excel.
  •  Use Advanced cut, copy paste in excel.
  • Format cells in excel (date, time, text, numeric, currency, percentage, fractions).
  • Format cell emphasis including: color, shading, merge, borders, comments.
  • Apply Conditional formatting.
  • Use absolute and relative cell referencing, named cells and ranges in excel formulas and functions+ types of errors and formula auditing.
  • Use mathematical functions (INT, ROUNDUP, ROUNDDOWN, SUMIF, SUMIFS, RANDBETWEEN).
  • Use statistical functions (COUNT, COUNTA, COUNTBALANK,COUNTIF,COUNTIFS, SUMIF,SUMIFS, RANK).
  • Use Logical functions 1,2 (IF, NEST IF, AND,OR, IFERROR, ISERROR).
  • Use text functions (LEFT, RIGHT, MID, SEARCH, TYPE, REPLACE, SUBSTITUTE, TEXT, LEN, &).
  • Use date and time functions (DAY, MONTH , YEAR , HOUR, MINUTE, SECOND, TIME, YEARFRAC, manipulate date and time formulas).
  • Use lookup functions (VLOOKUP, HLOOKUP).
  • Use Index-match function (INDEX, MATCH).
  • Prepare summaries using functions.
  • Create pivot table to summaries data.
  • Use subtotal function.
  • Use what-if analysis and scenario manager.
  • Present data using charts including pivot chart & format charts.
  • Create dashboards.

Target Audience

Finance professionals, Sales professionals, Marketing professional, HR professionals.

Course Curriculum

  Module (1): Manipulate and Format Workbook
Available in days
days after you enroll
  Module (2): Advanced Functions
Available in days
days after you enroll
  Module (3): Create summaries & Analyse Data
Available in days
days after you enroll
  Module (4): Create & Format Charts
Available in days
days after you enroll

Your Trainer Mrs. Shatha Idresi


Mrs. Shatha has more than 15 years' experience in teaching ICT, IT skills in international schools, she has a certificate in teaching and learning from Cambridge, and certified ICDL trainer.