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 template

The course plan will be the following:

Introducing you to the typicaldata collection – decision – reporting situation

Understanding andquantifying advantage of UserFormusing a funny competition

Understand“mechanics” of UserForm

Case studyon adding inputs to the UserForm

How to deal withImages in UserForm

Writeinformation from UserForm

Case study to add second UserForm andreuse the code

How to createreports in PowerPointfrom Excel data

Case study to practicesending data to the PowerPointslide

BONUS:

Archiving/Saving to SharePoint Library

Drafting Outlook Emails

Template'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

Who this course is for:
- 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
More Info