Autosum many ranges quickly with Multi-select & ALT= [quick tip]
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=
Analyzing half a million complaints – Customer Satisfaction Scorecard [Part 3 of 3]
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.
- Complaint reason analysis – Part 1
- Regional trends & analysis – Part 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.
Not so wild lookups [video]
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 wildcard
Use slicers to create a cool selection mechanism [quick tip]
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.
Make 1,200 dinosaurs in no time with Excel [formulas]
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.
Format charts quickly with chart styles & color themes [quick tip]
Here is a quick tip to reduce the time you spend on chart formatting – use chart styles & color themes.
Excel offers various pre-defined color schemes and chart styles. Using them is very simple.
- Select your chart
- Go to Chart Design ribbon
- Click on the style or color scheme you want.
- Your chart changes instantly.
How can I help you in 2016? [Survey]
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.