57 episodes

Become Awesome in Excel by Chandoo.org - A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel tips, techniques, tutorials and templates. We do this by providing you with spreadsheet design strategies & tactics, Excel tips, keyboard shortcuts, productivity hacks, case studies, personal experiences, interviews with Excel authors & Microsoft MVPs, book & product reviews related to Excel and answering your Excel questions & doubts.

Chandoo.org Podcast - Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel Chandoo - Microsoft Excel MVP, Training & Data Analysis Specialist

    • Business
    • 4.7 • 51 Ratings

Become Awesome in Excel by Chandoo.org - A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel tips, techniques, tutorials and templates. We do this by providing you with spreadsheet design strategies & tactics, Excel tips, keyboard shortcuts, productivity hacks, case studies, personal experiences, interviews with Excel authors & Microsoft MVPs, book & product reviews related to Excel and answering your Excel questions & doubts.

    CP056: So which formulas you should care to learn?

    CP056: So which formulas you should care to learn?

    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 updates

    3 legs of formula writing



    Function knowledge

    Operators

    Referencing





    6 categories of must-know functions



    Basic math

    Conditions

    Lookups

    Text

    Date & time

    Work specific





    Closing remarks & resources for you

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

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

    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 reviving our podcast and more.



    What is in this session?



    In this podcast,



    Why there was such a long gap between last and this episode

    What next?

    How to extract every 6th item from a list?

    CP054: Top 10 Pivot Table Tricks for YOU

    CP054: Top 10 Pivot Table Tricks for YOU

    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 updates

    Top 10 pivot table tricks



    Adding same value field twice

    Tabular layouts

    GETPIVOTDATA & 2 bonus tricks

    Relationships & data model

    One slicer to rule them all

    Show only top x values

    Relative performance

    Show unique count

    Spruce up with conditional formats

    Not so ugly pivot charts





    Resources & Show notes for you

    CP053: Excel Data Validation for Dummies

    CP053: Excel Data Validation for Dummies

    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 validation

    How Excel DV compares with database & software DV?

    Types of data validation rules

    List & custom rules explained

    Input & error messages

    Alternatives to data validation

    Enhancing data validation

    Removing data validation rules

    Homework problem for you

    Resources & show notes

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

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

    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 to Power Query

    Why you should get this book?

    What is in this book?

    A very cool example of the techniques you will learn

    Conclusions

    • 26 min
    CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered

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

    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 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

    • 38 min

Customer Reviews

4.7 out of 5
51 Ratings

51 Ratings

jrogers2 ,

Awesome podcast!!! Great for career

I listen to this podcast on my commute. It absolutely makes me a more valuable worker.

jackwebb714 ,

Are these boardcast in video?? or only audio.

I just downloaded the pivot table podcast. It is all audio, mp3? no video is distressing. The audio teaching is clear and understandable but clearly not as good as following along with a video.

isaedson ,

New Data Analyst

Chandoo.org podcast has been a great resource for me. I am a new Data Analyst with very basic knowledge of Excel. This podcast has helped me search in the right places, buy books and actually start programming in Excel I am not even halfway on the playlist and I have learned so many tricks that has made me impress my boss and her boss. Thanks Chandoo for making me awesome in Excel.

Top Podcasts In Business

Listeners Also Subscribed To