Course code: NP1873
This intermediate-level course builds on foundational Excel skills and introduces advanced tools for data control, logical functions, lookups, sorting, and date-time calculations. Learners will explore practical techniques to improve spreadsheet readability, automate decisions, and manage complex datasets. Ideal for professionals, analysts, and students ready to level up their Excel expertise.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 | ||||||
Use styles, validation, and navigation tools.
Automate decisions with IF and IFS functions.
Use flexible lookup functions for dynamic data.
Organize data with custom lists and formulas.
Calculate workdays, durations, and custom formats.
Module 1: Introduction
Module 2: Improving Data Interaction
Module 3: Smart Formulas and Functions
Module 4: Lookup and Reference Tools
Module 5: Sorting and Filtering Data
Module 6: Working with Dates
