Archive for May, 2016
Show more of your workbook on screens [quick tip]
Ever wanted to show your workbook to someone and felt that you had less screen real estate? This tip will help you get more out of your workbook.
So how to get 50% more space for your workbooks?
Simple, just follow these steps.Continue »
Fish Eye Effect for highlighting selection – Is it effective? [Advanced Charting]
A few days back, WSJ ran a visualization titled “What’s your pay gap?” It depicts median pay gap between female & male workers in 422 different professions in USA. The chart uses fish eye effect to highlight the selected profession. See below demo to understand the effect.Continue »
Excel Tips, Tricks, Cheats & Hacks – Readers Edition
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.
SUMPRODUCT – Beginner to Advanced [Master Class]
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 »
How many ‘Friday the 13th’s are in this year? [Formula fun + challenge]
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 »
Excel Tips, Tricks, Cheats & Hacks – Readers Edition Prequel
Over the past 3 weeks we have been able to showcase some Excel Tips, Tricks, Cheats and Hacks from some of the best excel practitioners on the net.
But now it’s your turn…
Apply Conditional Formatting using Slicers
Have you ever wondered about applying different Spreadsheet Formats or Styles to reports which you may be send to different people and so the styling may be different for each recipient?
I haven’t, but in this post I will show how you can add it to your worksheets.Continue »
Extract the 10 digit number [formula homework]
Okay, time for another challenge.
Imagine you have some data like this. Each cell contains 3 numbers separated by line break – CHAR(10) and you need to extract the number that is 10 digits long.
Go ahead and solve this riddle.Continue »
Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition
Learn some Excel Tips, Tricks, Cheats & Hacks from some Notable [Non-MVP] Excel Websites.Continue »