02_004 The Difference Between Absolute And Relative References

Intro to Excel 2013 Macros and Form Controls

This course is an introduction to Excel Macros and Form controls. The course is designed for those with some experience using Excel and now want to start using Macros and form controls in their spreadsheets. The course has three main parts, first part is all about working with and running macros, in this part you will learn how to record Macros work with and run Macros. You will learn the difference between absolute and relative references when recording your Macros and many other things you can do with Macros. The second part has to do with excel Form controls, you will learn the nine Form controls you can insert into your spreadsheets and how to define their properties to collect and work with data. The last part is us using what we have learned to create an order form application using excel formulas, form controls and macros.