Excel VBA: The VBA Beginner's Blueprint to Programming Excel

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

Course Description

Become an Excel Programmer and You Can Finally Put Your Work On Autopilot!


Even with all of Excel's great features, and built-in tools, you might find yourself doing repetitive tasks, that take longer than they should.

Or the day will come when you say, "Oh, I wish there were a better way to do this!"

The good news is that Excel, and other Microsoft Office applications, comes with Visual Basic for Applications (VBA), a programming language that will extend the functionality of your Office applications.


In This Course You Get:

  • Free Downloadable Workbooks - makes it easy to follow along & practice after class.
  • Test Your Skills - exercises to get you engaged & reinforce what you have learned.
  • Code Snippets - with common code bites.
  • VBA Glossary - talk the talk



This is a VBA beginner's course that will get you on the road to being in that elite group of VBA programmers.

Learning to program can seem daunting at first, but I'm going to make it as easy as possible.

With that said, VBA is a huge topic, and yes, there are a lot of lectures in this course.

But don't stress out.

What I do go over will get you from, "I don't even like looking at VBA", to, "I can do this!"



NOTE: There are multiple ways to get the same result in VBA.

So the way I write a procedure or two might be slightly different than your co-workers code, or yours, and that's O.K.


If you're ready to cut your workload, automate your tasks, and learn a desirable skill while your at it, click the Take This Course button on the top right, and I will help start programming your Excel workbooks with VBA.


Who this course is for:

  • This course is for the everyday Excel user, who wants to extend the functionality of their spreadsheets using Visual Basic for Applications (VBA), but who is not yet familiar with VBA.
  • This course is designed for beginners to VBA. Intermediate, and Advanced VBA users will find this course a great review, but this course is not designed for advanced users of VBA.

