Excel Tips

Rounding a number in Excel is very easy. There are situation wherein we need to round a number to closest 10 or 100. For example, if we have a number 115 then 120, if we have 112 then 110. For this there is a dedicated function in Excel called MROUND which comes useful for such [...]

The Pie charts well known for representing size relationship between the parts and entire thing. For example, if a company has multiple units, if you represent the profit of each unit in Pie Charts, it shows profit per unit in percentage. Sum of all slices/units is the total profit of the company.  Sometimes, we have [...]

When we work in excel sheets, we are required to find matching value in a row and return the Column name. For example, we need to calculate lowest priced store from the price table of multiple stores for multiple products. Another example can be finding the primary reason for exits from the exit feedback form [...]

Checkbox in excel is a very handy tool for creating the checklist or simple user forms. There is no need of any Excel VBA knowledge to insert Checkbox into a excel sheet. This is increase the speed at which user enters data as well as it reduces the chances of misspellings which will give trouble [...]

1 2 3 7 8