|
|
1. Congratulations! You're an Excel MacroVBA Master.mp4
|
MP4
|
4.7 MB
|
|
|
1. Congratulations! You're an Excel MacroVBA Master.srt
|
SRT
|
1.1 KB
|
|
|
1. Congratulations! You're an Excel MacroVBA Master.vtt
|
VTT
|
1.1 KB
|
|
|
1. Excel VBA Concepts.mp4
|
MP4
|
9.8 MB
|
|
|
1. Excel VBA Concepts.srt
|
SRT
|
4.7 KB
|
|
|
1. Excel VBA Concepts.vtt
|
VTT
|
4.1 KB
|
|
|
1. Introduction to Project #1 - Inserting and Formatting Text.mp4
|
MP4
|
6.4 MB
|
|
|
1. Introduction to Project #1 - Inserting and Formatting Text.srt
|
SRT
|
2.7 KB
|
|
|
1. Introduction to Project #1 - Inserting and Formatting Text.vtt
|
VTT
|
2.4 KB
|
|
|
1. Introduction to Project #2 - Interacting with the User.mp4
|
MP4
|
9.9 MB
|
|
|
1. Introduction to Project #2 - Interacting with the User.srt
|
SRT
|
3.9 KB
|
|
|
1. Introduction to Project #2 - Interacting with the User.vtt
|
VTT
|
3.4 KB
|
|
|
1. Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets.mp4
|
MP4
|
10.7 MB
|
|
|
1. Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets.srt
|
SRT
|
4.7 KB
|
|
|
1. Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets.vtt
|
VTT
|
4 KB
|
|
|
1. Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA.mp4
|
MP4
|
7.5 MB
|
|
|
1. Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA.srt
|
SRT
|
3.1 KB
|
|
|
1. Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA.vtt
|
VTT
|
2.7 KB
|
|
|
1. Introduction to Project #5 - Creating a Final Report.mp4
|
MP4
|
11 MB
|
|
|
1. Introduction to Project #5 - Creating a Final Report.srt
|
SRT
|
4.9 KB
|
|
|
1. Introduction to Project #5 - Creating a Final Report.vtt
|
VTT
|
4.2 KB
|
|
|
1. Introduction to Project #6 - Working with Excel VBA Forms.mp4
|
MP4
|
8.8 MB
|
|
|
1. Introduction to Project #6 - Working with Excel VBA Forms.srt
|
SRT
|
4.2 KB
|
|
|
1. Introduction to Project #6 - Working with Excel VBA Forms.vtt
|
VTT
|
3.7 KB
|
|
|
1. Project #7 Opening a Text File for Import.mp4
|
MP4
|
11.5 MB
|
|
|
1. Project #7 Opening a Text File for Import.srt
|
SRT
|
9.4 KB
|
|
|
1. Project #7 Opening a Text File for Import.vtt
|
VTT
|
8.7 KB
|
|
|
1. Welcome to the Course.mp4
|
MP4
|
16.5 MB
|
|
|
1. Welcome to the Course.srt
|
SRT
|
8.3 KB
|
|
|
1. Welcome to the Course.vtt
|
VTT
|
7.3 KB
|
|
|
1.1 Dec2015Sales.txt.txt
|
TXT
|
1.1 KB
|
|
|
1.1 QuarterlyReportForm-01.xlsm.xlsm
|
XLSM
|
29.7 KB
|
|
|
1.2 May2015Sales.txt.txt
|
TXT
|
1.2 KB
|
|
|
1.3 Jan2015Sales.txt.txt
|
TXT
|
1.2 KB
|
|
|
1.4 April2015Sales.txt.txt
|
TXT
|
1.8 KB
|
|
|
1.5 Feb2015Sales.txt.txt
|
TXT
|
1.2 KB
|
|
|
1.6 Mar2015Sales.txt.txt
|
TXT
|
1.2 KB
|
|
|
1.7 Nov2015Sales.txt.txt
|
TXT
|
1.3 KB
|
|
|
10. Project #6 Showing the Form.mp4
|
MP4
|
12.4 MB
|
|
|
10. Project #6 Showing the Form.srt
|
SRT
|
5.3 KB
|
|
|
10. Project #6 Showing the Form.vtt
|
VTT
|
4.6 KB
|
|
|
11. Project #6 - Quiz - Test Your Knowledge on Creating Excel VBA Forms.html
|
HTML
|
204.8 B
|
|
|
12. Project #6 - Exercise - Try it Yourself and Practice.pdf
|
PDF
|
279.8 KB
|
|
|
12.1 QuarterlyReportForm-01.xlsm.xlsm
|
XLSM
|
29.7 KB
|
|
|
13. Introduction to Project #7 Importing Data from a Text File(s).mp4
|
MP4
|
5.4 MB
|
|
|
13. Introduction to Project #7 Importing Data from a Text File(s).srt
|
SRT
|
4.2 KB
|
|
|
13. Introduction to Project #7 Importing Data from a Text File(s).vtt
|
VTT
|
3.9 KB
|
|
|
2. BONUS! - Special Offer! Discount on Any of my Courses!.html
|
HTML
|
2.6 KB
|
|
|
2. Project #1 - Start Recording!.mp4
|
MP4
|
24.4 MB
|
|
|
2. Project #1 - Start Recording!.srt
|
SRT
|
10.7 KB
|
|
|
2. Project #1 - Start Recording!.vtt
|
VTT
|
9.3 KB
|
|
|
2. Project #2 - Breaking Down the VBA Code.mp4
|
MP4
|
12 MB
|
|
|
2. Project #2 - Breaking Down the VBA Code.srt
|
SRT
|
4.7 KB
|
|
|
2. Project #2 - Breaking Down the VBA Code.vtt
|
VTT
|
4.2 KB
|
|
|
2. Project #3 Preparing to use the Macro Recorder.mp4
|
MP4
|
9.5 MB
|
|
|
2. Project #3 Preparing to use the Macro Recorder.srt
|
SRT
|
4.1 KB
|
|
|
2. Project #3 Preparing to use the Macro Recorder.vtt
|
VTT
|
3.5 KB
|
|
|
2. Project #4 Automate the SUM Function through Code.mp4
|
MP4
|
48.1 MB
|
|
|
2. Project #4 Automate the SUM Function through Code.srt
|
SRT
|
10.9 KB
|
|
|
2. Project #4 Automate the SUM Function through Code.vtt
|
VTT
|
9.3 KB
|
|
|
2. Project #6 Creating an Excel VBA Form.mp4
|
MP4
|
15.1 MB
|
|
|
2. Project #6 Creating an Excel VBA Form.srt
|
SRT
|
7.6 KB
|
|
|
2. Project #6 Creating an Excel VBA Form.vtt
|
VTT
|
6.6 KB
|
|
|
2. Project #7 Get Data from Text File.mp4
|
MP4
|
8.9 MB
|
|
|
2. Project #7 Get Data from Text File.srt
|
SRT
|
8.2 KB
|
|
|
2. Project #7 Get Data from Text File.vtt
|
VTT
|
7.6 KB
|
|
|
2. Project 5 Creating the Final Report Loop.mp4
|
MP4
|
47.8 MB
|
|
|
2. Project 5 Creating the Final Report Loop.srt
|
SRT
|
11.9 KB
|
|
|
2. Project 5 Creating the Final Report Loop.vtt
|
VTT
|
10.2 KB
|
|
|
2. The Visual Basic Editor.mp4
|
MP4
|
9.4 MB
|
|
|
2. The Visual Basic Editor.srt
|
SRT
|
4.9 KB
|
|
|
2. The Visual Basic Editor.vtt
|
VTT
|
4.3 KB
|
|
|
2. Understanding the Why and How Behind Excel Macros.mp4
|
MP4
|
14.9 MB
|
|
|
2. Understanding the Why and How Behind Excel Macros.srt
|
SRT
|
7.4 KB
|
|
|
2. Understanding the Why and How Behind Excel Macros.vtt
|
VTT
|
6.4 KB
|
|
|
2.1 AutomateSumFunction.xlsx.xlsx
|
XLSX
|
19.8 KB
|
|
|
2.1 InsertingAndFormattingText.xlsx.xlsx
|
XLSX
|
17.4 KB
|
|
|
2.1 SortingRecords.xlsm.xlsm
|
XLSM
|
31.8 KB
|
|
|
3. Excel VBA Modules.mp4
|
MP4
|
5.4 MB
|
|
|
3. Excel VBA Modules.srt
|
SRT
|
2.6 KB
|
|
|
3. Excel VBA Modules.vtt
|
VTT
|
2.2 KB
|
|
|
3. Project #2 - Prompting the User for Information.mp4
|
MP4
|
39.3 MB
|
|
|
3. Project #2 - Prompting the User for Information.srt
|
SRT
|
9.2 KB
|
|
|
3. Project #2 - Prompting the User for Information.vtt
|
VTT
|
8 KB
|
|
|
3. Project #3 - Inserting the Headers.mp4
|
MP4
|
11.1 MB
|
|
|
3. Project #3 - Inserting the Headers.srt
|
SRT
|
5.4 KB
|
|
|
3. Project #3 - Inserting the Headers.vtt
|
VTT
|
4.6 KB
|
|
|
3. Project #4 - Continue Automate SUM Function.mp4
|
MP4
|
32.7 MB
|
|
|
3. Project #4 - Continue Automate SUM Function.srt
|
SRT
|
8 KB
|
|
|
3. Project #4 - Continue Automate SUM Function.vtt
|
VTT
|
6.9 KB
|
|
|
3. Project #5 - Copying and Pasting Data with VBA.mp4
|
MP4
|
55.3 MB
|
|
|
3. Project #5 - Copying and Pasting Data with VBA.srt
|
SRT
|
13 KB
|
|
|
3. Project #5 - Copying and Pasting Data with VBA.vtt
|
VTT
|
11.1 KB
|
|
|
3. Project #6 Adding Controls to the Form.mp4
|
MP4
|
11.6 MB
|
|
|
3. Project #6 Adding Controls to the Form.srt
|
SRT
|
5.3 KB
|
|
|
3. Project #6 Adding Controls to the Form.vtt
|
VTT
|
4.6 KB
|
|
|
3. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4
|
MP4
|
16.3 MB
|
|
|
3. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.srt
|
SRT
|
12.6 KB
|
|
|
3. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.vtt
|
VTT
|
11.7 KB
|
|
|
3. Running A Macro.mp4
|
MP4
|
8.6 MB
|
|
|
3. Running A Macro.srt
|
SRT
|
4 KB
|
|
|
3. Running A Macro.vtt
|
VTT
|
3.4 KB
|
|
|
4. Continue Excel VBA InputBox.mp4
|
MP4
|
39.3 MB
|
|
|
4. Continue Excel VBA InputBox.srt
|
SRT
|
8.9 KB
|
|
|
4. Continue Excel VBA InputBox.vtt
|
VTT
|
7.7 KB
|
|
|
4. Creating Excel VBA Procedures.mp4
|
MP4
|
43.2 MB
|
|
|
4. Creating Excel VBA Procedures.srt
|
SRT
|
10.5 KB
|
|
|
4. Creating Excel VBA Procedures.vtt
|
VTT
|
9.1 KB
|
|
|
4. Project #1 - Running a Macro with a Button.mp4
|
MP4
|
11 MB
|
|
|
4. Project #1 - Running a Macro with a Button.srt
|
SRT
|
5.3 KB
|
|
|
4. Project #1 - Running a Macro with a Button.vtt
|
VTT
|
4.5 KB
|
|
|
4. Project #3 - Formatting the Headers.mp4
|
MP4
|
7.5 MB
|
|
|
4. Project #3 - Formatting the Headers.srt
|
SRT
|
3.4 KB
|
|
|
4. Project #3 - Formatting the Headers.vtt
|
VTT
|
2.9 KB
|
|
|
4. Project #4 - Test the SUM Function.mp4
|
MP4
|
12.4 MB
|
|
|
4. Project #4 - Test the SUM Function.srt
|
SRT
|
5.3 KB
|
|
|
4. Project #4 - Test the SUM Function.vtt
|
VTT
|
4.6 KB
|
|
|
4. Project #5 - Running the Final Report Procedure.mp4
|
MP4
|
11.4 MB
|
|
|
4. Project #5 - Running the Final Report Procedure.srt
|
SRT
|
4.4 KB
|
|
|
4. Project #5 - Running the Final Report Procedure.vtt
|
VTT
|
3.8 KB
|
|
|
4. Project #6 Changing Control and Form Properties.mp4
|
MP4
|
15 MB
|
|
|
4. Project #6 Changing Control and Form Properties.srt
|
SRT
|
7.6 KB
|
|
|
4. Project #6 Changing Control and Form Properties.vtt
|
VTT
|
7 KB
|
|
|
4. Project #7 Creating a Loop to Read Each File.mp4
|
MP4
|
14.5 MB
|
|
|
4. Project #7 Creating a Loop to Read Each File.srt
|
SRT
|
11.1 KB
|
|
|
4. Project #7 Creating a Loop to Read Each File.vtt
|
VTT
|
10.2 KB
|
|
|
5. Adding Code to a VBA Procedure.mp4
|
MP4
|
11.7 MB
|
|
|
5. Adding Code to a VBA Procedure.srt
|
SRT
|
5.1 KB
|
|
|
5. Adding Code to a VBA Procedure.vtt
|
VTT
|
4.4 KB
|
|
|
5. Project #1 - Opps! I Need to Edit My Macro.mp4
|
MP4
|
14.2 MB
|
|
|
5. Project #1 - Opps! I Need to Edit My Macro.srt
|
SRT
|
6.2 KB
|
|
|
5. Project #1 - Opps! I Need to Edit My Macro.vtt
|
VTT
|
5.4 KB
|
|
|
5. Project #2 Building Logic in Your Macros.mp4
|
MP4
|
14.8 MB
|
|
|
5. Project #2 Building Logic in Your Macros.srt
|
SRT
|
5.6 KB
|
|
|
5. Project #2 Building Logic in Your Macros.vtt
|
VTT
|
4.8 KB
|
|
|
5. Project #3 - Putting it all Together with alittle VBA Magic.mp4
|
MP4
|
65.5 MB
|
|
|
5. Project #3 - Putting it all Together with alittle VBA Magic.srt
|
SRT
|
14.5 KB
|
|
|
5. Project #3 - Putting it all Together with alittle VBA Magic.vtt
|
VTT
|
12.5 KB
|
|
|
5. Project #4 Loop the SUM Function over Multiple Worksheets.mp4
|
MP4
|
36.1 MB
|
|
|
5. Project #4 Loop the SUM Function over Multiple Worksheets.srt
|
SRT
|
8.4 KB
|
|
|
5. Project #4 Loop the SUM Function over Multiple Worksheets.vtt
|
VTT
|
7.3 KB
|
|
|
5. Project #5 - Quiz - Test Your Knowledge of Creating the Final Report.html
|
HTML
|
204.8 B
|
|
|
5. Project #6 Adding VBA Code to the Initialize Event of the Form.mp4
|
MP4
|
44.5 MB
|
|
|
5. Project #6 Adding VBA Code to the Initialize Event of the Form.srt
|
SRT
|
11.6 KB
|
|
|
5. Project #6 Adding VBA Code to the Initialize Event of the Form.vtt
|
VTT
|
10 KB
|
|
|
5. Project #7 Adding a New Sheet for Imported Data.mp4
|
MP4
|
5.9 MB
|
|
|
5. Project #7 Adding a New Sheet for Imported Data.srt
|
SRT
|
3.5 KB
|
|
|
5. Project #7 Adding a New Sheet for Imported Data.vtt
|
VTT
|
3.3 KB
|
|
|
6. Project #2 - Alerting the User of Errors.mp4
|
MP4
|
59.9 MB
|
|
|
6. Project #2 - Alerting the User of Errors.srt
|
SRT
|
13.6 KB
|
|
|
6. Project #2 - Alerting the User of Errors.vtt
|
VTT
|
11.5 KB
|
|
|
6. Project #3 - Running the Loop.mp4
|
MP4
|
10.2 MB
|
|
|
6. Project #3 - Running the Loop.srt
|
SRT
|
4.4 KB
|
|
|
6. Project #3 - Running the Loop.vtt
|
VTT
|
3.8 KB
|
|
|
6. Project #4 - Quiz - Test Your Knowledge Automating a Function with VBA.html
|
HTML
|
204.8 B
|
|
|
6. Project #5 - Exercise - Try it Yourself and Practice.pdf
|
PDF
|
287.8 KB
|
|
|
6. Project #7 Clear the Clipboard.mp4
|
MP4
|
7.1 MB
|
|
|
6. Project #7 Clear the Clipboard.srt
|
SRT
|
5.4 KB
|
|
|
6. Project #7 Clear the Clipboard.vtt
|
VTT
|
5 KB
|
|
|
6. Project 6 Adding VBA Code to the ComboBox Change Event.mp4
|
MP4
|
24.3 MB
|
|
|
6. Project 6 Adding VBA Code to the ComboBox Change Event.srt
|
SRT
|
6.2 KB
|
|
|
6. Project 6 Adding VBA Code to the ComboBox Change Event.vtt
|
VTT
|
5.3 KB
|
|
|
6. Saving an Excel File that contains Macros.mp4
|
MP4
|
7.1 MB
|
|
|
6. Saving an Excel File that contains Macros.srt
|
SRT
|
2.8 KB
|
|
|
6. Saving an Excel File that contains Macros.vtt
|
VTT
|
2.4 KB
|
|
|
6. Understanding Excel VBA Variables.mp4
|
MP4
|
37.7 MB
|
|
|
6. Understanding Excel VBA Variables.srt
|
SRT
|
8.7 KB
|
|
|
6. Understanding Excel VBA Variables.vtt
|
VTT
|
7.6 KB
|
|
|
6.1 QuarterlyReport.xlsm.xlsm
|
XLSM
|
26.5 KB
|
|
|
7. Building Logic with an IF Statement.mp4
|
MP4
|
18.2 MB
|
|
|
7. Building Logic with an IF Statement.srt
|
SRT
|
8 KB
|
|
|
7. Building Logic with an IF Statement.vtt
|
VTT
|
6.9 KB
|
|
|
7. Other Practical Uses of Message Boxes and Input Boxes.mp4
|
MP4
|
12.8 MB
|
|
|
7. Other Practical Uses of Message Boxes and Input Boxes.srt
|
SRT
|
4.7 KB
|
|
|
7. Other Practical Uses of Message Boxes and Input Boxes.vtt
|
VTT
|
4.3 KB
|
|
|
7. Practical Uses of Excel Macros.mp4
|
MP4
|
10.2 MB
|
|
|
7. Practical Uses of Excel Macros.srt
|
SRT
|
3.2 KB
|
|
|
7. Practical Uses of Excel Macros.vtt
|
VTT
|
3 KB
|
|
|
7. Project #3 - Quiz - Test Your Knowledge on VBA.html
|
HTML
|
204.8 B
|
|
|
7. Project #4 - Exercise - Try it Yourself and Practice.pdf
|
PDF
|
286.8 KB
|
|
|
7. Project #6 Adding VBA Code to the Add Worksheet Button Click Event.mp4
|
MP4
|
10.1 MB
|
|
|
7. Project #6 Adding VBA Code to the Add Worksheet Button Click Event.srt
|
SRT
|
5 KB
|
|
|
7. Project #6 Adding VBA Code to the Add Worksheet Button Click Event.vtt
|
VTT
|
4.3 KB
|
|
|
7. Project #7 Working with the ScreenUpdating Property.mp4
|
MP4
|
7.3 MB
|
|
|
7. Project #7 Working with the ScreenUpdating Property.srt
|
SRT
|
4.9 KB
|
|
|
7. Project #7 Working with the ScreenUpdating Property.vtt
|
VTT
|
4.6 KB
|
|
|
7.1 AutomateSumFunction.xlsx.xlsx
|
XLSX
|
19.8 KB
|
|
|
8. Project #1 - Quiz - Test Your Knowledge on Using the Macro Recorder.html
|
HTML
|
204.8 B
|
|
|
8. Project #2 - Quiz - Test Your Knowledge on Editing Your Macros.html
|
HTML
|
204.8 B
|
|
|
8. Project #3 - Exercise - Try it Yourself and Practice.pdf
|
PDF
|
333.1 KB
|
|
|
8. Project #6 - Change Worksheet Name.mp4
|
MP4
|
11.7 MB
|
|
|
8. Project #6 - Change Worksheet Name.srt
|
SRT
|
5.7 KB
|
|
|
8. Project #6 - Change Worksheet Name.vtt
|
VTT
|
4.9 KB
|
|
|
8. Project #7 Creating Reusable Code with a VBA Function.mp4
|
MP4
|
15.1 MB
|
|
|
8. Project #7 Creating Reusable Code with a VBA Function.srt
|
SRT
|
10.9 KB
|
|
|
8. Project #7 Creating Reusable Code with a VBA Function.vtt
|
VTT
|
10.1 KB
|
|
|
8. Working Excel VBA Loops to repeat blocks of code.mp4
|
MP4
|
54.9 MB
|
|
|
8. Working Excel VBA Loops to repeat blocks of code.srt
|
SRT
|
13.4 KB
|
|
|
8. Working Excel VBA Loops to repeat blocks of code.vtt
|
VTT
|
11.5 KB
|
|
|
8.1 CleaningUpData.xlsx.xlsx
|
XLSX
|
20.8 KB
|
|
|
9. Project #1 - Exercise - Try it Yourself and Practice.pdf
|
PDF
|
342.7 KB
|
|
|
9. Project #2 - Exercise - Try it Yourself and Practice.pdf
|
PDF
|
288.9 KB
|
|
|
9. Project #6 Adding VBA Code to the Create Report Button Click Event.mp4
|
MP4
|
50 MB
|
|
|
9. Project #6 Adding VBA Code to the Create Report Button Click Event.srt
|
SRT
|
12.3 KB
|
|
|
9. Project #6 Adding VBA Code to the Create Report Button Click Event.vtt
|
VTT
|
10.6 KB
|
|
|
9. VBA Concepts - Quiz - Test Your Knowledge on VBA Programming Concepts.html
|
HTML
|
204.8 B
|
|
|
9.1 InsertingAndFormattingText.xlsx.xlsx
|
XLSX
|
17.4 KB
|
|
|
9.1 SortingRecords.xlsm.xlsm
|
XLSM
|
21.8 KB
|
|
|
[FTU Forum].url
|
URL
|
204.8 B
|
|
|
[FreeCoursesOnline.Me].url
|
URL
|
102.4 B
|
|
|
[FreeTutorials.Us].url
|
URL
|
102.4 B
|