Mastering Excel VBA for the Real World

Focused View

Jose D. Sevilla

9:28:33

180 View

1 - Introduction

1 - Introduction.mp4

01:04

2 - Getting Familiar with the VBA Editor

2 - Adding the Developer Tab.mp4

01:05

3 - Main Parts of the VBA Editor.mp4

03:41

4 - Adding the Edit Toolbar.mp4

03:57

3 - Using the Macro Recorder Functionality

5 - HR-File.xlsx

5 - Macros Macro Security.mp4

04:42

6 - Recording Macros Part I.mp4

05:23

7 - Recording Macros Part II.mp4

04:43

8 - Editing Macros.mp4

03:46

9 - Programming in VBA vs Recording Macros.mp4

01:56

9 - Programming-in-VBA-over-Macro-Recorder.pdf

4 - Building solid ground in Excel VBA

10 - Excel VBA Object Model.mp4

04:14

10 - Excel-VBA-Object-Model.pdf

11 - Workbooks Worksheets and Sheets Collections.mp4

04:14

11 - Workbooks-Worksheets-and-Sheets-Collections.pdf

12 - Workbooks Coding Lesson.mp4

12:47

13 - Sheets Worksheets Coding Lesson.mp4

18:19

14 - Range Object Coding Lesson.mp4

18:30

15 - Columns Rows and Cells Properties Coding Lesson.mp4

10:39

5 - Learning about VBA Operators

16 - Arithmetic Operators.mp4

05:29

16 - Excel-VBA-Operators.pdf

17 - Comparison Operators.mp4

07:21

18 - Logical Operators.mp4

07:22

19 - Concatenation Operators.mp4

03:54

6 - Data Types in VBA and Variables

20 - Excel VBA Data Types.mp4

03:08

20 - Excel-VBA-Data-Types.pdf

21 - Variables Coding Lesson.mp4

12:07

22 - Excel VBA Constants.mp4

07:29

23 - Option Explicit in VBA.mp4

06:16

7 - Font Object

24 - Font Object Coding Lesson.mp4

23:27

8 - With End With Statement

25 - With End With Statement.mp4

07:36

9 - Set Statement

26 - Set Statement.mp4

09:31

10 - Excel VBA BuiltIn Functions

27 - Format Function.mp4

13:21

28 - String Functions Part I.mp4

08:15

29 - String Functions Part II.mp4

13:13

30 - Date and Time functions Part I.mp4

08:48

31 - Date and Time functions Part II.mp4

14:40

32 - Excel VBA Round Function.mp4

05:52

11 - WorksheetFunction Object

33 - WorksheetFunction.mp4

10:42

12 - User Defined Functions

34 - User Defined Functions.mp4

05:37

35 - The Call Statement Calling Functions andor SubProcedures.mp4

11:14

13 - Protecting your Macros

36 - Protecting your Macros.mp4

02:01

14 - Excel VBA Key Methods

37 - RangeReplace Method.mp4

02:33

38 - RangeSort Method.mp4

02:05

39 - RangeRemove Duplicates Method.mp4

09:41

40 - RangeAutoFilter Method.mp4

07:33

41 - RangeFind Method.mp4

08:15

15 - Conditional Statements for Decision Making

42 - If Statement.mp4

14:38

43 - Nested If Statements.mp4

09:12

44 - Select Case Statement.mp4

11:02

45 - Nested Select Case Statements.mp4

08:36

16 - Excel VBA Loops

46 - Do While Loop.mp4

07:36

47 - Do Until Loop.mp4

07:14

48 - For Next Loop Part I.mp4

07:56

49 - For Next Loop Part II.mp4

13:52

50 - For Each Loop.mp4

15:28

17 - Automating Pivot Tables and Pivot Charts dynamically in VBA

51 - Automate Pivot Tables in VBA.mp4

17:55

52 - Automate Pivot Charts.mp4

09:34

18 - ArrayLists in Excel VBA

53 - Installing-Net-Framework-version-3.5.pdf

53 - VBA ArrayList Part I.mp4

10:45

54 - VBA ArrayList Part II.mp4

09:01

55 - VBA ArrayList Part III.mp4

08:26

19 - Excel VBA Dictionaries

