CP02: Six Tips to get a Six Figure ($100,000+) Data Job
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
So you want a 6 figure data job? In this podcast episode, I am going to share 6 strategies and tactics to land a $100k+ data job.
Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Ladies & gentlemen… I have an exciting announcement. I am relaunching my podcast!!!
It only took me 7 years, but Chandoo.org podcast is now BACK! I am planning to make regular episodes on Excel, Power BI, SQL & Data Analytics.
In the 1st episode of Season 2 of Chandoo.org podcast I talk about, Top 5 Excel Skills you need to be a Successful Data Analyst in 2023.
CP056: So which formulas you should care to learn?
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
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)
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
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
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
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
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
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
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
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