Course code: NP1874
This advanced-level course empowers learners to master dynamic arrays, advanced lookup functions, statistical tools, and specialized rounding techniques in Excel 365. Designed for data professionals, analysts, and power users, this course focuses on automation, precision, and flexibility in spreadsheet operations using the latest Excel features.Professional
and certified lecturers
Internationally
recognized certifications
Wide range of technical
and soft skills courses
Great customer
service
Making courses
exactly to measure your needs
Starting date: Upon request
Guaranteed
Type: Self-paced
Course duration: 1 hour
Language: en
Price without VAT: 285 EUR
Starting date: Upon request
Guaranteed
Type: Self-paced
Course duration: 1 hour
Language: en
Price without VAT: 75 EUR
| Starting date |
Place |
Type | Course duration |
Language | Price without VAT | ||
|---|---|---|---|---|---|---|---|
| G | Upon request | Self-paced | 1 hour | en | 285 EUR | Register | |
| G | Upon request | Self-paced | 1 hour | en | 75 EUR | Register | |
| G | Guaranteed course | ||||||
Automate data spills and extract unique values.
Apply SORTBY, SEQUENCE, and RANDARRAY.
Use XLOOKUP, XMATCH, INDEX/MATCH, and OFFSET.
Use CHOOSE, SWITCH, and two-way lookups.
Use statistical functions and ranking tools.
Apply rounding logic and AGGREGATE function.
Module 1: Introduction
Module 2: Advanced Excel Functions
Module 3: Advanced Lookup Functions
Module 4: Statistical Functions in Excel
Module 5: Excel Rounding Functions
