Save Your time with Excel UserForm - Collecting Data
0.0 (0 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.
4 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Save Your time with Excel UserForm - Collecting Data to your Wishlist.

Add to Wishlist

Save Your time with Excel UserForm - Collecting Data

Save your time, let computer do the job! Get Easy Data Collection and Reporting solution in Excel
0.0 (0 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.
4 students enrolled
Created by Vladimir Zhbanko
Last updated 8/2017
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 5 Articles
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Re-use the code and templates to speed up work in Excel and PowerPoint
  • Insert images to excel cells
  • Know how to collect "clean" data
  • Create PowerPoint slides from Excel data
  • Design and manipulate Excel User Form
View Curriculum
Requirements
  • Curiosity
  • Be lazy and tired doing boring activities with Microsoft Office
  • Basic knowledge of VBA is preferred
Description

SHORT Summary:

You got it right! I am not teaching you Excel or VBA, I will try to Save Your Time by using Excel and VBA. Get the example with explanations and try to apply the course idea to your situations!

***

This course explains how very simple and free Excel UserForm can be used to improve work with very basic and simple excel workbook.

UserForm provides the advantage to have all relevant information in one place that helps to concentrate on task and be productive when dealing with information. 

Course is not focused to teach basics of the VBA coding by doing abstract coding exercises. Focus is made on understanding on how VBA code is applied for this particular situation. You will learn coding by re-using provided examples in fun case studies.

The course plan will be the following:

  • Introducing you to the typical data collection – decision – reporting situation
  • Understanding and quantifying advantage of UserForm using a funny competition
  • Understand “mechanics” of UserForm
  • Case study on adding inputs to the UserForm
  • How to deal with Images in UserForm
  • Write information from UserForm
  • Case study to add second UserForm and reuse the code
  • How to create reports in PowerPoint from Excel data
  • Case study to practice sending data to the PowerPoint slide
  • BONUS: Share and Get ideas. Special chapter where I will post other best ideas on UserForm usage from YOU!

At the end of the course you should be able to reuse given template to the data collection and reporting situation YOU have. You will be also able to pick other pieces of code to be more productive when dealing with Office Documents

In *summary*, this relatively short course is providing you very simple solution that can be applied for easier data collection, decision making and reporting. In case you don't require instant online collaboration, usage of Apps and complex infrastructure but still you desire to be efficient - then this is a course for you

Who is the target audience?
  • Anyone who want to Save Time when working with Microsoft Office documents
  • Anyone dealing with simple data process based on Microsoft Excel and other Office documents
  • You perform monotonous tasks and need some automation but without Cloud infrastructure
  • You want to make things simple using good-old-excel and on-line collaboration or Apps is not important for you
Students Who Viewed This Course Also Viewed
Curriculum For This Course
27 Lectures
01:30:12
+
Welcome to the course!
2 Lectures 07:09

This is the introduction video explaining that many processes we do are about to collect, analyse and decide based on information. Excel UserForm Course provides templates and guidance on how you can save your time while using basic Office Documents

Preview 03:18

Take this lecture to know the plan of the course and few other suggestions on how to get the most benefit out of the course!

Preview 03:51
+
Manipulating UserForm in Excel
11 Lectures 46:54

This lecture clearly demonstrate and quantify benefits of automating work with Office Documents with User Form. User Form helps to be more efficient, in particular, it helps to keep all information to one place and be concentrated on the task. A fun demonstration is performed using simple excel and same file but with addition of User Form. Results were showing that we are faster 2x with User Form to achieve the same amount of work

Preview 06:14

With this exercise you should be able to identify where it is better to apply the course know how while spending the right amount of time and achieving the maximum benefit

Reflection Activity: How can you apply this course
00:25

In this lecture we will learn how to import and reuse the UserForm and other provided code. This will also help you to know how to reuse your projects into the new activities

How to Import UserForm
07:33

This lecture explains how the template work and how exactly we facilitate and streamline work with data to take decision and reporting.

Preview 04:02

This lecture explains how to open, close and manipulate fields in the UserForm. You will learn how to keep track of the Worksheet row and keep it as a variable in the VBA code. You will also learn how to close the User Form with a button and how to use basic properties of the User Form

How to invoke, close User Form. Common Controls
05:25

This Lecture explains how do we use dedicated program to update fields that are inside User Form.

How to Populate input fields
03:53

In this lecture you will learn how to find functions and actually see how they work. Functions are important in coding as they are allowing to make the code compact and understandable. Simple tip: name the function with Verb because they are doing something! 

Re-using Functions across the Workbook
04:07

Simple recommendation to keep observations in rows and categories in columns

Just a bit of "Data Grammar"
00:25

In this lecture we are understanding how do we send data from UserForm fields into the Worksheet Report page.

How to Store User Form Data
06:08

In this case study you can practice and try to enhance given functionality by yourself. In particular you will master:

  • Adding new fields and bringing information there
  • Set User Form Fields properties programmatically and adding logic to data entry
  • Reset values after the data sending

Comment: research in google is allowed (e.g. "excel vba how to reset values in userform" ...:)

Case Study 1: Enhance Given User Form
03:31

Hopefully you have completed this Case Study yourself. Let's compare our solutions!

Solution to Case Study 1
05:10

Understand Mechanics of User Form

Understand Mechanics of User Form
3 questions
+
Adding Pictures into Cells - Robust way
5 Lectures 17:16

In this lecture I will uncover you the secret on why I started to work with User Form in the first place! Visual communication is very important however it's also important not to spend so much time with it!

This lecture just tackle the process of adding and modifying properties of Image Control of the User Form 

Picture Control of the UserForm
01:57

This lecture describes how to select picture from the computer or network location and to bring this picture to the User Form Image Control. You will also learn how to save image path to the variable because you will need to reuse it later

How to bring picture from file into the UserForm
02:31

This lecture will finalize base line explanation on how to use images in the User Form. You will see how you can write picture to the destination worksheet with pixel-like precision. We will use a trick that help us to keep picture as a shape inside the cell.

Write picture into cell Robust way
04:18

We will continue fun scenario of IT expert helping others to save time and be more productive. As we are heading to the end of the course your tasks will be oriented on re-using the code and creating new functionalities of template. This way you will practice to be more prepared to apply this course for your personal benefit

Case Study 2: Add more elements to the UserForm
02:33

In this lecture we will review how to solve the case study and also review which concepts we practiced. Download the file with solution using provided link so you can better follow the explanations of this lecture

Solution to Case Study 2
05:57

Check how you understood process of handling pictures with UserForm

Handle images with UserForm
3 questions
+
Automate PowerPoint slides generation from UserForm
3 Lectures 09:45

Excel is made for calculations, Word for writing texts and reports, PowerPoint for presentations... By connecting documents you can save a lot of time and be super productive! Probably this concept deserve the special course by itself but in this lecture we will just review how to automate creation of the PowerPoint presentation from the data that we nicely keep in Excel table

Generate PowerPoint from Vector of Data in Excel
04:09

In this Case Study you will improve our template even further. You will add more fields to the slide, customize them and apply PowerPoint template ... 

Case Study 3: Add more elements to the PowerPoint Slide
01:14

In this lecture we will review how to solve the case study and also review which concepts we practiced. Download the file with solution using provided link so you can better follow the explanations of this lecture

Solution to Case Study 3
04:22

One more quiz about PowerPoint slides generation

Automate PowerPoint slides generation from UserForm
3 questions
+
Conclusion
4 Lectures 09:03

In this lecture I would share with you my personal recommendation on how to use provided template for your activities to improve working with Office documents. These will consist in 3 parts

  1. Keep your code ready!
  2. Apply code and expand template
  3. Know the boundaries and limitations, explore the alternative solutions
How to use the Template from this course
03:53

This lecture explains what we have built in the course. The summary of all functionality achieved.

Preview 03:57

Just a final note

Congratulations for completing the course!
00:55

GET YOUR SPECIAL BONUS FOR NEXT COURSE
00:18
+
Extra: Practical Examples
2 Lectures 00:15

Coming soon!

Introduction to Practical Examples
00:14

Expanding our great Template by adding one more button... now we can also draft and send email from the UserForm

Sending emails with UserForm!
00:00
About the Instructor
Vladimir Zhbanko
5.0 Average rating
1 Review
7 Students
2 Courses
Senior Engineering Specialist and Entrepreneur

Hello, I am really excited that you read my little story here!

I am a Chemical Engineer by education, Problem Solver by nature and now trying to be an Entrepreneur. I currently work in Swiss Multinational Company as Senior Engineering Specialist in R&D where I strive to be in line with modern technology, Industry 4.0 not only by learning it but also applying it to gain value. Being Certified Green Belt in Lean Six Sigma I always try to reduce inefficiencies by finding complex patterns or applying new methods to close gaps.

Over years I was living in 3 countries and for that I can fluently speak 4 languages [EN, IT, ES, RU] and partially other 2 [DE, FR]. Apart of that I am a happy user of other 4 computer programming languages [R, C++(MQL4), VBA] and also a bit of [SQL].

I would like to bring to you some ideas on how one can be more productive. How to collect data in a smarter way using simple tools? How to make it easier to take a decision? And … why not to automate the decision using Artificial Intelligence? I will try to cover very practical side of technology, show you how you can benefit from it with concrete examples.

By the way, life is not only technology - I like cooking as well!!!

p.s. I will try my best to provide to you the best possible learning experience. If it would not be the case I would be very happy to receive any constructive feedback on how can I be better.