Excel VBA/Macros foundations for beginners

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

Course Description

Learn step by step how to automate your spreadsheets using the power of programming in Excel!

This course is designed to teach beginners who have no background in programming how to program in Excel VBA!

What you need before taking this course

  • The will to learn !
  • You need to be at least an intermediate user of Excel, know how to write formulas, draw charts and use pivot tables.

A Powerful Skill at Your Fingertips

Learning how to program in Excel will increase your market value and allow you to save time on your spreadsheets.

It will also be a great way to tap into the world of programming, and will help lay the foundation in case you need to learn any other programming language!

Who is the target audience?

This course is targeted towards beginners who want to start learning how to program in Excel.

If you don't know anything about Macros/VBA language, then this course is for you.

If you can only record Macros, but don't know how to write VBA code, then this course is for you as well.

If you already know how to write VBA code, including IF statements,Loops, and use Events, then this course isn't for you.

You need to be someone who knows his way around Excel and knows how to write formulas,use pivot tables, and draw charts.


Who this course is for:

  • Someone who wants to learn how to program/write code in Excel using the Visual Basic for Applications (VBA) language.
  • Needs to know how to write formulas, use pivot tables and draw charts in Excel.

Expected Outcomes

  1. By the end of the course, You will have developed a solid foundation in Excel VBA that will enable you to tackle more advanced topics in Excel VBA with ease. Learn how to deal with cells, worksheets, workbooks, and other objects in Excel using the VBA Language Learning one programming language can help you learn other programming languages as well! Requirements You should be an intermediate user of Excel You need to know how to write formulas, use pivot tables and draw charts. You need to have Excel 2007 or later Description Learn step by step how to automate your spreadsheets using the power of programming in Excel! This course is designed to teach beginners who have no background in programming how to program in Excel VBA! What you need before taking this course The will to learn ! You need to be at least an intermediate user of Excel, know how to write formulas, draw charts and use pivot tables. A Powerful Skill at Your Fingertips Learning how to program in Excel will increase your market value and allow you to save time on your spreadsheets. It will also be a great way to tap into the world of programming, and will help lay the foundation in case you need to learn any other programming language! Who is the target audience? This course is targeted towards beginners who want to start learning how to program in Excel. If you don't know anything about Macros/VBA language, then this course is for you. If you can only record Macros, but don't know how to write VBA code, then this course is for you as well. If you already know how to write VBA code, including IF statements,Loops, and use Events, then this course isn't for you. You need to be someone who knows his way around Excel and knows how to write formulas,use pivot tables, and draw charts. Who this course is for: Someone who wants to learn how to program/write code in Excel using the Visual Basic for Applications (VBA) language. Needs to know how to write formulas, use pivot tables and draw charts in Excel. Show more Show less Course content 12 sections • 129 lectures • 9h 12m total length Expand all sections Introduction 9 lectures • 39min Introduction Preview 03:29 Leaving a Review and Providing me with Feedback 04:59 Recording Macros vs Writing VBA Preview 03:49 Understanding Objects in Excel VBA 07:18 Understanding VBA Syntax and Parts of Speech Preview 09:48 Understanding VBA Syntax- Exercise 00:02 Activating the Developer tab 00:55 Recording a basic Macro 05:04 Absolute vs Relative Macro recording 03:56 Exploring the Visual Basic Environment 7 lectures • 19min Introduction to The Visual Basic Environment 02:09 The Project Explorer 02:05 The Properties WIndow 02:17 The Code WIndow 04:18 Immediate,Locals and Watch Window 03:48 Dealing with Modules 03:08 Comments in Excel VBA 00:59 The Range Object 12 lectures • 55min Introduction and Changing Cell Values 10:27 Adding a text to a cell 01:27 Dealing with Named Ranges 03:15 Value vs Text Property 03:37 Row and Column properties 02:02 The Select Method 02:12 The Count Property 03:37 The Address Property 09:23 The Formula Property 03:27 The Number Format Property 06:34 The Font Property 08:14 Exercise- Range object 00:17 Understanding the Cells collection object 5 lectures • 16min What is the cells object? 05:55 Using the Cells collection to affect cells positionally within a range 05:08 Affecting all cells within a sheet 02:20 Combining Range and cells objects 02:33 Exercise-Cells collection object 00:15 Working with Sheets/Worksheets 7 lectures • 31min Selecting Sheets 05:48 Adding Sheets 11:07 Sheets vs Worksheets 03:54 Copying Sheets 05:15 Moving Sheets 01:16 Deleting Sheets 03:32 Exercises-Worksheets 00:04 Understanding Variables in Excel VBA 9 lectures • 58min Introduction to Variables 06:22 Variable Data Types 09:27 Declaring Variables 14:06 Forcing Variable Declaration 04:56 Object Variables 08:28 Calling a procedure from Another Procedure & Variable Scope 03:15 Public and Private Variables 07:14 Declaring Constants 04:03 Exercises-Variables 00:03 Dealing with Workbooks 6 lectures • 28min Referring to Workbooks-Different ways 03:45 Closing Workbooks 03:17 Adding and Saving Workbooks Part 1 - Save method 04:03 Adding and Saving Workbooks Part 2 - Save as method 10:26 opening Workbooks 06:18 Exercise-Dealing with workbooks 00:21 Must Know Excel VBA Logic 16 lectures • 1hr 13min Finding the Last row 08:58 Finding the Last Column 03:39 Finding the next row 04:24 The WITH Statement 03:52 Comparison operators in Excel VBA 00:59 IF Statements- Simple IF Statements 06:43 IF THEN ELSE Structure 03:21 IF THEN ELSEIF Structure 06:42 Nested IFs 04:21 OR - AND logical operators 07:08 NOT Logical operator 02:49 If Statement Exercise 01:33 CASE Statements Part 1 - Single Case Statements 08:49 CASE Statements Part 2 - Nested Case Statements 06:22 Case Statements-Exercise 00:43 GOTO and Labels 02:44 Looping in Excel VBA 14 lectures • 54min Loops-Introduction 01:26 FOR NEXT Loop 10:55 Exit For 08:36 Exercise - For Next loop 01:00 FOR EACH Loop - Intro 06:42 FOR EACH Loops - More examples 04:48 Exercise - For each loop 01:47 Do Loop - Introduction 03:49 Do Loop Example 01:27 Do Until 01:50 Do While 01:44 Do while vs Do until - Movies Example 03:47 Exit Do Statement 04:57 Exercise - Do Loop 00:46 Interacting with your users 10 lectures • 39min The Messagebox - Introduction 03:14 Messagebox -Inputs 07:22 Messagebox - Capturing the User's input 04:30 Adding a new line to your VBA Strings 02:00 Exercise - Messagebox 02:10 The Inputbox - introduction 03:38 Inputbox - Example1 - Capturing a user's name 05:18 Inputbox -Employee Database Example Part 1 05:19 Inputbox -Employee Database Example Part 2 03:59 Exercise - InputBox 01:44 2 more sections Instructor Abdelrahman Abdou Founder|ExcelBonanza.com|20000+ Students|164 Countries 4.4 Instructor Rating 1,756 Reviews 43,334 Students 4 Courses Hi, I'm Abdelrahman and I'm an Excel Lover :) I have a Bachelor's Degree in Chemical Engineering. I Worked as MIS and Reporting Analyst in Vodafone International Services In Egypt for 3.5 years. I have more than 5 Years of Experience in Excel including building Dashboards and VBA. I have created numerous dashboards in my company and automated tens of reports. I love learning new things and my main learning method is through self-learning by watching video tutorials. I love Excel and I'm trying to share the love with everyone else ! 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:'67814c3b2fd56a65',m:'90ffd3113ae769db8ff29115a6a7db6b4684f080-1627844305-1800-AX+wHpuvooyiajv3vCgNL7rxIXPck/daEq4/yn3XEOXZ94FaP5q7KVbYcsFHc8Q54jeW/kt7506bmNuiTQ+bGvM5e774KVsu8WVMz0QVS/IP4XxviT8qelRODNfSNFFw0LjOcTm5/C6n3IOJmRms4YM=',s:[0xacbc7005ad,0xc1ec362f36],}})();
  2. Learn how to deal with cells, worksheets, workbooks, and other objects in Excel using the VBA Language Learning one programming language can help you learn other programming languages as well! Requirements You should be an intermediate user of Excel You need to know how to write formulas, use pivot tables and draw charts. You need to have Excel 2007 or later Description Learn step by step how to automate your spreadsheets using the power of programming in Excel! This course is designed to teach beginners who have no background in programming how to program in Excel VBA! What you need before taking this course The will to learn ! You need to be at least an intermediate user of Excel, know how to write formulas, draw charts and use pivot tables. A Powerful Skill at Your Fingertips Learning how to program in Excel will increase your market value and allow you to save time on your spreadsheets. It will also be a great way to tap into the world of programming, and will help lay the foundation in case you need to learn any other programming language! Who is the target audience? This course is targeted towards beginners who want to start learning how to program in Excel. If you don't know anything about Macros/VBA language, then this course is for you. If you can only record Macros, but don't know how to write VBA code, then this course is for you as well. If you already know how to write VBA code, including IF statements,Loops, and use Events, then this course isn't for you. You need to be someone who knows his way around Excel and knows how to write formulas,use pivot tables, and draw charts. Who this course is for: Someone who wants to learn how to program/write code in Excel using the Visual Basic for Applications (VBA) language. Needs to know how to write formulas, use pivot tables and draw charts in Excel. Show more Show less Course content 12 sections • 129 lectures • 9h 12m total length Expand all sections Introduction 9 lectures • 39min Introduction Preview 03:29 Leaving a Review and Providing me with Feedback 04:59 Recording Macros vs Writing VBA Preview 03:49 Understanding Objects in Excel VBA 07:18 Understanding VBA Syntax and Parts of Speech Preview 09:48 Understanding VBA Syntax- Exercise 00:02 Activating the Developer tab 00:55 Recording a basic Macro 05:04 Absolute vs Relative Macro recording 03:56 Exploring the Visual Basic Environment 7 lectures • 19min Introduction to The Visual Basic Environment 02:09 The Project Explorer 02:05 The Properties WIndow 02:17 The Code WIndow 04:18 Immediate,Locals and Watch Window 03:48 Dealing with Modules 03:08 Comments in Excel VBA 00:59 The Range Object 12 lectures • 55min Introduction and Changing Cell Values 10:27 Adding a text to a cell 01:27 Dealing with Named Ranges 03:15 Value vs Text Property 03:37 Row and Column properties 02:02 The Select Method 02:12 The Count Property 03:37 The Address Property 09:23 The Formula Property 03:27 The Number Format Property 06:34 The Font Property 08:14 Exercise- Range object 00:17 Understanding the Cells collection object 5 lectures • 16min What is the cells object? 05:55 Using the Cells collection to affect cells positionally within a range 05:08 Affecting all cells within a sheet 02:20 Combining Range and cells objects 02:33 Exercise-Cells collection object 00:15 Working with Sheets/Worksheets 7 lectures • 31min Selecting Sheets 05:48 Adding Sheets 11:07 Sheets vs Worksheets 03:54 Copying Sheets 05:15 Moving Sheets 01:16 Deleting Sheets 03:32 Exercises-Worksheets 00:04 Understanding Variables in Excel VBA 9 lectures • 58min Introduction to Variables 06:22 Variable Data Types 09:27 Declaring Variables 14:06 Forcing Variable Declaration 04:56 Object Variables 08:28 Calling a procedure from Another Procedure & Variable Scope 03:15 Public and Private Variables 07:14 Declaring Constants 04:03 Exercises-Variables 00:03 Dealing with Workbooks 6 lectures • 28min Referring to Workbooks-Different ways 03:45 Closing Workbooks 03:17 Adding and Saving Workbooks Part 1 - Save method 04:03 Adding and Saving Workbooks Part 2 - Save as method 10:26 opening Workbooks 06:18 Exercise-Dealing with workbooks 00:21 Must Know Excel VBA Logic 16 lectures • 1hr 13min Finding the Last row 08:58 Finding the Last Column 03:39 Finding the next row 04:24 The WITH Statement 03:52 Comparison operators in Excel VBA 00:59 IF Statements- Simple IF Statements 06:43 IF THEN ELSE Structure 03:21 IF THEN ELSEIF Structure 06:42 Nested IFs 04:21 OR - AND logical operators 07:08 NOT Logical operator 02:49 If Statement Exercise 01:33 CASE Statements Part 1 - Single Case Statements 08:49 CASE Statements Part 2 - Nested Case Statements 06:22 Case Statements-Exercise 00:43 GOTO and Labels 02:44 Looping in Excel VBA 14 lectures • 54min Loops-Introduction 01:26 FOR NEXT Loop 10:55 Exit For 08:36 Exercise - For Next loop 01:00 FOR EACH Loop - Intro 06:42 FOR EACH Loops - More examples 04:48 Exercise - For each loop 01:47 Do Loop - Introduction 03:49 Do Loop Example 01:27 Do Until 01:50 Do While 01:44 Do while vs Do until - Movies Example 03:47 Exit Do Statement 04:57 Exercise - Do Loop 00:46 Interacting with your users 10 lectures • 39min The Messagebox - Introduction 03:14 Messagebox -Inputs 07:22 Messagebox - Capturing the User's input 04:30 Adding a new line to your VBA Strings 02:00 Exercise - Messagebox 02:10 The Inputbox - introduction 03:38 Inputbox - Example1 - Capturing a user's name 05:18 Inputbox -Employee Database Example Part 1 05:19 Inputbox -Employee Database Example Part 2 03:59 Exercise - InputBox 01:44 2 more sections Instructor Abdelrahman Abdou Founder|ExcelBonanza.com|20000+ Students|164 Countries 4.4 Instructor Rating 1,756 Reviews 43,334 Students 4 Courses Hi, I'm Abdelrahman and I'm an Excel Lover :) I have a Bachelor's Degree in Chemical Engineering. I Worked as MIS and Reporting Analyst in Vodafone International Services In Egypt for 3.5 years. I have more than 5 Years of Experience in Excel including building Dashboards and VBA. I have created numerous dashboards in my company and automated tens of reports. I love learning new things and my main learning method is through self-learning by watching video tutorials. I love Excel and I'm trying to share the love with everyone else ! 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:'67814c3b2fd56a65',m:'90ffd3113ae769db8ff29115a6a7db6b4684f080-1627844305-1800-AX+wHpuvooyiajv3vCgNL7rxIXPck/daEq4/yn3XEOXZ94FaP5q7KVbYcsFHc8Q54jeW/kt7506bmNuiTQ+bGvM5e774KVsu8WVMz0QVS/IP4XxviT8qelRODNfSNFFw0LjOcTm5/C6n3IOJmRms4YM=',s:[0xacbc7005ad,0xc1ec362f36],}})();
  3. Learning one programming language can help you learn other programming languages as well! Requirements You should be an intermediate user of Excel You need to know how to write formulas, use pivot tables and draw charts. You need to have Excel 2007 or later Description Learn step by step how to automate your spreadsheets using the power of programming in Excel! This course is designed to teach beginners who have no background in programming how to program in Excel VBA! What you need before taking this course The will to learn ! You need to be at least an intermediate user of Excel, know how to write formulas, draw charts and use pivot tables. A Powerful Skill at Your Fingertips Learning how to program in Excel will increase your market value and allow you to save time on your spreadsheets. It will also be a great way to tap into the world of programming, and will help lay the foundation in case you need to learn any other programming language! Who is the target audience? This course is targeted towards beginners who want to start learning how to program in Excel. If you don't know anything about Macros/VBA language, then this course is for you. If you can only record Macros, but don't know how to write VBA code, then this course is for you as well. If you already know how to write VBA code, including IF statements,Loops, and use Events, then this course isn't for you. You need to be someone who knows his way around Excel and knows how to write formulas,use pivot tables, and draw charts. Who this course is for: Someone who wants to learn how to program/write code in Excel using the Visual Basic for Applications (VBA) language. Needs to know how to write formulas, use pivot tables and draw charts in Excel. Show more Show less Course content 12 sections • 129 lectures • 9h 12m total length Expand all sections Introduction 9 lectures • 39min Introduction Preview 03:29 Leaving a Review and Providing me with Feedback 04:59 Recording Macros vs Writing VBA Preview 03:49 Understanding Objects in Excel VBA 07:18 Understanding VBA Syntax and Parts of Speech Preview 09:48 Understanding VBA Syntax- Exercise 00:02 Activating the Developer tab 00:55 Recording a basic Macro 05:04 Absolute vs Relative Macro recording 03:56 Exploring the Visual Basic Environment 7 lectures • 19min Introduction to The Visual Basic Environment 02:09 The Project Explorer 02:05 The Properties WIndow 02:17 The Code WIndow 04:18 Immediate,Locals and Watch Window 03:48 Dealing with Modules 03:08 Comments in Excel VBA 00:59 The Range Object 12 lectures • 55min Introduction and Changing Cell Values 10:27 Adding a text to a cell 01:27 Dealing with Named Ranges 03:15 Value vs Text Property 03:37 Row and Column properties 02:02 The Select Method 02:12 The Count Property 03:37 The Address Property 09:23 The Formula Property 03:27 The Number Format Property 06:34 The Font Property 08:14 Exercise- Range object 00:17 Understanding the Cells collection object 5 lectures • 16min What is the cells object? 05:55 Using the Cells collection to affect cells positionally within a range 05:08 Affecting all cells within a sheet 02:20 Combining Range and cells objects 02:33 Exercise-Cells collection object 00:15 Working with Sheets/Worksheets 7 lectures • 31min Selecting Sheets 05:48 Adding Sheets 11:07 Sheets vs Worksheets 03:54 Copying Sheets 05:15 Moving Sheets 01:16 Deleting Sheets 03:32 Exercises-Worksheets 00:04 Understanding Variables in Excel VBA 9 lectures • 58min Introduction to Variables 06:22 Variable Data Types 09:27 Declaring Variables 14:06 Forcing Variable Declaration 04:56 Object Variables 08:28 Calling a procedure from Another Procedure & Variable Scope 03:15 Public and Private Variables 07:14 Declaring Constants 04:03 Exercises-Variables 00:03 Dealing with Workbooks 6 lectures • 28min Referring to Workbooks-Different ways 03:45 Closing Workbooks 03:17 Adding and Saving Workbooks Part 1 - Save method 04:03 Adding and Saving Workbooks Part 2 - Save as method 10:26 opening Workbooks 06:18 Exercise-Dealing with workbooks 00:21 Must Know Excel VBA Logic 16 lectures • 1hr 13min Finding the Last row 08:58 Finding the Last Column 03:39 Finding the next row 04:24 The WITH Statement 03:52 Comparison operators in Excel VBA 00:59 IF Statements- Simple IF Statements 06:43 IF THEN ELSE Structure 03:21 IF THEN ELSEIF Structure 06:42 Nested IFs 04:21 OR - AND logical operators 07:08 NOT Logical operator 02:49 If Statement Exercise 01:33 CASE Statements Part 1 - Single Case Statements 08:49 CASE Statements Part 2 - Nested Case Statements 06:22 Case Statements-Exercise 00:43 GOTO and Labels 02:44 Looping in Excel VBA 14 lectures • 54min Loops-Introduction 01:26 FOR NEXT Loop 10:55 Exit For 08:36 Exercise - For Next loop 01:00 FOR EACH Loop - Intro 06:42 FOR EACH Loops - More examples 04:48 Exercise - For each loop 01:47 Do Loop - Introduction 03:49 Do Loop Example 01:27 Do Until 01:50 Do While 01:44 Do while vs Do until - Movies Example 03:47 Exit Do Statement 04:57 Exercise - Do Loop 00:46 Interacting with your users 10 lectures • 39min The Messagebox - Introduction 03:14 Messagebox -Inputs 07:22 Messagebox - Capturing the User's input 04:30 Adding a new line to your VBA Strings 02:00 Exercise - Messagebox 02:10 The Inputbox - introduction 03:38 Inputbox - Example1 - Capturing a user's name 05:18 Inputbox -Employee Database Example Part 1 05:19 Inputbox -Employee Database Example Part 2 03:59 Exercise - InputBox 01:44 2 more sections Instructor Abdelrahman Abdou Founder|ExcelBonanza.com|20000+ Students|164 Countries 4.4 Instructor Rating 1,756 Reviews 43,334 Students 4 Courses Hi, I'm Abdelrahman and I'm an Excel Lover :) I have a Bachelor's Degree in Chemical Engineering. I Worked as MIS and Reporting Analyst in Vodafone International Services In Egypt for 3.5 years. I have more than 5 Years of Experience in Excel including building Dashboards and VBA. I have created numerous dashboards in my company and automated tens of reports. I love learning new things and my main learning method is through self-learning by watching video tutorials. I love Excel and I'm trying to share the love with everyone else ! 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:'67814c3b2fd56a65',m:'90ffd3113ae769db8ff29115a6a7db6b4684f080-1627844305-1800-AX+wHpuvooyiajv3vCgNL7rxIXPck/daEq4/yn3XEOXZ94FaP5q7KVbYcsFHc8Q54jeW/kt7506bmNuiTQ+bGvM5e774KVsu8WVMz0QVS/IP4XxviT8qelRODNfSNFFw0LjOcTm5/C6n3IOJmRms4YM=',s:[0xacbc7005ad,0xc1ec362f36],}})();