Latest News & Excel Tips 

Watch, Read & Learn

Latest Excel Tips

Excel XLOOKUP Function

Excel XLOOKUP Function

 Xlookup is the long awaited improvement on Vlookup, Hlookup and Index Match. It also allows for easier formula writing to allow for matches, Errors and Summing multiple array lookups. Below are 5 ways to utilise the Xlookup function and the formulas associated....

Add dates in Excel

Add dates in Excel

There are many different ways to add, subtract or count dates in Excel. Below are 11 of the most commonly used and most straight forward functions for them.Below is the formulas in text format for you to copy and paste into your Worksheet should you need to. If using...

REad

News & Stories

Excel XLOOKUP Function

Excel XLOOKUP Function

 Xlookup is the long awaited improvement on Vlookup, Hlookup and Index Match. It also allows for easier formula writing to allow for matches, Errors and Summing multiple array lookups. Below are 5 ways to utilise the Xlookup function and the formulas associated....

Add dates in Excel

Add dates in Excel

There are many different ways to add, subtract or count dates in Excel. Below are 11 of the most commonly used and most straight forward functions for them.Below is the formulas in text format for you to copy and paste into your Worksheet should you need to. If using...

Let Us Lend a Helping Hand

Call Now Button