Expected Outcomes

  1. If you plan to use Excel in your job, than learning VBA has its advantages! Enroll in this course to automate, and customize your Excel 2007, 2010, 2013, 2016, 2019, or 365 files with hours of Video Lectures, 40+ Articles, and 90+ Supplemental Resources. UNDERSTAND why you would want to use VBA in Excel KNOW the difference between Macros and VBA CREATE Macros in Excel MODIFY your Macros NAVIGATE comfortably in the Visual Basic Editor LEARN the essentials of writing Excel VBA code MODIFY your Workbooks using VBA CREATE Decision Structures in your VBA code LOOP your VBA code to have it run more than once CREATE user interaction dialog boxes, like Message Boxes, and Input Boxes CREATE User Forms from scratch DEBUG your VBA code LEARN how to handle errors CREATE New Worksheet Functions Show more Show less Requirements To get the most out of this course, you should have working knowledge of Microsoft Excel. Excel 2010, 2013, 2016, 2019, 365 Description Become an Excel Programmer and You Can Finally Put Your Work On Autopilot! Even with all of Excel's great features, and built-in tools, you might find yourself doing repetitive tasks, that take longer than they should. Or the day will come when you say, " Oh, I wish there were a better way to do this !" The good news is that Excel, and other Microsoft Office applications, comes with Visual Basic for Applications (VBA), a programming language that will extend the functionality of your Office applications. In This Course You Get: Free Downloadable Workbooks - makes it easy to follow along & practice after class. Test Your Skills - exercises to get you engaged & reinforce what you have learned. Code Snippets - with common code bites. VBA Glossary - talk the talk This is a VBA beginner's course that will get you on the road to being in that elite group of VBA programmers. Learning to program can seem daunting at first, but I'm going to make it as easy as possible. With that said, VBA is a huge topic, and yes, there are a lot of lectures in this course. But don't stress out. What I do go over will get you from, " I don't even like looking at VBA ", to, "I can do this!" NOTE: There are multiple ways to get the same result in VBA. So the way I write a procedure or two might be slightly different than your co-workers code, or yours, and that's O.K. If you're ready to cut your workload , automate your tasks , and learn a desirable skill while your at it, click the Take This Course button on the top right, and I will help start programming your Excel workbooks with VBA. Who this course is for: This course is for the everyday Excel user, who wants to extend the functionality of their spreadsheets using Visual Basic for Applications (VBA), but who is not yet familiar with VBA. This course is designed for beginners to VBA. Intermediate, and Advanced VBA users will find this course a great review, but this course is not designed for advanced users of VBA. Show more Show less Course content 17 sections • 183 lectures • 7h 4m total length Expand all sections Welcome to Excel VBA 1 lecture • 2min Introduction Preview 02:00 Introduction to Visual Basic for Applications 6 lectures • 8min Writing Code vs. Recording Macros Preview 02:14 Understanding Objects 02:34 Containers & Collections 01:06 How VBA Refers to Objects 01:11 Security Settings 2 pages Section Summary 00:54 Understanding, Recording , and Modifying Macros 12 lectures • 24min Recording Macros Preview 04:26 Testing the Macro and Looking at the VBA Preview 02:59 Absolute vs. Relative Mode Preview 01:55 Recording in Relative Mode Preview 05:40 Modifying Macros Using VBA Preview 03:40 Assigning Macros to Shortcut Keys 2 pages Accessing Macros through the Quick Access Toolbar 2 pages Accessing Macros through the Ribbon 1 page Accessing Macros through Shapes or Images 1 page Accessing Macros through Command Buttons 1 page Macro Example: Creating Buttons to Navigate Between Worksheets 03:59 Section Summary 01:03 Getting to Know the Visual Basic Editor 13 lectures • 18min The Microsoft Visual Basic Editor Preview 02:31 The Project Explorer Preview 02:11 The Properties Window Preview 01:46 The Code Window Preview 04:38 Other Windows: the Immediate Window, the Locals Window, and the Watch Window 02:04 Docking Windows 1 page Adding and Removing Modules 02:04 Exporting and Importing Modules 2 pages Naming Modules 01:34 Customizing the Visual Basic Environment 01:02 The Object Browser 1 page Protecting Your Code 1 page Section Summary 00:38 Getting Started with Programming VBA 13 lectures • 31min Introduction to Writing VBA 00:23 A Few Time Savers Writing VBA Preview 03:22 Resetting Your VBA Code Upon Errors Preview 02:14 Structure of Sub Procedures 01:36 Calling a Sub Procedure 03:38 Structure of Functions 03:09 Calling a Function 01:10 Calling Procedures with the Same Name 00:24 Comments Preview 05:20 Using Objects 03:00 Using Methods 03:29 Using Event Procedures - UPDATED 02:49 Section Summary 00:46 Getting to Know Variables, Data Types, and Operators 19 lectures • 24min Variables 06:59 Declaring Multiple Variables 00:20 Object Variables 02:34 Data Types 02:13 Using Identifier Type Characers to Declare Data Types 1 page Declaring Constants 02:39 Arithmetic Operators 1 page Exercise: Using Byte Variables 1 page Exercise: Using String Variables 1 page Exercise: Using Currency Variables 1 page Exercise: Using Date Variables 1 page Logical Operators 1 page The Colon Operator 00:06 String Concatenation 00:02 The Line Continuation Operator 00:16 Carriage Return Line Feed 01:39 The With Statement 00:33 Scope 05:47 Section Summary 00:53 Workbooks, Cells, and Ranges 34 lectures • 1hr 12min Creating a New Workbook 03:36 Opening and Closing Workbooks 02:26 Worksheets vs. Sheets 02:12 ActiveSheet 00:10 Adding Worksheets 04:18 Copying Worksheets 02:42 Moving Worksheets 00:10 Deleting Worksheets 00:08 The Cells Object 02:27 Exercise: Using Operators and the Cells Object 01:39 ActiveCell 04:41 Rows and Columns 02:47 Inserting Columns and Rows 00:11 AutoFit Columns and Rows 00:20 The Range Object 01:20 Referring to Named Ranges 01:56 The Select Method 00:10 The CurrentRegion Property 02:24 The Range.End Property 04:25 Copying Data on Your Worksheet 03:42 The Paste Method 04:25 Using PasteSpecial 03:28 Useful Font Object Members 1 page Clearing Contents and Formats 03:30 The Name Property 00:08 The Value Property 00:14 Exercise: Using Name, and Value 01:35 Sorting Fields 03:50 Filtering Fields 07:41 Removing Duplicate Records 03:39 The PrintPreview Method 00:10 The PrintOut Method 00:39 Section Summary 00:39 Test Your Skills 4 pages Formatting Values with Functions 8 lectures • 7min The Format Function: Using Named Format Expressions 03:41 The Format Function: Creating Custom Number Formats 3 pages The Format Function: Creating Custom Date/Time Formatting 2 pages The Format Function: Creating Custom String Formats 1 page Using the FormatCurrency Function 03:14 The FormatNumber Function 00:05 Using the FormatDateTime Function 1 page The FormatPercent Function 00:07 Using Decision Structures to Branch Your VBA Code 5 lectures • 13min Introduction to Decision Structures 00:48 If…Then 04:02 If…Then…Else 02:37 Select Case 05:18 Section Summary 00:18 Looping Your VBA Code 18 lectures • 43min How Are You Enjoying the Course? 1 page Introduction to Loops 01:03 For Next Loop 03:49 Exercise: For Next Loop 04:39 Stepping 02:08 Quick Questions: For Next Loops 00:12 Quick Answer: For Next Loops 00:08 For Each 01:29 Exercise: For Each, Example 1 03:19 Exercise: For Each, Example 2 06:35 Exiting a For Loop 02:34 Do Until Loop 01:33 Exercise: Do Until Loops 07:18 Do While Loop 01:11 Exercise: Do While Loop 03:39 Exiting a Do Loop 02:20 Section Summary 00:32 Test Your Skills 4 pages 7 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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:'67812e18ad2553fd',m:'4a526a54593c0762cea6bb60467d5212fb35ea25-1627843072-1800-AZA6MRSQ1oEXs+ThX6yh9oYwXpbakcsxEBpyqu4rgy9RYkV4F7d5k6aSFtMm0iNy9TCgKsf9hlC0ZnyuJcuVEoqokPCKy/mx7H4+BMN6+8ETWWsZb0h+O+XW7qYy80N/bUSy8cLuJ1june3TyGn3/qs=',s:[0x2e2e969dab,0xd82452d62f],}})();
  2. Enroll in this course to automate, and customize your Excel 2007, 2010, 2013, 2016, 2019, or 365 files with hours of Video Lectures, 40+ Articles, and 90+ Supplemental Resources. UNDERSTAND why you would want to use VBA in Excel KNOW the difference between Macros and VBA CREATE Macros in Excel MODIFY your Macros NAVIGATE comfortably in the Visual Basic Editor LEARN the essentials of writing Excel VBA code MODIFY your Workbooks using VBA CREATE Decision Structures in your VBA code LOOP your VBA code to have it run more than once CREATE user interaction dialog boxes, like Message Boxes, and Input Boxes CREATE User Forms from scratch DEBUG your VBA code LEARN how to handle errors CREATE New Worksheet Functions Show more Show less Requirements To get the most out of this course, you should have working knowledge of Microsoft Excel. Excel 2010, 2013, 2016, 2019, 365 Description Become an Excel Programmer and You Can Finally Put Your Work On Autopilot! Even with all of Excel's great features, and built-in tools, you might find yourself doing repetitive tasks, that take longer than they should. Or the day will come when you say, " Oh, I wish there were a better way to do this !" The good news is that Excel, and other Microsoft Office applications, comes with Visual Basic for Applications (VBA), a programming language that will extend the functionality of your Office applications. In This Course You Get: Free Downloadable Workbooks - makes it easy to follow along & practice after class. Test Your Skills - exercises to get you engaged & reinforce what you have learned. Code Snippets - with common code bites. VBA Glossary - talk the talk This is a VBA beginner's course that will get you on the road to being in that elite group of VBA programmers. Learning to program can seem daunting at first, but I'm going to make it as easy as possible. With that said, VBA is a huge topic, and yes, there are a lot of lectures in this course. But don't stress out. What I do go over will get you from, " I don't even like looking at VBA ", to, "I can do this!" NOTE: There are multiple ways to get the same result in VBA. So the way I write a procedure or two might be slightly different than your co-workers code, or yours, and that's O.K. If you're ready to cut your workload , automate your tasks , and learn a desirable skill while your at it, click the Take This Course button on the top right, and I will help start programming your Excel workbooks with VBA. Who this course is for: This course is for the everyday Excel user, who wants to extend the functionality of their spreadsheets using Visual Basic for Applications (VBA), but who is not yet familiar with VBA. This course is designed for beginners to VBA. Intermediate, and Advanced VBA users will find this course a great review, but this course is not designed for advanced users of VBA. Show more Show less Course content 17 sections • 183 lectures • 7h 4m total length Expand all sections Welcome to Excel VBA 1 lecture • 2min Introduction Preview 02:00 Introduction to Visual Basic for Applications 6 lectures • 8min Writing Code vs. Recording Macros Preview 02:14 Understanding Objects 02:34 Containers & Collections 01:06 How VBA Refers to Objects 01:11 Security Settings 2 pages Section Summary 00:54 Understanding, Recording , and Modifying Macros 12 lectures • 24min Recording Macros Preview 04:26 Testing the Macro and Looking at the VBA Preview 02:59 Absolute vs. Relative Mode Preview 01:55 Recording in Relative Mode Preview 05:40 Modifying Macros Using VBA Preview 03:40 Assigning Macros to Shortcut Keys 2 pages Accessing Macros through the Quick Access Toolbar 2 pages Accessing Macros through the Ribbon 1 page Accessing Macros through Shapes or Images 1 page Accessing Macros through Command Buttons 1 page Macro Example: Creating Buttons to Navigate Between Worksheets 03:59 Section Summary 01:03 Getting to Know the Visual Basic Editor 13 lectures • 18min The Microsoft Visual Basic Editor Preview 02:31 The Project Explorer Preview 02:11 The Properties Window Preview 01:46 The Code Window Preview 04:38 Other Windows: the Immediate Window, the Locals Window, and the Watch Window 02:04 Docking Windows 1 page Adding and Removing Modules 02:04 Exporting and Importing Modules 2 pages Naming Modules 01:34 Customizing the Visual Basic Environment 01:02 The Object Browser 1 page Protecting Your Code 1 page Section Summary 00:38 Getting Started with Programming VBA 13 lectures • 31min Introduction to Writing VBA 00:23 A Few Time Savers Writing VBA Preview 03:22 Resetting Your VBA Code Upon Errors Preview 02:14 Structure of Sub Procedures 01:36 Calling a Sub Procedure 03:38 Structure of Functions 03:09 Calling a Function 01:10 Calling Procedures with the Same Name 00:24 Comments Preview 05:20 Using Objects 03:00 Using Methods 03:29 Using Event Procedures - UPDATED 02:49 Section Summary 00:46 Getting to Know Variables, Data Types, and Operators 19 lectures • 24min Variables 06:59 Declaring Multiple Variables 00:20 Object Variables 02:34 Data Types 02:13 Using Identifier Type Characers to Declare Data Types 1 page Declaring Constants 02:39 Arithmetic Operators 1 page Exercise: Using Byte Variables 1 page Exercise: Using String Variables 1 page Exercise: Using Currency Variables 1 page Exercise: Using Date Variables 1 page Logical Operators 1 page The Colon Operator 00:06 String Concatenation 00:02 The Line Continuation Operator 00:16 Carriage Return Line Feed 01:39 The With Statement 00:33 Scope 05:47 Section Summary 00:53 Workbooks, Cells, and Ranges 34 lectures • 1hr 12min Creating a New Workbook 03:36 Opening and Closing Workbooks 02:26 Worksheets vs. Sheets 02:12 ActiveSheet 00:10 Adding Worksheets 04:18 Copying Worksheets 02:42 Moving Worksheets 00:10 Deleting Worksheets 00:08 The Cells Object 02:27 Exercise: Using Operators and the Cells Object 01:39 ActiveCell 04:41 Rows and Columns 02:47 Inserting Columns and Rows 00:11 AutoFit Columns and Rows 00:20 The Range Object 01:20 Referring to Named Ranges 01:56 The Select Method 00:10 The CurrentRegion Property 02:24 The Range.End Property 04:25 Copying Data on Your Worksheet 03:42 The Paste Method 04:25 Using PasteSpecial 03:28 Useful Font Object Members 1 page Clearing Contents and Formats 03:30 The Name Property 00:08 The Value Property 00:14 Exercise: Using Name, and Value 01:35 Sorting Fields 03:50 Filtering Fields 07:41 Removing Duplicate Records 03:39 The PrintPreview Method 00:10 The PrintOut Method 00:39 Section Summary 00:39 Test Your Skills 4 pages Formatting Values with Functions 8 lectures • 7min The Format Function: Using Named Format Expressions 03:41 The Format Function: Creating Custom Number Formats 3 pages The Format Function: Creating Custom Date/Time Formatting 2 pages The Format Function: Creating Custom String Formats 1 page Using the FormatCurrency Function 03:14 The FormatNumber Function 00:05 Using the FormatDateTime Function 1 page The FormatPercent Function 00:07 Using Decision Structures to Branch Your VBA Code 5 lectures • 13min Introduction to Decision Structures 00:48 If…Then 04:02 If…Then…Else 02:37 Select Case 05:18 Section Summary 00:18 Looping Your VBA Code 18 lectures • 43min How Are You Enjoying the Course? 1 page Introduction to Loops 01:03 For Next Loop 03:49 Exercise: For Next Loop 04:39 Stepping 02:08 Quick Questions: For Next Loops 00:12 Quick Answer: For Next Loops 00:08 For Each 01:29 Exercise: For Each, Example 1 03:19 Exercise: For Each, Example 2 06:35 Exiting a For Loop 02:34 Do Until Loop 01:33 Exercise: Do Until Loops 07:18 Do While Loop 01:11 Exercise: Do While Loop 03:39 Exiting a Do Loop 02:20 Section Summary 00:32 Test Your Skills 4 pages 7 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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:'67812e18ad2553fd',m:'4a526a54593c0762cea6bb60467d5212fb35ea25-1627843072-1800-AZA6MRSQ1oEXs+ThX6yh9oYwXpbakcsxEBpyqu4rgy9RYkV4F7d5k6aSFtMm0iNy9TCgKsf9hlC0ZnyuJcuVEoqokPCKy/mx7H4+BMN6+8ETWWsZb0h+O+XW7qYy80N/bUSy8cLuJ1june3TyGn3/qs=',s:[0x2e2e969dab,0xd82452d62f],}})();
  3. UNDERSTAND why you would want to use VBA in Excel KNOW the difference between Macros and VBA CREATE Macros in Excel MODIFY your Macros NAVIGATE comfortably in the Visual Basic Editor LEARN the essentials of writing Excel VBA code MODIFY your Workbooks using VBA CREATE Decision Structures in your VBA code LOOP your VBA code to have it run more than once CREATE user interaction dialog boxes, like Message Boxes, and Input Boxes CREATE User Forms from scratch DEBUG your VBA code LEARN how to handle errors CREATE New Worksheet Functions Show more Show less Requirements To get the most out of this course, you should have working knowledge of Microsoft Excel. Excel 2010, 2013, 2016, 2019, 365 Description Become an Excel Programmer and You Can Finally Put Your Work On Autopilot! Even with all of Excel's great features, and built-in tools, you might find yourself doing repetitive tasks, that take longer than they should. Or the day will come when you say, " Oh, I wish there were a better way to do this !" The good news is that Excel, and other Microsoft Office applications, comes with Visual Basic for Applications (VBA), a programming language that will extend the functionality of your Office applications. In This Course You Get: Free Downloadable Workbooks - makes it easy to follow along & practice after class. Test Your Skills - exercises to get you engaged & reinforce what you have learned. Code Snippets - with common code bites. VBA Glossary - talk the talk This is a VBA beginner's course that will get you on the road to being in that elite group of VBA programmers. Learning to program can seem daunting at first, but I'm going to make it as easy as possible. With that said, VBA is a huge topic, and yes, there are a lot of lectures in this course. But don't stress out. What I do go over will get you from, " I don't even like looking at VBA ", to, "I can do this!" NOTE: There are multiple ways to get the same result in VBA. So the way I write a procedure or two might be slightly different than your co-workers code, or yours, and that's O.K. If you're ready to cut your workload , automate your tasks , and learn a desirable skill while your at it, click the Take This Course button on the top right, and I will help start programming your Excel workbooks with VBA. Who this course is for: This course is for the everyday Excel user, who wants to extend the functionality of their spreadsheets using Visual Basic for Applications (VBA), but who is not yet familiar with VBA. This course is designed for beginners to VBA. Intermediate, and Advanced VBA users will find this course a great review, but this course is not designed for advanced users of VBA. Show more Show less Course content 17 sections • 183 lectures • 7h 4m total length Expand all sections Welcome to Excel VBA 1 lecture • 2min Introduction Preview 02:00 Introduction to Visual Basic for Applications 6 lectures • 8min Writing Code vs. Recording Macros Preview 02:14 Understanding Objects 02:34 Containers & Collections 01:06 How VBA Refers to Objects 01:11 Security Settings 2 pages Section Summary 00:54 Understanding, Recording , and Modifying Macros 12 lectures • 24min Recording Macros Preview 04:26 Testing the Macro and Looking at the VBA Preview 02:59 Absolute vs. Relative Mode Preview 01:55 Recording in Relative Mode Preview 05:40 Modifying Macros Using VBA Preview 03:40 Assigning Macros to Shortcut Keys 2 pages Accessing Macros through the Quick Access Toolbar 2 pages Accessing Macros through the Ribbon 1 page Accessing Macros through Shapes or Images 1 page Accessing Macros through Command Buttons 1 page Macro Example: Creating Buttons to Navigate Between Worksheets 03:59 Section Summary 01:03 Getting to Know the Visual Basic Editor 13 lectures • 18min The Microsoft Visual Basic Editor Preview 02:31 The Project Explorer Preview 02:11 The Properties Window Preview 01:46 The Code Window Preview 04:38 Other Windows: the Immediate Window, the Locals Window, and the Watch Window 02:04 Docking Windows 1 page Adding and Removing Modules 02:04 Exporting and Importing Modules 2 pages Naming Modules 01:34 Customizing the Visual Basic Environment 01:02 The Object Browser 1 page Protecting Your Code 1 page Section Summary 00:38 Getting Started with Programming VBA 13 lectures • 31min Introduction to Writing VBA 00:23 A Few Time Savers Writing VBA Preview 03:22 Resetting Your VBA Code Upon Errors Preview 02:14 Structure of Sub Procedures 01:36 Calling a Sub Procedure 03:38 Structure of Functions 03:09 Calling a Function 01:10 Calling Procedures with the Same Name 00:24 Comments Preview 05:20 Using Objects 03:00 Using Methods 03:29 Using Event Procedures - UPDATED 02:49 Section Summary 00:46 Getting to Know Variables, Data Types, and Operators 19 lectures • 24min Variables 06:59 Declaring Multiple Variables 00:20 Object Variables 02:34 Data Types 02:13 Using Identifier Type Characers to Declare Data Types 1 page Declaring Constants 02:39 Arithmetic Operators 1 page Exercise: Using Byte Variables 1 page Exercise: Using String Variables 1 page Exercise: Using Currency Variables 1 page Exercise: Using Date Variables 1 page Logical Operators 1 page The Colon Operator 00:06 String Concatenation 00:02 The Line Continuation Operator 00:16 Carriage Return Line Feed 01:39 The With Statement 00:33 Scope 05:47 Section Summary 00:53 Workbooks, Cells, and Ranges 34 lectures • 1hr 12min Creating a New Workbook 03:36 Opening and Closing Workbooks 02:26 Worksheets vs. Sheets 02:12 ActiveSheet 00:10 Adding Worksheets 04:18 Copying Worksheets 02:42 Moving Worksheets 00:10 Deleting Worksheets 00:08 The Cells Object 02:27 Exercise: Using Operators and the Cells Object 01:39 ActiveCell 04:41 Rows and Columns 02:47 Inserting Columns and Rows 00:11 AutoFit Columns and Rows 00:20 The Range Object 01:20 Referring to Named Ranges 01:56 The Select Method 00:10 The CurrentRegion Property 02:24 The Range.End Property 04:25 Copying Data on Your Worksheet 03:42 The Paste Method 04:25 Using PasteSpecial 03:28 Useful Font Object Members 1 page Clearing Contents and Formats 03:30 The Name Property 00:08 The Value Property 00:14 Exercise: Using Name, and Value 01:35 Sorting Fields 03:50 Filtering Fields 07:41 Removing Duplicate Records 03:39 The PrintPreview Method 00:10 The PrintOut Method 00:39 Section Summary 00:39 Test Your Skills 4 pages Formatting Values with Functions 8 lectures • 7min The Format Function: Using Named Format Expressions 03:41 The Format Function: Creating Custom Number Formats 3 pages The Format Function: Creating Custom Date/Time Formatting 2 pages The Format Function: Creating Custom String Formats 1 page Using the FormatCurrency Function 03:14 The FormatNumber Function 00:05 Using the FormatDateTime Function 1 page The FormatPercent Function 00:07 Using Decision Structures to Branch Your VBA Code 5 lectures • 13min Introduction to Decision Structures 00:48 If…Then 04:02 If…Then…Else 02:37 Select Case 05:18 Section Summary 00:18 Looping Your VBA Code 18 lectures • 43min How Are You Enjoying the Course? 1 page Introduction to Loops 01:03 For Next Loop 03:49 Exercise: For Next Loop 04:39 Stepping 02:08 Quick Questions: For Next Loops 00:12 Quick Answer: For Next Loops 00:08 For Each 01:29 Exercise: For Each, Example 1 03:19 Exercise: For Each, Example 2 06:35 Exiting a For Loop 02:34 Do Until Loop 01:33 Exercise: Do Until Loops 07:18 Do While Loop 01:11 Exercise: Do While Loop 03:39 Exiting a Do Loop 02:20 Section Summary 00:32 Test Your Skills 4 pages 7 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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:'67812e18ad2553fd',m:'4a526a54593c0762cea6bb60467d5212fb35ea25-1627843072-1800-AZA6MRSQ1oEXs+ThX6yh9oYwXpbakcsxEBpyqu4rgy9RYkV4F7d5k6aSFtMm0iNy9TCgKsf9hlC0ZnyuJcuVEoqokPCKy/mx7H4+BMN6+8ETWWsZb0h+O+XW7qYy80N/bUSy8cLuJ1june3TyGn3/qs=',s:[0x2e2e969dab,0xd82452d62f],}})();
  4. KNOW the difference between Macros and VBA CREATE Macros in Excel MODIFY your Macros NAVIGATE comfortably in the Visual Basic Editor LEARN the essentials of writing Excel VBA code MODIFY your Workbooks using VBA CREATE Decision Structures in your VBA code LOOP your VBA code to have it run more than once CREATE user interaction dialog boxes, like Message Boxes, and Input Boxes CREATE User Forms from scratch DEBUG your VBA code LEARN how to handle errors CREATE New Worksheet Functions Show more Show less Requirements To get the most out of this course, you should have working knowledge of Microsoft Excel. Excel 2010, 2013, 2016, 2019, 365 Description Become an Excel Programmer and You Can Finally Put Your Work On Autopilot! Even with all of Excel's great features, and built-in tools, you might find yourself doing repetitive tasks, that take longer than they should. Or the day will come when you say, " Oh, I wish there were a better way to do this !" The good news is that Excel, and other Microsoft Office applications, comes with Visual Basic for Applications (VBA), a programming language that will extend the functionality of your Office applications. In This Course You Get: Free Downloadable Workbooks - makes it easy to follow along & practice after class. Test Your Skills - exercises to get you engaged & reinforce what you have learned. Code Snippets - with common code bites. VBA Glossary - talk the talk This is a VBA beginner's course that will get you on the road to being in that elite group of VBA programmers. Learning to program can seem daunting at first, but I'm going to make it as easy as possible. With that said, VBA is a huge topic, and yes, there are a lot of lectures in this course. But don't stress out. What I do go over will get you from, " I don't even like looking at VBA ", to, "I can do this!" NOTE: There are multiple ways to get the same result in VBA. So the way I write a procedure or two might be slightly different than your co-workers code, or yours, and that's O.K. If you're ready to cut your workload , automate your tasks , and learn a desirable skill while your at it, click the Take This Course button on the top right, and I will help start programming your Excel workbooks with VBA. Who this course is for: This course is for the everyday Excel user, who wants to extend the functionality of their spreadsheets using Visual Basic for Applications (VBA), but who is not yet familiar with VBA. This course is designed for beginners to VBA. Intermediate, and Advanced VBA users will find this course a great review, but this course is not designed for advanced users of VBA. Show more Show less Course content 17 sections • 183 lectures • 7h 4m total length Expand all sections Welcome to Excel VBA 1 lecture • 2min Introduction Preview 02:00 Introduction to Visual Basic for Applications 6 lectures • 8min Writing Code vs. Recording Macros Preview 02:14 Understanding Objects 02:34 Containers & Collections 01:06 How VBA Refers to Objects 01:11 Security Settings 2 pages Section Summary 00:54 Understanding, Recording , and Modifying Macros 12 lectures • 24min Recording Macros Preview 04:26 Testing the Macro and Looking at the VBA Preview 02:59 Absolute vs. Relative Mode Preview 01:55 Recording in Relative Mode Preview 05:40 Modifying Macros Using VBA Preview 03:40 Assigning Macros to Shortcut Keys 2 pages Accessing Macros through the Quick Access Toolbar 2 pages Accessing Macros through the Ribbon 1 page Accessing Macros through Shapes or Images 1 page Accessing Macros through Command Buttons 1 page Macro Example: Creating Buttons to Navigate Between Worksheets 03:59 Section Summary 01:03 Getting to Know the Visual Basic Editor 13 lectures • 18min The Microsoft Visual Basic Editor Preview 02:31 The Project Explorer Preview 02:11 The Properties Window Preview 01:46 The Code Window Preview 04:38 Other Windows: the Immediate Window, the Locals Window, and the Watch Window 02:04 Docking Windows 1 page Adding and Removing Modules 02:04 Exporting and Importing Modules 2 pages Naming Modules 01:34 Customizing the Visual Basic Environment 01:02 The Object Browser 1 page Protecting Your Code 1 page Section Summary 00:38 Getting Started with Programming VBA 13 lectures • 31min Introduction to Writing VBA 00:23 A Few Time Savers Writing VBA Preview 03:22 Resetting Your VBA Code Upon Errors Preview 02:14 Structure of Sub Procedures 01:36 Calling a Sub Procedure 03:38 Structure of Functions 03:09 Calling a Function 01:10 Calling Procedures with the Same Name 00:24 Comments Preview 05:20 Using Objects 03:00 Using Methods 03:29 Using Event Procedures - UPDATED 02:49 Section Summary 00:46 Getting to Know Variables, Data Types, and Operators 19 lectures • 24min Variables 06:59 Declaring Multiple Variables 00:20 Object Variables 02:34 Data Types 02:13 Using Identifier Type Characers to Declare Data Types 1 page Declaring Constants 02:39 Arithmetic Operators 1 page Exercise: Using Byte Variables 1 page Exercise: Using String Variables 1 page Exercise: Using Currency Variables 1 page Exercise: Using Date Variables 1 page Logical Operators 1 page The Colon Operator 00:06 String Concatenation 00:02 The Line Continuation Operator 00:16 Carriage Return Line Feed 01:39 The With Statement 00:33 Scope 05:47 Section Summary 00:53 Workbooks, Cells, and Ranges 34 lectures • 1hr 12min Creating a New Workbook 03:36 Opening and Closing Workbooks 02:26 Worksheets vs. Sheets 02:12 ActiveSheet 00:10 Adding Worksheets 04:18 Copying Worksheets 02:42 Moving Worksheets 00:10 Deleting Worksheets 00:08 The Cells Object 02:27 Exercise: Using Operators and the Cells Object 01:39 ActiveCell 04:41 Rows and Columns 02:47 Inserting Columns and Rows 00:11 AutoFit Columns and Rows 00:20 The Range Object 01:20 Referring to Named Ranges 01:56 The Select Method 00:10 The CurrentRegion Property 02:24 The Range.End Property 04:25 Copying Data on Your Worksheet 03:42 The Paste Method 04:25 Using PasteSpecial 03:28 Useful Font Object Members 1 page Clearing Contents and Formats 03:30 The Name Property 00:08 The Value Property 00:14 Exercise: Using Name, and Value 01:35 Sorting Fields 03:50 Filtering Fields 07:41 Removing Duplicate Records 03:39 The PrintPreview Method 00:10 The PrintOut Method 00:39 Section Summary 00:39 Test Your Skills 4 pages Formatting Values with Functions 8 lectures • 7min The Format Function: Using Named Format Expressions 03:41 The Format Function: Creating Custom Number Formats 3 pages The Format Function: Creating Custom Date/Time Formatting 2 pages The Format Function: Creating Custom String Formats 1 page Using the FormatCurrency Function 03:14 The FormatNumber Function 00:05 Using the FormatDateTime Function 1 page The FormatPercent Function 00:07 Using Decision Structures to Branch Your VBA Code 5 lectures • 13min Introduction to Decision Structures 00:48 If…Then 04:02 If…Then…Else 02:37 Select Case 05:18 Section Summary 00:18 Looping Your VBA Code 18 lectures • 43min How Are You Enjoying the Course? 1 page Introduction to Loops 01:03 For Next Loop 03:49 Exercise: For Next Loop 04:39 Stepping 02:08 Quick Questions: For Next Loops 00:12 Quick Answer: For Next Loops 00:08 For Each 01:29 Exercise: For Each, Example 1 03:19 Exercise: For Each, Example 2 06:35 Exiting a For Loop 02:34 Do Until Loop 01:33 Exercise: Do Until Loops 07:18 Do While Loop 01:11 Exercise: Do While Loop 03:39 Exiting a Do Loop 02:20 Section Summary 00:32 Test Your Skills 4 pages 7 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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:'67812e18ad2553fd',m:'4a526a54593c0762cea6bb60467d5212fb35ea25-1627843072-1800-AZA6MRSQ1oEXs+ThX6yh9oYwXpbakcsxEBpyqu4rgy9RYkV4F7d5k6aSFtMm0iNy9TCgKsf9hlC0ZnyuJcuVEoqokPCKy/mx7H4+BMN6+8ETWWsZb0h+O+XW7qYy80N/bUSy8cLuJ1june3TyGn3/qs=',s:[0x2e2e969dab,0xd82452d62f],}})();
  5. CREATE Macros in Excel MODIFY your Macros NAVIGATE comfortably in the Visual Basic Editor LEARN the essentials of writing Excel VBA code MODIFY your Workbooks using VBA CREATE Decision Structures in your VBA code LOOP your VBA code to have it run more than once CREATE user interaction dialog boxes, like Message Boxes, and Input Boxes CREATE User Forms from scratch DEBUG your VBA code LEARN how to handle errors CREATE New Worksheet Functions Show more Show less Requirements To get the most out of this course, you should have working knowledge of Microsoft Excel. Excel 2010, 2013, 2016, 2019, 365 Description Become an Excel Programmer and You Can Finally Put Your Work On Autopilot! Even with all of Excel's great features, and built-in tools, you might find yourself doing repetitive tasks, that take longer than they should. Or the day will come when you say, " Oh, I wish there were a better way to do this !" The good news is that Excel, and other Microsoft Office applications, comes with Visual Basic for Applications (VBA), a programming language that will extend the functionality of your Office applications. In This Course You Get: Free Downloadable Workbooks - makes it easy to follow along & practice after class. Test Your Skills - exercises to get you engaged & reinforce what you have learned. Code Snippets - with common code bites. VBA Glossary - talk the talk This is a VBA beginner's course that will get you on the road to being in that elite group of VBA programmers. Learning to program can seem daunting at first, but I'm going to make it as easy as possible. With that said, VBA is a huge topic, and yes, there are a lot of lectures in this course. But don't stress out. What I do go over will get you from, " I don't even like looking at VBA ", to, "I can do this!" NOTE: There are multiple ways to get the same result in VBA. So the way I write a procedure or two might be slightly different than your co-workers code, or yours, and that's O.K. If you're ready to cut your workload , automate your tasks , and learn a desirable skill while your at it, click the Take This Course button on the top right, and I will help start programming your Excel workbooks with VBA. Who this course is for: This course is for the everyday Excel user, who wants to extend the functionality of their spreadsheets using Visual Basic for Applications (VBA), but who is not yet familiar with VBA. This course is designed for beginners to VBA. Intermediate, and Advanced VBA users will find this course a great review, but this course is not designed for advanced users of VBA. Show more Show less Course content 17 sections • 183 lectures • 7h 4m total length Expand all sections Welcome to Excel VBA 1 lecture • 2min Introduction Preview 02:00 Introduction to Visual Basic for Applications 6 lectures • 8min Writing Code vs. Recording Macros Preview 02:14 Understanding Objects 02:34 Containers & Collections 01:06 How VBA Refers to Objects 01:11 Security Settings 2 pages Section Summary 00:54 Understanding, Recording , and Modifying Macros 12 lectures • 24min Recording Macros Preview 04:26 Testing the Macro and Looking at the VBA Preview 02:59 Absolute vs. Relative Mode Preview 01:55 Recording in Relative Mode Preview 05:40 Modifying Macros Using VBA Preview 03:40 Assigning Macros to Shortcut Keys 2 pages Accessing Macros through the Quick Access Toolbar 2 pages Accessing Macros through the Ribbon 1 page Accessing Macros through Shapes or Images 1 page Accessing Macros through Command Buttons 1 page Macro Example: Creating Buttons to Navigate Between Worksheets 03:59 Section Summary 01:03 Getting to Know the Visual Basic Editor 13 lectures • 18min The Microsoft Visual Basic Editor Preview 02:31 The Project Explorer Preview 02:11 The Properties Window Preview 01:46 The Code Window Preview 04:38 Other Windows: the Immediate Window, the Locals Window, and the Watch Window 02:04 Docking Windows 1 page Adding and Removing Modules 02:04 Exporting and Importing Modules 2 pages Naming Modules 01:34 Customizing the Visual Basic Environment 01:02 The Object Browser 1 page Protecting Your Code 1 page Section Summary 00:38 Getting Started with Programming VBA 13 lectures • 31min Introduction to Writing VBA 00:23 A Few Time Savers Writing VBA Preview 03:22 Resetting Your VBA Code Upon Errors Preview 02:14 Structure of Sub Procedures 01:36 Calling a Sub Procedure 03:38 Structure of Functions 03:09 Calling a Function 01:10 Calling Procedures with the Same Name 00:24 Comments Preview 05:20 Using Objects 03:00 Using Methods 03:29 Using Event Procedures - UPDATED 02:49 Section Summary 00:46 Getting to Know Variables, Data Types, and Operators 19 lectures • 24min Variables 06:59 Declaring Multiple Variables 00:20 Object Variables 02:34 Data Types 02:13 Using Identifier Type Characers to Declare Data Types 1 page Declaring Constants 02:39 Arithmetic Operators 1 page Exercise: Using Byte Variables 1 page Exercise: Using String Variables 1 page Exercise: Using Currency Variables 1 page Exercise: Using Date Variables 1 page Logical Operators 1 page The Colon Operator 00:06 String Concatenation 00:02 The Line Continuation Operator 00:16 Carriage Return Line Feed 01:39 The With Statement 00:33 Scope 05:47 Section Summary 00:53 Workbooks, Cells, and Ranges 34 lectures • 1hr 12min Creating a New Workbook 03:36 Opening and Closing Workbooks 02:26 Worksheets vs. Sheets 02:12 ActiveSheet 00:10 Adding Worksheets 04:18 Copying Worksheets 02:42 Moving Worksheets 00:10 Deleting Worksheets 00:08 The Cells Object 02:27 Exercise: Using Operators and the Cells Object 01:39 ActiveCell 04:41 Rows and Columns 02:47 Inserting Columns and Rows 00:11 AutoFit Columns and Rows 00:20 The Range Object 01:20 Referring to Named Ranges 01:56 The Select Method 00:10 The CurrentRegion Property 02:24 The Range.End Property 04:25 Copying Data on Your Worksheet 03:42 The Paste Method 04:25 Using PasteSpecial 03:28 Useful Font Object Members 1 page Clearing Contents and Formats 03:30 The Name Property 00:08 The Value Property 00:14 Exercise: Using Name, and Value 01:35 Sorting Fields 03:50 Filtering Fields 07:41 Removing Duplicate Records 03:39 The PrintPreview Method 00:10 The PrintOut Method 00:39 Section Summary 00:39 Test Your Skills 4 pages Formatting Values with Functions 8 lectures • 7min The Format Function: Using Named Format Expressions 03:41 The Format Function: Creating Custom Number Formats 3 pages The Format Function: Creating Custom Date/Time Formatting 2 pages The Format Function: Creating Custom String Formats 1 page Using the FormatCurrency Function 03:14 The FormatNumber Function 00:05 Using the FormatDateTime Function 1 page The FormatPercent Function 00:07 Using Decision Structures to Branch Your VBA Code 5 lectures • 13min Introduction to Decision Structures 00:48 If…Then 04:02 If…Then…Else 02:37 Select Case 05:18 Section Summary 00:18 Looping Your VBA Code 18 lectures • 43min How Are You Enjoying the Course? 1 page Introduction to Loops 01:03 For Next Loop 03:49 Exercise: For Next Loop 04:39 Stepping 02:08 Quick Questions: For Next Loops 00:12 Quick Answer: For Next Loops 00:08 For Each 01:29 Exercise: For Each, Example 1 03:19 Exercise: For Each, Example 2 06:35 Exiting a For Loop 02:34 Do Until Loop 01:33 Exercise: Do Until Loops 07:18 Do While Loop 01:11 Exercise: Do While Loop 03:39 Exiting a Do Loop 02:20 Section Summary 00:32 Test Your Skills 4 pages 7 more sections Instructor IsáBel . Microsoft Certified IT Professional. Trainer of 21 Years 4.5 Instructor Rating 3,240 Reviews 29,858 Students 14 Courses Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want? IsáBel Will Show You How. ABOUT Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel. Technical courses in everyday language are offered in her Udemy portfolio. IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports. IsaBel grew up around teachers, so education was always important to her. All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL. She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals. COURSES ON UDEMY.COM SQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-Programmers Microsoft Office: - Excel Pivot Tables: The Power of Pivot Tables... Made Easy - Excel: Time Saving Tips That Will Boost Your Productivity ✔ - Excel VBA: The VBA Beginner's Blueprint to Programming Excel - Access: Time Saving Tips That Will Boost Your Productivity ✔ - Access Macros: Automate Your Access Databases - Microsoft Access: Beyond the Basics of Access Bundle - Access VBA: The Beginner's Blueprint to Programming Access - Microsoft Word: Forms, Mail Merge, and Field Code Rules - Microsoft Word Time Saving Tips To Boost Your Productivity ✔ - Microsoft Office: Word, Excel and Access Productivity Bundle SharePoint: - SharePoint 2010: Survey Creation for SharePoint Admins - SharePoint 2013: Survey Creation for SharePoint Admins RESOURCES: ▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters. 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:'67812e18ad2553fd',m:'4a526a54593c0762cea6bb60467d5212fb35ea25-1627843072-1800-AZA6MRSQ1oEXs+ThX6yh9oYwXpbakcsxEBpyqu4rgy9RYkV4F7d5k6aSFtMm0iNy9TCgKsf9hlC0ZnyuJcuVEoqokPCKy/mx7H4+BMN6+8ETWWsZb0h+O+XW7qYy80N/bUSy8cLuJ1june3TyGn3/qs=',s:[0x2e2e969dab,0xd82452d62f],}})();
  6. MODIFY your Macros NAVIGATE comfortably in the Visual Basic Editor LEARN the essentials of writing Excel VBA code MODIFY your Workbooks using VBA CREATE Decision Structures in your VBA code LOOP your VBA code to have it run more than once CREATE user interaction dialog boxes, like Message Boxes, and Input Boxes CREATE User Forms from scratch DEBUG your VBA code LEARN how to handle errors CREATE New Worksheet Functions Show more Show less Requirements To get the most out of this course, you should have working knowledge of Microsoft Excel. Excel 2010, 2013, 2016, 2019, 365 Description Become an Excel Programmer and You Can Finally Put Your Work On Autopilot! Even with all of Excel's great features, and built-in tools, you might find yourself doing repetitive tasks, that take longer than they should. Or the day will come when you say, " Oh, I wish there were a better way to do this !" The good news is that Excel, and other Microsoft Office applications, comes with Visual Basic for Applications (VBA), a programming language that will extend the functionality of your Office applications. In This Course You Get: Free Downloadable Workbooks - makes it easy to follow along & practice after class. Test Your Skills - exercises to get you engaged & reinforce what you have learned. Code Snippets - with common code bites. VBA Glossary - talk the talk This is a VBA beginner's course that will get you on the road to being in that elite group of VBA programmers. Learning to program can seem daunting at first, but I'm going to make it as easy as possible. With that said, VBA is a huge topic, and yes, there are a lot of lectures in this course. But don't stress out. What I do go over will get you from, " I don't even like looking at VBA ", to, "I can do this!" NOTE: There are multiple ways to get the same result in VBA. So the way I write a procedure or two might be slightly different than your co-workers code, or yours, and that's O.K. If you're ready to cut your workload , automate your tasks , and learn a desirable skill while your at it, click the Take This Course button on the top right, and I will help start programming your Excel workbooks with VBA. Who this course is for: This course is for the everyday Excel user, who wants to extend the functionality of their spreadsheets using Visual Basic for Applications (VBA), but who is not yet familiar with VBA. This course is designed for beginners to VBA. Intermediate, and Advanced VBA users will find this course a great review, but this course is not designed for advanced users of VBA. Show more Show less Course content 17 sections • 183 lectures • 7h 4m total length Expand all sections Welcome to Excel VBA 1 lecture • 2min Introduction Preview 02:00 Introduction to Visual Basic for Applications 6 lectures • 8min Writing Code vs. Recording Macros Preview 02:14 Understanding Objects 02:34 Containers & Collections 01:06 How VBA Refers to Objects 01:11 Security Settings 2 pages Section Summary 00:54 Understanding, Recording , and Modifying Macros 12 lectures • 24min Recording Macros Preview 04:26 Testing the Macro and Looking at the VBA Preview 02:59 Absolute vs. Relative Mode Preview 01:55 Recording in Relative Mode Preview 05:40 Modifying Macros Using VBA Preview 03:40 Assigning Macros to Shortcut Keys 2 pages Accessing Macros through the Quick Access Toolbar 2 pages Accessing Macros through the Ribbon 1 page Accessing Macros through Shapes or Images 1 page Accessing Macros through Command Buttons 1 page Macro Example: Creating Buttons to Navigate Between Worksheets 03:59 Section Summary 01:03 Getting to Know the Visual Basic Editor 13 lectures • 18min The Microsoft Visual Basic Editor Preview 02:31 The Project Explorer Preview 02:11 The Properties Window Preview 01:46 The Code Window Preview 04:38 Other Windows: the Immediate Window, the Locals Window, and the Watch Window 02:04 Docking Windows 1 page Adding and Removing Modules 02:04 Exporting and Importing Modules 2 pages Naming Modules 01:34 Customizing the Visual Basic Environment 01:02 The Object Browser 1 page Protecting Your Code 1 page Section Summary 00:38 Getting Started with Programming VBA 13 lectures • 31min Introduction to Writing VBA 00:23 A Few Time Savers Writing VBA Preview 03:22 Resetting Your VBA Code Upon Errors Preview 02:14 Structure of Sub Procedures 01:36 Calling a Sub Procedure 03:38 Structure of Functions 03:09 Calling a Function 01:10 Calling Procedures with the Same Name 00:24 Comments Preview 05:20 Using Objects 03:00 Using Methods 03:29 Using Event Procedures - UPDATED 02:49 Section Summary 00:46 Getting to Know Variables, Data Types, and Operators 19 lectures • 24min Variables 06:59 Declaring Multiple Variables 00:20 Object Variables 02:34 Data Types 02:13 Using Identifier Type Characers to Declare Data Types 1 page Declaring Constants 02:39 Arithmetic Operators 1 page Exercise: Using Byte Variables 1 page Exercise: Using String Variables 1 page Exercise: Using Currency Variables 1 page Exercise: Using Date Variables 1 page Logical Operators 1 page The Colon Operator 00:06 String Concatenation 00:02 The Line Continuation Operator 00:16 Carriage Return Line Feed 01:39 The With Statement 00:33 Scope 05:47 Section Summary 00:53 Workbooks, Cells, and Ranges 34 lectures • 1hr 12min Creating a New Workbook 03:36 Opening and Closing Workbooks 02:26 Worksheets vs. Sheets 02:12 ActiveSheet 00:10 Adding Worksheets 04:18 Copying Worksheets 02:42 Moving Worksheets 00:10 Deleting Worksheets 00:08 The Cells Object 02:27 Exercise: Using Operators and the Cells Object 01:39 ActiveCell 04:41 Rows and Columns 02:47 Inserting Columns and Rows 00:11 AutoFit Columns and Rows 00:20 The Range Object 01:20 Referring to Named Ranges 01:56 The Select Method 00:10 The CurrentRegion Property 02:24 The Range.End Property 04:25 Copying Data on Your Worksheet 03:42 The Paste Method 04:25 Using PasteSpecial 03:28 Useful Font Object Members 1 page Clearing Contents and Formats 03:30 The Name Property 00:08 The Value Property 00:14 Exercise: Using Name, and Value 01:35 Sorting Fields 03:50 Filtering Fields 07:41 Removing Duplicate Records 03:39 The PrintPreview Method 00:10 The PrintOut Method 00:39 Section Summary 00:39 Test Your Skills 4 pages Formatting Values with Functions 8 lectures • 7min The Format Function: Using Named Format Expressions 03:41 The Format Function: Creating Custom Number Formats 3 pages The Format Function: Creating Custom Date/Time Formatting 2 pages The Format Function: Creating Custom String Formats 1 page Using the FormatCurrency Function 03:14 The FormatNumber Function 00:05 Using the FormatDateTime Function 1 page The FormatPercent Function 00:07 Using Decision Structures to Branch Your VBA Code 5 lectures • 13min Introduction to Decision Structures 00:48 If…Then 04:02 If…Then…Else 02:37 Select Case 05:18 Section Summary 00:18 Looping Your VBA Code 18 lectures • 43min How Are You Enjoying the Course? 1 page Introduction to Loops 01:03 For Next Loop 03:49 Exercise: For Next Loop 04:39 Stepping 02:08 Quick Questions: For Next Loops 00:12 Quick Answer: For Next Loops 00:08 For Each 01:29 Exercise: For Each, Example 1 03:19 Exercise: For Each, Example 2 06:35 Exiting a For Loop 02:34 Do Until Loop 01:33 Exercise: Do Until Loops 07:18 Do While Loop 01:11 Exercise: Do While Loop 03:39 Exiting a Do Loop 02:20 Section Summary 00:32 Test Your Skills 4 pages 7 more sections Instructor IsáBel . Microsoft Certified I