- 40
- 116 607
Desi Goodly
India
เข้าร่วมเมื่อ 5 ม.ค. 2023
Lakho Rows ke Data par VLOOKUP Seconds Mein Lagana Sikhein! VLOOKUP on Large Data
How to Apply VLOOKUP on Large Data Set in Excel / VLOOKUP in Large Sheet
Is video mein aap seekhenge ki large datasets par Excel mein VLOOKUP kaise apply karein. Agar aapke paas lakhon rows ka data ho aur aapko quick results chahiye, toh yeh video aapke liye hai. Excel mein VLOOKUP lagane ka best tricks jaaniye aur apna time bachaaiye. Excel users ke liye yeh tutorial bahut helpful hoga, toh zarur dekhiye or sikhiye Excel VLOOKUP Tricks!
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dashboards/
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download the Excel File ⬇️ - goodly.co.in/wp-content/uploads/2024/11/Fast-Vlookup-on-large-dataset-in-Excel.xlsx
===== CONTACT 🌐 =====
Twitter - chandeep2786
LinkedIn - www.linkedin.com/in/chandeepchhabra/
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
Is video mein aap seekhenge ki large datasets par Excel mein VLOOKUP kaise apply karein. Agar aapke paas lakhon rows ka data ho aur aapko quick results chahiye, toh yeh video aapke liye hai. Excel mein VLOOKUP lagane ka best tricks jaaniye aur apna time bachaaiye. Excel users ke liye yeh tutorial bahut helpful hoga, toh zarur dekhiye or sikhiye Excel VLOOKUP Tricks!
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dashboards/
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download the Excel File ⬇️ - goodly.co.in/wp-content/uploads/2024/11/Fast-Vlookup-on-large-dataset-in-Excel.xlsx
===== CONTACT 🌐 =====
Twitter - chandeep2786
LinkedIn - www.linkedin.com/in/chandeepchhabra/
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
มุมมอง: 1 926
วีดีโอ
11 Zabardast Excel Tricks 🤯🔥
มุมมอง 13K14 วันที่ผ่านมา
Advanced Excel Tips and Tricks You Need to Know! Is video mein hum sikhenge 11 zabardast Excel tricks aur useful Excel functions jo aapke kaam ko asaan bana denge! Agar aap Excel beginner hain ya advanced user, ye Excel tips aur tricks aapke liye bohot helpful rahenge or apke kaam ko aasan kar denge. ONLINE COURSES ✔️ Mastering DAX in Power BI - goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Co...
Excel Seekhne Ka Sahi Tarika - The 80/20 Hack!
มุมมอง 1K28 วันที่ผ่านมา
How to Master Excel in 2024 with the 80/20 Rule! Is video mein hum Excel sikhne ka sahi tarika samjhenge. Excel mein 450 functions aur concepts hain, lekin main aapko wo top 20% concepts bataunga jo aapko zaroor aane chahiye. Ye wahi concepts hain jo har Excel job mein kaam aayenge. Agar aap ye concepts sikh lete hain, toh aapko job bhi jaldi mil sakti hai. Ye method aapko Excel jaldi seekhne a...
7 Zabardast Pivot Table Tricks 🤯🔥
มุมมอง 37K9 หลายเดือนก่อน
Excel Pivot Table Tips & Tricks in Hindi Is video mein, hum lekar aaye hain Excel Pivot Table ke 7 zabardast tricks jo aapke data analysis aur report creation ke skills ko ek naye level par le jayenge. Aisi aur informative videos ke liye, Goodly Hindi ko subscribe karna na bhulein. #Excel #pivottable #exceltipsandtricks ONLINE COURSES ✔️ Mastering DAX in Power BI - goodly.co.in/learn-dax-powerb...
Excel mein Multiple PDFs ko Ek File mein Combine Karne ki Magic Trick
มุมมอง 8829 หลายเดือนก่อน
How to Combine Data from Multiple PDF Files into a Single File in Excel Aaj hum seekhenge ki kaise hum Power Query ka istemal karke bohot saare PDF files ke data ko ek single file mein combine kar sakte hain. Iske liye hum Power Query mein Pdf.Tables function ka istemal karenge aur multiple PDFs ke data ko ek Excel file mein combine karenge #powerquery ONLINE COURSES ✔️ Mastering DAX in Power B...
Power BI Ke 7 Gazab Tricks 🤯
มุมมอง 1.4K9 หลายเดือนก่อน
7 Mind-Blowing Power BI Tricks for Beginners / Power BI Tips & Tricks in Hindi Iss video mein, hum aapko Power BI ke 7 majedar aur asardaar tricks dikhayenge, jo na sirf aapka bohot saara samay bachayenge, balki data analysis aur report creation ko bhi asaan aur tez banayenge. ONLINE COURSES ✔️ Mastering DAX in Power BI - goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course- goodly.co.in/learn...
Excel Me Multiple Files Ko Kaise Merge Kare || Step-by-Step Guide in Hindi
มุมมอง 1.4K9 หลายเดือนก่อน
th-cam.com/video/k0BsdZWcdyY/w-d-xo.htmlsi=9f20DAROURHtel8z th-cam.com/video/GMjskWrFZSk/w-d-xo.htmlsi=F_FPvjr1GFiIJ8XX Bohot baar hume files merge karni padti hai, lekin unme data bohot inconsistent hota hai. Is video mein, hum sikhenge ki kaise hum automatically multiple Excel files ko ek single file mein merge kar sakte hain. Aisi aur informative videos ke liye, Goodly Hindi ko subscribe kar...
Excel's Dynamic Range Ka Jadu | Goodly Hindi
มุมมอง 1K9 หลายเดือนก่อน
In this video, we will explore a super useful cell naming technique in Excel! ONLINE COURSES ✔️ Mastering DAX in Power BI - goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course- goodly.co.in/learn-power-query/ ✔️ Master Excel Step by Step- goodly.co.in/learn-excel/ ✔️ Business Intelligence Dashboards- goodly.co.in/learn-excel-dashboards/ LINKS 🔗 Blog 📰 - www.goodly.co.in/blog/ Corporate Traini...
Find Duplicate Values in VLOOKUP | Hindi
มุมมอง 1.1K10 หลายเดือนก่อน
Advance VLOOKUP in Excel / How to perform VLOOKUP in Power Query In this video, we will learn to extract duplicate values using a lookup formula in Excel. Normally, lookup formulas cannot handle duplicate values as they only work with unique values. However, I will show you a unique approach using an IF formula and TEXTJOIN function that will enable you to extract all the duplicate values with ...
Create a Dynamic File Path in Excel & Power BI || Goodly Hindi
มุมมอง 2.6K10 หลายเดือนก่อน
Combine Data from Multiple Excel Files in a Single File in Hindi - th-cam.com/video/k0BsdZWcdyY/w-d-xo.htmlsi=RbnLuF9DRM8gkvfF Combine Data from Multiple Excel Files with Dynamic Sheets and Columns - th-cam.com/video/GMjskWrFZSk/w-d-xo.htmlsi=5EbBoyKXEiKr-mXE Are you tired of dealing with static file paths in Excel and Power BI? In this video, we will show you how to make your Excel and Power B...
Advanced Group By Tricks in Power Bl || Goodly Hindi
มุมมอง 1.9K10 หลายเดือนก่อน
How to use the Group By option in Power BI / How to use Group By in Power Query / Summarize Data in Power BI without DAX In this video, I will share how to use the Group By feature effectively to summarize the data in Power Query and do better analysis. #powerquerytutorial #powerbi #dataanalysis ONLINE COURSES ✔️ Mastering DAX in Power BI - goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course-...
Actual v/s Target Chart in Power BI | Goodly Hindi
มุมมอง 1.9K11 หลายเดือนก่อน
In simple Hindi, we will learn to build Target v\s Actual Chart in Power BI We will also explore the logic & putting all the things together to build a beautiful Chart! Reid Haven's Tool Tip Video - th-cam.com/video/epDb9ruV0bU/w-d-xo.html ONLINE COURSES ✔️ Mastering DAX in Power BI - goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course- goodly.co.in/learn-power-query/ ✔️ Master Excel Step by ...
Power BI Beginners Guide 2024 (in Hindi)
มุมมอง 2.8K11 หลายเดือนก่อน
How to Learn Power BI the RIGHT WAY in 2024 / How to learn Power BI for Data Analysis in Hindi Welcome to the ultimate guide for mastering Power BI in 2024! If you're starting your journey in data analysis and want to learn Power BI the right way, this video is your go-to resource. Perfect for beginners and those interested in data science, our step-by-step learning guide will make learning Pow...
How to Unpivot Data in Google Sheets Using FLATTEN Function || Goodly Hindi
มุมมอง 36511 หลายเดือนก่อน
Iss video mein hum dekhenge ki Google Sheets mein data ko kaise Unpivot karte hain. Hum FLATTEN function ka use karke data ko Google Sheets mein unpivot kareenge. Unpivoting Explained | Create a Pivot Table with Cross-Tab Data - th-cam.com/video/52fIUNI3s90/w-d-xo.htmlsi=urcbq0EKCJ3YXXPJ #googlesheets #pivottable #FlattenFunction ONLINE COURSES ✔️ Mastering DAX in Power BI - goodly.co.in/learn-...
Filter Using a List of Values in Power Query | Goodly Hindi
มุมมอง 3K11 หลายเดือนก่อน
We will see the Magic of Dynamic Filters in the Power Query ONLINE COURSES ✔️ Mastering DAX in Power BI - goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course- goodly.co.in/learn-power-query/ ✔️ Master Excel Step by Step- goodly.co.in/learn-excel/ ✔️ Business Intelligence Dashboards- goodly.co.in/learn-excel-dashboards/ LINKS 🔗 Blog 📰 - www.goodly.co.in/blog/ Corporate Training 👨🏫 - www.goodl...
How to Calculate Growth Over Last Year in Power BI || Step-by-Step Tutorial
มุมมอง 3.3Kปีที่แล้ว
How to Calculate Growth Over Last Year in Power BI || Step-by-Step Tutorial
How to Use VLOOKUP Like Excel in Power BI Using DAX | Hindi
มุมมอง 2.1Kปีที่แล้ว
How to Use VLOOKUP Like Excel in Power BI Using DAX | Hindi
Automatically Remove Top Junk Rows & Combine Data from Multiple Excel Files || Goodly Hindi
มุมมอง 538ปีที่แล้ว
Automatically Remove Top Junk Rows & Combine Data from Multiple Excel Files || Goodly Hindi
The Magic of 'Let Function' in Excel || Goodly Hindi
มุมมอง 1.1Kปีที่แล้ว
The Magic of 'Let Function' in Excel || Goodly Hindi
Remove Nested IF using the VLOOKUP Function || Simplify Your Formulas || Excel Trick in Hindi
มุมมอง 746ปีที่แล้ว
Remove Nested IF using the VLOOKUP Function || Simplify Your Formulas || Excel Trick in Hindi
Auto-Import Data from Email Attachments to Excel using Power Query || Goodly Hindi
มุมมอง 861ปีที่แล้ว
Auto-Import Data from Email Attachments to Excel using Power Query || Goodly Hindi
Dynamic Filtering in Excel Power Query | How to Apply Filters That Update Automatically
มุมมอง 1.2Kปีที่แล้ว
Dynamic Filtering in Excel Power Query | How to Apply Filters That Update Automatically
Highlight Values below Target in Power BI | Goodly Hindi
มุมมอง 527ปีที่แล้ว
Highlight Values below Target in Power BI | Goodly Hindi
How to Create a Custom Fiscal Year Date Table in Power BI | Goodly Hindi
มุมมอง 7Kปีที่แล้ว
How to Create a Custom Fiscal Year Date Table in Power BI | Goodly Hindi
Highlight MIN and MAX Values in Power BI || Goodly Hindi
มุมมอง 7Kปีที่แล้ว
Highlight MIN and MAX Values in Power BI || Goodly Hindi
Combine Data from Multiple Excel Files with Dynamic Sheets and Columns || Goodly Hindi
มุมมอง 777ปีที่แล้ว
Combine Data from Multiple Excel Files with Dynamic Sheets and Columns || Goodly Hindi
Calculating Indian Fiscal Year and Quarter || A Step-by-Step Guide || Goodly Hindi
มุมมอง 448ปีที่แล้ว
Calculating Indian Fiscal Year and Quarter || A Step-by-Step Guide || Goodly Hindi
Impress Your Boss with these 5 Epic Excel Data-Cleaning Tricks | Goodly Hindi
มุมมอง 690ปีที่แล้ว
Impress Your Boss with these 5 Epic Excel Data-Cleaning Tricks | Goodly Hindi
How to Use VLOOKUP in Power Query | Goodly Hindi
มุมมอง 3.1Kปีที่แล้ว
How to Use VLOOKUP in Power Query | Goodly Hindi
5 Excel VLOOKUP Hacks That Are Too Good to Be True | Goodly Hindi
มุมมอง 366ปีที่แล้ว
5 Excel VLOOKUP Hacks That Are Too Good to Be True | Goodly Hindi
@YogeshTheDigitalGuru-j5p I want to know one formula. Amit 45/45 Amit. 59/34 Amit 92/45 Rahul 33/494 Rahul 45/45 Mere pas is tarah ka data he bahot sare log he isi tarah. Me chahta hu ye data is form me aajaye to kese hoga Amit 45/45, 59/34, 92/45 Rahul 33/494, 45/45
Awesome sir
🤨🤨
Sir course Hindi main v banaya
गजब मजा आ गया
Your videos are very useful and you explained beautifully every functions with details. But numbers of videos uploaded by you are very less. Sir, you are kindly requested to please upload more and more videos on your channel do that learners get benefitted much more.
Ye apka English wala video me apne Hindi dubbed bad me kiya hai. Maine ye video pahle dekha hai
Power query a to z video banaye
Sir please next video on X lookup basic to advanced, Index match basic to advanced, Power query basic to advanced, Left, right, mid basic to advanced 1 industry level projects Pls 🙏🙏🙏🙏🙏🙏 sir 😊
Next will be on Google sheets. I'll make a video on Xlookup tricks after that. thanks for the suggestions 😃
Download the Excel File ⬇ - goodly.co.in/wp-content/uploads/2024/11/Fast-Vlookup-on-large-dataset-in-Excel.xlsx Find Duplicate Values in VLOOKUP - th-cam.com/video/f32eQV3Vg-8/w-d-xo.htmlsi=eQS0Ds-7bGaEfOcf 11 Zabardast Excel Tricks - th-cam.com/video/NqrSUmPZ2sQ/w-d-xo.htmlsi=2NR2gEpvHsXzZs3G
So so so so Wonderful tricks, thanks
Yaar Chandeep, ki appaan, Vlookup dee jagah Xlookup nee la sagde, es file de ander ?
Practice file kahan hai ?
goodly.co.in/wp-content/uploads/2024/11/Fast-Vlookup-on-large-dataset-in-Excel.xlsx
Please course start in hindi
sir plz provide datasets for practice .....
goodly.co.in/wp-content/uploads/2024/11/Fast-Vlookup-on-large-dataset-in-Excel.xlsx
Another Cood tricks
Sir thank you thanks a lot
Hello sir ,Dono jagah false(0) formala lga ke bhi fast formula lg skta hai kya
on a large data .. it might crash your excel!
bhai qtr wise sales krne pe q3 q1 q2 aa rha hai value sorting ki wajah se but mujhe q1 q2 q3 me chahiye kaise karu
just sort by clicking on the header
Nice Bro kindly Stationery Shop k liy POS with Sales Purchase Inventory etc banaiy please Stationery Shop Daily Sales Inventory Purchase Profit and Loss
which software are you using for marking in red while recording screen?
camtasia
Congrats Another subscriber
welcome
Sir .I have subscribed you . Your teaching style is excellent. I want learn how make a excrl sheet for data entry. Regards.
"Your tutorials are a game-changer! The way you break down complex concepts into simple, easy-to-follow steps has truly enhanced my Excel skills. I can already see how much more efficient I’ll be in my work. Thank you for sharing your expertise and making learning so enjoyable! Keep up the amazing work-your content is incredibly valuable and motivating!"
Thanks!
cool.. great urdu❤
Hiii I am new subscriber
Welcome aboard!
Great!
Amazing
Good morning sir all sheets selected data only want to print in a single paper,excel
FANTASTIC
Sir please check my formula ="Q"&" "&CHOOSE(MONTH(A1),4,4,4,1,1,1,2,2,2,3,3,3)
I am like😮
alt + f1 for charts is not woring on w-11
Zabardast 😊
Sir row ko bhi very hide Kar saktay h
11th are awesome trick
Last one we learned first time.
We not only learn data analytics skills but also presentation skills. We love Chandeep Paji's cute hindi also.
Your the boss ❤️
for me personally, the best tricks were copy pasting new data to update the chart and using format feature in graphs like format painter.
Sir, kindly share your contact details, I would like to join your class.
please drop an email - pratik@goodly.co.in
Soooperb..
Thank you very very much, Chandeep bhayya!!🤗 Time Stamps: 01:21 Autofilter 03:21 Fast Sorting 05:01 Creating Charts 05:30 Update an existing chart with new data 06:54 Copy-Paste Formatting of one chart to another 08:15 Getting back to the formula (not to the formula bar, but within the sheet) 09:51 Converting numbers to dates 11:36 Sum data (of same locations) from multiple sheets 13:37 Multiple Vlookup values (i.e. when a primary key has multiple values) (MOST USEFUL) 17:42 VERY HIDE SHEETS option 19:45 Create and Add customs lists (eg. FY months) and use for custom sorting
Thank you so much for aur phele baar aapne hindi me kiya hai. Grt, i am inspired by your way of teaching.
❤
Auto Filter is awesome
Awesome tricks..Mind blowing
Thank you for sharing these tricks in a consolidation. I am using almost all these tricks / shortcut keys on daily basis.
WHILE APPLYING IF FORMULA, I GET ONLY ONE ANSWER.