All articles in 'Learn Excel' Category
Learn some of the Microsoft Excel MVP’s favorite Excel Tips, Tricks, Cheats & Hacks in this post
Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition
One of our readers emailed this question recently,
I like the conditional formatting icons. I am trying to present some business data where going down is good. How do I get a green colored down arrow icon?
Essentially, Ms. CanIGetItInGreen wants this:
Unfortunately, Excel’s conditional formatting icons are not customizable. So we can’t get the green down arrows without some sneak. And sneak we shall.Continue »
Let’s say you have data in a worksheet in various ranges, and you want sum up each range at the bottom.
Something like this:
How to do all this one shot?
Simple. We use multi-select & ALT=Continue »
Hi friends & readers of Chandoo.org,
I am very happy to invite you to our newest online class, 50 ways to analyze your data. This program makes you an awesome analyst, training you on vital skills like data analysis, data science, visualization, modeling business problems and finding best solutions.
Please click here to know more about this program & enroll.
What is this course?
It is the age of big data. Alas, what we need is big insights. But finding even small insights buried in our data is a hard task. To find the stories hidden in your data, you need to follow a process like this:
- Collect & clean data
- Structure the data
- Model business problems
- Analyze the data (or solve the problem)
- Visualize results
- Find conclusions
- Add layers of complexity to the problem
- Build what-if scenarios
- Reach conclusions
- Take action
This is where the 50 ways to analyze your data course helps. In this program, we analyze 50 familiar, important and diverse business situations using several of the above steps.Continue »
This is the final part of our series on how to analyze half a million customer complaints. Click below links to read part 1 & 2.
Customer satisfaction scorecard
In the previous parts of this case study, we understood what kind of complaints were made and where they came from (states). For the customer satisfaction scorecard, let’s focus on individual companies.Continue »
In case, this is the first time you are hearing about Excel formula wildcards, check out the Using wildcards in Excel VLOOKUP formula tutorial.
So you know about wild cards like * ?, now how would you tell VLOOKUP to ignore them?
Say, you are genuinely interested in looking the value “* Payroll” in a lookup table. What then?
This is exactly the problem faced by Peter in our forum post VLOOKUP and cells with “*” NOT to be interpreted as wildcardContinue »
Hi friends & readers of Chandoo.org
I am very happy to invite you to our newest online class, 50 ways to analyze your data. This program is aimed to make you an awesome analyst, training you on vital skills like data analysis, data science, visualization of outputs, modeling business problems and finding best solutions.
Please take a few minutes to read this. If you are interested in the program, sign up for the waiting list.Continue »
Most advanced Excel users know that slicers are cool. Today, let’s learn how to use slicers to create an awesome selection mechanism for your dashboards and forms.
First see a quick demo
Looks slick, eh? Read on.Continue »
It seems spreadsheets & dinosaurs on a collision course. How else can you explain Jon’s XKCD Velociraptor problem solved with Excel and now this. Debby, alert reader of our blog sent me this email yesterday.
I need an algebraic formula to solve this in Excel
I have 5 heads, 5 bodies, 4 arm sets, 4 leg sets and 3 tails. I need to see if I can create 1000 dinosaurs from these, and if that’s too many AND I need the 5 digit groupings to prove it and create them.
basically Xa*Xb*Xc*Xd*Xe=1000 – I’m not supposed to go over 1200. […] And then I want the 5 digit combinations if possible – right now they are trying to do the combinations by hand – would be awesome if we could do it in Excel.
A very happy new year to you. May 2016 be your most awesome year yet.
This year too I plan to share tutorials, tips, podcasts & videos to make you awesome. I hope to focus on
- Excel 2016 – exploring new features
- Power BI – What is it, how does it make you awesome.
- Write a sequel to The VLOOKUP Book.
- Launch a new online course on Power BI & New Excel.
- Run 2 more batches of 50 ways to analyze data program in Feb & July 2016.
- Run another dashboard contest on Chandoo.org
- Write about awesome ways to work with data – formulas, charts, tables, pivots etc.
- Talk about many advanced and work specific Excel scenarios in the podcast
But wait, what do you want to learn more…?
While these are my plans, I want to make sure Chandoo.org helps you the best. So please take a minute and answer this one question survey.Continue »
Here is a New year gift to all our readers – free 2016 Excel Calendar & daily planner Template.
This calendar has,
- One page full calendar with notes, in 4 different color schemes
- Daily event planner & tracker
- 1 Mini calendar
- Monthly calendar (prints to 12 pages)
- Works for any year, just change year in Full tab.
2015 has been the busiest year since starting Chandoo.org.
Wow, that is 12 years of breaking previous records. Thank you.
In 2015, we published 124 posts (down 3% YoY), received 6,300+ comments (up 5%). Our forum too had busy year with 1000s of new members and 5,000+ new threads. Chandoo.org podcast continued to shine, we had 24 episodes this year and reached the 50 episode milestone. Our podcast episodes has been downloaded more than 900,000 so far since launch (in March 2014) with 600,000+ downloads this year alone!!!
Fun fact: People have spent 6.8 million minutes in 2015 listening to Chandoo.org podcast. (assuming only 50% of downloads materialized to listens)Continue »
Today is a school holiday for kids. So we (Jo & I) are taking them to zoo for a day of walking, picnic and family time. Before I rush, I want to share two quick announcements with you.
KPI contest winners:
Thanks for everyone who participated in our recent KPI data visualization contest. Each and everyone who made the final list is a winner in my book. You have creativity, passion and a sense of sharing.
After reviewing all the entries and considering our judge’s opinions, here are the winners:Continue »
Here is an interesting twist on the good old VLOOKUP. How to find the pricing applicable for given quantity of a product?
Something like above.
Looks interesting? Then read on…Continue »
Imagine you are the head of training department at ACME Inc. You arrange training programs round the year to empower your team. It is hard work, coordinating between employees, trainers, department heads, venues and coffee machines. What if there is something to help you keep track of all this? I am not talking about getting you a shiny new iPad, you silly. I am talking about a tracker & calendar built in Excel that ties everything together (well, almost everything, you still have to fill the coffee machine.)
We are going to build a training program tracker & calendar using Excel.Continue »