CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic)
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Bill Jelen is one of my most favorite people on earth. That is why I wanted to have him as my first guest when I restarted the podcast. Even though I recorded this few weeks ago, only now I got around to publishing it. Please enjoy the conversation with Bill.
CP03: The Ugly Truth About Power BI (actually, 4 of them)
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Power BI is one of the most prominent data analytics technology out there.
Power BI is also one of the most marketed and hyped technology out there.
Unfortunately, both of these statements are true.
In a world where data is the buzz word, Power BI (or other similar platforms like Tableau) appeal to CXOs as panacea for all their data troubles.
But, just as any technology, Power BI too has it’s own shortcomings. So in this episode of my podcast, let’s uncover 4 ugly truths of Power BI.
CP045: Introduction to Monte Carlo Simulations in Excel
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 45th session of Chandoo.org podcast, let’s get in to Monte Carlo simulations.
What is in this session?
In this podcast,
- Quick personal updates – 200km BRM and book delay
- History of Monte Carlo simulations
- Monte Carlo simulations – an example
- How to do simulations in Excel
- Formulas
- VBA
- Data Tables
- Using data tables to run simulations – case study – estimating Pi value
- Things to keep in mind when setting up your simulation models
- Resources on Monte Carlo simulations in Excel
- Conclusions
CP036: How to do trend analysis using Excel?
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 36th session of Chandoo.org podcast, Let’s follow the trend.
What is in this session?
In this podcast,
- A quick trip to down under
- What is trend analysis
- 4 types of common trends
- linear
- curve
- cyclical
- strange
- Doing trend analysis in Excel – the process
- How to use trend analysis results
- Conclusions
CP033: There is an Easter egg in this podcast!!!
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips. What is in this session? This session has 2 things. A surprise Easter egg (an Excel tip hidden in the podcast audio) Collection of Excel tips recorded & submitted by Chandoo.org readers Listen to this session Click here […]
CP032: Rules for making legendary column charts
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 32nd session of Chandoo.org podcast, let’s make legendary column charts.
What is in this session?
Column charts are everywhere. As analysts, we are expected to create flawless, strikingly beautiful & insightful column charts all the time. Do you know the simple rules that can help you create legendary column charts?
That is our topic for this podcast session.
In this podcast, you will learn
- Few personal announcements
- Rule 0: Start at zero
- Rule 1: Sort the chart
- Rule 2: Slap a title on it
- Rule 3: Axis + grid-lines vs. Lables
- Rule 4: Moderate formatting
- Conclusions
Share your favorite Excel tip & you could win Beats Headphones [Podcast Anniversary Celebrations]
Yay, bring out the birthday hats, candles, cake & confetti. Chandoo.org podcast is 1 year old.
In this one year, we had 31 sessions, 4 guest appearances, 390,000 downloads & lots of 5 star reviews. Thank you so much for making it a grand success so far.
To celebrate the occasion, I want to reward 3 lucky listeners of our podcast.
How to participate in this contest?
- Simple. Figure out what your favorite Excel tip is.
- Open your smart phone’s voice recorder app
- on iPhone use the Voice Memos app
- on Andriod use sVoice or voice recorder widgets
- If you cant find these apps, just Google record audio <your phone name>
- Record the tip (less than 3 mins duration)
- Please say your name at the end of recording.
- Send the audio file by email to hello@chandoo.org
- Do so before end of day 16 March 2015 (Monday)
Once I collect all the tips, I will feature some of them in next episode of Chandoo.org podcast.