Excel Tutorials Archives

Excel XLOOKUP Function

by Andrew Kavanagh | Dec 23, 2020 | Excel Tutorials

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

by Andrew Kavanagh | Dec 7, 2020 | Excel Tutorials

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

by Andrew Kavanagh | Dec 3, 2020 | Excel Tutorials

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...

How To Unprotect Multiple Worksheets At Once with Password In Excel using VBA

by Andrew Kavanagh | Dec 2, 2020 | Excel Tutorials

The following will help you Unprotect 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...

How To Insert Sheet/tab Names In a Cell In Excel

by Andrew Kavanagh | Dec 1, 2020 | Excel Tutorials

Here is an easy way to insert the current worksheet’s name into a cell Insert the following formula into any cell and press enter =MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1))+1,255) In the below we have called the...

How to Add a Drop Down list using a Named Range in Excel

by Andrew Kavanagh | Nov 30, 2020 | Excel Tutorials

Previously we looked at making a simple dropdown list but this can be somewhat limited and time consuming if you need to add more options to choose from for any category. Here we will show you the benefits of using Name Ranges or Dynamic drop downs. Here we have our...