Data Filtering in Microsoft Excel 2013
Filtering is a fast and easy approach of sorting work with a portion of data so that you are able to display only the rows in your spreadsheet […]
Data Filtering in Microsoft Excel 2013 Read More »
Excel
Learning Excel has never been easier. Review hundreds of Excel tutorials geared towards beginners all the way to experts.
CUMIPMT Function
How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return the cumulative interest paid on a loan. This
RANK Function
The Excel Rank function returns the numeric value when compared to a list of numeric values. You can rank lists in ascending or descending order. Let’s first look
Compound Quarterly Growth Rate (CQGR)
Compound Quarterly Growth Rate (CQGR) in Excel is rather easy to calculate. This can be very useful to forecast potential income or forecast personal returns. Before we begin,
Compound Quarterly Growth Rate (CQGR) Read More »
MAX Function
The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values, TRUE and FALSE, and text
RAND Function
The Excel RAND function returns a random number between 0 and 1. This is a rather simple function in Excel, but can be useful in a number of