Desi Goodly
Desi Goodly
  • 40
  • 116 607
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!
มุมมอง: 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

ความคิดเห็น

  • @shubhamrathore3703
    @shubhamrathore3703 8 ชั่วโมงที่ผ่านมา

    @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

  • @abhishekmaurya8298
    @abhishekmaurya8298 12 ชั่วโมงที่ผ่านมา

    Awesome sir

  • @lookingfacts6879
    @lookingfacts6879 22 ชั่วโมงที่ผ่านมา

    🤨🤨

  • @vijaykumarjain3222
    @vijaykumarjain3222 23 ชั่วโมงที่ผ่านมา

    Sir course Hindi main v banaya

  • @satishverma1130
    @satishverma1130 23 ชั่วโมงที่ผ่านมา

    गजब मजा आ गया

  • @fpathan8091
    @fpathan8091 วันที่ผ่านมา

    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.

  • @deepraazshaw7369
    @deepraazshaw7369 วันที่ผ่านมา

    Ye apka English wala video me apne Hindi dubbed bad me kiya hai. Maine ye video pahle dekha hai

  • @miteshpatel7101
    @miteshpatel7101 วันที่ผ่านมา

    Power query a to z video banaye

  • @vandanapatil8182
    @vandanapatil8182 วันที่ผ่านมา

    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 😊

    • @desigoodly
      @desigoodly วันที่ผ่านมา

      Next will be on Google sheets. I'll make a video on Xlookup tricks after that. thanks for the suggestions 😃

  • @desigoodly
    @desigoodly วันที่ผ่านมา

    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

  • @abhishekmaurya8298
    @abhishekmaurya8298 วันที่ผ่านมา

    So so so so Wonderful tricks, thanks

  • @TonySon55
    @TonySon55 วันที่ผ่านมา

    Yaar Chandeep, ki appaan, Vlookup dee jagah Xlookup nee la sagde, es file de ander ?

  • @amritmukherji6830
    @amritmukherji6830 วันที่ผ่านมา

    Practice file kahan hai ?

    • @desigoodly
      @desigoodly วันที่ผ่านมา

      goodly.co.in/wp-content/uploads/2024/11/Fast-Vlookup-on-large-dataset-in-Excel.xlsx

  • @anandsharanpandya6836
    @anandsharanpandya6836 วันที่ผ่านมา

    Please course start in hindi

  • @chinyu5934
    @chinyu5934 วันที่ผ่านมา

    sir plz provide datasets for practice .....

    • @desigoodly
      @desigoodly วันที่ผ่านมา

      goodly.co.in/wp-content/uploads/2024/11/Fast-Vlookup-on-large-dataset-in-Excel.xlsx

  • @dipongkarroy1720
    @dipongkarroy1720 วันที่ผ่านมา

    Another Cood tricks

  • @abubakarmaleen1974
    @abubakarmaleen1974 วันที่ผ่านมา

    Sir thank you thanks a lot

  • @mohitvyas7867
    @mohitvyas7867 2 วันที่ผ่านมา

    Hello sir ,Dono jagah false(0) formala lga ke bhi fast formula lg skta hai kya

    • @desigoodly
      @desigoodly 2 วันที่ผ่านมา

      on a large data .. it might crash your excel!

  • @vkp526
    @vkp526 3 วันที่ผ่านมา

    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

    • @chandeepchhabra
      @chandeepchhabra 3 วันที่ผ่านมา

      just sort by clicking on the header

  • @zakirkhayali-xm3gr
    @zakirkhayali-xm3gr 3 วันที่ผ่านมา

    Nice Bro kindly Stationery Shop k liy POS with Sales Purchase Inventory etc banaiy please Stationery Shop Daily Sales Inventory Purchase Profit and Loss

  • @justkailash
    @justkailash 4 วันที่ผ่านมา

    which software are you using for marking in red while recording screen?

    • @desigoodly
      @desigoodly 3 วันที่ผ่านมา

      camtasia

  • @nayanbadkar8680
    @nayanbadkar8680 5 วันที่ผ่านมา

    Congrats Another subscriber

    • @desigoodly
      @desigoodly 5 วันที่ผ่านมา

      welcome

  • @naeemulhassan1426
    @naeemulhassan1426 6 วันที่ผ่านมา

    Sir .I have subscribed you . Your teaching style is excellent. I want learn how make a excrl sheet for data entry. Regards.

  • @A.O.Siddiqui
    @A.O.Siddiqui 7 วันที่ผ่านมา

    "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!"

  • @A.O.Siddiqui
    @A.O.Siddiqui 7 วันที่ผ่านมา

    Thanks!

  • @tanveerabbas3271
    @tanveerabbas3271 8 วันที่ผ่านมา

    cool.. great urdu❤

  • @rihansiddiqui0808
    @rihansiddiqui0808 8 วันที่ผ่านมา

    Hiii I am new subscriber

    • @desigoodly
      @desigoodly 8 วันที่ผ่านมา

      Welcome aboard!

  • @A.O.Siddiqui
    @A.O.Siddiqui 9 วันที่ผ่านมา

    Great!

  • @rajchandan7551
    @rajchandan7551 9 วันที่ผ่านมา

    Amazing

  • @omprakashthakur4515
    @omprakashthakur4515 10 วันที่ผ่านมา

    Good morning sir all sheets selected data only want to print in a single paper,excel

  • @ramu2526
    @ramu2526 10 วันที่ผ่านมา

    FANTASTIC

  • @avinashmajhi2510
    @avinashmajhi2510 11 วันที่ผ่านมา

    Sir please check my formula ="Q"&" "&CHOOSE(MONTH(A1),4,4,4,1,1,1,2,2,2,3,3,3)

  • @00000raunak123456789
    @00000raunak123456789 11 วันที่ผ่านมา

    I am like😮

  • @MImad-rv5gt
    @MImad-rv5gt 11 วันที่ผ่านมา

    alt + f1 for charts is not woring on w-11

  • @sanjaygandhi5494
    @sanjaygandhi5494 11 วันที่ผ่านมา

    Zabardast 😊

  • @shafatali1627
    @shafatali1627 12 วันที่ผ่านมา

    Sir row ko bhi very hide Kar saktay h

  • @Kumar_ravi_r
    @Kumar_ravi_r 13 วันที่ผ่านมา

    11th are awesome trick

  • @Harish.Prasad.Semwal
    @Harish.Prasad.Semwal 13 วันที่ผ่านมา

    Last one we learned first time.

  • @Harish.Prasad.Semwal
    @Harish.Prasad.Semwal 13 วันที่ผ่านมา

    We not only learn data analytics skills but also presentation skills. We love Chandeep Paji's cute hindi also.

  • @prashanthcs9808
    @prashanthcs9808 14 วันที่ผ่านมา

    Your the boss ❤️

  • @I_am_sj8
    @I_am_sj8 14 วันที่ผ่านมา

    for me personally, the best tricks were copy pasting new data to update the chart and using format feature in graphs like format painter.

  • @chandanprasad4959
    @chandanprasad4959 14 วันที่ผ่านมา

    Sir, kindly share your contact details, I would like to join your class.

    • @desigoodly
      @desigoodly 14 วันที่ผ่านมา

      please drop an email - pratik@goodly.co.in

  • @ashokkhegde
    @ashokkhegde 15 วันที่ผ่านมา

    Soooperb..

  • @SandeepKumar-dm3lc
    @SandeepKumar-dm3lc 15 วันที่ผ่านมา

    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

  • @mdsaleem123
    @mdsaleem123 15 วันที่ผ่านมา

    Thank you so much for aur phele baar aapne hindi me kiya hai. Grt, i am inspired by your way of teaching.

  • @surendravishwakarma5265
    @surendravishwakarma5265 15 วันที่ผ่านมา

  • @taizoondean689
    @taizoondean689 15 วันที่ผ่านมา

    Auto Filter is awesome

  • @57yogesh
    @57yogesh 15 วันที่ผ่านมา

    Awesome tricks..Mind blowing

  • @narasimhaprasad847
    @narasimhaprasad847 15 วันที่ผ่านมา

    Thank you for sharing these tricks in a consolidation. I am using almost all these tricks / shortcut keys on daily basis.

  • @Salmanfarhat-ub9yo
    @Salmanfarhat-ub9yo 15 วันที่ผ่านมา

    WHILE APPLYING IF FORMULA, I GET ONLY ONE ANSWER.