Podcasts by Chandoo.org Podcast - Become Awesome in Data Analytics
Want to be an AWESOME DATA ANALYST? Chandoo.org Podcast is the place to go. Learn how to use popular Data Analytics software like Power BI, Excel, SQL and more with your host Chandoo
Further podcasts by Chandoo - Microsoft Excel MVP, Training & Data Analysis Specialist
Podcast on the topic Wirtschaft
All episodes
CP05: Interview with MrExcel–Bill Jelen (on his incredible work ethic) from 2023-12-07T04:51:44
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 ...
Listen
SQL vs. Power Query–The Ultimate Comparison from 2023-10-13T06:01
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 transformati...
Listen
CP03: The Ugly Truth About Power BI (actually, 4 of them) from 2023-08-24T07:54
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 st...
Listen
CP02: Six Tips to get a Six Figure ($100,000+) Data Job from 2023-07-27T07:08:55
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 Listen
Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast) from 2023-07-13T23:23:51
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 epis...
Listen
CP056: So which formulas you should care to learn? from 2016-10-27T08:12:01
In the 56th episode of Chandoo.org podcast, let me answer the chicken and egg question of Excel users. How many formulas should ...
Listen
CP055:“Yes, I am back”edition (and a bonus Excel tip) from 2016-10-13T08:13:09
Ladies & gentlemen, its time we revived the much loved Chandoo.org podcast. In the 55th episode, I do a lousy imitation of Arnold Schwar...
Listen
CP054: Top 10 Pivot Table Tricks for YOU from 2016-03-31T08:16:56
In the 54th session of Chandoo.org podcast, let's make you awesome in Pivot Tables.
What is in this session?
...
Listen
CP053: Excel Data Validation for Dummies from 2016-03-10T08:12:28
In the 53rd session of Chandoo.org podcast, let's talk about data validation.
What is in this session?
In thi...
Listen
CP052: Book Review–M is for Data Monkey by Ken&Miguel from 2016-02-11T08:28:21
In the 52nd session of Chandoo.org podcast, let's discuss monkeys, Ok, I am kidding. We are going to t...
Listen
CP051: VLOOKUP FAQs–Most frequently asked questions about VLOOKUP–Answered from 2016-01-07T08:10:28
In the 51st session of Chandoo.org podcast, let's discuss most frequently asked questions about VLOOKUP. Listen
CP050: Fifty Excel Tips to make you awesome from 2015-12-03T08:14:08
This is going to be epic!!! In the 50th session of Chandoo.org podcast, we have 50 Excel tips to make you awesome....
Listen
CP049: Don’t do data dumps!!! from 2015-11-19T08:19:43
In the 49th session of Chandoo.org podcast, let's talk about data dumps!
What is in this session?
...
Listen
CP048: How to create animated charts in Excel? from 2015-11-12T08:16:06
In the 48th session of Chandoo.org podcast, let's make some animated charts!!!
What is in this sess...
Listen
CP047: Best Excel tools for Entrepreneurs from 2015-10-22T08:10:59
In the 47th session of Chandoo.org podcast, let's see how Excel can make you an awesome entrepreneur.
What is in this session?
... Listen
CP046: Gantt charts&project planning using Excel from 2015-10-08T08:10:01
In the 46th session of Chandoo.org podcast, let's talk about gantt charts and project plans.
What is in this session?
In thi...
Listen
CP045: Introduction to Monte Carlo Simulations in Excel from 2015-09-24T08:10:40
In the 45th session of Chandoo.org podcast, let's get in to Monte Carlo simulations.
What is in this session?
In this podcas...
Listen
CP044: My first dashboard was a failure!!! from 2015-09-10T08:16:39
In the 44th session of Chandoo.org podcast, let's talk about failures.
What is in this session?
In this podcast,
CP043: My favorite time saving features of Excel, Revealed. from 2015-08-27T08:15:04
In the 43rd session of Chandoo.org podcast, let's talk about top time saving features of Excel.
What is in this session? Listen
CP042: Financial Analysis&Modeling concepts–101 from 2015-08-13T08:33:58
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 fi...
Listen
CP041: 6 charts you’ll see in hell–v2.0 from 2015-08-06T08:51:21
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 clas...
Listen
CP040: Intro. to Power Query–What is it and how to get started–with Miguel Escobar from 2015-07-30T08:16:19
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 (w...
Listen
CP039: May the FOR Loop be with you–Introduction to For Loops in Excel VBA from 2015-07-23T08:37:12
In the 39th session of Chandoo.org podcast, Let's learn about FOR loops.
There is a special giveaway in this podcast. It ...
Listen
CP038: Data to Ink Ratio–What is it, How to optimize it, Techniques&Discussion from 2015-07-09T08:16:34
In the 38th session of Chandoo.org podcast, Let's optimize data to ink ratio of your charts.
What is in this session? Listen
CP037: Error error on the wall, How do I fix you all?–Understanding&Fixing Excel Errors from 2015-06-25T08:42:17
In the 37th session of Chandoo.org podcast, Let's debug 'em #VALUEs & #N/As.
What is in this session?
In ...
Listen
CP036: How to do trend analysis using Excel? from 2015-06-11T08:10:41
In the 36th session of Chandoo.org podcast, Let's follow the trend.
What is in this session?
In this podcast,
- A... Listen
CP035: on Solver, its story and future–Interview with Dan Fylstra from 2015-05-21T08:10:15
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 ...
Listen
CP034: Advanced Excel Essentials book talk with Jordan Goldmeier from 2015-04-23T15:01:23
In the 34th session of Chandoo.org podcast, Let's hear from Jordan Goldmeier - m...
Listen
CP033: There is an Easter egg in this podcast!!! from 2015-04-09T08:10:08
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...
Listen
CP032: Rules for making legendary column charts from 2015-04-02T08:02:48
In the 32nd session of Chandoo.org podcast, let's make legendary column charts.
What is in this session?
Column charts are e...
Listen
CP031: Invisibility Tricks–How to make things disappear in Excel? from 2015-03-05T08:14
In the 31st session of Chandoo.org podcast, let's disappear.
What is ... Listen
CP030: Detecting fraud in data using Excel–5 techniques for you from 2015-02-19T08:10:37
In the 30th session of Chandoo.org podcast, let's learn how to uncover fraud in data.
Listen
CP029: Impress your boss with Excel charts–6 step road map for you from 2015-02-05T08:10:55
In the 29th session of Chandoo.org podcast, let's impress the boss with Excel charts.
Wha... Listen
CP028: How to tell business logic&rules to Excel? from 2015-01-22T08:10:53
In the 28th session of Chandoo.org podcast, let's figure out how to express business rules & logic to Excel. Listen
CP027: 15 proven strategies to be awesome in 2015 from 2015-01-08T08:10:37
In the 27th session of Chandoo.org podcast, let's pave way for an awesome 2015.
We are going to talk about ...
Listen
Merry Christmas&Happy New Year 2015 [Holiday Gift Inside] from 2014-12-23T08:10:59
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 fulf...
Listen
CP026: All about Excel !@#$%^+/*(}][ from 2014-12-04T08:59:58
In the 26th session of Chandoo.org podcast, let's learn all about Excel !@#$%^+/*(}][<.
I am talking ab...
Listen
CP025: Sexy on spreadsheet, Ugly on Printout from 2014-11-06T08:20:52
In the 25th session of Chandoo.org podcast, let's learn how to avoid SSUP Listen
CP024: Customize Excel to boost your productivity from 2014-10-30T08:10:53
In the 24th session of Chandoo.org podcast, let's customize Excel so we become productive.
What is ...
Listen
CP023: My experience with Hudhud Cyclone [personal story] from 2014-10-16T13:58:01
In the 23rd session of Chandoo.org podcast, lets talk about my experience with Hudhud cyclone.
...
CP022: What’s a Macro? Introduction to Excel VBA, Macros&Automation from 2014-10-09T08:10:41
In the 22nd session of Chandoo.org podcast, lets do some macros.
What is in this ... Listen
CP021: How to quickly compare 2 lists in Excel from 2014-10-02T08:10:07
In the 21st session of Chandoo.org podcast, lets compare lists. Quickly
What is in this session? Listen
CP020: Top 10 time saving strategies for business analysts from 2014-09-18T13:20:01
In the 20th session of Chandoo.org podcast, lets save some time.
What is in this session?
We all wa...
Listen
CP019: 6 Tips for Best Practice Modeling–Interview with Danielle from Plum Solutions from 2014-09-04T08:13:47
In the 19th session of Chandoo.org podcast, lets talk about modeling best practices.
What is in this sessi... Listen
CP018: Dont be a Pivot Table Virgin! from 2014-08-21T07:32:06
In the 18th session of Chandoo.org podcast, lets loose your Pivot table virginity.
Note: This is a short format ...
Listen
CP017: Top 10 non-Excel MS Office tips for you–Interview with Paul Woods–Office MVP&Blogger from 2014-08-14T08:10:40
In the 17th session of Chandoo.org podcast, lets leave Excel aside and talk about other MS Office apps.
Thats right....
Listen
CP016: 3 Must have books for aspiring analysts from 2014-08-07T08:10:05
In the 16th session of Chandoo.org podcast, lets review 3 very useful books for aspiring analysts.
What is i...
Listen
CP015: Handling big data, Controlling model railroad sets, Overcoming Excel obsession&more–ASK CHANDOO from 2014-07-24T08:17:04
In the 15th session of Chandoo.org podcast, lets answer some of your burning Excel questions.
CP014: How to create awesome dashboards–10 step process for you from 2014-07-10T08:10:44
In the 14th session of Chandoo.org podcast, lets figure out how to make awesome dashboards.
What is in this session... Listen
CP013: Is this a FIFA worldcup of late goals, lets ask Excel [How to analyze data to answer questions like these…] from 2014-07-03T08:10:02
In the 13th session of Chandoo.org podcast, lets turn our attention to on-going FIFA worldcup and ask an important question.
Listen
CP012: Top 10 Excel Keyboard Shortcuts for you from 2014-06-26T08:16:41
In the 12th session of Chandoo.org podcast, lets get productive fast.
Announcement: Short fo...
Listen
CP011: 5 Excel magic tricks to impress your boss from 2014-06-19T08:06:44
If you want to create magical effect with your Excel workbook (or report, dashboard, model), then hear no further. In this episode, we explore 5 very powerful magic tricks you can apply to get j...
Listen
CP010: Averages are Mean–8 Techniques for making your analysis above average from 2014-05-30T08:10:47
CP009: Averages are Mean–Know these things before you make any more AVERAGE()s from 2014-05-22T08:17:58
In the 9th session of Chandoo.org podcast, lets raise above AVERAGEs.
AVERAGEs are a very popular and unive...
Listen
CP008: 6 Tips to handle workbooks made by someone else, #4 is something I struggle with too! from 2014-05-15T08:10:19
Here is a problem we all face once in a while. We inherit this bulky, bloated, leaking at the edges workbook from a colleague. Now the onus of maintaining it is on us. The person who ma...
Listen
CP007: aweSUM()–Overview of SUM functions in Excel from 2014-05-01T08:10
In the 7th session of Chandoo.org podcast, lets make you aweSUM().
Imagine for a second that Excel cannot add up numbers. And no it c...
Listen
CP006: How to be a better analyst?–Road map for getting better at Data Analysis&Improving your career prospects from 2014-04-24T08:06:44
In the 6th session of Chandoo.org podcast, we focus on making you a better analyst and propose a road map for getting better at data analysis & improving your career prospe...
Listen
CP005: Introduction to Form Controls–an interview with Debra Dalgleish from 2014-04-17T08:10:31
In the 5th session of Chandoo.org podcast, we are going to demystify form controls.
I am very happy and excited to i...
Listen
CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use&when to avoid them from 2014-04-03T08:10:13
In the 4th session of Chandoo.org podcast, lets talk about Pie charts.
Pie charts evoke strong opinions among analysts & managers. Some people love them and can't have enough of them...
Listen
CP003: Business Intelligence for Masses–Interview with Mike Alexander from 2014-03-27T08:10:06
In the third session of Chandoo.org podcast, we are going to get BI curious. ;)
Not that kind you silly, We are talking about Business Intelligence, Big Data, Power Pivot...
Listen
CP002: VTALKUP–5 Excel lookup functions demystified + 4 Resources for you from 2014-03-13T08:10:12
In the second session of Chandoo.org Podcast, We will be learning how to use 5 Excel lookup functions.
What is in this session?
In this session, we tackle one of t...
CP 001: Chandoo.org Podcast First Episode–Introduction, What to expect, Show formalities&Special gift from 2014-03-06T08:10:22
Chandoo.org Podcast is here....
Friends, fans & supporters of Chandoo.org,
I am so happy to add another dimension to our website. Chandoo.org podcast is finall...
Listen