Microsoft Excel 2016 - Recording a Macro

Recording a Macro in Microsoft Excel 2016.

This video was created by Optimum - the IT Training Consultancy.

[denniskipkoech]

Thanks a lot mate, for viewers appreciate his demo as being one of the easiest ways to help beginners understand excel macros and then proceed to record even more complex data transformations

[Tiberius_Gracchus]

Thank you for making this! Clear and quick!

[mobr.]

Thank you, this video was very helpful.

[carmenflowers]

Thank you well explained and easy to understand.

[eliotjbaker]

Great video, very relaxing and helpful.

[johnjordan]

Is there a way to record a macro for varying table sizes? Or does this only apply for conforming tables?

[renevanstein]

Great clip. Will use it to create my first Macro

[jielu]

Thank you, much clearer than my instructor

[ad]

amazing. i learned this and totally forgot it as i stopped using it. thank you for the refresher.

[philt]

Hi Mark, A very useful video explaining the use of macros for a beginner, Many Thanks

[shaynevantassel]

but what happens with the amounts? do you just change it manually?

[Rita-mhnz]

i extreamly need help for my assignment, i know how to run macro but to know my macro is run or not how can i review the test how can i check n know it is record..in maxbook air pls

[missf]

im trying to do a vlookup and it wont work....says NA when i press enter...do you know how i could fix this problem?

[madblade]

wouldn't you just need to use the format painter?

[adamcurtis]

Hi can I run the macro on the same sheet. I don't want to change the sheets

[danielrodriguez-florido]

Does it work like that if it has more rows/columns?

[KarlGallardo]

Thank you for the demo. I have one question, can you still apply the macro even if the data is not on the same cell, , row or column? I noticed that the succeeding data in the sheets have the same cell location, columns, and rows. thanks.

[jacobennis]

In this situation, would it serve the same purpose if you formatted the table the way you wanted, and then saved it as a blank template? Then you could enter data for each week and save it from the blank file.

[Pfresh]

Press CTRL+SHIFt and what? what is zed?

[StijnHommes]

Why would you bother with a macro here, when you can copy paste the formatting of an earlier formatted sheet over in half the time?