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