Excel Training – Page 51 – 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

A common theme for me in Excel training is the comment “I didn’t know Excel could do that” – and training is a good way of finding out what Excel can do (beyond what we are currently using in our work environments).

Excel VBA has been a bit of a mystery to me, and without knowing what it is, why should I add that to the list of Excel skills I want to acquire? Here is a really basic guide to Excel VBA.

What does VBA stand for?
VBA stands for Visual Basic for Applications.

What is Excel VBA for?
VBA is a language used for programming tasks and actions in Excel or developing additional functions in Excel worksheets that are customised to your work needs.

VBA is great for automating actions – saving time by performing programmed actions time and time again. So you don’t have to set things up from scratch each time.

For example, if you are at an intermediate level, you can use macros without opting for the use of VBA. However, understanding and using VBA gives you more flexibility to set up Excel to act on commands that may be too complex to be recorded in a macro. In this situation, VBA is suited to more advanced users of Excel.

Uses for VBA in the work environment
For those users who can apply VBA, it can make life easier for us who are still developing our skills.

Automating procedures – for example, a monthly summary report can be set up using VBA – so you can press a button and the report is generated (conducting all the different actions so you don’t have to).

Speeding up work by using VBA macro to automate repetitive actions – if you find yourself completing the same action over a number of Excel workbooks, consider that VBA could save you lots of time, by automating the action.

Customise Excel so that anyone in the organisation can use it. If, like me, you aren’t using VBA yet, it is a breath of fresh air if someone can sets up commands and functions so I can just get on with my work. So no matter whether the staff member is using Excel everyday, or infrequently, VBA is key to speeding up work and cutting out inaccuracies for everyone in the organisation.

For more information on our range of Excel VBA Training, please see VBA Training London.

Blog Categories