Excel Tutorial - Creating Your First Macro

Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis.

In this Excel Tutorial we show an example of how to get started working with Macros.

Macros save us lots of time and are ideal to replace any steps that need to be repeated.

In this macro example you are shown how to record a macro and add a heading and a few rows to a sheet.

We also discuss editing macros and a brief introduction to VBA, whilst recording a macro Excel is recording the steps in VBA (Visual Basic for Applications), once a macro is saved we can then edit the code.

Once saved we can run the new macro.

Please note that for this example we are using Microsoft Excel 2016 so if you are a different version the layout might differ.