发帖
雷达卡
Learn to Create and Program Microsoft Excel VBA User Forms like a Pro
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3.5 Hours | 463 MB
Customize Your Excel Interactions with Excel VBA UserForms
Microsoft Excel is a very powerful tool, but doesn't always provide the most accessible approach to working with your data. Through the use of Excel VBA and Excel VBA UserForms, you'll be able to create a more accessible and efficient environment to work with your specialized data.
By participating in this course on Microsoft Excel VBA UserForms you will journey through a step by step, project based learning experience. Each project you will be introduced to will build upon the previous project. While completing each project from start to completion, you'll build an Excel experience you'll want to re-create for each of your Microsoft Excel projects.
• Learn key VBA concepts that relate to building Excel VBA UserForm interafces
• Streamline yours and your users experience working with large Excel data sets
• Create intuitive Excel interfaces to create reports and provide summarized data based on Excel tables.
Join me in this course and become and Excel VBA UserForm champion! See you in the course.
What are the requirements?
• A copy of Microsoft Excel 2007, 2010, 2013 or 2016 can be used to follow along with this course.
What am I going to get from this course?
• Cut out the all the noise of working with large sets of Microsoft Excel Data by tailoring the Excel Users experience and interface
• Provide a seamless, accessible interface to your Excel users saving time and money
• Learn to develop interactive Excel interfaces with Excel VBA User Forms
• Take advantage of the most powerful aspect of Microsoft Excel to streamline your Excel interactions
What is the target audience?
• This Microsoft Excel VBA UserForms course is intended for Microsoft Excel users that are new to creating Excel VBA UserForms. No prior programming knowledge necessary to participate in the course.
Curriculum
Section 1: Quick Course Introduction
Lecture 1 Introduction
Lecture 2 Exercise Files - Download these Files
Section 2: Project #1 - Building a User Interface with an Excel VBA UserForm
Lecture 3 Microsoft Excel VBA Project #1 - Introduction
Lecture 4 Project #1 - Building the Excel VBA UserForm
Lecture 5 Project #1 - Adding Controls to the Excel UserForm
Lecture 6 Project #1 - Exercise - Adding Controls to the UserForm
Lecture 7 Project #1 - Working with the Control's Properties
Lecture 8 Project #1 - Exercise - Working with UserForm Control Properties
Lecture 9 Project #1 - Adding Excel VBA Code to the UserForm's Events
Lecture 10 Project #1 - For... Next... Loop Populating a ComboBox
Lecture 11 Project #1 - Control Default Value
Lecture 12 Project #1 - Call Start and End Time Buttons
Lecture 13 Project #1 - Displaying the Excel VBA UserForm to the User
Quiz 1 Project #1 - QUIZ - Building a User Interface with Excel VBA UserForms Quiz
Section 3: Project #2 - Connecting the UserForm to a Worksheet for Data Entry
Lecture 14 Microsoft Excel VBA Project #2 - Introduction
Lecture 15 Project #2 - Select Worksheets Dynamically on Submit
Lecture 16 Project #2 - Transfer Data from UserForm to Worksheet List
Lecture 17 Project #2 - Calculating Data in VBA
Lecture 18 Project #2 - Generate a Unique Call Log Record ID Procedure with VBA
Lecture 19 Project #2 - Exercise - Working with Excel VBA ARRAYS
Lecture 20 Project #2 - Call Generate Call ID Procedure from UserForm
Lecture 21 Project #2 - Vaildating Data Entry in the UserForm
Lecture 22 Project #2 - Clearing the Form
Quiz 2 Project #2 - Quiz
Section 4: Project #3 - Print Call Log Report
Lecture 23 Microsoft VBA Project #3 - Introduction
Lecture 24 Project #3 - Creating the Print Report Excel VBA UserForm
Lecture 25 Project #3 - Exercise - Setting Properties of the UserForm Controls
Lecture 26 Project #3 - Creating a New Excel Workbook with VBA
Lecture 27 Project 3 - Loop Through all Worksheets in Workbook
Lecture 28 Project #3 - Pasting Data into a New Excel Workbook
Lecture 29 Project #3 - A Little Clean Up with VBA
Lecture 30 Project #3 - Exercise - Close Button VBA
Lecture 31 Project #3 - Exercise - Creating the Print Report Button
Quiz 3 Project #3 - Quiz
Section 5: Project #4 - Current Call Stats
Lecture 32 Microsoft VBA Project #4 - Introduction
Lecture 33 Project #4 - Exercise - Build Call Stats Excel UserForm
Lecture 34 Project #4 - Exercise - Setting Properties of UserForm Call Stats
Lecture 35 Project #4 - Create Temporary Stats Worksheet
Lecture 36 Project #4 - Create Temp Sheet Continued
Lecture 37 Project #4 - Calculate Call Stats with VBA on Temporary Worksheet
Lecture 38 Project #4 - Initialize Call Stats UserForm
Lecture 39 Project #4 - Exercise - Refresh and Close Buttons
Lecture 40 Project #4 - Email Stats with VBA and Outlook
Lecture 41 Project #4 - Exercise - Call Stats Worksheet Button
Section 6: Congratulations and Bonus
Lecture 42 Congratulations! You've Completed the Course
Lecture 43 BONUS! Check out my other Courses on Udemy
视频下载：本帖隐藏的内容
推荐使用 360 浏览器下载：
Excel with Microsoft Excel VBA User Forms.part01.rar
(45 MB, 需要: 3 个论坛币)
Excel with Microsoft Excel VBA User Forms.part02.rar
(45 MB, 需要: 3 个论坛币)
Excel with Microsoft Excel VBA User Forms.part03.rar
(45 MB, 需要: 3 个论坛币)
Excel with Microsoft Excel VBA User Forms.part04.rar
(45 MB, 需要: 3 个论坛币)
Excel with Microsoft Excel VBA User Forms.part05.rar
(45 MB, 需要: 3 个论坛币)
Excel with Microsoft Excel VBA User Forms.part06.rar
(45 MB, 需要: 3 个论坛币)
Excel with Microsoft Excel VBA User Forms.part07.rar
(45 MB, 需要: 3 个论坛币)
Excel with Microsoft Excel VBA User Forms.part08.rar
(45 MB, 需要: 3 个论坛币)
Excel with Microsoft Excel VBA User Forms.part09.rar
(45 MB, 需要: 3 个论坛币)
Excel with Microsoft Excel VBA User Forms.part10.rar
(45 MB, 需要: 2 个论坛币)
Excel with Microsoft Excel VBA User Forms.part11.rar
(13.24 MB, 需要: 1 个论坛币)
京公网安备 11010802022788号
