Excel VBA courses London Resources

When I add financial data to my worksheets, I generally type in the content and format the cells afterwards – here are two ways to format cells with currency. I select my active cells, then I then click on all the cells, right click on format cells, and then go through the dialogue box to […]

It can be a pain when you have a list of names that are all in lower case, and you want to be able to change them to the right case.  This can be easily completed using a formula to make the changes. To change this list of names to the proper case, I can […]