Smart Data Collection With Excel Userform

Save your time, let computer do the job! Data Collection and Reporting solution in Excel

What you'll 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
Save completed file to SharePoint Document Library
Requirements
Curiosity
Be lazy and tired doing boring activities with Microsoft Office
Basic knowledge of VBA is preferred
Basic knowledge of Git version control system
Description
[UPDATED April 2020]SHORT Summary:Check out several examples of Office Automation using Excel UserForm. Apply these ideas in real life situations.***This course explains how 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.UserForm allows customization of data entry to make sure users would collect 'clean' data 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. Learn coding by re-using provided examples in fun case studies.Ready-to-use templates could be used as is e.g. personal goal tracking templateThe course plan will be the following:   Introducing you to the typical data collection – decision – reporting situationUnderstanding and quantifying advantage of UserForm using a funny competitionUnderstand “mechanics” of UserForm   Case study on adding inputs to the UserForm   How to deal with Images in UserForm   Write information from UserFormCase 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 slideBONUS: Archiving/Saving to SharePoint LibraryDrafting Outlook EmailsTemplate 'Set Powerful Goals'In the summary, this relatively short course is providing very simple solution that can be applied for easier data collection, decision making and reporting. In cases where instant online collaboration is not required but we want to be efficient - then this course will very likely be capable to solve the problem

Overview

Section 1: Welcome to the course!

Lecture 1 Introduction to the course

Lecture 2 How to get the most of the course

Section 2: Manipulating UserForm in Excel

Lecture 3 Understand advantage of excel UserForm

Lecture 4 Reflection Activity: Where to apply this course?

Lecture 5 How to Import UserForm

Lecture 6 How User Form Works?

Lecture 7 How to invoke, close User Form. Common Controls

Lecture 8 How to Populate input fields

Lecture 9 Re-using Functions across the Workbook

Lecture 10 Just a bit of "Data Grammar"

Lecture 11 How to Store User Form Data

Lecture 12 Case Study 1: Enhance Given User Form

Lecture 13 Solution to Case Study 1

Section 3: Adding Pictures into Cells - Robust way

Lecture 14 Picture Control of the UserForm

Lecture 15 How to bring picture from file into the UserForm

Lecture 16 Write picture into cell Robust way

Lecture 17 Case Study 2: Add more elements to the UserForm

Lecture 18 Solution to Case Study 2

Section 4: Automate PowerPoint slides generation from UserForm

Lecture 19 Generate PowerPoint from Vector of Data in Excel

Lecture 20 Case Study 3: Add more elements to the PowerPoint Slide

Lecture 21 Solution to Case Study 3

Section 5: Conclusion

Lecture 22 How to use the Template from this course

Lecture 23 What we built in the course?

Lecture 24 Congratulations for completing the course!

Lecture 25 GET YOUR SPECIAL BONUS FOR NEXT COURSE

Section 6: Useful VBA Functions

Lecture 26 Let's use VBA Functions!

Lecture 27 Function to check presence of specific string

Lecture 28 Function to determine a row of specific string

Section 7: Extra: Practical Examples

Lecture 29 Introduction to Practical Examples

Lecture 30 Data Entry to Table

Lecture 31 Saving a copy of completed file to SharePoint Document Library

Lecture 32 Sending emails with UserForm!

Lecture 33 Collecting data using Excel Forms within SharePoint Online

Lecture 34 Date and Time Picker

Section 8: Bonus Section April 2020: My Personal Goal Settings Template

Lecture 35 Idea of the Goal Settings Template

Lecture 36 Using Goal Setting Template: Set Goals

Lecture 37 Using Goal Setting Template: Analyse with Pivot Table

Lecture 38 Goal Setting Template: VBA Code Structure

Lecture 39 Course Project: Create your own UserForm

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 are not important