All articles in 'Learn Excel' Category
Over the last month we have seen some Excel Tips, Tricks, Cheats & Hacks presented by some of the best Excel practitioners on the internet.
In this final post of the series we highlight the Readers Contributions.
This is second episode of our Monthly Master Class.
In this one, you will learn all about SUMPRODUCT. Know all about basics to advanced usage of this powerful & versatile formula in this 98 minute master class.Continue »
Today is Friday the 13th. If you are a raging friggatriskaidekaphobiac, I suggest you to stop reading this post. For the rest of you, I have something fun.
Given a year in cell C3, let’s find out all the months with Friday the 13th. Something like above.Continue »
Learn some Excel Tips, Tricks, Cheats & Hacks from some Notable [Non-MVP] Excel Websites.Continue »
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.