Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Data Analysis: VLOOKUP, HLOOKUP, XLOOKUP, and Power Query Functions

Simon Sez IT via YouTube

Start learning Write review
Scrimba Ad

Get 20% off all career paths from fullstack to AI

Learn More → Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Learn essential Excel lookup functions and data analysis techniques in this comprehensive video tutorial. Master VLOOKUP, HLOOKUP, and XLOOKUP functions to efficiently retrieve and analyze data across complex spreadsheets. Explore practical applications with clear examples for both exact match searches and working with dynamic ranges. Advance your skills by diving into Power Query for automated data transformation and cleaning, while discovering how to create data models and leverage pivot tables for enhanced reporting capabilities. Download provided course files to practice hands-on with real-world examples and gain proficiency in streamlining data workflows using Excel's powerful data management tools.

Syllabus

- Data Analysis with VLOOKUP, HLOOKUP and XLOOKUP
- Data Models, Pivot Tables and Power Query in Excel

Taught by

Simon Sez IT

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Excel Data Analysis: VLOOKUP, HLOOKUP, XLOOKUP, and Power Query Functions

  • Profile image for Anand Gorde
    Anand Gorde
    This Excel course was really helpful and easy to follow. The instructor explained everything clearly with practical examples, which made learning simple. I feel much more confident using Excel now. I highly recommend this course to anyone who wants to improve their Excel skills.

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.