Episodes
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.
For more about Bill, visit his website https://mrexcel.com or his YouTube channel - https://www.youtube.com/@MrXL
Published 12/07/23
On the left side, we have a veteran warrior with 37 years of data battle scars and redundant six pack. They call him SQL.
On the right side, there is a young challenger with transformative powers and "never say undo" attitude. He goes by the moniker Power Query.
Who is going to win this battle?!?
I have been using SQL for 25 years and Power Query since it came out in early 2012. And in this article, let me share my views on how SQL compares with Power Query. If you prefer to...
Published 10/13/23
Power BI is one of the best data analytics platform in the world. But it is not all roses and honey. There are some ugly parts to this amazing software. In this podcast episode, let me share 4 of my frustrations with the software / platform.
For more, visit https://chandoo.org/wp/cp03-the-ugly-truth-about-power-bi/
Full podcast catalog - https://chandoo.org/wp/category/podcast/
My Power BI course - https://chandoo.org/wp/power-bi-course/
Published 08/24/23
So you want a 6 figure data job? In this podcast episode, I am going to share 6 strategies and tactics to land a $100k+ data job.
Published 07/27/23
Ladies & gentlemen... I have an exciting announcement. I am relaunching my podcast!!!
It only took me 7 years, but Chandoo.org podcast is now BACK! I am planning to make regular episodes on Excel, Power BI, SQL & Data Analytics.
In the 1st episode of Season 2 of Chandoo.org podcast I talk about, Top 5 Excel Skills you need to be a Successful Data Analyst in 2023.
Published 07/13/23
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 knowledge
Operators
Referencing
6 categories of must-know functions
Basic math
Conditions
Lookups
Text
Date & time
Work specific
Closing remarks & resources for you
Published 10/27/16
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 reviving our podcast and more.
What is in this session?
In this podcast,
Why there was such a long gap between last and this episode
What next?
How to extract every 6th item from a list?
Published 10/13/16
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
Relationships & data model
One slicer to rule them all
Show only top x values
Relative performance
Show unique count
Spruce up with conditional formats
Not so ugly pivot charts
Resources & Show notes for...
Published 03/31/16
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 rules explained
Input & error messages
Alternatives to data validation
Enhancing data validation
Removing data validation rules
Homework problem for you
Resources & show notes
Published 03/10/16
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 to Power Query
Why you should get this book?
What is in this book?
A very cool example of the techniques you will learn
Conclusions
Published 02/11/16
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 VLOOKUP slower than INDEX + MATCH?
What if my list has multiple matches?
How to fetch 2nd / 3rd matching item?
How to fetch all matching items?
How to fetch items matching multiple conditions?
How to speed up VLOOKUP?
Why doesn't...
Published 01/07/16
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 Data
Charts
Using Excel better
Published 12/03/15
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 dump
Give a table
Resources for you
Published 11/19/15
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 formula approach
VBA based animation
Cartoon film analogy
Understanding the VBA part
Example animated chart - Sales of a new product
Resources and downloads for you
Published 11/12/15
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
Customers & marketing
Planning & strategy
Processes & workflows
5 features of Excel that help
Conclusions
Published 10/22/15
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 Excel
Using bar charts with invisible series
Using conditional formatting and formulas
Using ready-made templates
Resources on Gantt charts & project planning
Conclusions
Published 10/08/15
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...
Published 09/24/15
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
Published 09/10/15
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
Tables
Pivot Tables
Auto fill
Format Painter
Find & Replace
VBA / Macro Recorder
Auto save
Auto complete / Intellisence
Recap & Conclusions
Published 08/27/15
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 about Awesome August
5 key finance concepts
Time value of money
Compound interest
Risk free rate of return
Net Present Value - NPV
Internal Rate of Return - IRR
Case study - Uber vs. Your car
Conclusions
Published 08/13/15
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
Published 08/06/15
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...
Published 07/30/15
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...
Published 07/23/15
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
Published 07/09/15