Intro to Excel 2013 Macros & Form Controls | 310 MB
This course is an introduction to Excel Macros & Form controls. The course is designed for those with some experience using Excel & now wants to start using Macros & form controls in in their spreadsheets. The course has three main parts, first part is all about working with & running macros, in this part you will learn how to record Macros work with & run Macros. You will learn the difference between absolute & relative references when recording your Macros & 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 & how to define their properties to collect & work with data. The last part is us using what we have learned to create an order form application using excel formulas, form controls & macros.
What are the requirements?
You will need Excel 2010 or 2013
What am I going to get from this course?
Over 21 lectures & 1.5 hours of content!
Record & run Macros
Assign Macros to different Objects in Excel
Learn the difference between absolute & relative references in Excel
Learn about the nine Form controls
Insert Form controls & define their properties
What is the target audience?
This course is designed for someone with some experience in Excel who wants to start using Excel Macros & Form controls