Excel 2019 VBA Advanced Tutorial скачать в хорошем качестве

Excel 2019 VBA Advanced Tutorial

Excel 2019 VBA Advanced Tutorial Get Ad-Free Training by becoming a member today!    / @learnittraining   Exercise Files: https://bit.ly/37mAIZM Who it's for: Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what’s possible in Excel. What it is: Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don’t exist in Excel. What you'll learn: In this series, users will be guided through the foundational concepts of VBA in Excel. Users will learn to build macros from the ground up, starting with recording macros that require little to no code, and working towards building their own macros using crucial VBA concepts such as Loop, If Then, and other complex functions. Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com For Private Group Trainings please visit: https://www.learnit.com/private-group... Manuals: https://bit.ly/30xZb59 Username: manuals Password: password Start 0:00 Introduction 0:03 Introduction to Forms and Controls 1:41 UserForm Object-Controls-Properties-Events-Methods 2:36 Reviewing Types of Modules and Inserting UserForm Objects 5:19 Changing Form Properties 8:39 Creating a Label Control and Adjusting its Properties 10:15 Copying a Label Control to Create a New One 13:10 Adding Two Text Box Controls to Forms 14:12 Adding Two Command Button Controls to Forms 16:01 Adding a Combo Box Control and Label 19:21 Adding Two Frame Controls with Three Option Buttons in Each 21:43 Adjusting Option Button Properties 25:16 Aligning and Grouping Form Controls 27:13 Testing and Adjusting Form Tab Order 30:07 Coding the Combo Box to Display Months 34:05 Coding Other Form Controls Using Text Files 38:47 Reviewing Coding in Text Files 41:23 Displaying the Form Programmatically 44:01 Forms and Controls Recap 47:39 Introduction to Pivot Tables in VBA 48:35 Introduction to Creating Pivot Tables 49:18 Creating Pivot Tables by Recording a Macro 52:39 Creating Pivot Tables 57:43 Testing CreatePivot Sub-Procedure 1:01:23 Creating Sub-Procedures to Set Pivot Table Fields 1:02:05 Finalizing Forms 1:09:42 Creating Sub-Procedures to Code Options in the Period Frame on Forms 1:13:17 Reviewing GetLastDate and GetFirstDate Code Blocks from Text Files 1:17:28 Coding Options in the Sales Frame on the Form 1:20:10 Reviewing Text File Procedures - ConsolidateData-GrabCells-FinishReport 1:22:39 Completing Code Modifications for Form Objects 1:26:10 Testing Completed Forms 1:31:12 Adding Icons to the QAT to Run the Form 1:35:55 Pivot Tables Recap 1:38:54 Conclusion 1:41:37 #excel #exceltutorial #exceltips #vba #excelvba (C) 2022 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.