56 - VBA Dictionaries Part I.mp4

16:50

57 - VBA Dictionaries Part II.mp4

08:16

58 - VBA Dictionaries Part III.mp4

08:46

20 - Automating Microsoft Word from Excel

59 - Microsoft Word Automation from Excel Part I.mp4

07:25

60 - Microsoft Word Automation from Excel Part II.mp4

08:19

21 - Working with csv Files in VBA

61 - Extract Data from another Workbook and save file as csv File.mp4

10:02

62 - Reading from csv File and convert it to a different Excel Extension.mp4

06:58

22 - Final HR File

63 - Final File.html

63 - final-hr-file.zip

23 - Error Handling and Err Object in VBA

64 - ErrorHandling.xlsx

64 - Error Handling.mp4

22:24

65 - Err Object and Error Handling.mp4

11:48

Description

Embrace the Magic of Excel VBA Automation

What You'll Learn?

How to improve your productivity by automating repetitive tasks in a single click.
How to Debug a code to understand what a code does, fix possible issues and make sure your code does exactly what you need it to do.
How use Excel VBA Dictionary
How to use ArrayList in Excel VBA with examples.
How to programmatically create Pivot Tables and Pivot Charts in Excel VBA.
How to use loops in Excel VBA (While Loop, do While Loop, For Loop and For Each Loop).
How to make decisions using the If statement (else, ElseIf, nested if statements), and case statements (Case else, nested case statements).
How to use Excel VBA user Defined Functions to avoid writing too much repetitive code.
How to control Word from Excel (Automate MS Word from Excel using Excel VBA)
How to use the font object.
How to use dynamic code.
How to work with csv files.
How to work with multiple workbooks

Who is this for?

Business Analysts

Reporting Analysts

Data Analyst

Any Excel user who wants to start automating complex and repetitive tasks

More details

Description
By taking this course on Udemy, you will gain knowledge on the following:
How to:
1. Create dynamic code in your automations.
2. Become more efficient and get more time to focus on other assignments as you will be able to execute complex tasks in a single click.
3. Create Pivot Tables programmatically.
4. Create Pivot Charts programmatically.
5. Use methods such as: Replace, Sort, Remove Duplicates, AutoFilter and Find in Excel VBA to dynamically find columns names, rather than fixed column positions in a data set.
6. Easily Automate Microsoft Word from Excel and Integrate your Excel data into your Word Automation.
7. Use Excel VBA Dictionaries
8. Use ArrayLists to improve the efficiency of your codes.
9. Use If statements, Nested If statements, Else and ElseIf Statement in Excel VBA.
10. Use case statements and nested case statements.
11. Use Excel VBA loops, including: While Loop, Do While Loop, For Next Loop and For Each Loop.
12. Use advanced decision making logics along with Excel VBA Loops to create advanced and flexible codes in Excel VBA.
13. Master the debugging process of an Excel VBA application to understand what your code does and how it does it.

The List above contains just some of the many benefits and advantages that Excel VBA brings to the table.
Who this course is for:
Business Analysts
Reporting Analysts
Data Analyst
Any Excel user who wants to start automating complex and repetitive tasks

User Reviews

Rating

average 0

Total votes0

Focused display

Excel VBA

Jose D. Sevilla

Instructor's Courses

Jose D. Sevilla, is an experienced Software Developer who is a Lifelong learner that applies programming knowledge to solve work related problems by developing automation tools in different programming languages. Jose D. Sevilla holds the following certifications: Oracle Certified Java SE 8 Programmer Oracle PL/SQL Developer CertifiedOracle SQL Database CertifiedCisco CCNA CertifiedAdditionally Jose D. Sevilla Development experience include the following:Oracle Application Express (Data Modeling, Data Security, Web Security, HTML, CSS, jQuery js Library)Oracle DatabaseOracle SQLOracle PLSQLJava Developer: Advanced Core Java (8, 11), Spring Framework, Spring Boot, Spring Data JPA (Java Persistent API), Rest API with Spring, ORM, Hibernate, JDBC, Selenium API, TestNg, JavaFx, Apache POI, Maven (software project management and comprehension tool).MySQL DatabaseAngularjQueryHTMLCSSExcel VBA

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.