How to Record a Macro in Excel

[@deenahockey7097]

It's a treasury for beginners 😊 Thank you 😊✌

[@GoSkillsCourses]

It is! Happy to hear you've found it useful! 😁

[@jeffconway8729]

Thanks, clear and to the point!

[@GoSkillsCourses]

Our pleasure!

[@bryan-leeedwards7571]

Great video. I noticed your formula extends to a limited range, if you have a dataset with more rows how can you ensure the macro will pick up those extra rows?

[@GoSkillsCourses]

Hello Bryan-Lee, if the dataset is an Excel-defined table, it will automatically expand as values as added, so the macro will take pick up those additional rows and your macro will run to include the new rows. This is the simplest solution and the one we would recommend for beginners to Excel macros. Our free lesson on Excel tables is here>> kzbin.info/www/bejne/qF7OgqevgNZpd5Y Otherwise, you'd have to go into the VBA script and edit the code used to write the macro

[@williamlindsay4296]

Very nice job, very clear and easy to understand. Thnks

[@GoSkillsCourses]

Glad it was helpful!

[@LotfiGARZOUN]

Nice tutorial In order to calculate Variance, I prefer using this simple formula = B3 / C3 - 1 What do you think 🤔

[@technocrat3548]

Thank you dear. Keep it up.

[@GoSkillsCourses]

You're most welcome 😊