Menu
Chandoo.org Podcasts
Introducing Chandoo.org Podcast. Become Awesome in Data on the go. You can listen all the episodes on this page or subscribe to my podcast on your favorite Podcast App. Some links are below:
- Chandoo.org Podcast on Apple
- on Spotify
- on Google Podcasts
- on RSS (copy this link and use it any podcast app / service)
- by Email (you get podcast updates + more, one email per week)
Enjoy the show :)
CP041: 6 charts you’ll see in hell – v2.0
In the 41st session of Chandoo.org podcast, Let's take a trip to data hell and meet 6 ugly, clumsy, confusing charts. I am revisiting a classic Chandoo.org article - 6 Charts you will see in hell.
What is in this session?
In this podcast,- Quick announcement about Awesome August
- 6 charts you should avoid
- 3D charts
- Pie / donut charts with too many slices
- Too much data
- Over formatting
- Complex charts
- Charts that don't tell a story
- Conclusions
CP040: Intro. to Power Query – What is it and how to get started – with Miguel Escobar
In the 40th session of Chandoo.org podcast, Let's talk about Power Query. I have the pleasure and fortune to catch up with Miguel Escobar (who along with Ken Puls runs PowerQuery.Training website) and talk about this very exciting piece of technology and how it can make our life simpler.
What is in this session?
In this podcast,- Welcome
- Miguel's introduction, background and current projects
- What is Power Query
- How to install it
- Sample use cases of Power Query
- What is Power BI
- Resources for learning Power Query - Books & Courses
CP039: May the FOR Loop be with you – Introduction to For Loops in Excel VBA
In the 39th session of Chandoo.org podcast, Let's learn about FOR loops.
There is a special giveaway in this podcast. It is a workbook with several FOR loop VBA code examples. Listen to the episode for instructions.
What is in this session?
In this podcast,- Announcements
- What is a loop - plain English & technical definitions
- For Loop vs. other kind of loops (While & Until)
- For Next loops
- For Each loops
- Nested For loops
- Special tips on For loops
- Performance issues & infinite loops
- Conclusions & giveaway
CP038: Data to Ink Ratio – What is it, How to optimize it, Techniques & Discussion
In the 38th session of Chandoo.org podcast, Let's optimize data to ink ratio of your charts.
What is in this session?
In this podcast,
- Announcements
- What is Data to Ink Ratio?
- Obvious ways to optimize Data to Ink Ratio
- More ways to optimize Data to Ink ratio
- Highlighting what is important
- Conclusions
CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors
In the 37th session of Chandoo.org podcast, Let's debug 'em #VALUEs & #N/As.
What is in this session?
In this podcast,
- Introduction to Excel formula errors
- The easy kind: syntax errors
- The triky ones: # ERRORs
- Fixing errors - using IFERROR & ISERROR
- Error checking & debug options
- Using Errors deliberately - charts & data validation
- A challenge for you - produce #NULL error
- Conclusions
CP036: How to do trend analysis using Excel?
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
CP035: on Solver, its story and future – Interview with Dan Fylstra
In the 35th session of Chandoo.org podcast, Let's hear from Dan Fylstra, the creator of Excel Solver. I had the fortune of meeting Dan when I was in Santa Clara last month. I immediately asked him to be part of Chandoo.org podcast and he was kind enough to agree. So today let's take a trip down the memory line, hear him talk about some of the fascinating all the early development stories of Solver, VisiCalc & Excel.
What is in this session?
In this podcast,- Introduction
- Early days of Solver
- Working with VisiCalc, migration to Excel
- What keeps Dan busy these days
- Advice for anyone planning to learn Solver & business modelling
CP034: Advanced Excel Essentials book talk with Jordan Goldmeier
In the 34th session of Chandoo.org podcast, Let's hear from Jordan Goldmeier - my friend, fellow blogger, Excel blogger & author. After many years of interaction thru email, blogs, Skype calls, finally I met him at PASS BA conference at Santa Clara this week. He gave me a copy of his new book - Advanced Excel Essentials and I immediately asked him to do a podcast. So here we go.
What is in this session?
In this podcast,- Introduction
- What is this book all about
- Sample chapter review - User forms
- Design principles for creating advanced user interactions
- How to become advanced Excel user - pathway recommended by Jordan
- More info about Jordan
- A secret for you
CP032: Rules for making legendary column charts
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
CP031: Invisibility Tricks – How to make things disappear in Excel?
In the 31st session of Chandoo.org podcast, let's disappear.
What is in this session?
Spreadsheets are complex things. They have outputs, calculation tabs, inputs, VBA code, from controls, charts, pivot tables and occasional picture of hello kitty. But when it comes to making a workbook production ready, you may want to hide away few things so it looks tidy. That is our topic for this podcast session. In this podcast, you will learn- Quick announcements first anniversary of our podcast etc.
- Hiding cells, rows, columns & sheets
- Hiding chart data points
- On/off effect with form controls, conditional formatting
- Making objects, charts, pictures disappear
- Disabling grid-lines, formula bar & headings
- Hiding things in print
CP030: Detecting fraud in data using Excel – 5 techniques for you
In the 30th session of Chandoo.org podcast, let's learn how to uncover fraud in data.
What is in this session?
In the wake of hedge fund scams, accounting frauds and globalization, We, analysts are constantly second guessing every source of data. So how do you answer a simple question like, "am I being lied to?" while looking at a set of numbers your supplier has sent you. That is our topic for this podcast session. In this podcast, you will learn- Quick announcements about 50 ways & 200k BRM
- Introduction to fraud detection
- 5 techniques for detecting fraud
- Benford's law
- Auto correlation
- Discontinuity at zero
- Analysis of distribution
- Learning systems & decision trees
- Implementing these techniques in Excel
- A word of caution
CP029: Impress your boss with Excel charts – 6 step road map for you
In the 29th session of Chandoo.org podcast, let's impress the boss with Excel charts.
What is in this session?
Many Excel charts live a short life. They spawn in an ambitious analyst's spreadsheet. They go to boss with literally flying colors. The boss frowns, they disappear in to recycle bin. Don't curse your Excel charts with short life span. Here is a 6 step road map to help you create awesome Excel charts, everytime. That is our topic for this podcast session. In this podcast, you will learn- Quick announcements about 50 ways & Einstein
- 6 step road map for charting success
- ONE: Dig your data
- TWO: Validate insights
- THREE: Pick charts that go well
- FOUR: Add title & message
- FIVE: Remove clutter
- SIX: Prompt action
- A real life example with road map in action
- Resources for creating awesome charts
CP028: How to tell business logic & rules to Excel?
In the 28th session of Chandoo.org podcast, let's figure out how to express business rules & logic to Excel.
What is in this session?
What good are spreadsheets if they can't solve business problems? But we all struggle when it comes to modeling real world business conditions in Excel. For example, if you have below business rule to decide how much discount to offer a customer,- If the customer bought 3 or more times previously and offer 15% discount
- If the customer bought 1 or 2 times previously AND customer's age is >40, offer 10% discount
- If the customer visited our New York store between 6PM-9PM offer 5% discount
- Else no discount
- The challenge of modeling business logic & rules in Excel
- My struggles with such formulas in early days
- 4 features of Excel that can help you with this.
- Example business rules & how to write formulas
CP027: 15 proven strategies to be awesome in 2015
In the 27th session of Chandoo.org podcast, let's pave way for an awesome 2015.
We are going to talk about 15 proven strategies for making you awesome in Excel & Your work.
What is in this session?
We all get fresh dose of energy, enthusiasm & drive during new years. So we aim for bigger & more awesome things. But once the first few weeks are over, we just settle down to the normal rhythm and forget about these big, hairy & audacious goals. Let's make 2015 different. In this podcast, Let's understand how you can become awesome in Excel & your work this year, with 15 proven strategies:- Announcements - my new year & plans for next few months
- Becoming awesome - 3 important areas of focus
- Learning
- New formulas
- New features
- Different charts
- Macros
- Linkup Excel with other software
- Get a book
- Join a course
- Application
- Take up a work project
- Consulting
- Mimic a chart in Excel
- Beyond XL - Power Pivot etc.
- Sharing
- Forums
- Helping a colleague
- Comment on blogs
- Train your team
Merry Christmas & Happy New Year 2015 [Holiday Gift Inside]
A big, warm & pleasant hello to you.
I wish you a merry Christmas & Happy New Year 2015. May your holidays be filled with joy, togetherness, celebrations and fulfillment. May your new year be filled with hope, energy and awesomeness.
I want to tell you how thankful I am for all your support in this year. Every time you visit our website, read an article, leave a comment, enroll in a course, purchase a product, read one of my books, listen to a podcast episode, watch a video or tell your friends about Chandoo.org, I feel nothing but gratitude, thankfulness and amazement. 2014 is the most successful year since starting Chandoo.org, all thanks to you. Heartfelt thanks to you, from my family, staff and volunteers.
About this year's holiday card
We took this picture recently when we went to Udaipur (a city in northern India). For a change, no one closed their eyes when the camera clicked.
A holiday gift for you...
Read on to download your special holiday gift.
About this year's holiday card
We took this picture recently when we went to Udaipur (a city in northern India). For a change, no one closed their eyes when the camera clicked.
A holiday gift for you...
Read on to download your special holiday gift. CP026: All about Excel !@#$%^+/*(}][<
In the 26th session of Chandoo.org podcast, let's learn all about Excel !@#$%^+/*(}][<.
I am talking about Excel operators, you silly.
What is in this session?
Do you know Excel has more than 25 operators? That is right. There are a variety of operators beyond the simple + - * and /.
In this podcast, let's understand all about these operators and how to use them. You will learn,
- Why there is a gap between last & this podcast session
- About Excel operators
- Arithmetic operators
- Text operators
- Reference operators
- Comparison operators
- Closing thoughts
CP025: Sexy on spreadsheet, Ugly on Printout
In the 25th session of Chandoo.org podcast, let's learn how to avoid SSUP syndrome.
What is in this session?
Most of us suffer from Sexy on the Spreadsheet, Ugly on Printout syndrome. I used to suffer from it too. This happens because we spend all our attention creating that perfect workbook, report or model. And then, we forget about making the proper print settings.
In this podcast, let's understand how to create awesome workbooks that look great and print great.
In this podcast, you will learn,
- Frozen & Cars, where my free time goes
- Primer on print settings
- Width & height of printouts
- Page breaks
- Row & column repetitions on every page
- Size & orientation of paper
- Dealing with unprintables
- Proofing your print settings
- Printing whats not on screen
- Closing thoughts
CP024: Customize Excel to boost your productivity
In the 24th session of Chandoo.org podcast, let's customize Excel so we become productive.
What is in this session?
Each of us use Excel in our own way. And yet, we all end up using the same Excel. That's not fair. Shouldn't the Excel of an accountant be different from Excel of a teacher?
In this podcast, lets understand some of the powerful & useful ways to customize Excel so that we can do our work better. Tune in only if you are serious about productivity.
You can get Excel Customization Handbook free. Listen to the podcast for instructions.
In this podcast, you will learn,- Announcements
- Why customize Excel?
- Customization options:
- Excel Options
- Quick Access Toolbar
- Excel Ribbon
- File menu / back stage view
- Themes, styles & templates
- Personal Macros
- Closing thoughts & Bonus give away instructions
CP023: My experience with Hudhud Cyclone [personal story]
In the 23rd session of Chandoo.org podcast, lets talk about my experience with Hudhud cyclone.
Note: This podcast session has no Excel tips. It is a story of how our family is surviving the effects & aftermath of destructing Hudhud cyclone that recently (on 12th October) passed thru our city. Hopefully, you still find it interesting & inspiring. If you are expecting some Excel tips, check again next week.
What is in this session?
Growing up, I lived all my childhood in coastal cities. So cyclones & severe storms are not new to me. But first time, I have experienced anything as severe, destructive & long as Cyclone Hudhud. After the cyclone, we (our family and 1000s of other families in Vizag, our city) had to endure days with no power, water, cellular signals and access to essential supplies. Fortunately, great progress has been made in the last few days and things are restoring to normalcy. We (our locality) is expecting to have power & regular water supply by this Sunday (19th of October).
Listen on Spotify
The reviews are in...
This guy ROCKS!
⭐⭐⭐⭐⭐
I’ve followed Chandoo for a number of years and he and some of his followers have really improved my Excel skills. His approach to teaching and his clear love of sharing knowledge is infectious and appealing. Great and please keep it going.
Victor Meldrew II
Awesome!
⭐⭐⭐⭐⭐
Absolutely awesome! A must listen for anybody wanting to improve their Excel skills.
Bishpmb
BI for anyone
⭐⭐⭐⭐⭐
Chandoo is fantastic. You don’t have to be in front of your computer to learn new Excel tips that you can put into action.
joyousc01
Awesome podcast!!! Great for career
⭐⭐⭐⭐⭐
I listen to this podcast on my commute. It absolutely makes me a more valuable worker.
jrogers2
I definitly recommed it…
⭐⭐⭐⭐⭐
I really get a lot from Chandoo’s podcasts. I’m not a data analysts but use Excel a lot during my day. Chandoo does a great job of proving quick tutorials that make me much more productive with Excel. He has a great way of explaining some confusing concepts in a way I can understand. I really look forward to the next new episode since it usually ups my understanding by a good percentage each episode. Only challenge I have is he does add in some dialog about his personal life that I easily get bored with. But it very appropriate, I think it’s just my issue.
gettinbetter66
Get FREE Excel & Power-BI Newsletter
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.
Online Classes
© All rights reserved.