Skip Blank doesnt skip blank cells ?!?
In our excel paste tricks post, I have mentioned a paste special feature called “skip blanks” that can apparently be used to skip blank cells when pasting data. I am writing about this again because, I have received an email from Bruce saying, This is erroneous. In actuality, the result that is pasted is the […]
Visualization Challenge – Budget vs. Actual Performance
Here is your chance to win a copy of The Visual Display of Quantitative Information by Edward Tufte, all you need to do is visualize budget vs. actual performance of the given data. Go!
Highlight Top 10 Values using Excel Conditional Formatting
In excel conditional formatting basics article, we have learned the basics of excel conditional formatting. In this article we will learn how to highlight top 5 or 10 values in a list using excel as shown aside. We will use LARGE excel formula and conditional formatting to do this.
New Improved Version of Excel Formula Help
Good news!!! We have upgraded the excel formula help page to a new, more easily accessible and better laid out page. Find out more…
Excel Conditional Formatting Basics
Do you know What is excel conditional formatting? Learn the basics, few examples and see how you can use it in day to day work in this installment of spreadcheats.
Us vs. Them – Compare Sales Performance using Charts & Form Controls
Today we will learn a little trick to compare 1 value with a set of values, For eg. our sales vs. competitor sales. We will learn how to create a chart like this.
How to use Excel Chart Templates and Save Time
Learn how to use excel chart templates in this installment of spreadcheats. Save time.