3. Excel VBA Concepts/7. Building Logic with an IF Statement.mp4 19.1 MB
3. Excel VBA Concepts/7. Building Logic with an IF Statement.srt 8.2 kB
3. Excel VBA Concepts/7. Building Logic with an IF Statement.vtt 7.1 kB
3. Excel VBA Concepts/8. Working Excel VBA Loops to repeat blocks of code.mp4 57.6 MB
3. Excel VBA Concepts/8. Working Excel VBA Loops to repeat blocks of code.srt 13.7 kB
3. Excel VBA Concepts/8. Working Excel VBA Loops to repeat blocks of code.vtt 11.8 kB
3. Excel VBA Concepts/9. VBA Concepts - Quiz - Test Your Knowledge on VBA Programming Concepts.html 166 Bytes
4. Project #2 Moving Beyond the Basics and Into VBA/1. Introduction to Project #2 - Interacting with the User.mp4 10.4 MB
4. Project #2 Moving Beyond the Basics and Into VBA/1. Introduction to Project #2 - Interacting with the User.srt 4.0 kB
4. Project #2 Moving Beyond the Basics and Into VBA/1. Introduction to Project #2 - Interacting with the User.vtt 3.5 kB
4. Project #2 Moving Beyond the Basics and Into VBA/2.1 SortingRecords.xlsm.xlsm 32.5 kB
4. Project #2 Moving Beyond the Basics and Into VBA/2. Project #2 - Breaking Down the VBA Code.mp4 12.6 MB
4. Project #2 Moving Beyond the Basics and Into VBA/2. Project #2 - Breaking Down the VBA Code.srt 4.8 kB
4. Project #2 Moving Beyond the Basics and Into VBA/2. Project #2 - Breaking Down the VBA Code.vtt 4.2 kB
4. Project #2 Moving Beyond the Basics and Into VBA/3. Project #2 - Prompting the User for Information.mp4 41.2 MB
4. Project #2 Moving Beyond the Basics and Into VBA/3. Project #2 - Prompting the User for Information.srt 9.4 kB
4. Project #2 Moving Beyond the Basics and Into VBA/3. Project #2 - Prompting the User for Information.vtt 8.2 kB
4. Project #2 Moving Beyond the Basics and Into VBA/4. Continue Excel VBA InputBox.mp4 41.2 MB
4. Project #2 Moving Beyond the Basics and Into VBA/4. Continue Excel VBA InputBox.srt 9.1 kB
4. Project #2 Moving Beyond the Basics and Into VBA/4. Continue Excel VBA InputBox.vtt 7.9 kB
4. Project #2 Moving Beyond the Basics and Into VBA/5. Project #2 Building Logic in Your Macros.mp4 15.5 MB
4. Project #2 Moving Beyond the Basics and Into VBA/5. Project #2 Building Logic in Your Macros.srt 5.7 kB
4. Project #2 Moving Beyond the Basics and Into VBA/5. Project #2 Building Logic in Your Macros.vtt 5.0 kB
4. Project #2 Moving Beyond the Basics and Into VBA/6. Project #2 - Alerting the User of Errors.mp4 62.9 MB
4. Project #2 Moving Beyond the Basics and Into VBA/6. Project #2 - Alerting the User of Errors.srt 13.9 kB
4. Project #2 Moving Beyond the Basics and Into VBA/6. Project #2 - Alerting the User of Errors.vtt 11.8 kB
4. Project #2 Moving Beyond the Basics and Into VBA/7. Other Practical Uses of Message Boxes and Input Boxes.mp4 13.4 MB
4. Project #2 Moving Beyond the Basics and Into VBA/7. Other Practical Uses of Message Boxes and Input Boxes.srt 4.8 kB
4. Project #2 Moving Beyond the Basics and Into VBA/7. Other Practical Uses of Message Boxes and Input Boxes.vtt 4.5 kB
4. Project #2 Moving Beyond the Basics and Into VBA/8. Project #2 - Quiz - Test Your Knowledge on Editing Your Macros.html 166 Bytes
4. Project #2 Moving Beyond the Basics and Into VBA/9.1 SortingRecords.xlsm.xlsm 22.3 kB
4. Project #2 Moving Beyond the Basics and Into VBA/9. Project #2 - Exercise - Try it Yourself and Practice.pdf 295.9 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
5. Project #3 Preparing and cleaning up Data with a little VBA/1. Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets.srt 4.8 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/1. Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets.vtt 4.1 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/2. Project #3 Preparing to use the Macro Recorder.mp4 10.0 MB
5. Project #3 Preparing and cleaning up Data with a little VBA/2. Project #3 Preparing to use the Macro Recorder.srt 4.2 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/2. Project #3 Preparing to use the Macro Recorder.vtt 3.6 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/3. Project #3 - Inserting the Headers.mp4 11.6 MB
5. Project #3 Preparing and cleaning up Data with a little VBA/3. Project #3 - Inserting the Headers.srt 5.5 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/3. Project #3 - Inserting the Headers.vtt 4.7 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/4. Project #3 - Formatting the Headers.mp4 7.8 MB
5. Project #3 Preparing and cleaning up Data with a little VBA/4. Project #3 - Formatting the Headers.srt 3.5 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/4. Project #3 - Formatting the Headers.vtt 3.0 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/5. Project #3 - Putting it all Together with alittle VBA Magic.mp4 68.7 MB
5. Project #3 Preparing and cleaning up Data with a little VBA/5. Project #3 - Putting it all Together with alittle VBA Magic.srt 14.9 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/5. Project #3 - Putting it all Together with alittle VBA Magic.vtt 12.8 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/6. Project #3 - Running the Loop.mp4 10.7 MB
5. Project #3 Preparing and cleaning up Data with a little VBA/6. Project #3 - Running the Loop.srt 4.5 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/6. Project #3 - Running the Loop.vtt 3.8 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/7. Project #3 - Quiz - Test Your Knowledge on VBA.html 166 Bytes
5. Project #3 Preparing and cleaning up Data with a little VBA/8.1 CleaningUpData.xlsx.xlsx 21.3 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/8. Project #3 - Exercise - Try it Yourself and Practice.pdf 341.1 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
6. Project #4 Using VBA to automate Excel Formulas/1. Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA.srt 3.1 kB
6. Project #4 Using VBA to automate Excel Formulas/1. Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA.vtt 2.7 kB
6. Project #4 Using VBA to automate Excel Formulas/2.1 AutomateSumFunction.xlsx.xlsx 20.3 kB
6. Project #4 Using VBA to automate Excel Formulas/2. Project #4 Automate the SUM Function through Code.mp4 50.5 MB
6. Project #4 Using VBA to automate Excel Formulas/2. Project #4 Automate the SUM Function through Code.srt 11.2 kB
6. Project #4 Using VBA to automate Excel Formulas/2. Project #4 Automate the SUM Function through Code.vtt 9.5 kB
6. Project #4 Using VBA to automate Excel Formulas/3. Project #4 - Continue Automate SUM Function.mp4 34.3 MB
6. Project #4 Using VBA to automate Excel Formulas/3. Project #4 - Continue Automate SUM Function.srt 8.2 kB
6. Project #4 Using VBA to automate Excel Formulas/3. Project #4 - Continue Automate SUM Function.vtt 7.1 kB
6. Project #4 Using VBA to automate Excel Formulas/4. Project #4 - Test the SUM Function.mp4 13.0 MB
6. Project #4 Using VBA to automate Excel Formulas/4. Project #4 - Test the SUM Function.srt 5.4 kB
6. Project #4 Using VBA to automate Excel Formulas/4. Project #4 - Test the SUM Function.vtt 4.7 kB
6. Project #4 Using VBA to automate Excel Formulas/5. Project #4 Loop the SUM Function over Multiple Worksheets.mp4 37.8 MB
6. Project #4 Using VBA to automate Excel Formulas/5. Project #4 Loop the SUM Function over Multiple Worksheets.srt 8.6 kB
6. Project #4 Using VBA to automate Excel Formulas/5. Project #4 Loop the SUM Function over Multiple Worksheets.vtt 7.4 kB
6. Project #4 Using VBA to automate Excel Formulas/6. Project #4 - Quiz - Test Your Knowledge Automating a Function with VBA.html 166 Bytes
6. Project #4 Using VBA to automate Excel Formulas/7.1 AutomateSumFunction.xlsx.xlsx 20.3 kB
6. Project #4 Using VBA to automate Excel Formulas/7. Project #4 - Exercise - Try it Yourself and Practice.pdf 293.6 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
7. Project #5 Bringing it all togther and create a weekly report/1. Introduction to Project #5 - Creating a Final Report.srt 5.0 kB
7. Project #5 Bringing it all togther and create a weekly report/1. Introduction to Project #5 - Creating a Final Report.vtt 4.3 kB
7. Project #5 Bringing it all togther and create a weekly report/2. Project 5 Creating the Final Report Loop.mp4 50.1 MB
7. Project #5 Bringing it all togther and create a weekly report/2. Project 5 Creating the Final Report Loop.srt 12.2 kB
7. Project #5 Bringing it all togther and create a weekly report/2. Project 5 Creating the Final Report Loop.vtt 10.4 kB
7. Project #5 Bringing it all togther and create a weekly report/3. Project #5 - Copying and Pasting Data with VBA.mp4 58.0 MB
7. Project #5 Bringing it all togther and create a weekly report/3. Project #5 - Copying and Pasting Data with VBA.srt 13.3 kB
7. Project #5 Bringing it all togther and create a weekly report/3. Project #5 - Copying and Pasting Data with VBA.vtt 11.4 kB
7. Project #5 Bringing it all togther and create a weekly report/4. Project #5 - Running the Final Report Procedure.mp4 12.0 MB
7. Project #5 Bringing it all togther and create a weekly report/4. Project #5 - Running the Final Report Procedure.srt 4.5 kB
7. Project #5 Bringing it all togther and create a weekly report/4. Project #5 - Running the Final Report Procedure.vtt 3.9 kB
7. Project #5 Bringing it all togther and create a weekly report/5. Project #5 - Quiz - Test Your Knowledge of Creating the Final Report.html 166 Bytes
7. Project #5 Bringing it all togther and create a weekly report/6.1 QuarterlyReport.xlsm.xlsm 27.1 kB
7. Project #5 Bringing it all togther and create a weekly report/6. Project #5 - Exercise - Try it Yourself and Practice.pdf 294.7 kB
8. Project #6 Working with VBA Forms/10. Project #6 Showing the Form.mp4 13.0 MB
8. Project #6 Working with VBA Forms/10. Project #6 Showing the Form.srt 5.4 kB
8. Project #6 Working with VBA Forms/10. Project #6 Showing the Form.vtt 4.7 kB
8. Project #6 Working with VBA Forms/11. Project #6 - Quiz - Test Your Knowledge on Creating Excel VBA Forms.html 166 Bytes
8. Project #6 Working with VBA Forms/1.1 QuarterlyReportForm-01.xlsm.xlsm 30.4 kB
8. Project #6 Working with VBA Forms/12.1 QuarterlyReportForm-01.xlsm.xlsm 30.4 kB
8. Project #6 Working with VBA Forms/12. Project #6 - Exercise - Try it Yourself and Practice.pdf 286.5 kB
8. Project #6 Working with VBA Forms/13. Introduction to Project #7 Importing Data from a Text File(s).mp4 5.7 MB
8. Project #6 Working with VBA Forms/13. Introduction to Project #7 Importing Data from a Text File(s).srt 4.3 kB
8. Project #6 Working with VBA Forms/13. Introduction to Project #7 Importing Data from a Text File(s).vtt 4.0 kB
8. Project #6 Working with VBA Forms/1. Introduction to Project #6 - Working with Excel VBA Forms.mp4 9.2 MB
8. Project #6 Working with VBA Forms/1. Introduction to Project #6 - Working with Excel VBA Forms.srt 4.3 kB
8. Project #6 Working with VBA Forms/1. Introduction to Project #6 - Working with Excel VBA Forms.vtt 3.8 kB
8. Project #6 Working with VBA Forms/2. Project #6 Creating an Excel VBA Form.mp4 15.8 MB
8. Project #6 Working with VBA Forms/2. Project #6 Creating an Excel VBA Form.srt 7.8 kB
8. Project #6 Working with VBA Forms/2. Project #6 Creating an Excel VBA Form.vtt 6.8 kB
8. Project #6 Working with VBA Forms/3. Project #6 Adding Controls to the Form.mp4 12.2 MB
8. Project #6 Working with VBA Forms/3. Project #6 Adding Controls to the Form.srt 5.4 kB
8. Project #6 Working with VBA Forms/3. Project #6 Adding Controls to the Form.vtt 4.7 kB
8. Project #6 Working with VBA Forms/4. Project #6 Changing Control and Form Properties.mp4 15.7 MB
8. Project #6 Working with VBA Forms/4. Project #6 Changing Control and Form Properties.srt 7.7 kB
8. Project #6 Working with VBA Forms/4. Project #6 Changing Control and Form Properties.vtt 7.2 kB
8. Project #6 Working with VBA Forms/5. Project #6 Adding VBA Code to the Initialize Event of the Form.mp4 46.6 MB
8. Project #6 Working with VBA Forms/5. Project #6 Adding VBA Code to the Initialize Event of the Form.srt 11.8 kB
8. Project #6 Working with VBA Forms/5. Project #6 Adding VBA Code to the Initialize Event of the Form.vtt 10.2 kB
8. Project #6 Working with VBA Forms/6. Project 6 Adding VBA Code to the ComboBox Change Event.mp4 25.5 MB
8. Project #6 Working with VBA Forms/6. Project 6 Adding VBA Code to the ComboBox Change Event.srt 6.3 kB
8. Project #6 Working with VBA Forms/6. Project 6 Adding VBA Code to the ComboBox Change Event.vtt 5.4 kB
8. Project #6 Working with VBA Forms/7. Project #6 Adding VBA Code to the Add Worksheet Button Click Event.mp4 10.6 MB
8. Project #6 Working with VBA Forms/7. Project #6 Adding VBA Code to the Add Worksheet Button Click Event.srt 5.1 kB
8. Project #6 Working with VBA Forms/7. Project #6 Adding VBA Code to the Add Worksheet Button Click Event.vtt 4.4 kB
8. Project #6 Working with VBA Forms/8. Project #6 - Change Worksheet Name.mp4 12.3 MB
8. Project #6 Working with VBA Forms/8. Project #6 - Change Worksheet Name.srt 5.8 kB
8. Project #6 Working with VBA Forms/8. Project #6 - Change Worksheet Name.vtt 5.0 kB
8. Project #6 Working with VBA Forms/9. Project #6 Adding VBA Code to the Create Report Button Click Event.mp4 52.4 MB
8. Project #6 Working with VBA Forms/9. Project #6 Adding VBA Code to the Create Report Button Click Event.srt 12.6 kB
8. Project #6 Working with VBA Forms/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.1 Dec2015Sales.txt.txt 1.2 kB
9. Project #7 Importing Data from Text Files/1.2 May2015Sales.txt.txt 1.3 kB
9. Project #7 Importing Data from Text Files/1.3 Jan2015Sales.txt.txt 1.3 kB
9. Project #7 Importing Data from Text Files/1.4 April2015Sales.txt.txt 1.8 kB
9. Project #7 Importing Data from Text Files/1.5 Feb2015Sales.txt.txt 1.2 kB
9. Project #7 Importing Data from Text Files/1.6 Mar2015Sales.txt.txt 1.2 kB
9. Project #7 Importing Data from Text Files/1.7 Nov2015Sales.txt.txt 1.3 kB
9. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.mp4 12.0 MB
9. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.srt 9.6 kB
9. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.vtt 8.9 kB
9. Project #7 Importing Data from Text Files/2. Project #7 Get Data from Text File.mp4 9.4 MB
9. Project #7 Importing Data from Text Files/2. Project #7 Get Data from Text File.srt 8.4 kB
9. Project #7 Importing Data from Text Files/2. Project #7 Get Data from Text File.vtt 7.8 kB
9. Project #7 Importing Data from Text Files/3. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4 17.1 MB
9. Project #7 Importing Data from Text Files/3. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.srt 12.9 kB
9. Project #7 Importing Data from Text Files/3. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.vtt 11.9 kB
9. Project #7 Importing Data from Text Files/4. Project #7 Creating a Loop to Read Each File.mp4 15.2 MB
9. Project #7 Importing Data from Text Files/4. Project #7 Creating a Loop to Read Each File.srt 11.4 kB
9. Project #7 Importing Data from Text Files/4. Project #7 Creating a Loop to Read Each File.vtt 10.5 kB
9. Project #7 Importing Data from Text Files/5. Project #7 Adding a New Sheet for Imported Data.mp4 6.2 MB
9. Project #7 Importing Data from Text Files/5. Project #7 Adding a New Sheet for Imported Data.srt 3.6 kB
9. Project #7 Importing Data from Text Files/5. Project #7 Adding a New Sheet for Imported Data.vtt 3.4 kB
9. Project #7 Importing Data from Text Files/6. Project #7 Clear the Clipboard.mp4 7.4 MB
9. Project #7 Importing Data from Text Files/6. Project #7 Clear the Clipboard.srt 5.5 kB
9. Project #7 Importing Data from Text Files/6. Project #7 Clear the Clipboard.vtt 5.1 kB
9. Project #7 Importing Data from Text Files/7. Project #7 Working with the ScreenUpdating Property.mp4 7.7 MB
9. Project #7 Importing Data from Text Files/7. Project #7 Working with the ScreenUpdating Property.srt 5.0 kB
9. Project #7 Importing Data from Text Files/7. Project #7 Working with the ScreenUpdating Property.vtt 4.7 kB
9. Project #7 Importing Data from Text Files/8. Project #7 Creating Reusable Code with a VBA Function.mp4 15.8 MB
9. Project #7 Importing Data from Text Files/8. Project #7 Creating Reusable Code with a VBA Function.srt 11.1 kB
9. Project #7 Importing Data from Text Files/8. Project #7 Creating Reusable Code with a VBA Function.vtt 10.3 kB