Conditional formatting: Highlight Cells Rules

Here you can highlight cells that either greater than, less than or equal to a value. It also allows us to highlight cells than contain specific text, value in between, duplicate to mention few. Let’s illustrate how Excel highlights cells that hold values that are greater than a particular one. For instance quantity sold that[…]

Shares 0

Combo chart in excel

Combo chart contains two or more chart types in a graph. Its cool feature is how it show the interconnected data with their combined relevance. For example Romatee Motorcycle sales trends across years. To insert combo chart for this is very easy particularly in excel 2013 and beyond. Highlight the cells range Go to Insert[…]

Shares 0

How to insert Pie chart in Excel

Pie chart is use to emphasises the contribution of each category to the pie that represents grand total. This can be demonstrate with the following example showing the number staff across selected department in Nicon Hotel. To insert pie chart for the above data set. Highlight the data Go to Insert Menu Select pie chart[…]

Shares 0

Column Chart in Excel

Column chart is used for comparing values across categories. This can either be in any of the three forms, which include (1) clustered column, (2) stacked column, and (3) 100% stacked column. Clustered column is use to emphasises individual variance when order of the category is not matter. The table below shown our Dashboard Software[…]

Shares 0

Remove Duplicates in Excel

This function is use to eliminate unnecessary repetition of item on the list. Let’s take a look at the two lists of various brand of motorcycle shown in the snapshots below. Let’s highlight the Duplicate brands for better clarification. Follow the following steps highlight the duplicates: Select the cells contains the items Click Home Menu[…]

Shares 0