Forum Login | Courses Login

ISNUMBER Formula in Excel

ISNUMBER Formula in Excel

by | Jul 8, 2020 | Online Business Courses

How to Use the ISNUMBER Formula in Excel The ISNUMBER formula is used to determine whether a cell contains a number or not. This can be useful if you want to write conditional logic based on a column that contains data but you want to only apply the formula to cells...
Geo Heat Map in Excel

Geo Heat Map in Excel

by | Jul 8, 2020 | Online Business Courses

How to Create/Use the Geo Heat Map in Excel Heat maps in Excel are available for different countries. It provides a good demonstration of where the concentration of sales data is geographically located. Data Function Explanation: Geo Heat Map: This function is used to...
RANK Formula in Excel

RANK Formula in Excel

by | Jul 7, 2020 | Online Business Courses

How to Use the RANK Formula in Excel The RANK formula in Excel is normally used to show ranking (high to low, or low to high) of any set of values. This is useful if you are applying statistical analysis on a data set and you need to provide a ranking of how they...
FREQUENCY Formula in Excel

FREQUENCY Formula in Excel

by | Jul 7, 2020 | Online Business Courses

How to Use the FREQUENCY Formula in Excel The FREQUENCY formula in excel is used to count the number of times an item appears in an array. It is useful to count the number of times a numerical value appears in a range. An alternative to this is to use a COUNTIFS...
FORECAST Formula in Excel

FORECAST Formula in Excel

by | Jul 7, 2020 | Online Business Courses

How to Use the FORECAST Formula in Excel The FORECAST formula in Excel is used to create a prediction about an item (e.g. sales, profit, etc.) by using previous results as a basis. There is a limitation in the simplicity of this forecast formula. This formula provides...