🔥The 9th Round of Easy Loan, Earn $40 Reward is in progress❗️ ⏰ Promotion Period: January 15th - Feburary 15th, 2025 👉 Register now and check more details at gate.io/campaigns/358

Hello folks.. 👋 I am doing my annual holiday sale this week. You can get 20% (or more) discount on my most popular Power BI and Excel courses. Check it out and pick up a course to be awesome chandoo.org/wp/holiday-sal…

Here is a formula to calculate duration in Excel between two dates in Days, Months & Years. You can even use it to make a getDuration() LAMBDA now. Get the formula - chandoo.org/wp/duration-be…

Recently I had a gnarly PDF data issue (aren't they all gnarly?) Two tables were coming in as a single one in PQ. I used a nifty little trick to saw the table in half and stitch it under. Check this video for the recipe 👇 youtu.be/kN9aTCx1TvE

Ever want to set up a two or multi-level data validation in Excel, like this? Check out my easy tutorial to see how XLOOKUP can solve the problem - chandoo.org/wp/how-to-crea…

Do you want to improve your Excel & Data skills in a fun, energy filled way? I highly recommend checking out Bulgaria Excel Days 2024 event. You are going to love the talks and people. The schedule is out now. Book a ticket here 👇 exceldays.itraining.bg/en/bulgaria-ex…

Excel's spill behavior is awesome, until you use it in a table. Then it gives the nasty #SPILL error. Here are 3 easy fixes to the problem 👉 chandoo.org/wp/how-to-fix-…

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…

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

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…

Obviously, they need Formulas, probably more than 1.

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

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

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

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

🏆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

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

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

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...🤩

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…)