INDEX MATCH > VLOOKUP
The INDEX MATCH function is one of Excel's most powerful functions. The friend of the much-used VLOOKUP, INDEX MATCH allows users to look...
Print Row & Column headers on every page
If you want to see raw and column headers on your printouts while you print worksheets, you can simply follow below steps: 1. Go to Page...
Learn How to Group PivotTable by Ranges
One of the most interesting and powerful features of PivotTables is their ability to group the data. In the row and column label areas of...
Change Default Font & Font Size in Excel
To change default font and font size for workbooks, follow below steps: 1. Click File Tab 2. Select Excel Options 3. From the Excel...
Learn How to Change Colour of Excel Gridlines
Have you ever wondered if you could change the colour of the Gridlines in Excel worksheets? By default, the gridlines displayed in the...
Add Background in Excel Worksheet
In Microsoft Excel, you can use a picture as a sheet background for display purposes only. A sheet background is not printed, and it is...
Learn How to Change Currency Symbols for Certain Cells in MS Excel
Sometimes you need to display multiple currencies in same Excel spreadsheet. To change some of the numbers to another type of currencies...
SUMIFS Function in Excel
Syntax =SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], ...) Arguments sum_range - The range to be summed range1 - The first...
Excel IFERROR Function
This article describes the formula syntax and usage of the IFERROR function in Microsoft Excel. The IFERROR function returns a value you...
Rounding Numbers in Excel
This article teaches three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function. Below image will show you what...
