FreeCourseSite com Udemy Master Microsoft Excel Macros and Excel VBA

FreeCourseSite com Udemy Master Microsoft Excel Macros and Excel VBA

Name	[FreeCourseSite.com] Udemy - Master Microsoft Excel Macros and Excel VBA	DOWNLOAD Copy Link
Total Size	1.2 GB
Total Files	211
Hash	9589B559F4CEFDCBBE045C3CA35B53130C21E7E6

/1. Course Introduction and Overview/
1. Welcome to the Course.mp4	17.3 MB
1. Welcome to the Course.srt	8.5 KB
1. Welcome to the Course.vtt	7.5 KB
2. Understanding the Why and How Behind Excel Macros.mp4	15.6 MB
2. Understanding the Why and How Behind Excel Macros.srt	7.5 KB
2. Understanding the Why and How Behind Excel Macros.vtt	6.5 KB
/10. Course Wrap Up/
1. Congratulations! You're an Excel MacroVBA Master.mp4	4.9 MB
1. Congratulations! You're an Excel MacroVBA Master.srt	1.2 KB
1. Congratulations! You're an Excel MacroVBA Master.vtt	1.1 KB
2. BONUS! - Special Offer! Discount on Any of my Courses!.html	2.6 KB
/2. Project #1 Using Excel's Macro Recorder Tool/
1. Introduction to Project #1 - Inserting and Formatting Text.mp4	6.7 MB
1. Introduction to Project #1 - Inserting and Formatting Text.srt	2.8 KB
1. Introduction to Project #1 - Inserting and Formatting Text.vtt	2.5 KB
2. Project #1 - Start Recording!.mp4	25.6 MB
2. Project #1 - Start Recording!.srt	10.9 KB
2. Project #1 - Start Recording!.vtt	9.5 KB
2.1 InsertingAndFormattingText.xlsx.xlsx	17.8 KB
3. Running A Macro.mp4	9.0 MB
3. Running A Macro.srt	4.1 KB
3. Running A Macro.vtt	3.5 KB
4. Project #1 - Running a Macro with a Button.mp4	11.6 MB
4. Project #1 - Running a Macro with a Button.srt	5.4 KB
4. Project #1 - Running a Macro with a Button.vtt	4.7 KB
5. Project #1 - Opps! I Need to Edit My Macro.mp4	14.8 MB
5. Project #1 - Opps! I Need to Edit My Macro.srt	6.3 KB
5. Project #1 - Opps! I Need to Edit My Macro.vtt	5.5 KB
6. Saving an Excel File that contains Macros.mp4	7.4 MB
6. Saving an Excel File that contains Macros.srt	2.8 KB
6. Saving an Excel File that contains Macros.vtt	2.5 KB
7. Practical Uses of Excel Macros.mp4	10.7 MB
7. Practical Uses of Excel Macros.srt	3.2 KB
7. Practical Uses of Excel Macros.vtt	3.0 KB
8. Project #1 - Quiz - Test Your Knowledge on Using the Macro Recorder.html	0.2 KB
9. Project #1 - Exercise - Try it Yourself and Practice.pdf	350.9 KB
9.1 InsertingAndFormattingText.xlsx.xlsx	17.8 KB
/3. Excel VBA Concepts/
1. Excel VBA Concepts.mp4	10.2 MB
1. Excel VBA Concepts.srt	4.8 KB
1. Excel VBA Concepts.vtt	4.2 KB
2. The Visual Basic Editor.mp4	9.9 MB
2. The Visual Basic Editor.srt	5.0 KB
2. The Visual Basic Editor.vtt	4.4 KB
3. Excel VBA Modules.mp4	5.7 MB
3. Excel VBA Modules.srt	2.6 KB
3. Excel VBA Modules.vtt	2.3 KB
4. Creating Excel VBA Procedures.mp4	45.3 MB
4. Creating Excel VBA Procedures.srt	10.7 KB
4. Creating Excel VBA Procedures.vtt	9.3 KB
5. Adding Code to a VBA Procedure.mp4	12.3 MB
5. Adding Code to a VBA Procedure.srt	5.2 KB
5. Adding Code to a VBA Procedure.vtt	4.5 KB
6. Understanding Excel VBA Variables.mp4	39.5 MB
6. Understanding Excel VBA Variables.srt	8.9 KB
6. Understanding Excel VBA Variables.vtt	7.8 KB
7. Building Logic with an IF Statement.mp4	19.1 MB
7. Building Logic with an IF Statement.srt	8.2 KB
7. Building Logic with an IF Statement.vtt	7.1 KB
8. Working Excel VBA Loops to repeat blocks of code.mp4	57.6 MB
8. Working Excel VBA Loops to repeat blocks of code.srt	13.7 KB
8. Working Excel VBA Loops to repeat blocks of code.vtt	11.8 KB
9. VBA Concepts - Quiz - Test Your Knowledge on VBA Programming Concepts.html	0.2 KB
/4. Project #2 Moving Beyond the Basics and Into VBA/
1. Introduction to Project #2 - Interacting with the User.mp4	10.4 MB
1. Introduction to Project #2 - Interacting with the User.srt	4.0 KB
1. Introduction to Project #2 - Interacting with the User.vtt	3.5 KB
2. Project #2 - Breaking Down the VBA Code.mp4	12.6 MB
2. Project #2 - Breaking Down the VBA Code.srt	4.8 KB
2. Project #2 - Breaking Down the VBA Code.vtt	4.3 KB
2.1 SortingRecords.xlsm.xlsm	32.5 KB
3. Project #2 - Prompting the User for Information.mp4	41.2 MB
3. Project #2 - Prompting the User for Information.srt	9.4 KB
3. Project #2 - Prompting the User for Information.vtt	8.2 KB
4. Continue Excel VBA InputBox.mp4	41.2 MB
4. Continue Excel VBA InputBox.srt	9.1 KB
4. Continue Excel VBA InputBox.vtt	7.9 KB
5. Project #2 Building Logic in Your Macros.mp4	15.5 MB
5. Project #2 Building Logic in Your Macros.srt	5.7 KB
5. Project #2 Building Logic in Your Macros.vtt	5.0 KB
6. Project #2 - Alerting the User of Errors.mp4	62.9 MB
6. Project #2 - Alerting the User of Errors.srt	13.9 KB
6. Project #2 - Alerting the User of Errors.vtt	11.8 KB
7. Other Practical Uses of Message Boxes and Input Boxes.mp4	13.4 MB
7. Other Practical Uses of Message Boxes and Input Boxes.srt	4.8 KB
7. Other Practical Uses of Message Boxes and Input Boxes.vtt	4.5 KB
8. Project #2 - Quiz - Test Your Knowledge on Editing Your Macros.html	0.2 KB
9. Project #2 - Exercise - Try it Yourself and Practice.pdf	295.9 KB
9.1 SortingRecords.xlsm.xlsm	22.3 KB
/5. Project #3 Preparing and cleaning up Data with a little VBA/
1. Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets.mp4	11.2 MB
1. Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets.srt	4.8 KB
1. Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets.vtt	4.1 KB
2. Project #3 Preparing to use the Macro Recorder.mp4	10.0 MB
2. Project #3 Preparing to use the Macro Recorder.srt	4.2 KB
2. Project #3 Preparing to use the Macro Recorder.vtt	3.6 KB
3. Project #3 - Inserting the Headers.mp4	11.6 MB
3. Project #3 - Inserting the Headers.srt	5.5 KB
3. Project #3 - Inserting the Headers.vtt	4.7 KB
4. Project #3 - Formatting the Headers.mp4	7.8 MB
4. Project #3 - Formatting the Headers.srt	3.5 KB
4. Project #3 - Formatting the Headers.vtt	3.0 KB
5. Project #3 - Putting it all Together with alittle VBA Magic.mp4	68.7 MB
5. Project #3 - Putting it all Together with alittle VBA Magic.srt	14.9 KB
5. Project #3 - Putting it all Together with alittle VBA Magic.vtt	12.8 KB
6. Project #3 - Running the Loop.mp4	10.7 MB
6. Project #3 - Running the Loop.srt	4.5 KB
6. Project #3 - Running the Loop.vtt	3.8 KB
7. Project #3 - Quiz - Test Your Knowledge on VBA.html	0.2 KB
8. Project #3 - Exercise - Try it Yourself and Practice.pdf	341.1 KB
8.1 CleaningUpData.xlsx.xlsx	21.3 KB
/6. Project #4 Using VBA to automate Excel Formulas/
1. Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA.mp4	7.8 MB
1. Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA.srt	3.1 KB
1. Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA.vtt	2.7 KB
2. Project #4 Automate the SUM Function through Code.mp4	50.5 MB
2. Project #4 Automate the SUM Function through Code.srt	11.2 KB
2. Project #4 Automate the SUM Function through Code.vtt	9.5 KB
2.1 AutomateSumFunction.xlsx.xlsx	20.3 KB
3. Project #4 - Continue Automate SUM Function.mp4	34.3 MB
3. Project #4 - Continue Automate SUM Function.srt	8.2 KB
3. Project #4 - Continue Automate SUM Function.vtt	7.1 KB
4. Project #4 - Test the SUM Function.mp4	13.0 MB
4. Project #4 - Test the SUM Function.srt	5.4 KB
4. Project #4 - Test the SUM Function.vtt	4.7 KB
5. Project #4 Loop the SUM Function over Multiple Worksheets.mp4	37.8 MB
5. Project #4 Loop the SUM Function over Multiple Worksheets.srt	8.6 KB
5. Project #4 Loop the SUM Function over Multiple Worksheets.vtt	7.4 KB
6. Project #4 - Quiz - Test Your Knowledge Automating a Function with VBA.html	0.2 KB
7. Project #4 - Exercise - Try it Yourself and Practice.pdf	293.6 KB
7.1 AutomateSumFunction.xlsx.xlsx	20.3 KB
/7. Project #5 Bringing it all togther and create a weekly report/
1. Introduction to Project #5 - Creating a Final Report.mp4	11.5 MB
1. Introduction to Project #5 - Creating a Final Report.srt	5.0 KB
1. Introduction to Project #5 - Creating a Final Report.vtt	4.3 KB
2. Project 5 Creating the Final Report Loop.mp4	50.1 MB
2. Project 5 Creating the Final Report Loop.srt	12.2 KB
2. Project 5 Creating the Final Report Loop.vtt	10.4 KB
3. Project #5 - Copying and Pasting Data with VBA.mp4	58.0 MB
3. Project #5 - Copying and Pasting Data with VBA.srt	13.3 KB
3. Project #5 - Copying and Pasting Data with VBA.vtt	11.4 KB
4. Project #5 - Running the Final Report Procedure.mp4	12.0 MB
4. Project #5 - Running the Final Report Procedure.srt	4.5 KB
4. Project #5 - Running the Final Report Procedure.vtt	3.9 KB
5. Project #5 - Quiz - Test Your Knowledge of Creating the Final Report.html	0.2 KB
6. Project #5 - Exercise - Try it Yourself and Practice.pdf	294.7 KB
6.1 QuarterlyReport.xlsm.xlsm	27.1 KB
/8. Project #6 Working with VBA Forms/
1. Introduction to Project #6 - Working with Excel VBA Forms.mp4	9.2 MB
1. Introduction to Project #6 - Working with Excel VBA Forms.srt	4.3 KB
1. Introduction to Project #6 - Working with Excel VBA Forms.vtt	3.8 KB
1.1 QuarterlyReportForm-01.xlsm.xlsm	30.4 KB
10. Project #6 Showing the Form.mp4	13.0 MB
10. Project #6 Showing the Form.srt	5.4 KB
10. Project #6 Showing the Form.vtt	4.7 KB
11. Project #6 - Quiz - Test Your Knowledge on Creating Excel VBA Forms.html	0.2 KB
12. Project #6 - Exercise - Try it Yourself and Practice.pdf	286.5 KB
12.1 QuarterlyReportForm-01.xlsm.xlsm	30.4 KB
13. Introduction to Project #7 Importing Data from a Text File(s).mp4	5.7 MB
13. Introduction to Project #7 Importing Data from a Text File(s).srt	4.3 KB
13. Introduction to Project #7 Importing Data from a Text File(s).vtt	4.0 KB
2. Project #6 Creating an Excel VBA Form.mp4	15.8 MB
2. Project #6 Creating an Excel VBA Form.srt	7.8 KB
2. Project #6 Creating an Excel VBA Form.vtt	6.8 KB
3. Project #6 Adding Controls to the Form.mp4	12.2 MB
3. Project #6 Adding Controls to the Form.srt	5.4 KB
3. Project #6 Adding Controls to the Form.vtt	4.7 KB
4. Project #6 Changing Control and Form Properties.mp4	15.7 MB
4. Project #6 Changing Control and Form Properties.srt	7.7 KB
4. Project #6 Changing Control and Form Properties.vtt	7.2 KB
5. Project #6 Adding VBA Code to the Initialize Event of the Form.mp4	46.6 MB
5. Project #6 Adding VBA Code to the Initialize Event of the Form.srt	11.8 KB
5. Project #6 Adding VBA Code to the Initialize Event of the Form.vtt	10.2 KB
6. Project 6 Adding VBA Code to the ComboBox Change Event.mp4	25.5 MB
6. Project 6 Adding VBA Code to the ComboBox Change Event.srt	6.3 KB
6. Project 6 Adding VBA Code to the ComboBox Change Event.vtt	5.4 KB
7. Project #6 Adding VBA Code to the Add Worksheet Button Click Event.mp4	10.6 MB
7. Project #6 Adding VBA Code to the Add Worksheet Button Click Event.srt	5.1 KB
7. Project #6 Adding VBA Code to the Add Worksheet Button Click Event.vtt	4.4 KB
8. Project #6 - Change Worksheet Name.mp4	12.3 MB
8. Project #6 - Change Worksheet Name.srt	5.8 KB
8. Project #6 - Change Worksheet Name.vtt	5.0 KB
9. Project #6 Adding VBA Code to the Create Report Button Click Event.mp4	52.4 MB
9. Project #6 Adding VBA Code to the Create Report Button Click Event.srt	12.6 KB
9. Project #6 Adding VBA Code to the Create Report Button Click Event.vtt	10.8 KB
/9. Project #7 Importing Data from Text Files/
1. Project #7 Opening a Text File for Import.mp4	12.0 MB
1. Project #7 Opening a Text File for Import.srt	9.6 KB
1. Project #7 Opening a Text File for Import.vtt	8.9 KB
1.1 Dec2015Sales.txt.txt	1.2 KB
1.2 May2015Sales.txt.txt	1.3 KB
1.3 Jan2015Sales.txt.txt	1.3 KB
1.4 April2015Sales.txt.txt	1.8 KB
1.5 Feb2015Sales.txt.txt	1.2 KB
1.6 Mar2015Sales.txt.txt	1.2 KB
1.7 Nov2015Sales.txt.txt	1.3 KB
2. Project #7 Get Data from Text File.mp4	9.4 MB
2. Project #7 Get Data from Text File.srt	8.4 KB
2. Project #7 Get Data from Text File.vtt	7.8 KB
3. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4	17.1 MB
3. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.srt	12.9 KB
3. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.vtt	11.9 KB
4. Project #7 Creating a Loop to Read Each File.mp4	15.2 MB
4. Project #7 Creating a Loop to Read Each File.srt	11.4 KB
4. Project #7 Creating a Loop to Read Each File.vtt	10.5 KB
5. Project #7 Adding a New Sheet for Imported Data.mp4	6.2 MB
5. Project #7 Adding a New Sheet for Imported Data.srt	3.6 KB
5. Project #7 Adding a New Sheet for Imported Data.vtt	3.4 KB
6. Project #7 Clear the Clipboard.mp4	7.4 MB
6. Project #7 Clear the Clipboard.srt	5.5 KB
6. Project #7 Clear the Clipboard.vtt	5.1 KB
7. Project #7 Working with the ScreenUpdating Property.mp4	7.7 MB
7. Project #7 Working with the ScreenUpdating Property.srt	5.0 KB
7. Project #7 Working with the ScreenUpdating Property.vtt	4.7 KB
8. Project #7 Creating Reusable Code with a VBA Function.mp4	15.8 MB
8. Project #7 Creating Reusable Code with a VBA Function.srt	11.1 KB
8. Project #7 Creating Reusable Code with a VBA Function.vtt	10.3 KB
/
[CourseClub.NET].url	0.1 KB
[FCS Forum].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
Total files 211