Create your own App in Excel
4.2 (15 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.
381 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Create your own App in Excel to your Wishlist.

Add to Wishlist

Create your own App in Excel

Simple, easy step by step approach to creating your own applications using UserForms in Excel
4.2 (15 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.
381 students enrolled
Last updated 4/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • To be able to create an interactive frontend linked to a database with the help of userforms
View Curriculum
Requirements
  • Any versions of Excel from 2003
  • Knowledge of VBA in Excel
Description

UserForms is an advanced and powerful feature in Excel that allows for automation through the creation of Excel macros using VBA (Visual Basic for Applications). Userforms are custom forms that you can create to complement and interact with your worksheet, in some cases your userforms can completely replace interaction with your worksheet.

With userforms you can create custom forms with fields where input values can be selected from a dropdown, or checkboxes, create command buttons etc. Such forms can be created for those who are not comfortable working on an Excel sheet thereby making their interaction with excel to the bare minimum.

In this course, we take you through the various components that can be included in a custom form and most importantly we cover the various steps whereby you can ensure that data entered is always validated.

Needless to say to take this course you need a good working knowledge of Excel and VBA macros. If you would like to brush up your Basic Excel and VBA skills you can take our course on Excel for Beginners to Intermediate and our Excel Automation course.

Who is the target audience?
  • Inidividuals who have a good working knowledge of Excel & VBA
  • Those who would like to create a easy to use front end as an alternative to working on excel worksheets.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
15 Lectures
01:21:38
+
Introduction to Excel Apps using Userforms
2 Lectures 03:19

Introduction to Excel Apps using userforms: Why userforms

In what ways are the userforms being used and in what ways can we use them

Please download supplementary material

Preview 01:30

Introduction to Excel Apps using userforms: Snapshot of the course

This lecture, gives a gist of all the topics covered in the course and intended outcome of the course.

Please download supplementary material

Preview 01:49
+
Step By Step Approach to creating an App in Excel
8 Lectures 51:00

Step by step approach to creating an App in Excel: Creating an Empty userform

In this lecture, we talk about how we insert an empty userform in VBA

Please download supplementary material

Preview 01:11

Step by step approach to creating userforms: Creating Controls

Here we talk about Controls like - Buttons, Text box, checkbox, radio button, dropdown, etc

Preview 07:10

Step by step approach to creating userforms: Connecting Text Box and Combo Box

Directly connecting the text box and combobox to excel and test if the data reaches in Excel on pressing the Submit Button

Connecting Text Box and ComboBox to execute the submission at relevant Events
08:18

Step by step approach to creating userforms: Adding values in the combo box

A combo box when created will be an empty combo box, in this lecture we will see how can we put the values in the combo box

Adding Values in the combo box
05:53

Step by step approach to creating userforms: Connecting Radio buttons to Excel data

Radio buttons are the ones with "Only One" to be selected, so how to structure the conditional statements to read it through Excel.

Connecting Radio buttons to Excel data
04:40

Step by step approach to creating userforms: Connecting check boxes to excel data

Check boxes are the ones where multiple selections can be made, thus we write different conditional statements for each.

Connecting Check Boxes to Excel data
07:31

Step by step approach to creating userforms: Making the excel connection intelligent & dynamic

using variables in place of constants and making the connection more dynamic and usable

Making the Excel Connection Intelligent & Dynamic
09:34

Testing the form
06:43
+
Getting your App to interact with the user
4 Lectures 25:48

Getting your app to interact with the user: why should an app interact with the user

This lecture, explains why is it necessary for us to make the app interactive and how does it saves time an energy at work

Why should an app interact with the user
01:52

Getting you app to interact with the user: Understanding Property windows & events

In this lecture we will handle the properties of various objects that we have used in the previous lectures and modify these properties based on the user entries.

Eg: when a person types an email id that already exists, the box turns red in color. This happens on a 'while writing it' event.

Understanding the Property Window & Events
07:54

Getting your app to interact with users: Creating validations

In this lecture, we explain :

How a validation is Applied through a condition.

When should this be validated

What should be the outcome of validation.

Creating validations
09:12

Getting your app to interact with users: Creating conditional labels

In this lecture we take a similar example of the one that we took in the last lecture. In this case we learn:

How to create a conditionally visible Label.

When should this label interact with the user.

Creating conditional labels on 'while writing' event
06:50
+
Create your own app
1 Lecture 01:31
Project - create your own app
01:31
About the Instructor
ATI - Analytics Training Institute
4.1 Average rating
220 Reviews
8,850 Students
13 Courses
Committed to creating a difference

We are an Analytics firm committed to developing intellectual property that will help individuals and their organisation take smarter decisions every day. ATI, the education arm of Redwood Associates has helped 200 companies and over 15000 individuals speak the language of DATA

The founder Gautam Munshi has nearly two decades of high performance analytics experience. His strong belief that anyone can become an analyst has led him to build a team of 12 - a group of math geeks, techies, musicians, comedians, beer enthusiasts, agriculturists, geneticists, teachers and bankers,who have the gumption that they can make a difference and truly believe that analytics can influence and make a huge impact on a day-day basis. It is this diverse lot that brings Analytics to the mind space of every individual. You can view their moments in the lime light here and follow them on Facebook