Modern Excel Functions

SKU: M2134
4 Lesson
|
4 Hours
This course introduces modern Excel functions designed for dynamic data analysis. You will learn how dynamic arrays work and how functions like FILTER, SORT and UNIQUE simplify data processing.
Enroll Now
Modern Excel Functions

Overview

Prerequisites

  • Basic knowledge of Excel formulas
  • Familiarity with working with datasets

What Will You Learn

  • Understand dynamic arrays in Excel
  • Use FILTER to extract specific data
  • Sort datasets automatically with SORT
  • Identify unique values using UNIQUE
  • Combine modern functions for advanced analysis

Key Features

Course Curriculum

1. Understanding dynamic arrays
2. Spill ranges and automatic calculations
1. Using FILTER function
2. Combining FILTER with conditions
1. Using SORT function
2. Using UNIQUE function
1. Using formulas together
2. Building smart data analysis formulas
Talk To Us

We are happy to help you

1-800-7430-173 (US Toll Free)
+91 7240740740 (India)
Drop Us a Query
Fields marked * are mandatory

Request For Live Demo Class

Course Fees

Online Class Room Program

US $ 199.00
100% Money Back Guarantee
  • Duration : 4 Hrs
  • Plus Self Paced

Classes Starting From

  • Fast Track Batch 28 May 2026
  • Weekday Batch 01 Jun 2026
  • Weekend Batch 30 May 2026

Corporate Training

Corporate Training
  • Customized Training Delivery Model
  • Flexible Training Schedule Options
  • Industry Experienced Trainers
  • 24x7 Support
Contact Us

Trusted By Top Companies Worldwide

MITSUBISHI
Emirates
BECHTEL
Tech Mahindra
Techmill
metacube
Fareportal
Trelleborg
Capgemini
AU Small Finance Bank
United Nations
Inter Mid
SoftFlex
align
utthunga
Rimini Street
EJADAH
Yash Technologies
suyati
Hettich
APPCINO

Want to know Today's Offer

Reviews

Login
Forgot Password?
Don't have an account?
Sign Up

Our Alumni works at

HCL
FAI
YOKAGAWA
Tech Mahindra
SOCIETE GENERALE
SAMSUNG
EMIDS
DHL
FedEx
PayPal
BOSCH
asian paints
MICRO FOCUS
hgs
eClerx
Nasdaq
Persistent
CSS CORP

Explore Other Courses

Recently Viewed Courses

×

Your Shopping Cart


Your shopping cart is empty.
Checkout

View Cart

Continue Shopping