14Apr2015

Using Array Formulas in Excel

An Array formula works with an array. You may see array formulas referred to as “CSE formulas,” because you press CTRL+SHIFT+ENTER to enter them into your workbooks. The following is a list of functions in Excel that use arrays: LINEST() MDETERM() MINVERSE() MMULT() SUM(IF()) SUMPRODUCT() TRANSPOSE() TREND() In general, array is a collection of items
  • 14 Apr, 2015
  • Excel for Commerce
  • 0 Comments
  • array formulas, Excel Consultant, Excel Expert,
Read more
09Dec2014

How to use SUMPRODUCT function in Excel

SUMPRODUCT function in Excel returns the sum of the products of the corresponding ranges or arrays. Let’s check the syntax for this function. Formula Syntax: SUMPRODUCT (array 1, [array 2], [array 3], …) The arrays in the formula are the ranges of the cells that we wish to multiply.   SUMPRODUCT function in Excel: Let’s
  • 9 Dec, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, SumProduct,
Read more
15Oct2014

How to use LOOKUP functions in Excel – by our Excel Expert

The process of looking up specific values in a data set is the most common task in Excel. If your intent is to become an Excel Expert someday then you will need a good understanding of all the lookup formulas available in Microsoft Excel. There are 6 lookup functions in excel: LOOKUP, VLOOKUP, HLOOKUP, (INDEX
  • 15 Oct, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Hlookup, Index, Lookup, Match, Offset, Vlookup,
Read more
30Sep2014

SUMIF and SUMIFS

SUMIF: SUMIF function in Microsoft Excel, adds the cells specified by a criteria. Syntax for this excel function =Sumif(range, criteria, sum range) Sumif formula can be used in Microsoft Excel to add all values against a single criteria. Let’s take an example, here we have a data table of Sales persons and their sales numbers.
  • 30 Sep, 2014
  • Excel for Commerce
  • 0 Comments
  • sumif, sumifs,
Read more
29Sep2014

COUNTIF and COUNTIFS

COUNTIF: The COUNTIF function in Microsoft Excel counts the number of cells within a range that meet a single criterion that you specify. For example, let’s create a table of Employees and their work hours. We are interested in finding the number of employees who work more than eight hours, this can be easily done
  • 29 Sep, 2014
  • Excel for Commerce
  • 0 Comments
  • countif, countifs,
Read more