CP020: Top 10 time saving strategies for business analysts
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 20th session of Chandoo.org podcast, lets save some time.
What is in this session?
We all want to save time and stay productive. The obvious answer seems like using keyboard shortcuts. But they can only get you so far. So what about the real productive strategies? That is what we address in this podcast.
In this podcast, you will learn,
- Announcements
- 5 key areas of business analyst work – tracking, analysis, reporting, data management & modeling
- Time saving strategies for tracking
- for analysis
- for reporting
- for data management
- for modeling
- Conclusions
CP019: 6 Tips for Best Practice Modeling – Interview with Danielle from Plum Solutions
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 19th session of Chandoo.org podcast, lets talk about modeling best practices.
What is in this session?
I am very happy to interview my good friend, blogger, author, excel trainer & business-women – Danielle Stein Fairhurst for this session. I first met Danielle when I went to Sydney, Australia in April 2012. Our friendship & collaboration grew a lot in the last 2.5 years. She is a great speaker & trainer. This episode is loaded with her trademark style commentary, explanation & tips for better modeling. I hope you will enjoy it.
In this podcast, you will learn,
- Introduction to Danielle & her work
- 6 Tips for Best Practice Modeling
- Write consistent formulas
- Avoid hard-coding
- Smart referencing
- Ditch the bad habits
- Document assumptions
- Format & label things
- Resources for learning more
CP018: Dont be a Pivot Table Virgin!
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 18th session of Chandoo.org podcast, lets loose your Pivot table virginity.
Note: This is a short format episode. Less time to listen, but just as much awesome.
What is in this session?
Pivot tables are a very powerful & quick way to analyze data and get reports from Excel. But surprisingly, not many use them. Today, lets bust your pivot table virginity and understand the concepts like pivoting, values, labels, filters, groups and more.
In this podcast, you will learn,
- Announcements
- What is a Pivot Table?
- Example of business data & reporting needs
- Key pivot table terms to understand
- Creating your first pivot table
- Learning more about pivot tables
CP017: Top 10 non-Excel MS Office tips for you – Interview with Paul Woods – Office MVP & Blogger
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 17th session of Chandoo.org podcast, lets leave Excel aside and talk about other MS Office apps.
Thats right. We will be learning 10 tips on how to use Word, Power Point, Outlook etc. Ready?
In this podcast, you will learn,
- About Paul
- Ten tips for MS Office
- 1. Use Excel to communicate instead of just calculations
- 2. Paste Special
- 3. Double click trick!
- 4. Inserting screenshots
- 5. Turning off notifications
- & more…
CP016: 3 Must have books for aspiring analysts
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 16th session of Chandoo.org podcast, lets review 3 very useful books for aspiring analysts.
What is in this session?
Analytics is an increasingly popular area now. Every day, scores of fresh graduates are reporting to their first day of work as analysts. But to succeed as an analyst?
By learning & practicing of course.
And books play a vital role in opening new pathways for us. They can alter the way we think, shape our behavior and make us awesome, all in a few page turns.
So in this episode, let me share 3 must have books for (aspiring) analysts.
CP015: Handling big data, Controlling model railroad sets, Overcoming Excel obsession & more – ASK CHANDOO
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 15th session of Chandoo.org podcast, lets answer some of your burning Excel questions.
What is in this session?
Around last week, I invited you to ask me anything. More than 150 people responded to this call and sent in their questions. Since answering all the questions is not possible, I handpicked roughly 10 questions to answer in this episode of Chandoo.org podcast.
In this podcast, you will learn,
- How to fill blank cells with data from above
- How to work with Big data in Excel
- How to combine data from multiple sources & analyze it in Excel
- How I am managing my life after starting Chandoo.org
- How to create and distribute stand-alone Excel products
- How to control a model railroad set using Excel VBA (not fully answered)
- & more…
CP014: How to create awesome dashboards – 10 step process for you
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 14th session of Chandoo.org podcast, lets figure out how to make awesome dashboards.
What is in this session?
Excel based dashboards are much in demand these days, thanks to advancements in Excel & growing pressure on costs. Now a days, analysts & managers are expected to quickly put together a dashboard using Excel. But how do you make a dashboard? What process you should follow? These are the questions we address in this podcast.
In this podcast, you will learn,
- Announcements about upcoming dashboard classes
- Ten step process for creating awesome dashboards
- 1. Talk to your end users
- 2. Make a sketch of the dashboard
- 3. Validate your understanding
- 4. Collect data
- 5. Structure the data
- …