Monthly Archives: March 2016

Lost in colors

Which one of the following charts use better colors? It is not surprising if you prefer the one on the left as the colors used are of high contrast. However, will you change your mind after you read the same … Continue reading

Rate this:

Posted in Excel Tips, General | Leave a comment

Input fraction number in Excel

This title sounds a bit silly,  but I do believe many users must have experienced frustration when they tried to input a fraction number as simple as 1/2 in Excel. When we input something like x/y, Excel assumes that we are … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Allen Wyatt’s Excel Macros for Beginners course – Registration Ends Thursday

Earlier this month I let you know about Allen Wyatt’s Excel Macros for Beginners course. He only opens the doors to the course a few times each year, and he’s already busy helping those who have signed up for the … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Rank in subgroup… RANKIF?

To get the overall ranking is easy with the RANK function.  The syntax of RANK =RANK(Number,Ref,[order]) Number is the number we want to rank; Ref is the list of numbers of comparison (could be an array, a reference or a list … Continue reading

Rate this:

Posted in Formula | Tagged , , | Leave a comment

Don’t Miss Out on the Early Bird Registration for Allen Wyatt’s Excel Macros for Beginners course

About a week ago I let you know about Allen Wyatt’s Excel Macros for Beginners course. At the time, I invited you to visit Allen’s overview for the course, and I told you that you could register for this excellent … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

An example of using Solver for a causal problem in daily life

This post is intended to give you an example of using Solver in Excel to solve a causal problem in daily life – buying postal stamps.  Don’t consider it a tutorial. 😛 Have you ever heard of Solver in Excel? I think … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Want to learn Macro? Here’s the chance.

If you have been following my blog, you should know that I focus on tricks and tips of “preset” ways in Excel. For some people, using those preset ways is enough, but for others, Excel may be a bit restrictive … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment