Charmed Price Problem
Here is a charming little problem to kick start your day.
Lets say you run a cute little bakery around the corner. Since you want your prices to look charming, you have a policy to round them down or up based on below rule.
If the price ends with 0, 1 or 2 cents, round it down to 9 cents.
If the price ends with 3, 4 or 5 cents, round it up to 5 cents.
If the price ends with 6, 7, 8 or 9 cents, round it up to 9 cents.
For example,
So how do you round to nearest charmed price? You could do it manually. But you would rather bake a few more of those Tiny Cup Cakes than waste time rounding the prices. So you want an automatic way to round prices. This is where Excel helps.
CP021: How to quickly compare 2 lists in Excel
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 21st session of Chandoo.org podcast, lets compare lists. Quickly
What is in this session?
Comparing things is a favorite pastime for analysts all over the world. Sadly, it is also an area where we waste hours. So in this episode, I share my top secret comparison techniques to save you time.
Note: This is a short format podcast. That means you spend less time listening to it, while becoming more awesome.
In this podcast, you will learn,
- Why I sound like I am on a secret mission at a mafia hideout.
- 5 ways to compare 2 lists
- Manual method
- Conditional Formatting
- Row Differences
- LOOKUP formulas
- COUNTIF formulas
- Bonus tip: Removing duplicates
- Conclusions
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…
CHOOSE() me, an introduction to Excel CHOOSE function
Today lets learn about Excel CHOOSE() function.
CHOOSE eh? What does it do?
To understand CHOOSE() and appreciate its uses, lets invent an imaginary boos-subordinate pair.
Jasmine is the boss. She is, well, lets call her peculiar. She likes olives, Tuesdays & color Red. She hates potatoes.
Martin is the faithful butler of Jasmine. He is obedient, quirky and tall. He likes lotuses, Fridays & color blue. He hates potassium.
Enter Jasmine’s scarf problem:
Jasmine likes to wear a different colored scarf every weekday. She likes to wear Red colored scarf on Mondays & Tuesdays. She likes to put on the blue polka dot scarf on Wednesdays. On Thursdays, she wears her olive colored scarf. On Fridays & Saturdays, she prefers the lovely orange blue scarf. Sundays are no scarf days.
No wonder she is peculiar.