Podchaser Logo

Chandoo.org Podcast - Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel

A Business podcast
Good podcast? Give it some love!

Episodes of Chandoo.org Podcast

In the 56th episode of Chandoo.org podcast, let me answer the chicken and egg question of Excel users. How many formulas should you care to learn? What is in this session? In this podcast, Two personal updates 3 legs of formula writing Function
Ladies & gentlemen, its time we revived the much loved Chandoo.org podcast. In the 55th episode, I do a lousy imitation of Arnold Schwarzenegger's famous "I will be back" and tell you why there was such a long gap between episodes, my plans for
In the 54th session of Chandoo.org podcast, let's make you awesome in Pivot Tables. What is in this session? In this podcast, Quick updates Top 10 pivot table tricks Adding same value field twice Tabular layouts GETPIVOTDATA & 2 bonus tricks Re
In the 53rd session of Chandoo.org podcast, let's talk about data validation. What is in this session? In this podcast, What is data validation How Excel DV compares with database & software DV? Types of data validation rules List & custom rule
In the 52nd session of Chandoo.org podcast, let’s discuss monkeys, Ok, I am kidding. We are going to talk about M is for Data Monkey book. What is in this session? In this podcast, Updates: Why so much gap between episodes? Quick introduction
In the 51st session of Chandoo.org podcast, let's discuss most frequently asked questions about VLOOKUP. What is in this session? In this podcast, What is VLOOKUP? What happens when VLOOKUP can't find the value? Should my list be sorted? Is VLO
This is going to be epic!!! In the 50th session of Chandoo.org podcast, we have 50 Excel tips to make you awesome. What is in this session? In this podcast, Thank you message Fifty tips in 5 buckets Shortcuts & Productivity Formulas Managing Da
In the 49th session of Chandoo.org podcast, let's talk about data dumps! What is in this session? In this podcast, What is a data dump Examples of data dump Why we dump Ways to avoid data dumps Go for information dumps Sort the dump Filter the
In the 48th session of Chandoo.org podcast, let's make some animated charts!!! What is in this session? In this podcast, Announcements Why animate your charts? Non-VBA methods to animate charts Excel 2013's built-in animation effects Iterative
In the 47th session of Chandoo.org podcast, let's see how Excel can make you an awesome entrepreneur. What is in this session? In this podcast, Why Excel for entrepreneurs Key areas of a business owner's work Projects & to dos Finances Customer
In the 46th session of Chandoo.org podcast, let’s talk about gantt charts and project plans. What is in this session? In this podcast, A brief intro to Excel 2016 What is a Gantt chart? How Gantt charts can help us? How to create Gantt charts
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 exa
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 dashboar
In the 43rd session of Chandoo.org podcast, let's talk about top time saving features of Excel. What is in this session? In this podcast, Quick announcement about Awesome August My 9 favorite time saving features of Excel Remove Duplicates Tabl
In the 42nd session of Chandoo.org podcast, Let’s talk about money. We are going to learn about various concepts that are vital for doing financial analysis and building models. What is in this session? In this podcast, Quick announcement abo
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, Quic
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 tech
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
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 D
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 &
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 Exce
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 ki
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 C
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 r
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
Rate Podcast
Do you host or manage this podcast?
Claim and edit this page to your liking.
Are we missing an episode or update?
Use this to check the RSS feed immediately.