All Episodes

CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic)

SQL vs. Power Query – The Ultimate Comparison

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

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

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

CP056: So which formulas you should care to learn?

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

CP054: Top 10 Pivot Table Tricks for YOU

CP053: Excel Data Validation for Dummies

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

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

CP050: Fifty Excel Tips to make you awesome

CP049: Don’t do data dumps!!!

CP048: How to create animated charts in Excel?

CP047: Best Excel tools for Entrepreneurs

CP046: Gantt charts & project planning using Excel

CP045: Introduction to Monte Carlo Simulations in Excel

CP044: My first dashboard was a failure!!!

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

CP042: Financial Analysis & Modeling concepts – 101

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

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

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

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

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

CP036: How to do trend analysis using Excel?

CP035: on Solver, its story and future – Interview with Dan Fylstra

CP034: Advanced Excel Essentials book talk with Jordan Goldmeier

CP033: There is an Easter egg in this podcast!!!

CP032: Rules for making legendary column charts

CP031: Invisibility Tricks – How to make things disappear in Excel?

CP030: Detecting fraud in data using Excel – 5 techniques for you

CP029: Impress your boss with Excel charts – 6 step road map for you

CP028: How to tell business logic & rules to Excel?

CP027: 15 proven strategies to be awesome in 2015

Merry Christmas & Happy New Year 2015 [Holiday Gift Inside]

CP026: All about Excel !@#$%^+/*(}][

CP025: Sexy on spreadsheet, Ugly on Printout

CP024: Customize Excel to boost your productivity

CP023: My experience with Hudhud Cyclone [personal story]

CP022: What’s a Macro? Introduction to Excel VBA, Macros & Automation

CP021: How to quickly compare 2 lists in Excel

CP020: Top 10 time saving strategies for business analysts

CP019: 6 Tips for Best Practice Modeling – Interview with Danielle from Plum Solutions

CP018: Dont be a Pivot Table Virgin!

CP017: Top 10 non-Excel MS Office tips for you – Interview with Paul Woods – Office MVP & Blogger

CP016: 3 Must have books for aspiring analysts

CP015: Handling big data, Controlling model railroad sets, Overcoming Excel obsession & more – ASK CHANDOO

CP014: How to create awesome dashboards – 10 step process for you

CP013: Is this a FIFA worldcup of late goals, lets ask Excel [How to analyze data to answer questions like these…]

CP012: Top 10 Excel Keyboard Shortcuts for you

CP011: 5 Excel magic tricks to impress your boss

CP010: Averages are Mean – 8 Techniques for making your analysis above average

CP009: Averages are Mean – Know these things before you make any more AVERAGE()s

CP008: 6 Tips to handle workbooks made by someone else, #4 is something I struggle with too!

CP007: aweSUM() – Overview of SUM functions in Excel

CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects

CP005: Introduction to Form Controls – an interview with Debra Dalgleish

CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them

CP003: Business Intelligence for Masses – Interview with Mike Alexander

CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you

CP 001: Chandoo.org Podcast First Episode – Introduction, What to expect, Show formalities & Special gift