We use cookies to enhance your experience to know more press on the following link. Privacy Policy
إدارة تقنية المعلومات
18243

MS Excel Advanced

09-11-2025 To 13-11-2025
Online

This course will cover advanced Excel functions and features, including logical and lookup functions, conditional formatting, data validation, array formulas, and more. Participants will learn how to create, edit, and apply these advanced formulas and functions, allowing them to better analyze and manipulate data, solve complex problems, and automate repetitive tasks.

Date :
From 09 Till 13 Nov. 2025
City :
Online
Fees :
2900
Date :
From 09 Till 13 Nov. 2025
City :
Online
Fees :
2900

Overview

The aim of this training course is to provide participants with a comprehensive understanding of advanced formulas and functions in MS Excel, enabling them to perform complex data analysis, manipulation, and automation to enhance productivity and improve decision-making.

This course will cover advanced Excel functions and features, including logical and lookup functions, conditional formatting, data validation, array formulas, and more. Participants will learn how to create, edit, and apply these advanced formulas and functions, allowing them to better analyze and manipulate data, solve complex problems, and automate repetitive tasks.

Who Should Attend

This course is designed for professionals, and individuals who have a basic understanding of Excel and want to advance their skills and knowledge in using complex formulas and functions for data analysis, manipulation, and automation.

Target Group:

  • Business analysts
  • Financial analysts
  • Data analysts
  • Project managers
  • Accountants
  • Researchers
  • Office administrators
  • Anyone seeking to improve their MS Excel skills
  • Complete understanding of the higher functions of Excel
  • Perform the most advanced calculations and functions, manipulate data
  • Build complex formulas using nested functions (such as IF statements)
  • Find quicker ways to customise formulas by taking advantage of the built-in functions available in Excel
  • Save time by learning more sophisticated search and auditing techniques when working with data-heavy spreadsheets
  • Advanced formula creation and editing
  • Data analysis and manipulation
  • Conditional formatting and data validation
  • Array formula mastery
  • Error-handling techniques
  • Automation and efficiency improvement

Using logical functions

  • The IF function (recap)
  • Creating nested IF functions
  • The IFS function
  • AND and OR functions
  • Combining logical functions
  • Working with Lookups

  • The VLOOKUP function
  • The HLOOKUP function
  • The XLOOKUP function (365)
  • INDEX & MATCH
  • Contact Us

    For each learning and development project we establish strong relationships and effective communication with partners.
    Don't hesitate to contact us.