Excel VBA courses London – STL

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 select “currency”, then 2 decimal places….I then use the fill handle to copy the format into the remaining column.

format-currency-excel-vba-courses-london — Formatting cells using the Format Cells dialogue box

This works as a process, but I can make this quicker using the currency button in the Home tab. I select the cells, then go to the Home tab, Number section, and select the currency button.

Home-tab-currency-excel-vba-london — Currency button adds the format in one click. Nice.

I achieve the same result but in a quicker way.

For syllabus information on our courses from introduction to Excel VBA Courses London https://www.stl-training.co.uk/excel-vba-2010-training-course.php

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 use one of Excel’s off-the-peg Text formulas by using PROPER.

proper-formula-excel-vba-courses-london — The Proper formula in the Formulas tab.

To apply this, I need to use an empty column (in this case B) to apply the formula to the original names. This is only temporary as I will copy the names back into Column A when it’s all done.

I click on cell B2 to set up my formula. I go to the Formulas tab, and select Text Formulas, and PROPER.

A dialogue box appears, and I can now select the first name in column A.

active-cell-excel-vba-courses-london — selecting the cell contents that need to be changed

When I click ok, the first name is now in the correct case. I can copy this formula by using the autofill handle, to complete the changes to the remaining names.

Autofill-formula-excel-vba-courses-london — Autofilling the formula to the remaining cells

The names have all be corrected and I can copy them from column B back into column A.

Our Excel courses cover all levels from introduction to advanced, including Excel VBA courses london, https://www.stl-training.co.uk/vba-training-london.php.

Blog Categories