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:
    CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you Mar 13, 2014
    Show notes

    In the second session of Chandoo.org Podcast, We will be learning how to use 5 Excel lookup functions.

    CP002: VTALKUP - Demystifying 5 Excel lookup functions + 4 resources for you

    Good News – We are on iTunes and more

    Before we proceed with the show, let me share few very happy news with you all.

    • Chandoo.org Podcast is on iTunes. What more, we are featured in New & Noteworthy section too. Click here to subscribe.
    • Our show is on Stitcher and Windows Phone Podcasts too: Click here to subscribe on Stitcher. For Windows phone, search your podcasts app for our show.
    • As always, you can get latest episodes, show notes & resources from our Podcast page.

    What is in this session?

    In this session, we tackle one of the most important areas of Excel. The lookup functions.

    You will learn,

    • Why lookup functions are necessary
    • 5 Important lookup functions in Excel – VLOOKUP, HLOOKUP, LOOKUP, MATCH & INDEX
    • When & how to use each of these 5 functions?
    • Extreme scenarios:
      • What happens when the value you are looking up is not there?
      • What if too many items match the lookup value?
      • What if you have too many conditions in the lookup criteria?
    • Using IFERROR function
    • Re-cap of the new powers you acquired
    • 4 Resources for you to learn lookup functions better

    Go ahead and listen to the show.

    Links & Resources mentioned in this session:

    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

    Example workbook for this podcast:

    Click here to download example workbook to play with the ideas mentioned in this podcast.

    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

    Special gift for you:

    • Listen to this session to unlock a special gift for you.

    Transcript of this session:

    Download session transcript [PDF]

    Thanks to Jordan

    I almost forgot. Special thanks to Jordan (@SpikingWhamos) for suggesting VTALKUP as a name.

    If you enjoy the podcast…,

    Please do these 2 things. It means a lot me & our community.

    1. Subscribe to our podcast on iTunes
    2. Please leave an honest review on iTunes by clicking here.. It will help the show & its rankings immensely. Thank you so much.

    Now its your turn to talk

    Do you use lookup formulas in Excel? What do you use them for? Where do you struggle? What new things have you learned about them thru this podcast? Please share your views, suggestions, questions and tips in the comments area below.

    The post CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

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

    Chandoo.org Podcast - Session 001 - Introduction, What to expect, Show formalities & a special gift for you

    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 finally here. You can listen to the inaugural episode by using the audio player above.

    How do I subscribe to this podcast?

    There are 5 ways to subscribe to this podcast.

    1. Subscribe on iTunes: The most popular and easiest way to get our podcast. Click here and subscribe to it on iTunes.
    2. Subscribe thru Stictcher, Blackberry or Zune Podcasting directories: The process of adding our podcast to these listings is underway. I will share links once we are ready.
    3. Subscribe to our Podcast RSS This is ready. Just click on the Podcast RSS link and add it to your feed reader. You get new podcast episodes right to your computer / tablet.
    4. Subscribe to Chandoo.org newsletter This is better. You get not just podcast sessions, but regular Excel tips, templates and tutorials too.
    5. Just visit Chandoo.org regularly. Whenever we have a new podcast, you can just listen to it right here. Book mark our podcast page too.

    What is in this session?

    Since this is the very first episode of our show, I focused on these aspects,

    • Introducing myself, my family & Chandoo.org to you
    • Setting expectations for this podcast
    • Format of the show & resources you will get
    • Important links and pages
    • A special gift to you for tuning in.

    So go ahead and listen the show.

    Right click here to download the MP3 file to your computer.

    Links & resources mentioned in this session:

    Special free gift to our listeners

    • You must listen to the podcast to get this link.

    Chandoo.org on Social Media:

    • Our YouTube Channel has more than 80 videos and crossed a million views.
    • Our Facebook Page where we post new content, tips & fun questions every week.
    • Chandoo.org on Twitter is a place for you to get latest content, ask questions or see cool links.
    • Chandoo.org Pinterest board has awesome collection of Excel tips, charts, dashboards and books.

    Podcasts I listen to:

    • Smart Passive Income Podcast by Pat Flynn has a ton of information, inspiration and ideas for small business owners like me.
    • This is your life podcast by Michael Hyatt helps you become a better leader, communicator and individual.
    • Freaknomics Radio explores the hidden side of everything and asks interesting questions.

    Ask your questions:

    Click here to post your questions and I will answer them in a future episode of our podcast. That simple.

    About Chandoo & Chandoo.org:

    • Welcome to Chandoo.org, what we do and how we can help you.
    • Story of Chandoo.org startup – part 1 & part 2.
    • Meet my family
    • About Chandoo
    • My MVP Award profile

    If you enjoy the podcast…,

    Please do these 2 things. It means a lot me & our community.

    1. Subscribe to our podcast on iTunes
    2. Please leave an honest review on iTunes by clicking here.. It will help us the show & its rankings immensely. Thank you so much.

    The post CP 001: Chandoo.org Podcast First Episode – Introduction, What to expect, Show formalities & Special gift appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

    Previous 1 5 6 7

    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