Skillsharebeginneren

Excel Formulas & Functions: VLookup, HLookup, XLookup, Index-Match & More

Learn Microsoft Excel: Beginner to advanced skills. Master spreadsheets, data analysis, and powerful features. Boost your productivity!

5.0(3)
92students
1h 2m
Certificate
VersaSkills Suzanne_Hussein
VersaSkills Suzanne_HusseinInstructor

Course Content

Excel Formulas & Functions: VLookup, HLookup, XLookup, Index-Match & More is a beginner-level Skillshare course taught by VersaSkills Suzanne_Hussein. It runs 1h 2m, is taught in English, and includes a certificate of completion. Learners rate it 5.0 out of 5 from 3 reviews, with 92 students enrolled. It is a paid course, first published March 2025.

Unlock the Power of Microsoft Excel: A Comprehensive Course

Whether you're a beginner or an advanced user, this Microsoft Excel class is designed to elevate your data skills. Gain mastery over formulas, functions, and essential features to significantly streamline your workflow and work more efficiently with data and spreadsheets. If you're looking to master Excel formulas and functions, this step-by-step course is for you!

What You’ll Learn:

  • Extensive Coverage: Begin with fundamental functions like SUM and COUNT, then progress to advanced techniques including INDEX, MATCH, VLOOKUP, and XLOOKUP. Build a solid foundation for comprehensive Excel expertise.
  • Data Validation & Cleaning: Ensure data accuracy and integrity using Data Validation. Plus, master crucial text functions like TRIM, FIND, and SEARCH to effectively clean and prepare data for analysis.
  • Powerful Data Analysis: Learn to perform targeted calculations with SUMIF, COUNTIF, and ROUNDIF. Develop skills in efficiently handling and structuring both text and numerical values within your spreadsheets.
  • Data Transformation & Lookup Techniques: Become proficient in essential lookup functions such as VLOOKUP, HLOOKUP, and the modern XLOOKUP. Discover how to effectively transpose and organize data for optimal analysis.
  • Professional Data Presentation: Develop skills to structure and present your data in a visually compelling manner. Create polished spreadsheets that effectively communicate insights and stand out.
  • Hands-on Learning: Reinforce your understanding through real-world exercises and practice files. Benefit from step-by-step guidance from the instructor to solidify your skills.
$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0(437)
3h 15m
all
skillshare
5.0(302)
38m
intermediate
skillshare
5.0(28)
2h 31m
beginner
skillshare
skillshare

Advanced Excel

by Lisa Newton

5.0(6)
1h 22m
expert