# 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

## 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

## 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 , , | 8 Comments

## 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

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