8. Project #6 Working with VBA Forms/6. Project 6 Adding VBA Code to the ComboBox Change Event.mp4 25.5 MB
3. Excel VBA Concepts/7. Building Logic with an IF Statement.mp4 19.1 MB
1. Course Introduction and Overview/1. Welcome to the Course.mp4 17.3 MB
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/8. Project #7 Creating Reusable Code with a VBA Function.mp4 15.8 MB
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/4. Project #6 Changing Control and Form Properties.mp4 15.7 MB
1. Course Introduction and Overview/2. Understanding the Why and How Behind Excel Macros.mp4 15.6 MB
4. Project #2 Moving Beyond the Basics and Into VBA/5. Project #2 Building Logic in Your Macros.mp4 15.5 MB
9. Project #7 Importing Data from Text Files/4. Project #7 Creating a Loop to Read Each File.mp4 15.2 MB
2. Project #1 Using Excel's Macro Recorder Tool/5. Project #1 - Opps! I Need to Edit My Macro.mp4 14.8 MB
4. Project #2 Moving Beyond the Basics and Into VBA/7. Other Practical Uses of Message Boxes and Input Boxes.mp4 13.4 MB
8. Project #6 Working with VBA Forms/10. Project #6 Showing the Form.mp4 13.0 MB
6. Project #4 Using VBA to automate Excel Formulas/4. Project #4 - Test the SUM Function.mp4 13.0 MB
4. Project #2 Moving Beyond the Basics and Into VBA/2. Project #2 - Breaking Down the VBA Code.mp4 12.6 MB
8. Project #6 Working with VBA Forms/8. Project #6 - Change Worksheet Name.mp4 12.3 MB
3. Excel VBA Concepts/5. Adding Code to a VBA Procedure.mp4 12.3 MB
8. Project #6 Working with VBA Forms/3. Project #6 Adding Controls to the Form.mp4 12.2 MB
9. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.mp4 12.0 MB
7. Project #5 Bringing it all togther and create a weekly report/4. Project #5 - Running the Final Report Procedure.mp4 12.0 MB
5. Project #3 Preparing and cleaning up Data with a little VBA/3. Project #3 - Inserting the Headers.mp4 11.6 MB
2. Project #1 Using Excel's Macro Recorder Tool/4. Project #1 - Running a Macro with a Button.mp4 11.6 MB
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
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/6. Project #3 - Running the Loop.mp4 10.7 MB
2. Project #1 Using Excel's Macro Recorder Tool/7. Practical Uses of Excel Macros.mp4 10.7 MB
8. Project #6 Working with VBA Forms/7. Project #6 Adding VBA Code to the Add Worksheet Button Click Event.mp4 10.6 MB
4. Project #2 Moving Beyond the Basics and Into VBA/1. Introduction to Project #2 - Interacting with the User.mp4 10.4 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
4. Project #2 Moving Beyond the Basics and Into VBA/7. Other Practical Uses of Message Boxes and Input Boxes.srt 4.8 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/3. Project #3 - Inserting the Headers.vtt 4.7 kB
9. Project #7 Importing Data from Text Files/7. Project #7 Working with the ScreenUpdating Property.vtt 4.7 kB
6. Project #4 Using VBA to automate Excel Formulas/4. Project #4 - Test the SUM Function.vtt 4.7 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/3. Project #6 Adding Controls to the Form.vtt 4.7 kB
2. Project #1 Using Excel's Macro Recorder Tool/4. Project #1 - Running a Macro with a Button.vtt 4.7 kB
7. Project #5 Bringing it all togther and create a weekly report/4. Project #5 - Running the Final Report Procedure.srt 4.5 kB
3. Excel VBA Concepts/5. Adding Code to a VBA Procedure.vtt 4.5 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/6. Project #3 - Running the Loop.srt 4.5 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
3. Excel VBA Concepts/2. The Visual Basic Editor.vtt 4.4 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/1. Introduction to Project #6 - Working with Excel VBA Forms.srt 4.3 kB
8. Project #6 Working with VBA Forms/13. Introduction to Project #7 Importing Data from a Text File(s).srt 4.3 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
4. Project #2 Moving Beyond the Basics and Into VBA/2. Project #2 - Breaking Down the VBA Code.vtt 4.2 kB
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/1. Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets.vtt 4.1 kB
2. Project #1 Using Excel's Macro Recorder Tool/3. Running A Macro.srt 4.1 kB
4. Project #2 Moving Beyond the Basics and Into VBA/1. Introduction to Project #2 - Interacting with the User.srt 4.0 kB
8. Project #6 Working with VBA Forms/13. Introduction to Project #7 Importing Data from a Text File(s).vtt 4.0 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
5. Project #3 Preparing and cleaning up Data with a little VBA/6. Project #3 - Running the Loop.vtt 3.8 kB
8. Project #6 Working with VBA Forms/1. Introduction to Project #6 - Working with Excel VBA Forms.vtt 3.8 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
9. Project #7 Importing Data from Text Files/5. Project #7 Adding a New Sheet for Imported Data.srt 3.6 kB
4. Project #2 Moving Beyond the Basics and Into VBA/1. Introduction to Project #2 - Interacting with the User.vtt 3.5 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/4. Project #3 - Formatting the Headers.srt 3.5 kB
2. Project #1 Using Excel's Macro Recorder Tool/3. Running A Macro.vtt 3.5 kB
9. Project #7 Importing Data from Text Files/5. Project #7 Adding a New Sheet for Imported Data.vtt 3.4 kB
2. Project #1 Using Excel's Macro Recorder Tool/7. Practical Uses of Excel Macros.srt 3.2 kB
6. Project #4 Using VBA to automate Excel Formulas/1. Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA.srt 3.1 kB
2. Project #1 Using Excel's Macro Recorder Tool/7. Practical Uses of Excel Macros.vtt 3.0 kB
5. Project #3 Preparing and cleaning up Data with a little VBA/4. Project #3 - Formatting the Headers.vtt 3.0 kB
2. Project #1 Using Excel's Macro Recorder Tool/6. Saving an Excel File that contains Macros.srt 2.8 kB
2. Project #1 Using Excel's Macro Recorder Tool/1. Introduction to Project #1 - Inserting and Formatting Text.srt 2.8 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
2. Project #1 Using Excel's Macro Recorder Tool/8. Project #1 - Quiz - Test Your Knowledge on Using the Macro Recorder.html 166 Bytes
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/8. Project #2 - Quiz - Test Your Knowledge on Editing Your Macros.html 166 Bytes
5. Project #3 Preparing and cleaning up Data with a little VBA/7. Project #3 - Quiz - Test Your Knowledge on VBA.html 166 Bytes
6. Project #4 Using VBA to automate Excel Formulas/6. Project #4 - Quiz - Test Your Knowledge Automating a Function with VBA.html 166 Bytes
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
8. Project #6 Working with VBA Forms/11. Project #6 - Quiz - Test Your Knowledge on Creating Excel VBA Forms.html 166 Bytes