Training course information
Course outline
Training schedule

At the end of this course, the participants should be able to:

  • Master the conditional formatting skill
  • Master the data validation skill and data filtering
  • Deal professionally with logical, Statistical and search and functions
  • Use references options
  • Design charts
  • Take advantage of the tables
  • Use Macro
  • Protect data

Conditional formatting (advanced formula-based)

  • Examples
  • Exercises

Data Validation

  • Examples
  • Exercises

Advanced data sorting and filtering

  • Examples
  • Advanced filtering

Reference types in the formula

  • Create Range
  • Relative reference
  • Mixed reference
  • Absolute reference
  • 3D references

Logical functions

  • IF function
  • IFS function
  • IFERROR function
  • AND function
  • OR function

Lookup functions

  • VLOOKUP function
  • XLOOKUP function

 Charts

  • Create a chart at a glance
  • Create a stacked vertical bar
  • Working with pie charts
  • Sparklines

Tables

  • Examples
  • Exercises
  • Rename table name
  • Format table
  • Create formula in a new column
  • Remove duplicate row

Automate processes with macros

  • Steps to create a micro
  • How to put a button for the micro in the taskbar
  • Examples

Use form control buttons to create interactive worksheets

  • Add a worksheet control
  • Examples
  • Exercises

Protect data

  • Protect sheet
  • Protect workbook

Training Courses Schedule for 2026 is now available

Discover our 2026 training programs and design your professional development plan with ALTAWAIL Consulting & Training.
Download the full schedule now to view upcoming course dates and outstanding training opportunities.

We provide consulting and training solutions backed by our accumulated expertise and the latest technologies and methodologies, enhancing the readiness of your employees and organization to deliver exceptional products and services.

-

2025 Training Schedule

Training course language: English

Training course venue: Jeddah

Training course end date: 29 April، 2025

Training course start date: 27 April، 2025

Training course language: English

Training course venue: Riyadh

Training course end date: 19 August، 2025

Training course start date: 17 August، 2025

Training course language: Arabic

Training course venue: Riyadh

Training course end date: 9 December، 2025

Training course start date: 7 December، 2025

Training course fee : SAR 4900

Advanced Microsoft Excel Skills

Find a course that works for you