Excel VBA and Macros - Beginner to Professional
Focused View
9:47:04
14 View
1.1 Resources with Code.zip
1.2 Resources without Code.zip
1. 1.1 Course Structure and Resources.mp4
03:10
1. 2.0 What are Macros & VBA.mp4
02:54
2. 2.1 The Developer Tab.mp4
02:06
3.1 2.2 Recording and running a Macro - WithoutCode.xlsx
3.2 2.2 recording and running a macro.zip
3. 2.2 Recording and running a Macro.mp4
07:28
4.1 2.3 Relative References - WithoutCode.xlsx
4.2 2.3 relative references.zip
4. 2.3 Relative References.mp4
04:54
5.1 2.4 Macro Buttons - WithoutCode.xlsx
5.2 2.4 macro buttons.zip
5. 2.4 Macro Buttons.mp4
03:51
6.1 2.5 Creating simple macros -WithoutCode.xlsx
6.2 2.5 creating simple macros.zip
6. 2.5 Creating simple macros.mp4
13:57
7.1 2.6 VBA interface - WithoutCode.xlsx
7.2 2.6 vba interface.zip
7. 2.6 VBA interface.mp4
06:52
8.1 2.7 A look at the code - WithoutCode.xlsx
8.2 2.7 a look at the code.zip
8. 2.7 A look at the code.mp4
05:38
9.1 2.8 Editing the code - WithoutCode.xlsx
9.2 2.8 editing the code.zip
9. 2.8 Editing the code.mp4
07:16
10.1 2.9 Debugging the code - WithoutCode.xlsx
10.2 2.9 debugging the code.zip
10. 2.9 Debugging the code.mp4
05:59
11.1 2.10 VBA Language grammar - WithoutCode.xlsx
11.2 2.10 vba language grammar.zip
11. 2.10 VBA Language grammar.mp4
20:44
1. 3.0 Introduction.mp4
01:55
2.1 3.1 - Color Code Concept.pdf
2. 3.1 Code Concept - Colors In VBA (Green, Black, Blue , Red).mp4
04:16
3.1 3.2 - VBA Object Model.pdf
3. 3.2 VBA Object Model.mp4
08:31
4.1 3.3 - VBA Functions Guide.xlsx
4.2 3.3 - VBA Functions.pdf
4. 3.3 Functions in VBA.mp4
03:44
5.1 3.4 - VBA Shortcuts.pdf
5.2 3.4 - VBA Shortcuts.xlsx
5. 3.4 Shortcuts in VBA.mp4
02:13
1. 4.0 Introduction.mp4
01:01
2.1 4.1 selecting cells - withoutcode.zip
2.2 4.1 selecting cells.zip
2. 4.1 Selecting Cells.mp4
09:16
3.1 4.2 selecting ranges - withoutcode.zip
3.2 4.2 selecting ranges.zip
3. 4.2 Selecting Ranges.mp4
13:13
4.1 4.3 copy and pasting - withoutcode.zip
4.2 4.3 copy and pasting.zip
4. 4.3 Copy and Pasting.mp4
14:33
5.1 4.4 clearing data - withoutcode.zip
5.2 4.4 clearing data.zip
5. 4.4 Clearing data.mp4
03:41
6.1 4.5 sorting -withoutcode.zip
6.2 4.5 sorting.zip
6. 4.5 Sorting.mp4
07:34
7.1 4.6 filtering -withoutcode.zip
7.2 4.6 filtering.zip
7. 4.6 Filtering.mp4
10:31
8.1 4.7 visible cells -withoutcode.zip
8.2 4.7 visible cells.zip
8. 4.7 Visible Cells.mp4
06:59
9.1 4.8 referencing worksheets - withoutcode.zip
9.2 4.8 referencing worksheets.zip
9. 4.8 Referencing worksheets.mp4
08:21
1.1 5.0 - What are Variables.pdf
1. 5.0 Introduction - What are Variables.mp4
06:49
2.1 5.1 Variable Data types in VBA.pdf
2.2 5.1 Variable Data types in VBA.xlsx
2. 5.1 Variable Data Types in VBA.mp4
03:53
3.1 5.2 - number variables.zip
3. 5.2 Number Variables - Small Numbers - Big Numbers - Decimals.mp4
12:33
4.1 5.3 option explicit - withoutcode.zip
4.2 5.3 option explicit.zip
4. 5.3 Options Explicit - Automatic Variable Check.mp4
03:33
5.1 5.4 - variable scope - withoutcode.zip
5.2 5.4 - Variable Scope.pdf
5.3 5.4 - variable scope.zip
5. 5.4 What is the scope of a Variable.mp4
09:12
6.1 5.5 Arrays Overview.pdf
6. 5.5 Arrays - Overview.mp4
02:03
7.1 5.6 arrays - one dimensional (filling) - withoutcode.zip
7.2 5.6 arrays - one dimensional (filling).zip
7. 5.6 Arrays - One Dimensional (Filling).mp4
11:36
8.1 5.7 arrays - one dimensional (empty to excel) - withoutcode.zip
8.2 5.7 arrays - one dimensional (empty to excel).zip
8. 5.7 Arrays - One Dimensional (Empty to Excel).mp4
08:32
9.1 5.8 Arrays - One Dimensional (Empty to Excel) Final.mp4
08:32
9.2 5.8 arrays - one dimensional (reading from array) - withoutcode.zip
9.3 5.8 arrays - one dimensional (reading from array).zip
9. 5.8 Arrays - One Dimensional (Reading from Array).mp4
10:23
10.1 5.9 arrays - two dimensional (filling) - withoutcode.zip
10.2 5.9 arrays - two dimensional (filling).zip
10. 5.9 Arrays - Two Dimensional (Filling).mp4
04:34
11.1 5.10 arrays - two dimensional (empty to excel) -without code.zip
11.2 5.10 arrays - two dimensional (empty to excel).zip
11. 5.10 Arrays - Two Dimensional (Empty to Excel).mp4
04:34
12.1 5.11 arrays - two dimensional (reading from array) -withoutcode.zip
12.2 5.11 arrays - two dimensional (reading from array).zip
12. 5.11 Arrays - Two Dimensional (Reading from Array).mp4
10:26
1.1 6.0 Input Box - What is it.pdf
1. 6.0 The Input Box - What is it.mp4
02:04
2.1 6.1 input box - example 1 - withoutcode.zip
2.2 6.1 input box - example 1.zip
2. 6.1 Input Box - example 1.mp4
04:05
3.1 6.2 input box - example 2 - withoutcode.zip
3.2 6.2 input box - example 2.zip
3. 6.2 Input Box - example 2.mp4
04:16
4.1 6.3 input box - example 3 - withoutcode.zip
4.2 6.3 input box - example 3.zip
4. 6.3 Input Box - example 3.mp4
05:30
5.1 6.4 Message Box - What is it.pdf
5. 6.4 The Message Box - What is it.mp4
01:42
6.1 6.5 message box - example 1 - withoutcode.zip
6.2 6.5 message box - example 1.zip
6. 6.5 Message Box - example 1.mp4
02:24
7.1 6.6 message box - example 2 - withoutcode.zip
7.2 6.6 message box - example 2.zip
7. 6.6 Message Box - example 2.mp4
06:24
8.1 6.7 message box - example 3 - withoutcode.zip
8.2 6.7 message box - example 3.zip
8. 6.7 Message Box - example 3.mp4
08:20
1.1 7.0 - IF Statement.pdf
1. 7.0 IF Statement Introduction.mp4
03:01
2.1 7.1 if statement - withoutcode.zip
2.2 7.1 if statement.zip
2. 7.1 IF Statement.mp4
12:49
3.1 7.2 if + goto statement - withoutcode.zip
3.2 7.2 if + goto statement.zip
3. 7.2 IF + GOTO Statement.mp4
05:42
4.1 7.3 if + or, if + and statement -withoutcode.zip
4.2 7.3 if + or, if + and statement.zip
4. 7.3 IF + OR, IF + AND Statement.mp4
06:34
1.1 8.0 - What are loops in VBA.pdf
1. 8.0 What are Loops in VBA.mp4
05:57
2.1 8.1 example 1. for loops - getting started - withoutcode.zip
2.2 8.1 example 1. for loops - getting started.zip
2. 8.1 For Loops - Getting Started.mp4
05:32
3.1 8.2 example 2. for loops - looping through worksheet in the workbook - withoutcode.zip
3.2 8.2 example 2. for loops - looping through worksheet in the workbook.zip
3. 8.2 For Loops - Looping through Worksheets in the workbook.mp4
06:42
4.1 8.3 exmaple 3. for loops - looping through cell in a range - withoutcode.zip
4.2 8.3 exmaple 3. for loops - looping through cell in a range.zip
4. 8.3 For Loops - Looping Through Cell in a Range.mp4
02:24
5.1 8.4 example 2. do loops - getting started - withoutcode.zip
5.2 8.4 example 2. do loops - getting started.zip
5. 8.4 Do Loops - Getting Started.mp4
06:29
6.1 8.5 example 3. loops inside another loops - withoutcode.zip
6.2 8.5 example 3. loops inside another loops.zip
6. 8.5 Loops within Loops.mp4
08:55
7.1 8.6 example 4. loops & if statements - withoutcode.zip
7.2 8.6 example 4. loops & if statements.zip
7. 8.6 Loops & IF Statements.mp4
05:50
8.1 8.7 example 5. loops & arrays - withoutcode.zip
8.2 8.7 example 5. loops & arrays.zip
8. 8.7 Loops & Arrays.mp4
11:44
1. 9.0 Combining Concepts Introduction.mp4
01:17
2.1 9.1 hardcode and save - withoutcode.zip
2.2 9.1 hardcode and save.zip
2. 9.1 Hard code all values within your workbook and Save file.mp4
09:32
3.1 9.2 - Finding the last Row-Column-Cell.pdf
3.2 9.2 finding the last row-column-cell - withoutcode.zip
3.3 9.2 finding the last row-column-cell.zip
3. 9.2 Finding the last worksheet row-column-cell.mp4
15:58
4.1 9.3 - Compare Two Datasets.pdf
4.2 9.3 comparing two datasets - without code.zip
4.3 9.3 comparing two datasets.zip
4. 9.3 Comparing two datasets and returning the top results.mp4
31:34
1.1 10.0 Custom Functions - What are they.pdf
1. 10.0 Custom Functions - What are they.mp4
02:08
2.1 10.1 setting up a custom function - withoutcode.zip
2.2 10.1 setting up a custom function.zip
2. 10.1 Setting up a custom function.mp4
06:10
3.1 10.2 custom functions - countcell colors.zip
3.2 10.2custom functions - countcell colors - withoutcode.zip
3. 10.2 Custom Functions - CountCell Colors.mp4
07:44
4.1 10.3 custom functions - split letters and numbers - withoutcode.zip
4.2 10.3 custom functions - split letters and numbers.zip
4. 10.3 Custom Functions - Split Letters and Numbers.mp4
10:51
5.1 10.4 custom functions - within sub procedure withoutcode.zip
5.2 10.4 custom functions - within sub procedure.zip
5. 10.4 Custom Functions - Within Sub Procedure.mp4
03:34
1. 11.0 Beyond the worksheet - Introduction.mp4
01:38
2.1 11.1 check if a folder exists - create a folder - withoutcode.zip
2.2 11.1 check if a folder exists - create a folder.zip
2. 11.1 Check if a folder exists - Create a folder.mp4
09:54
3.1 11.2 check if a file exists - create a file - withoutcode.zip
3.2 11.2 check if a file exists - create a file.zip
3. 11.2 Check if a file exists - Create a file.mp4
09:43
4.1 11.3 delete a file - all files in a folder - withoutcode.zip
4.2 11.3 delete a file - all files in a folder.zip
4. 11.3 Delete a File - all Files in a folder - a Folder.mp4
10:59
5.1 11.4 rename a file - multiple files - withoutcode.zip
5.2 11.4 rename a file - multiple files.zip
5. 11.4 Rename a File - Multiple Files.mp4
09:56
6.1 11.5 copy & rename a file(s) -withoutcode.zip
6.2 11.5 copy & rename a file(s).zip
6. 11.5 Copy & Rename a File(s).mp4
06:00
7.1 11.6 extract data from a file - all files in a folder -withoutcode.zip
7.2 11.6 extract data from a file - all files in a folder.zip
7. 11.6 Extract Data from a file - All Files in a folder.mp4
17:44
8.1 11.7 divide a file into multiple files - withoutcode.zip
8.2 11.7 divide a file into multiple files.zip
8. 11.7 Divide a file Into multiple files.mp4
05:39
9.1 11.8 create a pdf report (single and multi page) - withoutcode.zip
9.2 11.8 create a pdf report (single and multi page).zip
9. 11.8 Create a PDF Report (Single and Multi Page).mp4
10:38
10.1 11.9 send emails with vba outlook - withoutcode .zip
10.2 11.9 send emails with vba outlook .zip
10. 11.9 Send Emails with VBA Outlook (Audience, Attachments, Subject, Email Body, t.mp4
21:16
1. Final Words.mp4
01:08
More details
User Reviews
Rating
average 0
Focused display
Udemy
View courses UdemyStudents 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.
- language english
- Training sessions 79
- duration 9:47:04
- English subtitles has
- Release Date 2024/02/15
