Making you awesome in Excel, Power BI, data analytics & charting. One tweet at a time. Also, love mangoes, lego, cycling and coffee...
Wellington City, New Zealand
Joined July 2008
- Tweets4.3K
- Following142
- Followers27.6K
- Likes879
Pinned Tweet
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
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-exce…)
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...🤩
Print proof on my desk.
Minor issues to fix (print quality).
There will be two versions: B&W and Color. We're making sure the B&W version is readable.
Coming soon (April 30).
#dax #optimization
Hint: reading it before bed counts as an arm exercise (1.5kg, 3.3lbs).
Chandoo.org retweeted
🚀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-po…
PS: Share with your PowerBI friends too
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-inte…
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.
Formula 1 chief appalled to find team using Excel to manage 20,000 car parts trib.al/xAQdzQH
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-examp…
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-bold-…
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-sp…
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/bu…
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-create…
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
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-betw…
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-sale-…
