Smart Data Collection with Excel UserForm

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course 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 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:

    • 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

Expected Outcomes

  1. 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 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: 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 Show more Show less Course content 8 sections • 39 lectures • 1h 56m total length Expand all sections Welcome to the course! 2 lectures • 7min Introduction to the course Preview 03:18 How to get the most of the course Preview 03:51 Manipulating UserForm in Excel 11 lectures • 47min Understand advantage of excel UserForm Preview 06:14 Reflection Activity: Where to apply this course? 00:17 How to Import UserForm 07:33 How User Form Works? Preview 04:02 How to invoke, close User Form. Common Controls 05:25 How to Populate input fields 03:53 Re-using Functions across the Workbook 04:07 Just a bit of "Data Grammar" 00:24 How to Store User Form Data 06:08 Case Study 1: Enhance Given User Form 03:31 Solution to Case Study 1 05:10 Understand Mechanics of User Form 3 questions Adding Pictures into Cells - Robust way 5 lectures • 17min Picture Control of the UserForm 01:57 How to bring picture from file into the UserForm 02:31 Write picture into cell Robust way 04:18 Case Study 2: Add more elements to the UserForm 02:33 Solution to Case Study 2 05:57 Handle images with UserForm 3 questions Automate PowerPoint slides generation from UserForm 3 lectures • 10min Generate PowerPoint from Vector of Data in Excel 04:09 Case Study 3: Add more elements to the PowerPoint Slide 01:14 Solution to Case Study 3 04:22 Automate PowerPoint slides generation from UserForm 3 questions Conclusion 4 lectures • 9min How to use the Template from this course 03:53 What we built in the course? Preview 03:57 Congratulations for completing the course! 00:55 GET YOUR SPECIAL BONUS FOR NEXT COURSE 00:18 Useful VBA Functions 3 lectures • 2min Let's use VBA Functions! 00:01 Function to check presence of specific string 00:52 Function to determine a row of specific string 00:47 Extra: Practical Examples 6 lectures • 4min Introduction to Practical Examples 00:14 Data Entry to Table 00:19 Saving a copy of completed file to SharePoint Document Library 01:21 Sending emails with UserForm! 00:28 Collecting data using Excel Forms within SharePoint Online 01:21 Date and Time Picker 00:23 Bonus Section April 2020: My Personal Goal Settings Template 5 lectures • 21min Idea of the Goal Settings Template 01:21 Using Goal Setting Template: Set Goals Preview 08:53 Using Goal Setting Template: Analyse with Pivot Table 06:54 Goal Setting Template: VBA Code Structure 03:58 Course Project: Create your own UserForm 00:03 Instructor Vladimir Zhbanko Senior Engineering Specialist and Instructor 4.2 Instructor Rating 262 Reviews 10,153 Students 13 Courses Hello, I am really excited that you read my little story here! I am a Chemical Engineer by education, Problem Solver by nature and Instructor by hobby. I currently work in Swiss Multinational Company as Senior Engineering Specialist in R&D. I like to learn and apply modern technology 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 5 languages [EN, RU, IT, ES, DE] and a bit of [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 and Python]. I would like to bring 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 how to benefit from it with concrete examples. By the way, life is not only technology - I like movies, cooking, chess, ice hockey, you name it! p.s. I will try my best to provide 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d1f7be4e0686',m:'ac67f4a979083d6380c06e4ac438bd7ee3bf213a-1627849784-1800-ATO1KHp1U1MznD93ZuTX8oa8DD3WTPBg56ZfJU5q/gJ7VcrSrDPgjsSKOBogbNnYcfYxfSFhlae7+/muAYJjaRpNPUyD7kk0jxJA/m2/qmvA/2wrPPDjLem5QI/NOfVNjX2exCRAO6c2ScyxhHU+99uFRbJUQAyHbfzaW3OVqyRf',s:[0x5bb14de3d6,0xfbf725b311],}})();
  2. 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 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: 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 Show more Show less Course content 8 sections • 39 lectures • 1h 56m total length Expand all sections Welcome to the course! 2 lectures • 7min Introduction to the course Preview 03:18 How to get the most of the course Preview 03:51 Manipulating UserForm in Excel 11 lectures • 47min Understand advantage of excel UserForm Preview 06:14 Reflection Activity: Where to apply this course? 00:17 How to Import UserForm 07:33 How User Form Works? Preview 04:02 How to invoke, close User Form. Common Controls 05:25 How to Populate input fields 03:53 Re-using Functions across the Workbook 04:07 Just a bit of "Data Grammar" 00:24 How to Store User Form Data 06:08 Case Study 1: Enhance Given User Form 03:31 Solution to Case Study 1 05:10 Understand Mechanics of User Form 3 questions Adding Pictures into Cells - Robust way 5 lectures • 17min Picture Control of the UserForm 01:57 How to bring picture from file into the UserForm 02:31 Write picture into cell Robust way 04:18 Case Study 2: Add more elements to the UserForm 02:33 Solution to Case Study 2 05:57 Handle images with UserForm 3 questions Automate PowerPoint slides generation from UserForm 3 lectures • 10min Generate PowerPoint from Vector of Data in Excel 04:09 Case Study 3: Add more elements to the PowerPoint Slide 01:14 Solution to Case Study 3 04:22 Automate PowerPoint slides generation from UserForm 3 questions Conclusion 4 lectures • 9min How to use the Template from this course 03:53 What we built in the course? Preview 03:57 Congratulations for completing the course! 00:55 GET YOUR SPECIAL BONUS FOR NEXT COURSE 00:18 Useful VBA Functions 3 lectures • 2min Let's use VBA Functions! 00:01 Function to check presence of specific string 00:52 Function to determine a row of specific string 00:47 Extra: Practical Examples 6 lectures • 4min Introduction to Practical Examples 00:14 Data Entry to Table 00:19 Saving a copy of completed file to SharePoint Document Library 01:21 Sending emails with UserForm! 00:28 Collecting data using Excel Forms within SharePoint Online 01:21 Date and Time Picker 00:23 Bonus Section April 2020: My Personal Goal Settings Template 5 lectures • 21min Idea of the Goal Settings Template 01:21 Using Goal Setting Template: Set Goals Preview 08:53 Using Goal Setting Template: Analyse with Pivot Table 06:54 Goal Setting Template: VBA Code Structure 03:58 Course Project: Create your own UserForm 00:03 Instructor Vladimir Zhbanko Senior Engineering Specialist and Instructor 4.2 Instructor Rating 262 Reviews 10,153 Students 13 Courses Hello, I am really excited that you read my little story here! I am a Chemical Engineer by education, Problem Solver by nature and Instructor by hobby. I currently work in Swiss Multinational Company as Senior Engineering Specialist in R&D. I like to learn and apply modern technology 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 5 languages [EN, RU, IT, ES, DE] and a bit of [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 and Python]. I would like to bring 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 how to benefit from it with concrete examples. By the way, life is not only technology - I like movies, cooking, chess, ice hockey, you name it! p.s. I will try my best to provide 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d1f7be4e0686',m:'ac67f4a979083d6380c06e4ac438bd7ee3bf213a-1627849784-1800-ATO1KHp1U1MznD93ZuTX8oa8DD3WTPBg56ZfJU5q/gJ7VcrSrDPgjsSKOBogbNnYcfYxfSFhlae7+/muAYJjaRpNPUyD7kk0jxJA/m2/qmvA/2wrPPDjLem5QI/NOfVNjX2exCRAO6c2ScyxhHU+99uFRbJUQAyHbfzaW3OVqyRf',s:[0x5bb14de3d6,0xfbf725b311],}})();
  3. 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 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: 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 Show more Show less Course content 8 sections • 39 lectures • 1h 56m total length Expand all sections Welcome to the course! 2 lectures • 7min Introduction to the course Preview 03:18 How to get the most of the course Preview 03:51 Manipulating UserForm in Excel 11 lectures • 47min Understand advantage of excel UserForm Preview 06:14 Reflection Activity: Where to apply this course? 00:17 How to Import UserForm 07:33 How User Form Works? Preview 04:02 How to invoke, close User Form. Common Controls 05:25 How to Populate input fields 03:53 Re-using Functions across the Workbook 04:07 Just a bit of "Data Grammar" 00:24 How to Store User Form Data 06:08 Case Study 1: Enhance Given User Form 03:31 Solution to Case Study 1 05:10 Understand Mechanics of User Form 3 questions Adding Pictures into Cells - Robust way 5 lectures • 17min Picture Control of the UserForm 01:57 How to bring picture from file into the UserForm 02:31 Write picture into cell Robust way 04:18 Case Study 2: Add more elements to the UserForm 02:33 Solution to Case Study 2 05:57 Handle images with UserForm 3 questions Automate PowerPoint slides generation from UserForm 3 lectures • 10min Generate PowerPoint from Vector of Data in Excel 04:09 Case Study 3: Add more elements to the PowerPoint Slide 01:14 Solution to Case Study 3 04:22 Automate PowerPoint slides generation from UserForm 3 questions Conclusion 4 lectures • 9min How to use the Template from this course 03:53 What we built in the course? Preview 03:57 Congratulations for completing the course! 00:55 GET YOUR SPECIAL BONUS FOR NEXT COURSE 00:18 Useful VBA Functions 3 lectures • 2min Let's use VBA Functions! 00:01 Function to check presence of specific string 00:52 Function to determine a row of specific string 00:47 Extra: Practical Examples 6 lectures • 4min Introduction to Practical Examples 00:14 Data Entry to Table 00:19 Saving a copy of completed file to SharePoint Document Library 01:21 Sending emails with UserForm! 00:28 Collecting data using Excel Forms within SharePoint Online 01:21 Date and Time Picker 00:23 Bonus Section April 2020: My Personal Goal Settings Template 5 lectures • 21min Idea of the Goal Settings Template 01:21 Using Goal Setting Template: Set Goals Preview 08:53 Using Goal Setting Template: Analyse with Pivot Table 06:54 Goal Setting Template: VBA Code Structure 03:58 Course Project: Create your own UserForm 00:03 Instructor Vladimir Zhbanko Senior Engineering Specialist and Instructor 4.2 Instructor Rating 262 Reviews 10,153 Students 13 Courses Hello, I am really excited that you read my little story here! I am a Chemical Engineer by education, Problem Solver by nature and Instructor by hobby. I currently work in Swiss Multinational Company as Senior Engineering Specialist in R&D. I like to learn and apply modern technology 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 5 languages [EN, RU, IT, ES, DE] and a bit of [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 and Python]. I would like to bring 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 how to benefit from it with concrete examples. By the way, life is not only technology - I like movies, cooking, chess, ice hockey, you name it! p.s. I will try my best to provide 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d1f7be4e0686',m:'ac67f4a979083d6380c06e4ac438bd7ee3bf213a-1627849784-1800-ATO1KHp1U1MznD93ZuTX8oa8DD3WTPBg56ZfJU5q/gJ7VcrSrDPgjsSKOBogbNnYcfYxfSFhlae7+/muAYJjaRpNPUyD7kk0jxJA/m2/qmvA/2wrPPDjLem5QI/NOfVNjX2exCRAO6c2ScyxhHU+99uFRbJUQAyHbfzaW3OVqyRf',s:[0x5bb14de3d6,0xfbf725b311],}})();
  4. 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 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: 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 Show more Show less Course content 8 sections • 39 lectures • 1h 56m total length Expand all sections Welcome to the course! 2 lectures • 7min Introduction to the course Preview 03:18 How to get the most of the course Preview 03:51 Manipulating UserForm in Excel 11 lectures • 47min Understand advantage of excel UserForm Preview 06:14 Reflection Activity: Where to apply this course? 00:17 How to Import UserForm 07:33 How User Form Works? Preview 04:02 How to invoke, close User Form. Common Controls 05:25 How to Populate input fields 03:53 Re-using Functions across the Workbook 04:07 Just a bit of "Data Grammar" 00:24 How to Store User Form Data 06:08 Case Study 1: Enhance Given User Form 03:31 Solution to Case Study 1 05:10 Understand Mechanics of User Form 3 questions Adding Pictures into Cells - Robust way 5 lectures • 17min Picture Control of the UserForm 01:57 How to bring picture from file into the UserForm 02:31 Write picture into cell Robust way 04:18 Case Study 2: Add more elements to the UserForm 02:33 Solution to Case Study 2 05:57 Handle images with UserForm 3 questions Automate PowerPoint slides generation from UserForm 3 lectures • 10min Generate PowerPoint from Vector of Data in Excel 04:09 Case Study 3: Add more elements to the PowerPoint Slide 01:14 Solution to Case Study 3 04:22 Automate PowerPoint slides generation from UserForm 3 questions Conclusion 4 lectures • 9min How to use the Template from this course 03:53 What we built in the course? Preview 03:57 Congratulations for completing the course! 00:55 GET YOUR SPECIAL BONUS FOR NEXT COURSE 00:18 Useful VBA Functions 3 lectures • 2min Let's use VBA Functions! 00:01 Function to check presence of specific string 00:52 Function to determine a row of specific string 00:47 Extra: Practical Examples 6 lectures • 4min Introduction to Practical Examples 00:14 Data Entry to Table 00:19 Saving a copy of completed file to SharePoint Document Library 01:21 Sending emails with UserForm! 00:28 Collecting data using Excel Forms within SharePoint Online 01:21 Date and Time Picker 00:23 Bonus Section April 2020: My Personal Goal Settings Template 5 lectures • 21min Idea of the Goal Settings Template 01:21 Using Goal Setting Template: Set Goals Preview 08:53 Using Goal Setting Template: Analyse with Pivot Table 06:54 Goal Setting Template: VBA Code Structure 03:58 Course Project: Create your own UserForm 00:03 Instructor Vladimir Zhbanko Senior Engineering Specialist and Instructor 4.2 Instructor Rating 262 Reviews 10,153 Students 13 Courses Hello, I am really excited that you read my little story here! I am a Chemical Engineer by education, Problem Solver by nature and Instructor by hobby. I currently work in Swiss Multinational Company as Senior Engineering Specialist in R&D. I like to learn and apply modern technology 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 5 languages [EN, RU, IT, ES, DE] and a bit of [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 and Python]. I would like to bring 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 how to benefit from it with concrete examples. By the way, life is not only technology - I like movies, cooking, chess, ice hockey, you name it! p.s. I will try my best to provide 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d1f7be4e0686',m:'ac67f4a979083d6380c06e4ac438bd7ee3bf213a-1627849784-1800-ATO1KHp1U1MznD93ZuTX8oa8DD3WTPBg56ZfJU5q/gJ7VcrSrDPgjsSKOBogbNnYcfYxfSFhlae7+/muAYJjaRpNPUyD7kk0jxJA/m2/qmvA/2wrPPDjLem5QI/NOfVNjX2exCRAO6c2ScyxhHU+99uFRbJUQAyHbfzaW3OVqyRf',s:[0x5bb14de3d6,0xfbf725b311],}})();
  5. 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 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: 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 Show more Show less Course content 8 sections • 39 lectures • 1h 56m total length Expand all sections Welcome to the course! 2 lectures • 7min Introduction to the course Preview 03:18 How to get the most of the course Preview 03:51 Manipulating UserForm in Excel 11 lectures • 47min Understand advantage of excel UserForm Preview 06:14 Reflection Activity: Where to apply this course? 00:17 How to Import UserForm 07:33 How User Form Works? Preview 04:02 How to invoke, close User Form. Common Controls 05:25 How to Populate input fields 03:53 Re-using Functions across the Workbook 04:07 Just a bit of "Data Grammar" 00:24 How to Store User Form Data 06:08 Case Study 1: Enhance Given User Form 03:31 Solution to Case Study 1 05:10 Understand Mechanics of User Form 3 questions Adding Pictures into Cells - Robust way 5 lectures • 17min Picture Control of the UserForm 01:57 How to bring picture from file into the UserForm 02:31 Write picture into cell Robust way 04:18 Case Study 2: Add more elements to the UserForm 02:33 Solution to Case Study 2 05:57 Handle images with UserForm 3 questions Automate PowerPoint slides generation from UserForm 3 lectures • 10min Generate PowerPoint from Vector of Data in Excel 04:09 Case Study 3: Add more elements to the PowerPoint Slide 01:14 Solution to Case Study 3 04:22 Automate PowerPoint slides generation from UserForm 3 questions Conclusion 4 lectures • 9min How to use the Template from this course 03:53 What we built in the course? Preview 03:57 Congratulations for completing the course! 00:55 GET YOUR SPECIAL BONUS FOR NEXT COURSE 00:18 Useful VBA Functions 3 lectures • 2min Let's use VBA Functions! 00:01 Function to check presence of specific string 00:52 Function to determine a row of specific string 00:47 Extra: Practical Examples 6 lectures • 4min Introduction to Practical Examples 00:14 Data Entry to Table 00:19 Saving a copy of completed file to SharePoint Document Library 01:21 Sending emails with UserForm! 00:28 Collecting data using Excel Forms within SharePoint Online 01:21 Date and Time Picker 00:23 Bonus Section April 2020: My Personal Goal Settings Template 5 lectures • 21min Idea of the Goal Settings Template 01:21 Using Goal Setting Template: Set Goals Preview 08:53 Using Goal Setting Template: Analyse with Pivot Table 06:54 Goal Setting Template: VBA Code Structure 03:58 Course Project: Create your own UserForm 00:03 Instructor Vladimir Zhbanko Senior Engineering Specialist and Instructor 4.2 Instructor Rating 262 Reviews 10,153 Students 13 Courses Hello, I am really excited that you read my little story here! I am a Chemical Engineer by education, Problem Solver by nature and Instructor by hobby. I currently work in Swiss Multinational Company as Senior Engineering Specialist in R&D. I like to learn and apply modern technology 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 5 languages [EN, RU, IT, ES, DE] and a bit of [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 and Python]. I would like to bring 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 how to benefit from it with concrete examples. By the way, life is not only technology - I like movies, cooking, chess, ice hockey, you name it! p.s. I will try my best to provide 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d1f7be4e0686',m:'ac67f4a979083d6380c06e4ac438bd7ee3bf213a-1627849784-1800-ATO1KHp1U1MznD93ZuTX8oa8DD3WTPBg56ZfJU5q/gJ7VcrSrDPgjsSKOBogbNnYcfYxfSFhlae7+/muAYJjaRpNPUyD7kk0jxJA/m2/qmvA/2wrPPDjLem5QI/NOfVNjX2exCRAO6c2ScyxhHU+99uFRbJUQAyHbfzaW3OVqyRf',s:[0x5bb14de3d6,0xfbf725b311],}})();
  6. 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 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: 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 Show more Show less Course content 8 sections • 39 lectures • 1h 56m total length Expand all sections Welcome to the course! 2 lectures • 7min Introduction to the course Preview 03:18 How to get the most of the course Preview 03:51 Manipulating UserForm in Excel 11 lectures • 47min Understand advantage of excel UserForm Preview 06:14 Reflection Activity: Where to apply this course? 00:17 How to Import UserForm 07:33 How User Form Works? Preview 04:02 How to invoke, close User Form. Common Controls 05:25 How to Populate input fields 03:53 Re-using Functions across the Workbook 04:07 Just a bit of "Data Grammar" 00:24 How to Store User Form Data 06:08 Case Study 1: Enhance Given User Form 03:31 Solution to Case Study 1 05:10 Understand Mechanics of User Form 3 questions Adding Pictures into Cells - Robust way 5 lectures • 17min Picture Control of the UserForm 01:57 How to bring picture from file into the UserForm 02:31 Write picture into cell Robust way 04:18 Case Study 2: Add more elements to the UserForm 02:33 Solution to Case Study 2 05:57 Handle images with UserForm 3 questions Automate PowerPoint slides generation from UserForm 3 lectures • 10min Generate PowerPoint from Vector of Data in Excel 04:09 Case Study 3: Add more elements to the PowerPoint Slide 01:14 Solution to Case Study 3 04:22 Automate PowerPoint slides generation from UserForm 3 questions Conclusion 4 lectures • 9min How to use the Template from this course 03:53 What we built in the course? Preview 03:57 Congratulations for completing the course! 00:55 GET YOUR SPECIAL BONUS FOR NEXT COURSE 00:18 Useful VBA Functions 3 lectures • 2min Let's use VBA Functions! 00:01 Function to check presence of specific string 00:52 Function to determine a row of specific string 00:47 Extra: Practical Examples 6 lectures • 4min Introduction to Practical Examples 00:14 Data Entry to Table 00:19 Saving a copy of completed file to SharePoint Document Library 01:21 Sending emails with UserForm! 00:28 Collecting data using Excel Forms within SharePoint Online 01:21 Date and Time Picker 00:23 Bonus Section April 2020: My Personal Goal Settings Template 5 lectures • 21min Idea of the Goal Settings Template 01:21 Using Goal Setting Template: Set Goals Preview 08:53 Using Goal Setting Template: Analyse with Pivot Table 06:54 Goal Setting Template: VBA Code Structure 03:58 Course Project: Create your own UserForm 00:03 Instructor Vladimir Zhbanko Senior Engineering Specialist and Instructor 4.2 Instructor Rating 262 Reviews 10,153 Students 13 Courses Hello, I am really excited that you read my little story here! I am a Chemical Engineer by education, Problem Solver by nature and Instructor by hobby. I currently work in Swiss Multinational Company as Senior Engineering Specialist in R&D. I like to learn and apply modern technology 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 5 languages [EN, RU, IT, ES, DE] and a bit of [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 and Python]. I would like to bring 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 how to benefit from it with concrete examples. By the way, life is not only technology - I like movies, cooking, chess, ice hockey, you name it! p.s. I will try my best to provide 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781d1f7be4e0686',m:'ac67f4a979083d6380c06e4ac438bd7ee3bf213a-1627849784-1800-ATO1KHp1U1MznD93ZuTX8oa8DD3WTPBg56ZfJU5q/gJ7VcrSrDPgjsSKOBogbNnYcfYxfSFhlae7+/muAYJjaRpNPUyD7kk0jxJA/m2/qmvA/2wrPPDjLem5QI/NOfVNjX2exCRAO6c2ScyxhHU+99uFRbJUQAyHbfzaW3OVqyRf',s:[0x5bb14de3d6,0xfbf725b311],}})();