Chandoo
Chandoo
  • Видео 480
  • Просмотров 48 459 460
The amazing ONE formula Excel dashboard with LET function
One formula = Excel Dashboard 😎
That is right. In this video, let me share a revolutionary approach to creating Excel dashboards using just ONE formula.
💥 Full video + Excel file: Join my Excel School program to get the full video and unlocked Excel workbook. Go here 👉 chandoo.org/wp/excel-school-program/
~
Excel 365's LET function offers a powerful and elegant way to create dashboards and business reports with just a single formula. In this advanced tutorial, let me share the approach with a full-length example. Your mind will be blown for sure 🤯
The approach:
============
◉ Writing big formulas with Advanced Formula Editor in Excel
◉ Using XLOOKUP to combine data
◉ LET function to create variabl...
Просмотров: 8 672

Видео

3 Powerful Data Slides for your NEXT Presentation (Free PPT File)
Просмотров 8 тыс.День назад
Magic Trick 1: Creating a progress chart with animation Magic Trick 2: Fill a percentage of a shape Magic Trick 3: Jazz up numbers on a slide with transitions ⏱ In the video: 0:00: Demo of the 3 PowerPoint Magic Tricks 0:38: Creating the progress chart (donut chat) 2:30: Animating the progress chart 3:29: Filling inside a shape 5:50: Creating a 3 number slide with wow effect 📁 Download the pres...
Data Engineer vs. Analyst vs. Scientist - What they do, skills and salaries
Просмотров 12 тыс.14 дней назад
Do you wonder what is the difference between a data analyst, engineer and scientist is? In this video, let me explain what these 3 roles are, what skills you need to get in, how the career path looks like, what is the typical salary and how the work feels. LET'S GO! ⏱ IN THIS VIDEO: 0:00 - Data Engineer vs. Data Analyst vs. Data Scientist 0:35 - The rules 1:08 - What they do? DE vs. DA vs. DS 4...
Combine Excel Sheets with *this* simple formula
Просмотров 27 тыс.14 дней назад
Do you know that Excel now has a formula to combine data from multiple sheets? Yes, the VSTACK() function can combine data from multiple worksheets in one go. In this quick video, let me show you how to use the VSTACK function to combine data from monthly budget worksheets. 📁 Sample data file: chandoo.org/wp/wp-content/uploads/2024/06/vstack-conslidation.xlsx ~ #excel #chandoo #consolidation
End to End Data Analysis Project with Power BI - Netflix Example 📺
Просмотров 33 тыс.Месяц назад
Learn how to perform data analysis using a real-life dataset of Netflix shows. We are going to run 10 kinds of analysis & EDA with Power BI. 1) Column Profiling 2) Dealing with missing values (empty / blank) 3) Encoding nulls 4) Imputing missing values 5) Working with Dates and cleaning them 6) Adding new columns of data 7) Splitting / Extracting data 8) Extracting just the first item 9) Text /...
How ChatGPT made me 10X better in Excel Formulas 💡
Просмотров 69 тыс.Месяц назад
AI tools like ChatGPT are great for enhancing your Excel skills. In this video, I present 7 tactics I use to 10x my Excel formula skills. 1️⃣ Asking AI for the formula 2️⃣ Explain it to me 3️⃣ Alternatives 4️⃣ Debug the formula with AI 5️⃣ Give me clues 6️⃣Test my skills 7️⃣ Critique my approach 📁 Download sample data file Grab the sample data file from here chandoo.org/wp/wp-content/uploads/20...
Excel PROs use these hidden features to work faster 🚀
Просмотров 32 тыс.Месяц назад
📗 Get your Free Excel Tips Book - chandoo.org/wp/subscribe/ ~ Welcome to the first episode of Excel Secrets. Let's zoom in to the home ribbon and uncover some of the most useful and time-saving features. In this video, you are going to uncover the amazing powers of Excel's home ribbon, the most useful and versatile of all ribbons. We are also going to take a closer look at the top secret 🤫 time...
Powerful trick to get data from any folder in Excel (works even after renaming!)
Просмотров 13 тыс.Месяц назад
Power Query is great for automation, until it doesn't work because someone (I am not naming them) goes ahead and renames a file or the folder! Then you witness the slow collapse of your automation domino empire. In this video, let me share with you a simple and elegant fix to the problem. Using parameters! Learn how to automate tasks effectively with Power Query using dynamic folder paths. ⏱ vi...
How to make a bar graph in Excel LIKE A PRO - 5 Tricks
Просмотров 11 тыс.2 месяца назад
Learn how to create a professional-looking bar graph in Excel with this easy-to-follow tutorial. In addition, discover five expert tricks to take your data visualization skills to the next level. Whether you're a beginner or looking to enhance your Excel proficiency, this video has you covered. Watch now and become a bar graph master! 📂 Sample file for you to practice: Need to practice these ti...
How to make an interactive TOP 10 Chart with Power BI (using parameters)
Просмотров 9 тыс.2 месяца назад
🏆 Participate in my Dashboard Competition 👉 bit.ly/3xgC1WB ~ If you make dashboards or reports with Power BI, you often get questions like, "but I want to see top 10 products, not just 5" or "can we see top 10 store names instead of all?" from your stakeholders all the time. In this video, let me present you with an elegant and simple solution to such problems. A dynamic TOPN chart What is TOPN...
Make an Incredible Finance KPI Dashboard with Power BI in 20 minutes
Просмотров 58 тыс.2 месяца назад
🏆 Participate in my Dashboard Competition 👉 bit.ly/3xgC1WB ~ Make an incredible Power BI Dashboard to visualize your finance KPI data in just 20 minutes. In this video, learn how to take raw business data and turn it into useful insights by following these 4 steps: 1) Data Preparation - Connecting and transforming data using Power Query in Power BI 2) Data Modelling - Setting up a semantic mode...
How to calculate Compound Interest in Excel - Formula with Examples 💻
Просмотров 15 тыс.2 месяца назад
Compound interest is defined as "the interest on savings calculated on both the initial principal and the accumulated interest from previous periods." Classically, known as "interest on interest", this is the most common type of interest used in everyday finance situations. To calculate compound interest in Excel, on principal amount P at the rate of interest R for the number of years N and com...
Automatically Extract BOLD Text with VBA [Adv. Excel]
Просмотров 18 тыс.2 месяца назад
It seemed impossible to do in Excel. I had to extract "Bold" portions of 1000s of cells as part of the data cleanup process. Then I came across a simple VBA fix. In this video, let me share the solution and expose you to the limitless possibilities of VBA in Excel. You may want to put on your socks, cause this one is going to knock them right off 🧦🚀 👩‍💻 Get the VBA Code Solution: Visit chandoo....
This ~NEW~ Excel Function is Shockingly Powerful!
Просмотров 268 тыс.3 месяца назад
Every heard of SCAN function in Excel? Today, let me show you why you need this function and how it changes the way you solve your data problems. I think SCAN is Magic ✨ You are going learn: What is SCAN function in Excel SCAN syntax and application How to use SCAN to calculate running total quickly Using SCAN to get Maximum values SCAN with LAMBDA Advanced SCAN usage when your data is dynamic ...
SQL Joins - Beginner to PRO Masterclass with 10 Examples
Просмотров 19 тыс.3 месяца назад
Left, right, inner, outer, anti, no matter what you call them, Joins are an important part of the SQL for data analysis. In this comprehensive video, learn how to create your first join and more with easy, clear and relevant explanation of the concepts. 💻 Get the data: Visit chandoo.org/wp/learn-sql-for-data-analysis/ to get the dataset. Use the instructions on that page to set up the data in S...
7 Technologies you need to become a Data Analyst in 2024 🚀
Просмотров 49 тыс.3 месяца назад
7 Technologies you need to become a Data Analyst in 2024 🚀
How to get Excel & MS Office for FREE (Power BI + SQL too)
Просмотров 29 тыс.3 месяца назад
How to get Excel & MS Office for FREE (Power BI SQL too)
Welcome to Chandoo.org on YouTube 👋
Просмотров 29 тыс.4 месяца назад
Welcome to Chandoo.org on RUclips 👋
Honest review of Excel CoPilot - What it can and cannot do 🤖
Просмотров 58 тыс.4 месяца назад
Honest review of Excel CoPilot - What it can and cannot do 🤖
Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)
Просмотров 56 тыс.4 месяца назад
Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)
How to create a Work Schedule (Roster) using Excel
Просмотров 18 тыс.4 месяца назад
How to create a Work Schedule (Roster) using Excel
How to "automatically" extract data from a messy PDF table to Excel
Просмотров 20 тыс.4 месяца назад
How to "automatically" extract data from a messy PDF table to Excel
Get "ALL" Option in Excel Data Validation with this Crazy Trick 💡
Просмотров 21 тыс.5 месяцев назад
Get "ALL" Option in Excel Data Validation with this Crazy Trick 💡
I tried all 347 Excel Shortcuts, and here are the BEST ones you need to know
Просмотров 32 тыс.5 месяцев назад
I tried all 347 Excel Shortcuts, and here are the BEST ones you need to know
How to set up and use Calculation Groups in DAX | Power BI
Просмотров 17 тыс.6 месяцев назад
How to set up and use Calculation Groups in DAX | Power BI
How to find Outliers in Your Data Easily with Z-Scores in Excel
Просмотров 24 тыс.6 месяцев назад
How to find Outliers in Your Data Easily with Z-Scores in Excel
How to make an employee time tracker with Excel [Easy setup]
Просмотров 12 тыс.6 месяцев назад
How to make an employee time tracker with Excel [Easy setup]
How I made a COLOURFUL slicer in Power BI 🎨
Просмотров 14 тыс.7 месяцев назад
How I made a COLOURFUL slicer in Power BI 🎨
You need these 4 Excel Skills if you run a Small Business
Просмотров 15 тыс.7 месяцев назад
You need these 4 Excel Skills if you run a Small Business
10 Advanced XLOOKUP Tips & Tricks
Просмотров 28 тыс.7 месяцев назад
10 Advanced XLOOKUP Tips & Tricks

