[UPDATED April 2020]

SHORTSummary:

Check out several examples of Office Automation using Excel UserForm. Apply these ideas in real life situations.

***

This course explains how simple and freeExcel UserForm can be usedto improve work withverybasic and simple excel workbook:

• UserForm provides the advantage to have all relevant information in one place that helps to concentrate on taskand 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. Focusis made on understanding on how VBA code is applied for this particular situation. Learn coding by re-using provided examples infun 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 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 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