Udemy

Create your own App in Excel

Enroll Now
  • 502 Students
  • Updated 4/2016
  • Certificate Available
4.2
(34 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 21 Minute(s)
Language
English
Taught by
ATI - Analytics Training Institute
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.2
(34 Ratings)

Course Overview

Create your own App in Excel

Simple, easy step by step approach to creating your own applications using UserForms in Excel

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.

Course Content

  • 4 section(s)
  • 15 lecture(s)
  • Section 1 Introduction to Excel Apps using Userforms
  • Section 2 Step By Step Approach to creating an App in Excel
  • Section 3 Getting your App to interact with the user
  • Section 4 Create your own app

What You’ll Learn

  • To be able to create an interactive frontend linked to a database with the help of userforms


Reviews

  • F
    Fernando Parmesar
    5.0

    I'm not a quick learner , so the pace the teacher walks trough the material is just right for me. Secondly the examples the teacher uses make it easy to follow and understand the concept.

  • A
    Akanksha Chaudhary
    5.0

    It is a good match till now.

  • P
    Philipp Lukevic
    1.0

    The entire contents of this course can be accessed for free as well as in a much more comprehensive form on YouTube.

  • S
    Sukhdev Dhaliwal
    3.5

    It was much better if couple of projects had been included. it was too basic but search showed it as advanced level.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed