In this video we are going to see how to enable developer tab and understand file extensions. This is the very basics of VBA you should be aware if you want to master Excel VBA Macros.

Learn how to record macros in excel. If you are new to VBA or coding then recording macros is the best way to learn VBA.

Learn more on recording macros. Now that we have seen how to format using recording now we see how we generate a list of text and get that list when required on a click.

Know the difference between absolute and relative reference in VBA Macros. Using this most of the recording can be made dynamic and a lot of stuff can be automated.

We are now ready to check the VBA environment and write our own code. So lets take it easy and start with the basics of vba coding. Here we are going to write our first macro and see how we execute it.

Lets see how to write a basic code to format a cell. Learn how to bold, italic, underline, change background color, font color and size with vba. This is very useful when you would like to create a particular style with too many formatting.

Lets now see how to write a code to get a list of text. With this we learn how to write a dynamic code using relative reference and get a list.

Lets explore further usage of Activecell and offset. Using offset not only you can move vertically down but any which ways like horizontally left or right, vertically up or down or diagonally or may be randomly to other text. This piece will help you a lot to automate major excel tasks.

Using "With" in VBA brings a lot of structure and simplification to your code. It makes the code more readable and easy to read as well as write the code.

Also in VBA you don't have to select a cell before putting a value there. Lets see how we do that as well.

Lets see more examples of how to use Activecell, Offset and With to write values diagonally, vertically up, horizontally down and so on...

Lets see how we move the cursor to a particular cell. Lets also see how to select multiple cells and put values into it with VBA.

So we are now good with selecting a cell. Lets see how to select a row, column or for that matter an entire sheet.