3. Excel VBA Concepts/7. Building Logic with an IF Statement.mp418.18MB
3. Excel VBA Concepts/8. Working Excel VBA Loops to repeat blocks of code.mp454.92MB
4. Project #2 Moving Beyond the Basics and Into VBA/1. Introduction to Project #2 - Interacting with the User.mp49.92MB
4. Project #2 Moving Beyond the Basics and Into VBA/2. Project #2 - Breaking Down the VBA Code.mp411.98MB
4. Project #2 Moving Beyond the Basics and Into VBA/3. Project #2 - Prompting the User for Information.mp439.32MB
4. Project #2 Moving Beyond the Basics and Into VBA/4. Continue Excel VBA InputBox.mp439.26MB
4. Project #2 Moving Beyond the Basics and Into VBA/5. Project #2 Building Logic in Your Macros.mp414.77MB
4. Project #2 Moving Beyond the Basics and Into VBA/6. Project #2 - Alerting the User of Errors.mp459.94MB
4. Project #2 Moving Beyond the Basics and Into VBA/7. Other Practical Uses of Message Boxes and Input Boxes.mp412.81MB
5. Project #3 Preparing and cleaning up Data with a little VBA/1. Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets.mp410.72MB
5. Project #3 Preparing and cleaning up Data with a little VBA/2. Project #3 Preparing to use the Macro Recorder.mp49.51MB
5. Project #3 Preparing and cleaning up Data with a little VBA/3. Project #3 - Inserting the Headers.mp411.07MB
5. Project #3 Preparing and cleaning up Data with a little VBA/4. Project #3 - Formatting the Headers.mp47.47MB
5. Project #3 Preparing and cleaning up Data with a little VBA/5. Project #3 - Putting it all Together with alittle VBA Magic.mp465.49MB
5. Project #3 Preparing and cleaning up Data with a little VBA/6. Project #3 - Running the Loop.mp410.23MB
6. Project #4 Using VBA to automate Excel Formulas/1. Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA.mp47.47MB
6. Project #4 Using VBA to automate Excel Formulas/2. Project #4 Automate the SUM Function through Code.mp448.14MB
6. Project #4 Using VBA to automate Excel Formulas/3. Project #4 - Continue Automate SUM Function.mp432.71MB
6. Project #4 Using VBA to automate Excel Formulas/4. Project #4 - Test the SUM Function.mp412.37MB
6. Project #4 Using VBA to automate Excel Formulas/5. Project #4 Loop the SUM Function over Multiple Worksheets.mp436.06MB
7. Project #5 Bringing it all togther and create a weekly report/1. Introduction to Project #5 - Creating a Final Report.mp411MB
7. Project #5 Bringing it all togther and create a weekly report/2. Project 5 Creating the Final Report Loop.mp447.77MB
7. Project #5 Bringing it all togther and create a weekly report/3. Project #5 - Copying and Pasting Data with VBA.mp455.34MB
7. Project #5 Bringing it all togther and create a weekly report/4. Project #5 - Running the Final Report Procedure.mp411.42MB
8. Project #6 Working with VBA Forms/1. Introduction to Project #6 - Working with Excel VBA Forms.mp48.8MB
8. Project #6 Working with VBA Forms/10. Project #6 Showing the Form.mp412.4MB
8. Project #6 Working with VBA Forms/13. Introduction to Project #7 Importing Data from a Text File(s).mp45.43MB
8. Project #6 Working with VBA Forms/2. Project #6 Creating an Excel VBA Form.mp415.06MB
8. Project #6 Working with VBA Forms/3. Project #6 Adding Controls to the Form.mp411.65MB
8. Project #6 Working with VBA Forms/4. Project #6 Changing Control and Form Properties.mp414.96MB
8. Project #6 Working with VBA Forms/5. Project #6 Adding VBA Code to the Initialize Event of the Form.mp444.46MB
8. Project #6 Working with VBA Forms/6. Project 6 Adding VBA Code to the ComboBox Change Event.mp424.35MB
8. Project #6 Working with VBA Forms/7. Project #6 Adding VBA Code to the Add Worksheet Button Click Event.mp410.11MB
8. Project #6 Working with VBA Forms/8. Project #6 - Change Worksheet Name.mp411.7MB
8. Project #6 Working with VBA Forms/9. Project #6 Adding VBA Code to the Create Report Button Click Event.mp450MB
9. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.mp411.47MB
9. Project #7 Importing Data from Text Files/2. Project #7 Get Data from Text File.mp48.94MB
9. Project #7 Importing Data from Text Files/3. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp416.31MB
9. Project #7 Importing Data from Text Files/4. Project #7 Creating a Loop to Read Each File.mp414.49MB
9. Project #7 Importing Data from Text Files/5. Project #7 Adding a New Sheet for Imported Data.mp45.91MB
9. Project #7 Importing Data from Text Files/6. Project #7 Clear the Clipboard.mp47.09MB
9. Project #7 Importing Data from Text Files/7. Project #7 Working with the ScreenUpdating Property.mp47.32MB
9. Project #7 Importing Data from Text Files/8. Project #7 Creating Reusable Code with a VBA Function.mp415.1MB