How to use VLOOKUP in Excel

Описание: CBT Nuggets trainer Simona Millham demonstrates VLOOKUP, one of the most widely used functions in Microsoft Excel. Simona shows how to look up values in a table and return data you need, and also explains the differences between VLOOKUP and HLOOKUP. You will also learn why naming your ranges can make your formulas more efficient and easier to manage.

👉 Watch the entire Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) MO-211 training course: https://courses.cbt.gg/54l
🚀 Not a CBT Nuggets subscriber? Sign up today — your first 7 days are FREE: https://training.cbt.gg/sbp
===================

FAQs

Who should take this Excel course?
This course is for professionals who want to reach expert-level mastery of Microsoft Excel. It’s especially valuable for analysts, finance professionals, project managers, administrators, and anyone who builds reports or analyzes data. If you’ve ever wanted to learn how to create a pivot table in Excel (or use advanced formulas, charts, and workbooks with confidence) this course is designed for you.

Does the MOS: Excel Expert certification pay well?
While salaries vary by role and industry, earning the MOS Excel Expert certification often boosts career opportunities and earning potential. Employers value professionals who can automate reporting, eliminate errors, and create efficient Excel workbooks. Certification proves you can deliver accurate, data-driven insights, skills that translate directly into higher-value positions.

What certification does this Excel course prepare me for?
This training prepares you for the MO-211: Microsoft Office Specialist Excel Expert (Microsoft 365 Apps) exam. Passing MO-211 is part of earning the broader Microsoft Office Specialist Expert certification, which also requires additional exams in Word, PowerPoint, or Outlook. With this course, you’ll focus on advanced Excel skills that prove you can manage, analyze, and present data at the expert level.

Why is it so hard to learn how to make pivot tables in Excel?
Pivot tables in Excel are powerful because they combine multiple skills: cleaning raw data, selecting the right fields, and answering meaningful business questions. Many learners get stuck because they start without clear goals or structured practice. This course simplifies the process step by step, showing you exactly how to create a pivot table in Excel and apply it to real-world data analysis.

What jobs can I get with this MOS: Expert Excel course?
Expert-level Excel skills are in demand across industries. With this certification, you’ll stand out for roles like data analyst, financial analyst, business intelligence specialist, project manager, or administrative manager. The MOS Excel Expert proves you’re not just proficient, but certified to handle advanced analysis, large datasets, and complex reporting with ease.
-----------------

🌐 Get your IT Team trained — request a demo today: https://training.cbt.gg/getdemo
💡 Use our FREE IT Assessment tools to make data-driven decisions about your IT career path: https://training.cbt.gg/sh31
📚 FREE IT Certification Guides for popular IT certifications: https://training.cbt.gg/mwu
-----------------

#microsoft365 #exceltips #excel #microsoftexcel #microsoftoffice #ittraining #onlinetraining #microsoftcertification #adept #cbtnuggets