There are many instances where Excel users may want to...
Read More
DATE & TIME FUNCTIONS.
Use date and time functions to time stamp, organise and/ or filter data.
FINANCIAL FUNCTIONS.
Use financial functions to calculate complex financial modelling, such as Net Present Value (NPV) or Internal Rate of Return (IRR).
No posts found!
LOGICAL FUNCTIONS.
Use logical functions to create arguments to return results based on a set of criteria.
Create IF statements with AND/ OR arguments
In the simplest terms, IF statements are logic based formula...
Read MoreLOOKUP & REFERENCE FUNCTIONS.
Use lookup and reference functions to return a value from a data table.
How to use INDEX and MATCH
The index and match formula is an advanced lookup which...
Read More
Return a result from a corresponding column in a table with VLOOKUP
A vlookup is a vertical lookup between two corresponding columns...
Read MoreMATHEMATICAL FUNCTIONS.
Use mathematical functions to summarise data or solve numerical problems.
Rounding numbers to a specified decimal place or nearest major unit
Sometimes you don't require numbers to the nth level of...
Read More
Sum data based on multiple criteria with SUMIFS
The SUMIFS function is probably one of the most useful...
Read MoreTEXT FUNCTIONS.
Use text functions to extract, build or validate non-numerical values.
Automatically return the tab name
Just like the header or a company's letterhead or titles...
Read More