Turbocharge Your Spreadsheets with Excel Macros

In this post our VBA for Excel trainer Mark explains how using macros is like turbocharging your car. It also helps eliminate human error!

If Rolls Royce says it’s “Ok to turbo”, then it’s “Ok to turbo”…

…if the Boss says it’s “Ok to Macro”, then it’s “Ok to macro”!

turbocharged-excel-spreadsheets

There was a time (for those of us old enough to remember) when a new word hit the motorcar market: “Turbo”. Some of us know it’s slang for “turbine” referring to the part that forces air into the engine rather than merely allowing air to be sucked into the engine resulting in a serious increase in engine speed and power.

For the boy (and girl) racers, they thought they’d died and gone to heaven, for manufacturers pushing an engine to the limits of it’s endurance sometimes resulted in lots of smoke pouring from under the bonnet, combined with the dashboard lit up like a Christmas tree.

So the upside, more power, MUCH more power, the downside, more to go wrong, and when it did, VERY wrong!

Now, where IS he going with this I hear you ask? Macros. Read the rest of “Turbocharge Your Spreadsheets with Excel Macros”

Time saving tips for Excel

It doesn’t take long for what was a simple spreadsheet to grow and become a monstrous maze of data. These become increasingly difficult to navigate and work with, making the simplest tasks take an unnecessary amount of time.

While it’s no substitute to proper Excel Training, Microsoft included several handy shortcuts and little-used functions that once used become essential for future spreadsheet set up, manipulation and navigation.

Macros

If you find that you are spending most of your time performing the same monotonous spreadsheet tasks, such as copying data from one place to another, you need to look into is setting up your own macros.

Excel Macro 1

Name your Macro and set its shortcut once you have pressed the 'Record Macro' button.

Built using VBA (Visual Basic for Applications), a Microsoft built event-driven programming language; macros allow the user to create a set of instructions which it can complete within the parameters you set. This means that you can set them up to automatically perform tasks such as cell formatting, cell selection, adding or removing rows or columns or even adding a date into your spreadsheet. Read the rest of “Time saving tips for Excel”