Комментарии

  • @yourfriend9935
    @yourfriend9935 17 часов назад

    23:00

  • @sarifulhasan
    @sarifulhasan 19 часов назад

    It's amazing sir... Thank you very much..

  • @shreyanshdangi4366
    @shreyanshdangi4366 20 часов назад

    Thanks for this informative video...

  • @ishfaqshah5169
    @ishfaqshah5169 22 часа назад

    Thanks. It was so cool. One question if the sheets have different no. of rows, what to do in such cases?

    • @chandoo_
      @chandoo_ 16 часов назад

      You can make the range big enough so it gets everything. We are removing the blank values thru filter.

  • @jamessmithson4757
    @jamessmithson4757 22 часа назад

    this video just saved me an hour

  • @AP-eb8hd
    @AP-eb8hd 22 часа назад

    Awesome as usual Purna ..

  • @mrbartuss1
    @mrbartuss1 День назад

    The question is WHY?

    • @EamonnCottrell
      @EamonnCottrell 20 часов назад

      There is no why; there is no spoon.

    • @reanalytics1863
      @reanalytics1863 19 часов назад

      There are multiple reasons why 1: Sorting the entire report is powerful but only possible when the entire report is an array 2 : Filtering an array is more accurate than filtering individual columns

    • @chandoo_
      @chandoo_ 17 часов назад

      Because we can. I explain my reasons at the end. It is an interesting experiment. I got to learn many new ways of working with long formulas. Hopefully you got to takeaway something too.

  • @MihailBaleev
    @MihailBaleev День назад

    Top quality content! Totally deserved to be part of an excel conference. Respect 🫡

  • @shreyanshdangi4366
    @shreyanshdangi4366 День назад

    Thanks for this helpful video

  • @shreyanshdangi4366
    @shreyanshdangi4366 День назад

    Very good video and rhanks

  • @Mesjach
    @Mesjach День назад

    You're here for Excel. I'm here for Chandoo jokes.

  • @shreyanshdangi4366
    @shreyanshdangi4366 День назад

    Thanks for this video....very helpful

  • @chrism9037
    @chrism9037 День назад

    Epic formula, thanks Chandoo!

  • @shreyanshdangi4366
    @shreyanshdangi4366 День назад

    Thanks for this video....very helpful

  • @vijaydiwevdi1304
    @vijaydiwevdi1304 День назад

    Thanks sir

  • @aashukumar9237
    @aashukumar9237 День назад

    How to download the pratice data?

  • @vikeyvikey3149
    @vikeyvikey3149 День назад

    Guruji❤❤❤❤❤❤❤❤

  • @BillSzysz1
    @BillSzysz1 День назад

    Thanks Chandoo 👍👍👍 Maybe it's worth putting the whole thing in a LAMBDA function with three arguments in the form of individual tables? It would be less scary for not very advanced users and more resistant to unwanted actions.

    • @chandoo_
      @chandoo_ 17 часов назад

      Yes, we can. As this is a very specific, non-repeating thing, I think a LAMBDA wouldn't be needed. But the AFE makes it easy to convert such formulas to LAMBDAs.

  • @paramveerssachdeva
    @paramveerssachdeva День назад

    Can't Thank you enough brother. Will be joining your excel school from my other ID.

  • @LokanathReddy-s8y
    @LokanathReddy-s8y День назад

    Thanks for sharing your knowledge to everyone .

  • @jagatkrishna1543
    @jagatkrishna1543 День назад

    Thanks 🙏 SIR ❤

  • @anandpathare6421
    @anandpathare6421 День назад

    Very nice and helpful to learnn😊

  • @nwitachoudhury5361
    @nwitachoudhury5361 День назад

    Do you have a video tutorial to ADDCOLUMN on IsHoliday (Y/N)? Specially for Easter?

  • @chaitanyalanka7043
    @chaitanyalanka7043 День назад

    we have to use filters and we can get one link in google then we can place the ID/Name in that link then we will see the output for the particular person/ID the data we are getting for that particular ID/Name we have placed in the filters

  • @ona7574
    @ona7574 День назад

    Amazing!

  • @shreyanshdangi4366
    @shreyanshdangi4366 День назад

    Very good video...thanks for this

  • @FarzanaNoushad-ky5od
    @FarzanaNoushad-ky5od День назад

    i cant find the datasets.could you please provide me the datasets

  • @DEEPANSHUGUPTA-DM23DM077
    @DEEPANSHUGUPTA-DM23DM077 День назад

    I want to learn Power BI as a beginner, but with so many options, it's confusing to choose the best one. Someone recommended RUclips videos over expensive courses. My questions are: 1) Is your RUclips playlist enough to go from beginner to expert? 2) Are older videos still relevant in 2024? 3) If I study 2 hours daily, how long will it take to become proficient? 4) Do you have any other important advice? Since its really important for me. I look forward to your prompt response. Thank you.

  • @vijaimahesh277
    @vijaimahesh277 2 дня назад

    Hi man, like what if I want to show a trend change, can i make a single line chart as a gradient from green to red?

  • @emilyenyi7666
    @emilyenyi7666 2 дня назад

    Hello, can see you have been indoors for sometime. Wishing you fast recovery

  • @SoundarabaranidaranDhamodharan
    @SoundarabaranidaranDhamodharan 2 дня назад

    Check out "The Mentor" Edtech platform where you can learn data analytics from scratch to advance from the current industry experts as 15 candidates per batch with placement assistance. Duration : 3 months Additional features: Resume building Naukri profile building Linkedin profile building Mock interviews Case studies Live projects Beta certification for best performers (value addition to your profile ) Reply here for more details

  • @maheshashu1899
    @maheshashu1899 2 дня назад

    While practicing with datasets ms Excel is not responding re-start,close the program dialog box getting always please give solution for this .

  • @shivaratribikshapathilinus5985
    @shivaratribikshapathilinus5985 2 дня назад

    Am learning the ETL

  • @shivaratribikshapathilinus5985
    @shivaratribikshapathilinus5985 2 дня назад

    Hi... bro can you send me the your number please

  • @Shiva-kl2wp
    @Shiva-kl2wp 2 дня назад

    Hi Chandoo. Whenever I see your videos I feel excited and you seem very familiar. I tried to sign up with your Excel School Program, when I hit the button I was speechless with your price. I accept that you are not running charity but the people like me paying 10K Or 16K it's not a piece of cake. Most of the people are often think that they have to learn something, but they don't know the correct path and correct mentor, once they found like you then the 2nd challenge is money. It always be more than their capacity. I have wish to learn advanced excel and I attended for Jatan Sha workshops few time,he said nicely but end of the workshop he explain about the packages and set a price that was so high than my financial position. Same here I felt like that. But your explanation was awesome. Thank you so much.

    • @chandoo_
      @chandoo_ 2 дня назад

      You are welcome Shiva. No matter how I price these courses, there will be someone who will find them unaffordable. That is why I give away 90% of everything I create for free thru RUclips and my website. I charge for other 10% so I can live and support my family. Please use my channel + other resources to learn for free.

  • @mm0dk0ur
    @mm0dk0ur 2 дня назад

    Thank you soooooo much

  • @srithiprerana7482
    @srithiprerana7482 2 дня назад

    Thank you so much , your videos are really helpful always !!

  • @shreyanshdangi4366
    @shreyanshdangi4366 2 дня назад

    Very inforamtive video but difficult in sequence like you tokd to view power video first in one of the question

  • @Virgo_0709
    @Virgo_0709 2 дня назад

    This is beautiful. You make learning fun and easy to understand. Even as s beginner. Please can you make more videos on power point presentation. Thank you

    • @chandoo_
      @chandoo_ 2 дня назад

      Thank you! Will do!

  • @shreyanshdangi4366
    @shreyanshdangi4366 2 дня назад

    This is the amazing video....thanks for it

    • @chandoo_
      @chandoo_ 2 дня назад

      Most welcome 😊

  • @shreyanshdangi4366
    @shreyanshdangi4366 2 дня назад

    Very good video and i learned all the concepts

  • @Fun_is_everything777
    @Fun_is_everything777 2 дня назад

    👌👌👌

  • @myronm973
    @myronm973 2 дня назад

    Great Tutorial, helped me a lot!

  • @FaizanKhan-db9cw
    @FaizanKhan-db9cw 2 дня назад

    i'm using excel 2019 and tried VSTACK formula but its showing #Name (Error) please guide

  • @Plumber_chanel
    @Plumber_chanel 2 дня назад

    Hindi video bolo sir

  • @kpodugbejacob9984
    @kpodugbejacob9984 2 дня назад

    Thank you

  • @VijayPawar-sz6gq
    @VijayPawar-sz6gq 2 дня назад

    👌

  • @howtolearnexcel
    @howtolearnexcel 2 дня назад

    Great tutorial! Can't get enough of Morph animation effect in PowerPoint. It's so mesmerizing!

    • @chandoo_
      @chandoo_ День назад

      I love Morph too. So many creative ways to use it.

  • @AbdulAhad-wy3hi
    @AbdulAhad-wy3hi 2 дня назад

    Very good video to start with. One query from this from the last part you did. At the start when upload the data to Power BI from excel files are these linked from the system or are they uploaded separately once. If integrated then any change in the source file will change the data which means we need to upload a copy file of excel in order not to get our work change every time. If not integrated, then how come your Refresh changed the whole things Thanks a lot

    • @chandoo_
      @chandoo_ 2 дня назад

      The source file (in this example) stays on my computer. Whenever the source changes, I can trigger the refresh in Power BI to update all the calculations and graphs. But in most corporate situations, the source file stays in a network drive / sharepoint / cloud. In such cases, you can also schedule / automate the refresh process so that the graphs are updated automatically.

  • @SandeepSharma-md2ex
    @SandeepSharma-md2ex 2 дня назад

    Pls make a video how can I subtotal only negative values in using subtotal formula