Chandoo.org
@r1c1
Followers
28K
Following
882
Media
543
Statuses
4K
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
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 - https://t.co/yNQKGjMUyn
3
9
55
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: https://t.co/UrAUAnD63F)
1
2
15
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).
0
1
22
IT: Is having great time, but just forgot the password 😂
0
2
10
🚀Add Images from OneDrive & SharePoint in Power BI the right way #powerbi #onedrive #sharepoint #skills
4
12
66
🏆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: https://t.co/AOpSaLusqe PS: Share with your PowerBI friends too
0
6
17
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 - https://t.co/uSiKkTt7gF
3
24
81
=CONCAT(BASE(HSTACK(311*2,REPT(3,5)+1,43*431-1,5*7*9*11*11),6^2)) 🥚
6
11
57
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. https://t.co/vKmmqJmWkz
1
6
39
Obviously, they need Formulas, probably more than 1.
Formula 1 chief appalled to find team using Excel to manage 20,000 car parts
1
2
25
The moment you realize XLOOKUP can lookup horizontally, vertically and anywhere in the middle too. Here is a step-by-step tut: https://t.co/TPI7YJYGfs
1
10
66
Do you want Excel but don't have money? Check out my guide to getting Excel, Power BI and SQL for free. https://t.co/SikjDEByZA
0
7
35
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 👉 https://t.co/KXDu58gnCR
0
7
41
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 👉 https://t.co/oH6ljZUBuI
2
13
50
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 👇 https://t.co/i8fLpeiExQ
exceldays.itraining.bg
Bulgaria Excel Days 2024 - An International Conference - 24 april and 4 Masterclasses - 23 and 25 april
0
2
12
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 - https://t.co/QmGNkfl0xB
0
10
37
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 👇 https://t.co/cf29NzEarg
2
4
25
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 - https://t.co/SlbCxoT2Ax
0
31
104
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 https://t.co/4UOOMp5bnU
0
2
3