Excel - Funzioni di Ricerca (cerca.vert, cerca.x, index etc)
Enroll now →
About this course
This course is designed to help you master Excel's search functions, from the fundamentals to practical applications. You'll learn how to effectively use formulas like CERCA.VERT (VLOOKUP), XLOOKUP, and INDEX & MATCH, all while working through real-world exercises that reinforce your understanding. Whether you're a complete beginner or looking to sharpen your existing skills, this course will equip you to analyze and manage large datasets with confidence.
What you'll learn
- how to use CERCA.VERT (VLOOKUP) to find values in a column
- how to perform row searches using CERCA.ORIZZ (HLOOKUP)
- how to use the more modern CERCA.X (XLOOKUP)
- effective application of INDEX & MATCH for versatile searching
Course objectives
- to understand and apply Excel's main search functions
- to improve efficiency in data analysis and management
- to gain practical experience through exercises
Skills you'll gain
Related courses
Data Science Foundations
USD 49
Data Analytics in the Public Sector with R
USD 49
Data Science as a Field
USD 99
Geographic Information Systems (GIS)
USD 49
Data Visualization & Analytics in Tableau
USD 49
Programming for Python Data Science: Principles to Practice
USD 49
Enhancing Reproducible Science with GitHub and Docker
USD 49
Statistical Methods and Data Analysis
USD 49
Course details are provided by the platform and may change — always confirm on the provider's site. Links may be affiliate links.