Excel Macros & Excel VBA Programming for Beginners

سرفصل های دوره

Become a proficient Excel Macros and Excel VBA Programmer in very short time. 2024 UPDATED

1. Introduction

1. Introduction

2. Course Resources

3. Compatibility & Macros Security

4. Why a macro and not regular Excel

5. IMPORTANT Opening macro-enabled workbooks.html

6. For Mac users.html

Files.zip

2. The Basics of Macros

1. Introduction

2. How to Record a Macro

3. How to Run a Macro and Assign it to an Icon or a Button

4. Personal Macro Workbook

5. Watch An Excel Macro Write Your VBA Code

6. Rules regarding Naming Macros.html

7. Assignment 1.html

8. EXERCISE Record a Macro.html

9. The Basics of Macros.html

Files.zip

3. Get in-depth with Macros

1. Introduction

2. A Detailed Example of how we Record a Macro

3. Inserting a Data Entry Form into a Database Automatically

4. Clean the Format of a Data Table using Macros

5. Absolute vs. Relative Referencing during Macro Recording

6. (NEW 2024) Writing Effective Macros

7. DEMO Use Navigation Buttons to Change Chart Type

8. Get in-depth with Macros.html

Files.zip

4. Starting Excel VBA Programming

1. Introduction

2. A tour of the Developer Tab

3. Overview of procedures in VBA

4. Referring to Ranges

5. Different Ways to Refer to a Range in VBA

6. Dynamic Ranges (& Intro to Variables)

7. Copying Data using VBA Code (& Intro to Objects)

8. Copying Data to the Bottom of a Range

9. Finding Data with VBA

10. Replacing Data Quickly

11. Using Special Cells to Remove Blank Rows

12. Why use Option Explicit

13. How to troubleshoot when your code is not working properly

14. Excel VBA Indentation.html

15. Starting Excel VBA Programming.html

Files.zip

5. VBA Language Elements in Detail

1. Introduction

2. (NEW 2024) VBA Data Types

3. (NEW 2024) VBA Syntax and Expression Entry PART1

4. (NEW 2024) VBA Syntax and Expression Entry PART2

5. Sub Procedures

6. Sub Procedure Examples

7. Variables

8. (NEW 2024) Manage Variable Scope

9. (NEW 2024) Define Static Variables and Constants

10. (NEW 2024) Define object variables

11. Strings and Dates

12. Assignment Statements

13. Constants

14. Arrays

15. (NEW 2024) Activity Define variables, constants, and calculations

16. (NEW 2024) SOLUTION of Activity Define variables, constants, and calculations

17. PROJECT Using Relative or Absolute Reference

18. VBA Language Elements in Detail.html

Files.zip

6. Common Objects, Properties & Methods

1. Introduction to Objects, Properties, Methods, and Events

2. RANGE Property

3. CELLS Property

4. OFFSET Property

5. VALUE, TEXT, COUNT, COLUMN, ROWS & ADRRESS Properties

6. SELECT, CLEAR & DELETE Methods

7. Subroutine Examples - Part1

8. Subroutine Examples - Part2

9. Subroutine Examples - Part3

10. How to handle basic user error in your subroutines

11. Common Objects, Properties & Methods.html

Files.zip

7. Filtering and Sorting with VBA

1. Introduction

2. Sorting with VBA Part1

3. Sorting with VBA Part2

4. Sorting with VBA Part3

5. Filtering with VBA Part1

6. Filtering with VBA Part2

Files.zip

8. Using VBA and Worksheet Functions

1. Introduction

2. (NEW 2024) How to create a Function in VBA

3. How to make your own user-defined (UDF) function (Custom Functions)

4. How to convert a user-defined function to an Excel Add-In

5. Custom Function Examples

6. How to borrow functions from Excel

7. Message Box and Built-In Functions EXAMPLES

8. Using Worksheet Functions in VBA

9. Using VBA and Worksheet Functions.html

Files.zip

9. IF and FOR Looping Statements

1. Introduction

2. The If-Then Structure

3. For-Next loops

4. Applications of Looping Methodologies - Part1

5. Applications of Looping Methodologies - Part2

6. Applications of Looping Methodologies - Part3

7. Iterating through a Selection vs. a Range

8. Using the For Each... Next statement

9. DEMO Using IF..ELSE Statements with Macros

10. DEMO Using FORNEXT Statements with Macros

11. IF and FOR Looping Statements.html

Files.zip

10. Variable iteration loops

1. Do...Loops

2. Validating user input using a Do...Loop

3. Creating a guessing game using a Do...Loop

4. Do-While loop and Do-Until loop.html

5. The GoTo Statement

6. Combining Macro Recording and VBA Statements

7. How to join 2 different Macros

8. Variable iteration loops.html

Files.zip

11. VBA Projects & Ready-to-use MACROS

1. PROJECT Transfer Data From one Excel Worksheet to another

2. PROJECT Create an Interactive Map using VBA & Macros

3. PROJECT Add a confirmation dialog box with VBA IF statements

4. PROJECT Prompting a user to select a worksheet and run a macro

5. PROJECT How to Create Notifications-Reminders using VBA Code

6. PROJECT How to create an Excel Animated Chart using VBA Code

7. PROJECT Saving a Workbook before Closing

8. PROJECT Closing All Workbooks at Once

Files.zip

12. BONUS SECTION

1. SPECIAL BONUS Discover Exciting Offers!.html

2. Excel 2019 Tutorial for Beginners

54,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy