- Видео 105
- Просмотров 24 488
Computing Expert
Индия
Добавлен 8 ноя 2024
Welcome to COMPUTING EXPERT-your go-to source for expert tips and tricks in computer knowledge!
Dive into advanced tutorials on Excel, PowerPoint, and more, designed to boost your productivity and take your skills to the next level. Whether you're looking to master complex Excel functions, create standout PowerPoint presentations, or explore the latest computer hacks, we’ve got you covered. Subscribe now for easy-to-follow videos and elevate your tech skills with every clicks.
Dive into advanced tutorials on Excel, PowerPoint, and more, designed to boost your productivity and take your skills to the next level. Whether you're looking to master complex Excel functions, create standout PowerPoint presentations, or explore the latest computer hacks, we’ve got you covered. Subscribe now for easy-to-follow videos and elevate your tech skills with every clicks.
How to use Vlookup in Excel ! Vlookup in Microsoft Excel ! Excel Vlookup formula !
In this video, we cover:
✅ How to use Excel VLOOKUP without mistakes
✅ Finding data across different sheets
✅ Getting exact and approximate matches
✅ Solving common VLOOKUP errors effortlessly
Time Span :
0:00 Intro (about this video)
0:21 Benefit of this video
0:58 Vlookup Explained (beginner to advanced)
3:31 Lookup from another sheet
4:46 Lookup approximate match (closet match)
6:32 Avoid errors (common vlookup errors)
We'll start with the basics, showing you how to use VLOOKUP to find related data (like a customer’s profession) while setting up your table array correctly to avoid formula errors. Learn why fixing the table array is crucial for accuracy.
Practice File:
docs.google.com/spreadsheets/d/...
✅ How to use Excel VLOOKUP without mistakes
✅ Finding data across different sheets
✅ Getting exact and approximate matches
✅ Solving common VLOOKUP errors effortlessly
Time Span :
0:00 Intro (about this video)
0:21 Benefit of this video
0:58 Vlookup Explained (beginner to advanced)
3:31 Lookup from another sheet
4:46 Lookup approximate match (closet match)
6:32 Avoid errors (common vlookup errors)
We'll start with the basics, showing you how to use VLOOKUP to find related data (like a customer’s profession) while setting up your table array correctly to avoid formula errors. Learn why fixing the table array is crucial for accuracy.
Practice File:
docs.google.com/spreadsheets/d/...
Просмотров: 46
Видео
Advance 🤯 Hidden Features of Excel Pivot Tables | Full Hindi Tutorial for Beginners & Experts.
Просмотров 55714 дней назад
Advance 🤯 Hidden Features of Excel Pivot Tables | Full Hindi Tutorial for Beginners & Experts.
OMG😱 15 secret advance Excel formulas for daily use ‼️Excel formulas tutorial in hindi❗
Просмотров 16221 день назад
OMG😱 15 secret advance Excel formulas for daily use ‼️Excel formulas tutorial in hindi❗
Excel Chart with SUMIF formula and Drop-down List‼️Excel chart and formula and function
Просмотров 52Месяц назад
Excel Chart with SUMIF formula and Drop-down List‼️Excel chart and formula and function
Power Point full Tutorial !How to prepare this unique PPT Rotations slide ? Free Download PPT
Просмотров 106Месяц назад
Power Point full Tutorial !How to prepare this unique PPT Rotations slide ? Free Download PPT
Excel Waterfall Chart Full Tutorial ! Learn Everything About Waterfall Charts in Hindi
Просмотров 33Месяц назад
Excel Waterfall Chart Full Tutorial ! Learn Everything About Waterfall Charts in Hindi
How to Create a Unique PPT with SWOT Analysis: Full Step-by-Step Tutorial!
Просмотров 29Месяц назад
How to Create a Unique PPT with SWOT Analysis: Full Step-by-Step Tutorial!
Excel Check ✅ Box and Bar Chart Tutorial, "Excel में Check Box से Bar Chart को Interactive बनाएं"
Просмотров 31Месяц назад
Excel Check ✅ Box and Bar Chart Tutorial, "Excel में Check Box से Bar Chart को Interactive बनाएं"
Top 15 Basic Excel Formulas You MUST Know | Excel for Beginners Tutorial
Просмотров 44Месяц назад
Top 15 Basic Excel Formulas You MUST Know | Excel for Beginners Tutorial
Excel Pivot Table Formula kese lagaye tips and tricks ! Step-by-Step Guide
Просмотров 118Месяц назад
Excel Pivot Table Formula kese lagaye tips and tricks ! Step-by-Step Guide
Animation Power Point free download #ppt #animation #powerpoint #presentation #tutorial
Просмотров 49Месяц назад
Animation Power Point free download #ppt #animation #powerpoint #presentation #tutorial
Sir, also share video for power pivot..😊
As soon as possible
Bhai itta lamba kyu le jana ek column me sum karke usko drop down bhi to kr skte hai
@@adarsh8411 Dost ye 10000 same hai isliye...lekin sabhi salary me different ho to ek sath sabhi me se substrate kar sakte hai...aur data large aur jyada column ho to between column insert karne se dusre formula gadbada jate hai...jese ki kahi vlookup laga ho to column insert nahi kar sakate.. I hope you understand for this shortcut.
Hi Sir, Great video but it will be more helpful if you can provide practice sheet along the video. Thank you !
@@zaidtisekar5723 I share you practice file..give me your mail ID.
You can mail me personally my mail id is.. computingexpert13@gmail.com
कृपया Power bi का भी detail में वीडियो बनाये. धन्यवाद 🎉
@@mitjoshi8411 Sure definitely bnayenge.
Helpfull video
Good knowledge sharing video
Thanks
Nice job
Thanks!
Best for presentation
Thanks a lot
Good work
Slide presentation is worth for working
Working is good I want Tamplate
Good job 👌
Thanks 😅
New concept 🎉
Helpful
Glad you think so!
Really Expert class
Thanks a lot
Brief about check box from developer tab
Great
Usefull video ❤
Glad you think so!
Power Pivot ka tutorial share kijiye
@@AlkeshPatel-l8w Subscribe my channel and on notification as soon as early possible available on my channel
Experience video can do better Record
@@alkeshpatel9382 Sure try my best 😌
Good one
@@alkpat Thanks 🙏
Simple excel learn best
@@ALKESHPATEL-k8j Thanks 🙏
Good Explained 👌
@@alkeshpatel2437 thanks
Very useful formula
Thanks a lot
Nice work
Thanks for the visit
Required
GOOD
Like you efforts but work more
I will try my best
I want more attractive home page tutorial
Great
I wait for 😂 tutorial