There are many things in Microsoft Excel that you may never know. This tutorial will illustrate “how to” create Charts by Microsoft Excel with one key. Learn it from the example below.
continue reading "An easiest way to Create Charts in Microsoft Excel"

For Microsoft Excel, we usually use various formula to calculate the number but the formula can also be used in text operation. This tips I will let you know how to combine text from different cell. I will take the symbol, &, called Ampersand to operate the combination of text. The syntax we must put in cell is :
continue reading "How to Combine Text from many Cell using the & : Excel Tip"

Normally we shade color in cell by using fill color tool. If your cells are filled with numbers, you can distinguish the numbers and the number range by shading different color in each cell. But it is hard work to do them one by one if you have more cells to do. The Conditional Formatting is one of the Excel’s tools in order to help you adding color vary with the numbers you input. Let you follow the example below and get “how to use the Conditional Formatting tool?”.
continue reading "Shading cell color vary with the objective number"

How to find the maximum or highest number in the Excel sheet ?

For the Microsoft Excel. If you have many numbers or values and you must place the highest value in a cell, you will feel dizzy to find the highest value for that cell. Because of too many number, the Microsoft Excel supplies you the MAX Function for your convenience. The syntax of the MAX Function is
continue reading "Find Highest number by using MAX Function"