Intro to Excel 2013 Macros and Form Controls
1.5 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
12 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Intro to Excel 2013 Macros and Form Controls to your Wishlist.

Add to Wishlist

Intro to Excel 2013 Macros and Form Controls

Do more with Excel Macros and Form controls
1.5 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
12 students enrolled
Created by Bobson St. Pierre
Last updated 9/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Record and run Macros
  • Assign Macros to different Objects in Excel
  • Learn the difference between absolute and relative references in Excel
  • Learn about the nine Form controls
  • Insert Form controls and define their properties
View Curriculum
Requirements
  • You will need Excel 2010 or 2013
Description

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.

Who is the target audience?
  • This course is designed for someone with some experience in Excel who wants to start using Excel Macros and Form controls
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 21 Lectures Collapse All 21 Lectures 01:44:51
+
Overview
1 Lecture 01:30
+
Creating And Modifying Macros
10 Lectures 41:50



The Difference Between Absolute And Relative References
07:59

Macro Security
03:50

Assigning A Keystroke To A Macro
02:49

Running a Macro When You Open a Workbook
04:45

Assigning Macros to Shapes and Objects
02:18

Adding Macros to The Excel Ribbon
03:27

Add Macro Button to the quick access toolbar
01:14
+
Form Controls
7 Lectures 34:42
What are the nine Form controls
03:51

Inserting a Command Button
03:48

Inserting a Combo Box
03:57

Inserting a List Box
03:47

Inserting Check boxes and Option buttons
04:30

Inserting a Scroll Bar
11:16

Inserting a spin button
03:33
+
Putting it all together
3 Lectures 26:49
Creating an order form Part 1
08:35

Creating an order form part 2
08:38

Creating an order form part 3
09:36
About the Instructor
Bobson St. Pierre
1.5 Average rating
2 Reviews
59 Students
3 Courses
Excel VBA Programmer & Certified Microsoft Office Specialist

My name is Bobson St. Pierre I am a Certified Microsoft Office Specialist and have over 14 years of experience in the IT field. I have worked as an Excel VBA programmer, Ms Office Support Specialist, Consultant, and now Trainer. I want to take what I know about Excel and Microsoft Office and share it with you.