Forum Login | Courses Login

Transpose Formula in Excel

Transpose Formula in Excel

by | Jun 16, 2020 | Online Business Courses

How to Use the Transpose Formula in Excel The transpose formula in Excel is used if you are working with data that is either vertical or horizontal and you want to flip it in the opposite direction and present it in the opposite way. The transpose formula is an array,...
SUMIFS Formula in Excel

SUMIFS Formula in Excel

by | Jun 16, 2020 | Online Business Courses

How to Use the SUMIFS Formula in Excel The SUMIFS Formula is used to add the numbers which apply when multiple criteria are met. This is different from the SUMIF formula which only relies on one criterion. SUMIFS Formula Explanation      =SUMIFS(sum_range,...
SUMIF Formula in Excel

SUMIF Formula in Excel

by | Jun 16, 2020 | Online Business Courses

How to Use the SUMIF Formula in Excel The SUMIF formula is a function in Excel used to sum the values in a range that meet one criterion that you specify. This is different from SUMIFS because SUMIFS can handle multiple criteria int the formula. SUMIF Formula...
MATCH Formula in Excel

MATCH Formula in Excel

by | Jun 16, 2020 | Online Business Courses

How to Use the MATCH Formula in Excel The MATCH formula looks for an item within a range and returns the relative position of that item in the range. It is often used in combination with the INDEX function and is often nested within an INDEX function. However, for the...
INDEX Formula in Excel

INDEX Formula in Excel

by | Jun 16, 2020 | Online Business Courses

How to Use the INDEX Formula in Excel The Index formula is typically used to return the value of an item in a table depending on the row and column number chosen to be indexed in the formula. The Array Formula Syntax Includes: Array (required):- This is a range of...