Monthly Archives: March 2016

Lost in colors

Posted on March 26, 2016 by

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

Posted on March 19, 2016 by

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

Rank in subgroup… RANKIF?

Posted on March 12, 2016 by

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

Posted on March 8, 2016 by

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

Posted on March 5, 2016 by

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 , | 1 Comment

Want to learn Macro? Here’s the chance.

Posted on March 1, 2016 by

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