Tip of the Month =SUBTOTAL
MArry Christmas Everyone, here's the Excel Tip of the Month #subtotal #excel #tip
Financial Functions in Excel
Let’s consider a loan with monthly payments, an annual interest rate of 6%, 10-year duration, a present value of $250,000 (amount...
Sum/Count by Cell Colour in Microsoft Excel (VBA)
Last week one of my friends asked me whether it is possible to add cells based on their cell colour or not. As we know, Excel does not...
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...
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...
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...
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...
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...
Upper/Lower/Proper Case in Excel
In this article, we will learn how to convert text strings in Excel to Upper, Lower, and Proper cases. Upper function will convert the...
