Can you enter a formula in cell B2 that will multiply the numbers in column A by the numbers in row 1, creating a multiplication table? This should be one formula copied across the remaining cells. Can you do it? Read here to see how.
UPPER, lower & Proper In Excel
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.