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 conversa

SQL vs. Power Query - What are the key differences and how I use them?

Oct 13th, 2023 28m 25s

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 m

CP03: The Ugly Truth About Power BI (actually, 4 of them)

Aug 24th, 2023 21m 47s

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

CP02: Six Tips to get a Six Figure ($100,000+) Data Job

Jul 27th, 2023 30m 18s

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. The post CP02: Six Tips to get a Six Figure ($100,000+) Data Job appeared first on Chandoo.org - Learn Excel, Pow

Top 5 Excel Skills you need to be a Successful Data Analyst in 2023

Jul 13th, 2023 26m 33s

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 epis

CP056: So which formulas you should care to learn?

Oct 27th, 2016 35m 27s

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 updates3 legs of formula writingFuncti

CP055: “Yes, I am back” edition (and a bonus Excel tip)

Oct 13th, 2016 22m 36s

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

CP054: Top 10 Pivot Table Tricks for YOU

Mar 31st, 2016 34m 49s

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 updatesTop 10 pivot table tricksAdding same value field twiceTabular layoutsGETPIVOTDATA & 2 bonus tricks

CP053: Excel Data Validation for Dummies

Mar 10th, 2016 35m 26s

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 validationHow Excel DV compares with database & software DV?Types of data validation rulesList & custom rul

CP052: Book Review – M is for Data Monkey by Ken & Miguel

Feb 11th, 2016 26m 19s

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

CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered

Jan 7th, 2016 38m 48s

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 VL

CP050: Fifty Excel Tips to make you awesome

Dec 3rd, 2015 1h 4m

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 messageFifty tips in 5 bucketsShortcuts & ProductivityFormulasManaging

CP049: Don’t do data dumps!!!

Nov 19th, 2015 17m 48s

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 dumpExamples of data dumpWhy we dumpWays to avoid data dumpsGo for information dumpsSort the dumpFilter th

CP048: How to create animated charts in Excel?

Nov 12th, 2015 29m 44s

In the 48th session of Chandoo.org podcast, let's make some animated charts!!!What is in this session?In this podcast,AnnouncementsWhy animate your charts?Non-VBA methods to animate chartsExcel 2013's built-in animation effectsIterativ

CP047: Best Excel tools for Entrepreneurs

Oct 22nd, 2015 34m 52s

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 entrepreneursKey areas of a business owner's workProjects & to dosFinancesCustom

CP046: Gantt charts & project planning using Excel

Oct 8th, 2015

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 2016What is a Gantt chart?How Gantt charts can help us?How to create Gantt charts

CP045: Introduction to Monte Carlo Simulations in Excel

Sep 24th, 2015 34m 46s

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 delayHistory of Monte Carlo simulationsMonte Carlo simulations - an ex

CP044: My first dashboard was a failure!!!

Sep 10th, 2015 29m 24s

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 ExcelStory of my first ever dashboardImportant lessons - Requirement Analysis for dashboa

CP043: My favorite time saving features of Excel, Revealed.

Aug 27th, 2015 22m 30s

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 AugustMy 9 favorite time saving features of ExcelRemove DuplicatesTab

CP042: Financial Analysis & Modeling concepts – 101

Aug 13th, 2015 34m 5s

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

CP041: 6 charts you’ll see in hell – v2.0

Aug 6th, 2015 24m 6s

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

CP040: Intro. to Power Query – What is it and how to get started – with Miguel Escobar

Jul 30th, 2015 1h 2m

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

CP039: May the FOR Loop be with you – Introduction to For Loops in Excel VBA

Jul 23rd, 2015 37m 26s

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

CP038: Data to Ink Ratio – What is it, How to optimize it, Techniques & Discussion

Jul 9th, 2015 26m 31s

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,AnnouncementsWhat is Data to Ink Ratio?Obvious ways to optimize Data to Ink RatioMore ways to optimize D

CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors

Jun 25th, 2015 27m 19s

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 errorsThe easy kind: syntax errorsThe triky ones: # ERRORsFixing errors – using IFERROR &