TopPodcast.com
Menu
  • Home
  • Top Charts
  • Top Networks
  • Top Apps
  • Top Independents
  • Top Podfluencers
  • Top Picks
    • Top Business Podcasts
    • Top True Crime Podcasts
    • Top Finance Podcasts
    • Top Comedy Podcasts
    • Top Music Podcasts
    • Top Womens Podcasts
    • Top Kids Podcasts
    • Top Sports Podcasts
    • Top News Podcasts
    • Top Tech Podcasts
    • Top Crypto Podcasts
    • Top Entrepreneurial Podcasts
    • Top Fantasy Sports Podcasts
    • Top Political Podcasts
    • Top Science Podcasts
    • Top Self Help Podcasts
    • Top Sports Betting Podcasts
    • Top Stocks Podcasts
  • Podcast News
  • About Us
  • Podcast Advertising
  • Contact
Not in our directory?
Add Show Here
Podcast Equipment
Center

toppodcastlogoOur TOPPODCAST Picks

  • Comedy
  • Crypto
  • Sports
  • News
  • Politics
  • True Crime
  • Business
  • Finance

Follow Us

toppodcastlogoStay Connected

    View Top 200 Chart
    Back to Rankings Page
    Technology

    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 – an award winning author, speaker and YouTuber.

    Advertise

    Copyright: © Chandoo.org

    • Apple Podcasts
    • Google Play
    • Spotify
    Latest Episodes:
    CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered Jan 07, 2016
    Show notes

    In the 51st session of Chandoo.org podcast, let’s discuss most frequently asked questions about VLOOKUP.

    VLOOKUP FAQs - Frequently asked questions about Excel VLOOKUP formula

    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 my VLOOKUP work?
    • What to do in case of errors?
    • Resources for you

    Listen to this session

    Click here to download the MP3 file.

    Resources for this podcast

    4 Resources to learn lookup functions:

    1. Comprehensive guide to Excel lookup functions
    2. VLOOKUP Cheatsheet
    3. The VLOOKUP Quiz – test your knowledge
    4. Recommended book: The VLOOKUP Book

    Other formulas and links mentioned in this podcast:

    • INDEX formula – introduction, how to use it and why you should use it?
    • INDEX + MATCH formula combination
    • IFERROR Formula What is it, syntax, examples and uses
    • Looking up 2nd or 3rd matching value
    • Looking up based on multiple conditions
    • Ultimate VLOOKUP trick – Multi-condition lookup

    Speeding up VLOOKUPs:

    • Using relationships feature in Excel 2013
    • Faster VLOOKUPs with sorting

    Transcript of this session:

    Download this podcast transcript [PDF]

    Want to know more about VLOOKUP? Please ask…

    Still have questions about VLOOKUP? Please post them in the comments section. I will try to help you.

    The post CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

    CP050: Fifty Excel Tips to make you awesome Dec 03, 2015
    Show notes

    This is going to be epic!!! In the 50th session of Chandoo.org podcast, we have 50 Excel tips to make you awesome.

    Fifty Excel Tips to make you awesome - Chandoo.org podcast - Session 50

    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

    Listen to this session

    Click here to download the MP3 file.

    Resources for this podcast

    Keyboard shortcuts:

    • Top 10 keyboard shortcuts for you – podcast 012
    • Comprehensive list of Excel keyboard shortcuts
    • 25 Excel tricks to boost your productivity

    Formulas:

    • Top 10 formulas for analysts & managers
    • Beyond SUM & IF – 15 formulas for you
    • Using wild cards in formulas (* &)
    • Formulas discussed in the podcast:
      • SUMIFS
      • SUBTOTAL
      • CHOOSE
      • AND OR – Logical formulas – podcast 028
      • IFERROR

    Managing Data:

    • Excel Tables – an introduction
    • Using Text to Columns to convert dates
    • Flash fill – an introduction
    • Remove Duplicates – a quick tutorial
    • Go to special – what is so special about it?
    • Introduction to Data model & Relationships in Excel 2013
    • Power Query – an intro – podcast 040

    Charting:

    • Data bars in Conditional formatting – a case study
    • Sparklines can go right to left
    • Hide ‘0’ in axis
    • Dynamic titles & labels in charts

    Using Excel:

    • How to create custom ribbons in Excel – tutorial
    • Work with charts faster using selection pane
    • How to make gorgeous printable workbooks – podcast 025
    • Hide away unused rows & columns & 9 more tips to create awesome workbooks

    Transcript of this session:

    Download this podcast transcript [PDF]

    What is your favorite tip?

    Now it’s your turn. Which one of the fifty is your favorite? Or do you have something new altogether? Please share in the comments.

    Spread the love – Review my podcast

    If you enjoy Chandoo.org podcast, please take a minute and write a review on iTunes.

    Also, do share this podcast on a colleague / friend. Make them awesome. Send them here: http://chandoo.org/podcast

    The post CP050: Fifty Excel Tips to make you awesome appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

    CP049: Don’t do data dumps!!! Nov 19, 2015
    Show notes

    In the 49th session of Chandoo.org podcast, let’s talk about data dumps!

    Don't do data dumps - what are data dumps, why they are bad & how to avoid them - Chandoo.org podcast - Session 49

    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

    Listen to this session

    Click here to download the MP3 file.

    Resources for making animated charts

    Making better charts in Excel:

    • How to select right type of chart for your data
    • Why 3D pie charts are evil

    Charting podcasts:

    • CP029 – Impress your boss with awesome charts – 6 step road map
    • CP032 – Rules for creating legendary column charts
    • CP038 – Data to Ink Ratio – What is it and how to optimize it

    Transcript of this session:

    Download this podcast transcript [PDF]

    Come across any data dumps? Share your story…

    Now it’s your turn. Do you come across any data dumps in your line work? Share the story in the comments section.

    Dump some love – Review my podcast

    If you enjoy Chandoo.org podcast, please take a minute and write a review on iTunes.

    Also, do dump this podcast on a colleague / friend. Make them awesome. Send them here: http://chandoo.org/podcast

    The post CP049: Don’t do data dumps!!! appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

    CP048: How to create animated charts in Excel? Nov 12, 2015
    Show notes

    In the 48th session of Chandoo.org podcast, let’s make some animated charts!!!

    session-048

    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

    Listen to this session

    Click here to download the MP3 file.

    Resources for making animated charts

    Example animated chart (shown in the title image):

    Download example animated chart. Play with it to learn more.

    More animated charts using Excel:

    • Diwali flower pot cracker using animated charts
    • Another Diwali animated chart in Excel
    • Journey of Hurricane Sandy – Animated Chart
    • 3D Dancing pendulums using Excel Charts & VBA
    • Designing a clock using Excel

    VBA Basics:

    • Podcasts:
      • Introduction to VBA – CP022
      • Using FOR Loops in VBA – CP039
    • Articles:
      • Introduction to VBA – 5 part tutorial

    Non-VBA animation using formulas:

    Animation without macros [for fun]

    Transcript of this session:

    Download this podcast transcript [PDF]

    How do you create animated charts in Excel?

    Now it’s your turn. Do you make animated charts? Please share your techniques and samples in the comments section. Wow us.

    The post CP048: How to create animated charts in Excel? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

    CP047: Best Excel tools for Entrepreneurs Oct 22, 2015
    Show notes

    In the 47th session of Chandoo.org podcast, let’s see how Excel can make you an awesome entrepreneur.

    Best excel tools and features for entrepreneurs - Chandoo.org podcast - session 47

    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
      • Tables
      • Financial formulas
      • Pivot tables
      • Forecasting techniques
      • VBA & formula driven workbooks
    • Conclusions

    Listen to this session

    Click here to download the MP3 file.

    Excel resources for entrepreneurs

    If you are an entrepreneur or small business owner, check out these links and become awesome at your work.

    On projects & to dos:

    • Introduction to Excel tables
    • Introduction to structured references and awesome ways to use tables
    • Project management using Excel – 6 part tutorial

    On finances:

    • Basic financial formulas and analysis concepts in Excel – podcast
    • Case study: Cost vs benefit analysis using Excel
    • Financial modeling using Excel – 6 part tutorial

    On Marketing & customer data analysis:

    • Introduction to pivot tables
    • Don’t be a pivot table virgin – podcast
    • More on Excel pivot tables

    On forecasting & planning:

    • Introduction to trend analysis and forecasting using Excel – 3 part tutorial
    • Trend analysis using Excel – podcast

    On processes and workflows:

    • Top 10 formulas for analysts & managers (entrepreneurs can use them too!)
    • Introduction to Excel VBA – podcast

    Scott Adam’s book – How to fail at almost everything and still win big

    Transcript of this session:

    Download this podcast transcript [PDF]

    Are you an entrepreneur? Tell me how you use Excel…

    Now it’s your turn. If you are an entrepreneur or small business owner, please tell me how you use Excel. Share your story in the comments section.

    Subscribe to our podcast and get latest episodes automatically

    Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you.

    Other options to subscribe

    The post CP047: Best Excel tools for Entrepreneurs appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

    CP046: Gantt charts & project planning using Excel Oct 08, 2015
    Show notes

    In the 46th session of Chandoo.org podcast, let’s talk about gantt charts and project plans.

    Gantt charts and project planning using MS Excel - Chandoo.org podcast - session 46

    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

    Listen to this session

    Click here to download the MP3 file.

    Resources on Gantt Charts & Project Planning

    Tutorials on how to create Gantt charts in Excel

    • Gantt charts & project plans in Excel – tutorial
    • Gantt charts using bar charts
    • Quick Gantt charts using conditional formatting
    • Gantt box chart – when there is uncertainty in project plans

    Project Management Resources & Articles

    • Project status dashboard using Excel
    • Project portfolio dashboard using Excel
    • More project management tips, tutorials & resources for you
    • Excel for PMs – online course form Chandoo.org

    Ready to use Excel Project Management Templates

    Ready to use Excel PM Template pack from Chandoo.org

    Transcript of this session:

    Download this podcast transcript [PDF]

    Are you a project manager? Tell us how you use Excel…

    I use Excel to manage all my projects – work related, vacation, product launches, product comparison etc. If you are a project manager, what do you use Excel for? Please share your experiences and ideas in the comments section.

    Subscribe to our podcast and get latest episodes automatically

    Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you.

    Other options to subscribe

    The post CP046: Gantt charts & project planning using Excel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

    CP045: Introduction to Monte Carlo Simulations in Excel Sep 24, 2015
    Show notes

    In the 45th session of Chandoo.org podcast, let’s get in to Monte Carlo simulations.

    Introduction to Monte Carlo simulations in Excel - Chandoo.org podcast - session 045

    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 simulations in Excel
    • Conclusions

    Listen to this session

    Click here to download the MP3 file.

    Resources on Monte Carlo simulations

    Articles & tutorials on data tables & Monte Carlo simulations

    • The best explanation about data tables & Monte Carlo simulations
    • Estimating Pi ? value by throwing frozen hot dogs on Excel charts
    • Simulating Monopoly board game to find best strategies

    Example workbook – Estimating Pi value with Monte Carlo simulations

    • Click here to download the Pi Estimation Monte Carlo simulation workbook

    Courses:

    • 50 ways to analyze your data from Chandoo

    50 ways to analyze data is a comprehensive online course to help you become a better analyst. In this course, you will learn how to create Monte Carlo simulations, optimization models, advanced analysis models & visualizations.

    Please click here to know more about 50 ways program

    Transcript of this session:

    Download this podcast transcript [PDF]

    Simulate stuff? Stimulate someone, share stories…

    Do you simulate stuff at your work (or personal life)? If so, please share your experience with rest of Chandoo.org audience. Post your simulation process, tips & ideas in the comments section.

    The post CP045: Introduction to Monte Carlo Simulations in Excel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

    CP044: My first dashboard was a failure!!! Sep 10, 2015
    Show notes

    In the 44th session of Chandoo.org podcast, let’s talk about failures.

    My first dashboard was a failure and what did I learn from it - making awesome dashboards - Chandoo.org podcast - session 44

    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

    Listen to this session

    Click here to download the MP3 file.

    Resources to make awesome dashboards

    Podcast episodes:

    • Create awesome dashboards with this 10 step process
    • Make better charts by optimizing Data to Ink ratio
    • Rules for making legendary column charts

    Books on Dashboards:

    • Information dashboard design by Stephen Few
    • Non-designers design book by Robin Williams
    • Dashboards for Excel by Jordan & Chandoo

    Courses:

    • Excel School + Dashboards – Online classes from Chandoo

    Excel School, is a comprehensive online course to help you become awesome in all aspects of data analysis, visualization, interactive workbooks, dashboard reporting and automation.

    es-dashboards-program

    In this course, you will learn to:

    • Analyze data using simple & advanced formulas in Excel
    • Structure & process large volumes of data quickly using tables & pivot tables
    • Present information using charts, interactive & dynamic charts and complex charts
    • Create dashboards using 8 in-depth tutorials & case studies
    • Make gorgeous workbooks using conditional formatting, color & font choices and more
    • Develop workbooks faster: using my favorite tricks and productivity hacks

    Please click here to know more about Excel School and enroll

    Transcript of this session:

    Download this podcast transcript [PDF]

    Help our community & me learn more by sharing your mistakes

    It’s your turn. Share the mistakes you made during data analysis, dashboard preparation or automation projects. Let’s all learn from these and become stronger.

    The post CP044: My first dashboard was a failure!!! appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

    CP043: My favorite time saving features of Excel, Revealed. Aug 27, 2015
    Show notes

    In the 43rd session of Chandoo.org podcast, let’s talk about top time saving features of Excel.

    Top time saving features of Excel - Chandoo.org Podcast - Session 43

    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

    Listen to this session

    Click here to download the MP3 file.

    Resources to save time

    Dealing with duplicates

    • Remove duplicates button – explained
    • Remove duplicate combinations

    Tables & Pivot Table concepts:

    • Introduction to Excel Tables
    • Introduction to Excel Pivot Tables
    • Structural References & how to use them

    Auto fill & flash fill:

    • Fill up patterns with Auto-fill
    • Flash fill in Excel – a quick intro

    Format Painter and how it can save time for you:

    • Format faster with format painter & double click
    • Format all charts in same way using format painter

    Find & Replace:

    • Use find / replace to change formats quickly
    • Change formulas with find / replace

    VBA & Macro Recorder

    • Introduction to VBA & Macros
    • What is a macro and how to get started – podcast

    Transcript of this session:

    Download this podcast transcript [PDF]

    Which Excel feature is the most time saving one?

    I’ve revealed my secrets. Now it’s your turn. Tell me your favorite time saving feature of Excel.

    And if you have a few minutes time, Please write a review for Chandoo.org podcast on iTunes. Please click here to do that (see the instructions if you don’t know how to write a review on iTunes).

    The post CP043: My favorite time saving features of Excel, Revealed. appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

    CP042: Financial Analysis & Modeling concepts – 101 Aug 13, 2015
    Show notes

    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.

    Introduction to financial analysis & modeling concepts - CP042 - Chandoo.org podcast

    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

    Listen to this session

    Click here to download the MP3 file.

    Resources to learn about financial analysis & modeling

    Uber vs. Your car – Analysis model

    Please click here to download the Uber vs. Your car analysis workbook.

    Finance concepts:

    • NPV – what is it and how to calculate it in Excel?
    • IRR – how to calculate it?
    • CAGR – how to calculate it?
    • Introduction to financial modeling using Excel – 6 part tutorial

    Case studies:

    • Cost vs. benefit analysis – which bulbs to use?
    • Interactive mortgage calculator
    • How much money you need to retire?

    Advanced concepts:

    • Project finance modeling in Excel – case study
    • Data tables & Montecarlo simulations in Excel – Gold mine case study

    Recommended courses:

    • Financial Modeling school from Chandoo.org – this online course teaches you all the concepts necessary to build full-length valuation & analysis models using Excel
    • 50 Ways to analyze data from Chandoo.org – this online course makes you awesome in all aspects of data analysis, reporting & visual analysis using Excel

    Transcript of this session:

    Download this podcast transcript [PDF]

    According to you, What are key concepts for financial analysis?

    I shared my opinion and explained 5 concepts in the podcast. Now its your turn.

    Tell me what are the key concepts to master if someone needs to learn about financial analysis & modeling? Please share your thoughts and inputs in the comments section.

    The post CP042: Financial Analysis & Modeling concepts – 101 appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

    Previous 1 2 3 4 7 Next

    Related Podcasts

    Reply All

    1

    Reply All Games & Hobbies
    Inside VR & AR

    2

    Inside VR & AR Gadgets
    Note to Self

    3

    Note to Self News
    BrainStuff

    4

    BrainStuff Natural Sciences
    This Week in Tech (Audio)

    5

    This Week in Tech (Audio) News
    Hands-On Tech (Audio)

    6

    Hands-On Tech (Audio) Technology
    footer-logo

    Contact Us

    Toll Free: 844-670-7747

    Links

    • Home
    • Top Charts
    • Networks
    • Apps
    • Independents Podcasts
    • Podcast Advertising
    • Podcast News
    • Contact Us
    • About Us
    • Analytics & Insights

    Stay Connected

      Privacy, Terms of Use & Our Code of Ethics Protecting Content Creators Copyrights