Forum Login | Courses Login

DMIN Formula in Excel

DMIN Formula in Excel

by | Jun 25, 2020 | Online Business Courses

How to Use the DMIN Formula in Excel The DMIN formula in Excel is used to find the smallest number in the database that matches the specific condition set. Formula explanation: Database: Range of data within which we want to perform the analysis. Field: The item which...
COUNTBLANK Formula in Excel

COUNTBLANK Formula in Excel

by | Jun 25, 2020 | Online Business Courses

How to Use the COUNTBLANK Formula in Excel The COUNTBLANK formula in Excel is used to count the blank cells within a selected range. Depending on the analysis that you’re performing, this could come in handy as you do not have to manually Formula explanation: • Range:...
FORMULA TEXT function in Excel

FORMULA TEXT function in Excel

by | Jun 24, 2020 | Online Business Courses

How to Use the FORMULA TEXT function in Excel The Formula TEXT function in Excel is used to return a formula as text. If you have got a string of formula that is used as an equation within a cell, you can use the formula text formula and it will actually write out...
VLOOKUP Formula in Excel

VLOOKUP Formula in Excel

by | Jun 24, 2020 | Online Business Courses

How to Use the VLOOKUP Formula in Excel When you have a specific item you’d like to lookup in a table and there is only one of that item in the table i.e. it is unique. This uses a vertical lookup. Separately, you could use the HLOOKUP formula but the HLOOKUP...
SLOPE Formula in Excel

SLOPE Formula in Excel

by | Jun 24, 2020 | Online Business Courses

How to Use the SLOPE Formula in Excel The SLOPE formula is a statistical function in excel that can be used to return the slope of the linear regression line through data points. The SLOPE formula is the vertical distance divided by the horizontal distance between any...