Latest News & Excel Tips
Watch, Read & Learn
Latest Excel Tips
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
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...
How To Protect Multiple Worksheets At Once with Password In Excel using VBA
The following will help you Protect an entire workbook in one go using VBA. It is best if you know how to use or run VBA code to use this. If you don't know how to use VBA code feel free to contact us. Hold down the ALT + F11 keys, and it opens the Microsoft Visual...
REad
News & Stories
Euro 2021 Sweepkit
For those doing Office Sweeps for the European Championships here is a handy workbook that will help you pick the winner. Feel free to share with Friends/Colleagues. Click on the link below. Good luck. Excel Support Euro Sweepkit 2021
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
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...