top of page

Search

UNIQUE

UNIQUE function returns unique values that appear in a given range. array: Requires selection of a range to be evaluated. [by_col]:...

6 views

XLOOKUP

XLOOKUP function is a lookup function that searches for a given value in a given range and returns a corresponding value. XLOOKUP is only...

8 views

IFS & IF

IF forumla allows for a custom outcomes depending if the statement is TRUE or FALSE. logical_test: Evaluates a statement that either TRUE...

4 views

Conditional Formatting

Cells can be formatted automatically based if a formula statement is TRUE. 1. Select the range of cells where the condition will apply....

6 views

INDIRECT Formulas

Cell references can be passed into formula indirectly. This is especially useful when constructing dynamic formulas. To illustrate the...

4 views

Dates

Arithmetic operations can be performed on dates in excel. This is because dates are stored as values in excel. Example: Date 2020-01-01...

5 views

Error Handling

IFERROR function allows to insert a value expressed as a number, text or formula if the original formula results in error. value: a...

5 views

SUMPRODUCT

SUMPRODUCT is a function that multiplies each cell within range against each other and sums the result together. This function is often...

2 views

Text to Column

Text to column can be used to format or parse text.. Parsing text: Select a column which needs to be parsed. Only one row at a time can...

6 views

Power Query

Power Query allows to connect Excel Workbooks to other documents or other data sources. It also allows for data transformations and use...

3 views

INDEX-MATCH

INDEX MATCH combination is an alternative to VLOOKUP. The advantage of this combination lies in its flexibility to return value in any...

9 views

MIN - MAX - AVERAGE

MIN is a formula that will give a lowest value in a specified range. MAX is a formula that will give a highest value in a specified...

4 views

COUNTIFS

COUNTIFS counts instances of all arguments being met. COUNTIFS has the following arguments: criteria_range: A table range of values which...

10 views

Pivot Table

A pivot table constructs a dynamic table from a data in a given range. All columns must be labeled for a pivot table to work. To create a...

34 views

SUMIFS & SUM

SUMIFS adds value in an array provided all arguments are met. SUMIFS has 3 arguments: sum_range: A table range of values which will be...

32 views

VLOOKUP

VLOOKUP function searches for a value in a first column of the range and returns a corresponding value in a column specified. The...

35 views

Range

In the example above we are selecting two different ranges. Ranges essentially constitute a table within excel. Example: Looking at the...

32 views

bottom of page