Blogs

How to use Excel's XLOOKUP Function

Looks up values from another table

How to use Excel's INDEX Function

Returns a value from a range based on the position specified

Blog Excel Mastery Series

7 min to read

The Excel Navigation Pane

Quickly understand how a workbook is structured.

1 min to read

How to use Excel's MIN Function

Returns the smallest value from a range of numbers

1 min to read

How to use Excel's MAX Function

Returns the largest value from a range of numbers

How to use Excel's EOMONTH function

Returns the last day of the month after adding a specified number of months

How to use Excel's IF Function

Returns one value for a TRUE result, and another for a FALSE result

Blog Excel Mastery Series

Absolute, Relative and Mixed References

Formulae in Excel contain references to other cells or ranges of cells. There are three types of references that can be used: absolute, relative or mixed.

Blog Excel Mastery Series

Excel Functions by Category

Excel functions listed by category.