Smart Data Collection with Excel UserForm

Course details

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