Create IF statements with AND/ OR arguments
In the simplest terms, IF statements are logic based formula which tests a condition and returns one value for a true statement and another for a false statement.
How to use INDEX and MATCH
The index and match formula is an advanced lookup which has many advantages over vlookups. It gives users the flexibility to combine horizontal and vertical matches as well as lookup multiple column or row criteria.
Rounding numbers to a specified decimal place or nearest major unit
Sometimes you don’t require numbers to the nth level of detail, especially if you want to avoid Excel’s ###### symbol or having to resize your columns
Return a result from a corresponding column in a table with VLOOKUP
A vlookup is a vertical lookup between two corresponding columns in a data table, where the value returned is based on the first match.
Automatically return the tab name
Just like the header or a company’s letterhead or titles and chapters within a book, there may be instances where you may want a cell within the worksheet to reference the name of the tab. This formula will automatically update with any changes to the tab name.
Sum data based on multiple criteria with SUMIFS
The SUMIFS function is probably one of the most useful functions with Excel that you will ever use. Rather than summing data by a fixed range, the SUMIFS function will allow you to sum values from a column or row based on the criteria in a corresponding column or row.
Return the first or last day of the month with EOMONTH
There are many instances where Excel users may want to return the first or last day of the month from a cell referencing a date. This can include creating additional mapping so that formulas work using one date as a criteria rather than a ranges of dates, and being able to summarise data in a more simple way.
Excel Functions & Formulas
A list of over 100 Excel functions and formulas to help you create better spreadsheets. These functions have been categorised to for ease of use.