In the 44th session of Chandoo.org podcast, let’s talk about failures.
What is in this session?
In this podcast,
- Book announcement about Dashboards for Excel
- Story of my first ever dashboard
- Important lessons – Requirement Analysis for dashboards
- Resources for creating awesome dashboards
- Podcasts
- Books
- Courses
Listen to this session
Podcast: Play in new window | Download
Subscribe: RSS
Click here to download the MP3 file.
Resources to make awesome dashboards
Podcast episodes:
- Create awesome dashboards with this 10 step process
- Make better charts by optimizing Data to Ink ratio
- Rules for making legendary column charts
Books on Dashboards:
- Information dashboard design by Stephen Few
- Non-designers design book by Robin Williams
- Dashboards for Excel by Jordan & Chandoo
Courses:
- Excel School + Dashboards – Online classes from Chandoo
Excel School, is a comprehensive online course to help you become awesome in all aspects of data analysis, visualization, interactive workbooks, dashboard reporting and automation.
In this course, you will learn to:
- Analyze data using simple & advanced formulas in Excel
- Structure & process large volumes of data quickly using tables & pivot tables
- Present information using charts, interactive & dynamic charts and complex charts
- Create dashboards using 8 in-depth tutorials & case studies
- Make gorgeous workbooks using conditional formatting, color & font choices and more
- Develop workbooks faster: using my favorite tricks and productivity hacks
Please click here to know more about Excel School and enroll
Transcript of this session:
Download this podcast transcript [PDF]
Help our community & me learn more by sharing your mistakes
It’s your turn. Share the mistakes you made during data analysis, dashboard preparation or automation projects. Let’s all learn from these and become stronger.
5 Responses to “Number to Words – Excel Formula”
As well as the Indian version, perhaps you could look into an English version as against the American version.
Things diverge after one hundred with one hundred one OR one hundred AND one.
I'm sure that it is always AND after n00 or n00,000 where there any of those zeros have a value. So five hundred thousand and sixteen. There could be two and's seven hundred and eighty-six thousand four hundred and twenty-six.
Chandoo, you are a genius.
Hi Chandoo,
Please take a look at my NumToWords and NumToDollars formulas that I shared here:
https://techcommunity.microsoft.com/t5/excel/excel-numtowords-formula/m-p/727433
That is a genius technique Robert. Thanks for posting it here.
100000000 One Hundred FALSE Million
Is there any reason for this error?