57 episodes
Chandoo.org Podcast - Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel Chandoo - Microsoft Excel MVP, Training & Data Analysis Specialist
-
- Business
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?
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 -
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
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
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
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 -
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
Top Podcasts In Business
Listeners Also Subscribed To