This week’s blog post looks at 3 text-related formula : UPPER, LOWER & PROPER. Click Here To Read More…
How To Add Macros To Custom Toolbar
This week’s blog post looks at how to add macros to the custom toolbar in Excel, or indeed other MS Office apps too. Click here to read more…
A Quicker Way To Create VLookUps Across Multiple Columns
Click here to read the full post. Have you ever had to create several VLookUps across multiple columns and found it to be a slow (sometimes confusing process)? Here I show you how to create one VLookUp and then slightly change the formula so you can then copy it and apply to more than one column.
Excel VBA Macros
This is a link to our Excel VBA Macros page, which includes a demo video based on an example of a macro created which reduced a task from 1.5 hours per week to a few minutes.