Chandoo.org

You don't complex formulas or advanced stuff to create impressive dashboards in Excel. Here is an interactive dashboard built with just pivots. Watch the tutorial here - youtu.be/35VnP0Rz71I

@exceldashboards I am well.. 😆 Just not posting on x. But I post regularly on YouTube (and send the weekly newsletter)

@r1c1 "Missing You" is populating every cell in my dashboard. Hope you're well!

72% of data jobs need advanced Excel skills. Steal this Ultimate Advanced Excel Skills Mind-map to grow your career 🚀 (download high-res version here: chandoo.org/wp/advanced-ex…)

@siddarthsanghvi If you find my Youtube videos and style engaging, you will enjoy the course. I suggest setting aside 1-2 hours per week and following the course for best results.

@r1c1 hey Chandoo, I want to enroll into your excel course (most advanced, with all the latest updates). The only concern I have is, I am not a person who can focus courses online so easily. Need your suggestion, if your course could be easy to grasp it online 😅

@PhilSeamark @marcorus Wow.. just booked my ticket. Can't believe I missed the CFS.

Looking forward to presenting with my good friend @marcorus for the first time, on what else, but #DAX !!! :) I promise this will be a great session with lots to learn! Not to be missed if you use #PowerBI. Register for free here: eventbrite.com/e/sqlsaturday-…

I am still working the first book and may never graduate to the optimize stage. But a must buy nevertheless if you are serious about DAX. Waiting...🤩

IT: Is having great time, but just forgot the password 😂

🚀Add Images from OneDrive & SharePoint in Power BI the right way #powerbi #onedrive #sharepoint #skills

🏆CONTEST ALERT!!! Make a Power BI Dashboard to impress Awesome Chocolates CEO and win $500 Amazon gift cards. Contest ends on 30th April, so hurry up and submit your best work 👩‍💻👨‍💻 Details here: chandoo.org/wp/announcing-… PS: Share with your PowerBI friends too

@Kannan__P Thank you Kannan. Wish you the same :)

@r1c1 Happy Ugadi

Power BI makes it dead simple to create interactive KPI dashboards. In this video, I show how to make one in just 20 minutes. Watch and build here - youtu.be/i3AR0gt9SHA

Compound Interest Formulas in Excel - a simple overview chandoo.org/wp/compound-in…

=CONCAT(BASE(HSTACK(311*2,REPT(3,5)+1,43*431-1,5*7*9*11*11),6^2)) 🥚

This NEW Excel function is shockingly powerful. Put on a helmet ⛑ or cast iron casserole on your head before using it. You are sufficiently warned. youtu.be/VrQSgI596IQ

Obviously, they need Formulas, probably more than 1.

@Kannan__P Here is the one - youtu.be/DDlZXXEI1bU

@r1c1 Could you please share a YouTube video. Thank you.

The moment you realize XLOOKUP can lookup horizontally, vertically and anywhere in the middle too. Here is a step-by-step tut: chandoo.org/wp/xlookup-exa…

@kurtbuhler @figma Great example there Kurt. I am going to keep this in mind next time I talk up something shiny and new.

So @figma released a new feature that will have a huge positive impact on productivity. But what's more amazing is how they're promoting adoption and educating the community to use it, right out the gate. The effectiveness here really blows me away. A 🧵 about why ⬇️

Do you want Excel but don't have money? Check out my guide to getting Excel, Power BI and SQL for free. youtu.be/Rzm0_YzG5sM

We all have that boss who BOLDs cell values in Excel 😤. If you ever need a simple solution to extract "bold" portions of cells automatically, use my getBoldText() function in Excel. Here it is 👉 chandoo.org/wp/get-the-bol…