|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| [BONUS LECTURE] Course Coupons Learn New Skills.html |
5.03KB |
| 1. Creating a New Workbook.mp4 |
10.08MB |
| 1. Creating a New Workbook-en_US.srt |
4.26KB |
| 1. Creating Functions for Your Worksheets.mp4 |
9.88MB |
| 1. Creating Functions for Your Worksheets-en_US.srt |
7.91KB |
| 1. Introduction.mp4 |
3.48MB |
| 1. Introduction-en_US.srt |
2.38KB |
| 1. Introduction to Debugging and Error Handling.mp4 |
5.82MB |
| 1. Introduction to Debugging and Error Handling-en_US.srt |
612B |
| 1. Introduction to Decision Structures.mp4 |
8.15MB |
| 1. Introduction to Decision Structures-en_US.srt |
1022B |
| 1. Introduction to Loops.mp4 |
13.89MB |
| 1. Introduction to Loops-en_US.srt |
1.14KB |
| 1. Introduction to User Forms.mp4 |
4.01MB |
| 1. Introduction to User Forms-en_US.srt |
1.41KB |
| 1. Introduction to Writing VBA.mp4 |
4.94MB |
| 1. Introduction to Writing VBA-en_US.srt |
518B |
| 1. Recording Macros.mp4 |
8.79MB |
| 1. Recording Macros-en_US.srt |
6.21KB |
| 1. Thank You!.mp4 |
8.57MB |
| 1. Thank You!-en_US.srt |
1.10KB |
| 1. The Format Function Using Named Format Expressions.mp4 |
7.11MB |
| 1. The Format Function Using Named Format Expressions-en_US.srt |
4.27KB |
| 1. The Microsoft Visual Basic Editor.mp4 |
7.47MB |
| 1. The Microsoft Visual Basic Editor-en_US.srt |
3.19KB |
| 1. Variables.mp4 |
43.19MB |
| 1. Variables-en_US.srt |
9.84KB |
| 1. Working with Message Boxes.mp4 |
6.60MB |
| 1. Working with Message Boxes-en_US.srt |
6.01KB |
| 1. Writing Code vs. Recording Macros.mp4 |
20.41MB |
| 1. Writing Code vs. Recording Macros-en_US.srt |
2.66KB |
| 10. Exercise Do Until Loops.mp4 |
20.04MB |
| 10. Exercise Do Until Loops-en_US.srt |
8.31KB |
| 10. The Range Object.mp4 |
2.25MB |
| 10. The Range Object-en_US.srt |
1.36KB |
| 10. Using Methods.mp4 |
7.75MB |
| 10. Using Methods-en_US.srt |
4.35KB |
| 11. Do While Loop.mp4 |
10.53MB |
| 11. Do While Loop-en_US.srt |
1.43KB |
| 11. Referring to Named Ranges.mp4 |
4.94MB |
| 11. Referring to Named Ranges-en_US.srt |
2.09KB |
| 11. Using Event Procedures - UPDATED.mp4 |
5.34MB |
| 11. Using Event Procedures - UPDATED-en_US.srt |
3.70KB |
| 12. Exercise Do While Loop.mp4 |
11.78MB |
| 12. Exercise Do While Loop-en_US.srt |
4.28KB |
| 12. The CurrentRegion Property.mp4 |
7.87MB |
| 12. The CurrentRegion Property-en_US.srt |
2.66KB |
| 13. Exiting a Do Loop.mp4 |
7.74MB |
| 13. Exiting a Do Loop-en_US.srt |
2.70KB |
| 13. The Range.End Property.mp4 |
19.99MB |
| 13. The Range.End Property-en_US.srt |
5.37KB |
| 14. Copying Data on Your Worksheet.mp4 |
8.52MB |
| 14. Copying Data on Your Worksheet-en_US.srt |
4.32KB |
| 15. The Paste Method.mp4 |
7.68MB |
| 15. The Paste Method-en_US.srt |
5.09KB |
| 16. Using PasteSpecial.mp4 |
10.38MB |
| 16. Using PasteSpecial-en_US.srt |
4.18KB |
| 17. Clearing Contents and Formats.mp4 |
6.88MB |
| 17. Clearing Contents and Formats-en_US.srt |
4.46KB |
| 18. Exercise Using Name, and Value.mp4 |
4.39MB |
| 18. Exercise Using Name, and Value-en_US.srt |
1.86KB |
| 19. Sorting Fields.mp4 |
22.72MB |
| 19. Sorting Fields-en_US.srt |
4.60KB |
| 2. A Few Time Savers Writing VBA.mp4 |
3.59MB |
| 2. A Few Time Savers Writing VBA-en_US.srt |
4.59KB |
| 2. Creating a Form.mp4 |
10.85MB |
| 2. Creating a Form-en_US.srt |
3.41KB |
| 2. Creating a Simple Chart with VBA.mp4 |
9.67MB |
| 2. Creating a Simple Chart with VBA-en_US.srt |
4.89KB |
| 2. Debugging Setting a Breakpoint.mp4 |
13.70MB |
| 2. Debugging Setting a Breakpoint-en_US.srt |
5.60KB |
| 2. Exercise Message Boxes.mp4 |
18.20MB |
| 2. Exercise Message Boxes-en_US.srt |
8.14KB |
| 2. For Next Loop.mp4 |
4.65MB |
| 2. For Next Loop-en_US.srt |
4.71KB |
| 2. If...Then.mp4 |
12.77MB |
| 2. If...Then-en_US.srt |
4.99KB |
| 2. Object Variables.mp4 |
4.18MB |
| 2. Object Variables-en_US.srt |
3.39KB |
| 2. Opening and Closing Workbooks.mp4 |
6.52MB |
| 2. Opening and Closing Workbooks-en_US.srt |
3.18KB |
| 2. Testing the Macro and Looking at the VBA.mp4 |
7.03MB |
| 2. Testing the Macro and Looking at the VBA-en_US.srt |
4.03KB |
| 2. The Project Explorer.mp4 |
8.11MB |
| 2. The Project Explorer-en_US.srt |
2.97KB |
| 2. Understanding Objects.mp4 |
17.78MB |
| 2. Understanding Objects-en_US.srt |
3.18KB |
| 2. Using the FormatCurrency Function.mp4 |
6.53MB |
| 2. Using the FormatCurrency Function-en_US.srt |
4.55KB |
| 20. Filtering Fields.mp4 |
32.91MB |
| 20. Filtering Fields-en_US.srt |
9.12KB |
| 21. Removing Duplicate Records.mp4 |
7.02MB |
| 21. Removing Duplicate Records-en_US.srt |
4.75KB |
| 3. Absolute vs. Relative Mode.mp4 |
4.57MB |
| 3. Absolute vs. Relative Mode-en_US.srt |
2.32KB |
| 3. Containers & Collections.mp4 |
7.81MB |
| 3. Containers & Collections-en_US.srt |
1.29KB |
| 3. Data Types.mp4 |
3.25MB |
| 3. Data Types-en_US.srt |
2.80KB |
| 3. Debugging The Watch Window.mp4 |
9.53MB |
| 3. Debugging The Watch Window-en_US.srt |
3.55KB |
| 3. Exercise For Next Loop.mp4 |
8.26MB |
| 3. Exercise For Next Loop-en_US.srt |
5.65KB |
| 3. If...Then...Else.mp4 |
8.18MB |
| 3. If...Then...Else-en_US.srt |
3.11KB |
| 3. Resetting Your VBA Code Upon Errors.mp4 |
5.36MB |
| 3. Resetting Your VBA Code Upon Errors-en_US.srt |
3.09KB |
| 3. Showing a Form from the VBE.mp4 |
3.46MB |
| 3. Showing a Form from the VBE-en_US.srt |
904B |
| 3. The Properties Window.mp4 |
8.02MB |
| 3. The Properties Window-en_US.srt |
2.28KB |
| 3. Using WorksheetFunction to Perform Calculations.mp4 |
6.51MB |
| 3. Using WorksheetFunction to Perform Calculations-en_US.srt |
5.26KB |
| 3. Working with Input Boxes.mp4 |
5.42MB |
| 3. Working with Input Boxes-en_US.srt |
4.23KB |
| 3. Worksheets vs. Sheets.mp4 |
5.69MB |
| 3. Worksheets vs. Sheets-en_US.srt |
2.88KB |
| 4. Adding Controls to a Form.mp4 |
15.13MB |
| 4. Adding Controls to a Form-en_US.srt |
4.54KB |
| 4. Adding Worksheets.mp4 |
8.37MB |
| 4. Adding Worksheets-en_US.srt |
5.41KB |
| 4. Debugging Stepping Through VBA Code.mp4 |
15.25MB |
| 4. Debugging Stepping Through VBA Code-en_US.srt |
6.38KB |
| 4. Declaring Constants.mp4 |
5.10MB |
| 4. Declaring Constants-en_US.srt |
3.32KB |
| 4. Exercise Input Boxes.mp4 |
20.79MB |
| 4. Exercise Input Boxes-en_US.srt |
10.16KB |
| 4. How VBA Refers to Objects.mp4 |
11.57MB |
| 4. How VBA Refers to Objects-en_US.srt |
1.32KB |
| 4. Recording in Relative Mode.mp4 |
17.23MB |
| 4. Recording in Relative Mode-en_US.srt |
7.83KB |
| 4. Select Case.mp4 |
11.59MB |
| 4. Select Case-en_US.srt |
5.75KB |
| 4. Stepping.mp4 |
2.85MB |
| 4. Stepping-en_US.srt |
2.79KB |
| 4. Structure of Sub Procedures.mp4 |
1.39MB |
| 4. Structure of Sub Procedures-en_US.srt |
2.15KB |
| 4. The Code Window.mp4 |
15.64MB |
| 4. The Code Window-en_US.srt |
6.23KB |
| 4. Using Static Arrays.mp4 |
35.06MB |
| 4. Using Static Arrays-en_US.srt |
7.89KB |
| 5. Attaching Events to Form Controls.mp4 |
14.40MB |
| 5. Attaching Events to Form Controls-en_US.srt |
7.68KB |
| 5. Calling a Sub Procedure.mp4 |
5.22MB |
| 5. Calling a Sub Procedure-en_US.srt |
4.34KB |
| 5. Carriage Return Line Feed.mp4 |
5.07MB |
| 5. Carriage Return Line Feed-en_US.srt |
1.89KB |
| 5. Copying Worksheets.mp4 |
6.18MB |
| 5. Copying Worksheets-en_US.srt |
3.57KB |
| 5. Debugging The Immediate Window.mp4 |
19.24MB |
| 5. Debugging The Immediate Window-en_US.srt |
7.73KB |
| 5. For Each.mp4 |
1.72MB |
| 5. For Each-en_US.srt |
1.95KB |
| 5. Modifying Macros Using VBA.mp4 |
10.38MB |
| 5. Modifying Macros Using VBA-en_US.srt |
4.97KB |
| 5. Other Windows the Immediate Window, the Locals Window, and the Watch Window.mp4 |
6.44MB |
| 5. Other Windows the Immediate Window, the Locals Window, and the Watch Window-en_US.srt |
3.02KB |
| 5. The Array Function.mp4 |
3.28MB |
| 5. The Array Function-en_US.srt |
1.32KB |
| 6. Adding and Removing Modules.mp4 |
6.69MB |
| 6. Adding and Removing Modules-en_US.srt |
2.64KB |
| 6. Debugging The Locals Window.mp4 |
7.93MB |
| 6. Debugging The Locals Window-en_US.srt |
3.78KB |
| 6. Exercise For Each, Example 1.mp4 |
7.97MB |
| 6. Exercise For Each, Example 1-en_US.srt |
3.72KB |
| 6. Macro Example Creating Buttons to Navigate Between Worksheets.mp4 |
8.35MB |
| 6. Macro Example Creating Buttons to Navigate Between Worksheets-en_US.srt |
4.67KB |
| 6. Scope.mp4 |
15.80MB |
| 6. Scope-en_US.srt |
7.33KB |
| 6. Structure of Functions.mp4 |
3.68MB |
| 6. Structure of Functions-en_US.srt |
4.02KB |
| 6. The Cells Object.mp4 |
24.20MB |
| 6. The Cells Object-en_US.srt |
3.01KB |
| 6. Using VBA to E-mail Workbooks.mp4 |
5.64MB |
| 6. Using VBA to E-mail Workbooks-en_US.srt |
3.67KB |
| 6. Validating Form Data.mp4 |
4.49MB |
| 6. Validating Form Data-en_US.srt |
2.64KB |
| 7. Calling a Function.mp4 |
2.50MB |
| 7. Calling a Function-en_US.srt |
1.30KB |
| 7. Deleting Blank Rows and Columns.mp4 |
14.73MB |
| 7. Deleting Blank Rows and Columns-en_US.srt |
4.88KB |
| 7. Error Handling The On Error GoTo Statement.mp4 |
31.93MB |
| 7. Error Handling The On Error GoTo Statement-en_US.srt |
7.45KB |
| 7. Exercise Dependent Combo Boxes.mp4 |
1.74MB |
| 7. Exercise Dependent Combo Boxes-en_US.srt |
1.41KB |
| 7. Exercise For Each, Example 2.mp4 |
19.45MB |
| 7. Exercise For Each, Example 2-en_US.srt |
8.00KB |
| 7. Exercise Using Operators and the Cells Object.mp4 |
4.56MB |
| 7. Exercise Using Operators and the Cells Object-en_US.srt |
2.03KB |
| 7. Naming Modules.mp4 |
5.95MB |
| 7. Naming Modules-en_US.srt |
2.06KB |
| 8. ActiveCell.mp4 |
8.70MB |
| 8. ActiveCell-en_US.srt |
5.19KB |
| 8. Comments.mp4 |
18.45MB |
| 8. Comments-en_US.srt |
7.46KB |
| 8. Customizing the Visual Basic Environment.mp4 |
4.84MB |
| 8. Customizing the Visual Basic Environment-en_US.srt |
1.30KB |
| 8. Error Handling The On Error Resume Next Statement.mp4 |
5.83MB |
| 8. Error Handling The On Error Resume Next Statement-en_US.srt |
1.90KB |
| 8. Exiting a For Loop.mp4 |
4.58MB |
| 8. Exiting a For Loop-en_US.srt |
2.84KB |
| 8. Test Your Skills.mp4 |
8.24MB |
| 8. Test Your Skills-en_US.srt |
2.84KB |
| 8. Using GoTo to Create Branching Logic in Your VBA Code.mp4 |
10.26MB |
| 8. Using GoTo to Create Branching Logic in Your VBA Code-en_US.srt |
5.68KB |
| 9. Do Until Loop.mp4 |
13.57MB |
| 9. Do Until Loop-en_US.srt |
1.74KB |
| 9. Error Handling The Err Object.mp4 |
11.17MB |
| 9. Error Handling The Err Object-en_US.srt |
4.93KB |
| 9. Rows and Columns.mp4 |
4.38MB |
| 9. Rows and Columns-en_US.srt |
3.14KB |
| 9. Using Objects.mp4 |
9.35MB |
| 9. Using Objects-en_US.srt |
3.51KB |
| Accessing-Macros-through-Command-Buttons.pdf |
357.35KB |
| Accessing-Macros-through-Shapes.pdf |
343.84KB |
| Accessing-Macros-through-the-Quick-Access-Toolbar.pdf |
410.42KB |
| Accessing-Macros-through-the-Ribbon.pdf |
362.21KB |
| ActiveSheet.html |
380B |
| Add.xlsm |
12.74KB |
| Aligning-Controls.pdf |
347.83KB |
| Arithmetic-Operators.pdf |
326.76KB |
| ArraytoPopulate.xlsm |
14.47KB |
| Assigning-a-Macros-to-a-Shortcut-Key.pdf |
279.92KB |
| AutoFit Columns and Rows.html |
996B |
| Bonus Resources.txt |
357B |
| Calling Procedures with the Same Name.html |
888B |
| Clear.xlsm |
16.11KB |
| Closing a Form.html |
154B |
| Code-Snippets.pdf |
467.17KB |
| Common-Excel-VBA-Statements.pdf |
390.49KB |
| Control Availability.html |
435B |
| Copy.xlsm |
8.90KB |
| CopyData.xlsm |
17.08KB |
| Create-Charts.xlsm |
15.09KB |
| Creating-Functions.xlsm |
18.68KB |
| Creating-Functions-Exercise.pdf |
240.37KB |
| CurrentRegion.xlsm |
17.97KB |
| Custom-Date-Formatting.pdf |
374.81KB |
| Customizing-the-Visual-Basic-Environment.pdf |
605.94KB |
| Custom-Number-Formatting.pdf |
382.51KB |
| Custom-String-Formatting.pdf |
446.17KB |
| Debugging.xlsm |
18.76KB |
| Declaring Multiple Variables.html |
689B |
| DeletingBlankRowsandColumns.xlsm |
151.97KB |
| Deleting Worksheets.html |
408B |
| Dependent-Combo-Boxes.pdf |
419.24KB |
| Docking-Windows.pdf |
341.54KB |
| DoUntil.xlsm |
17.84KB |
| DoWhile.xlsm |
18.92KB |
| ErrorHandling.xlsm |
18.70KB |
| Excel-VBA-Functions.pdf |
412.49KB |
| Exercise-Name-Value.xlsm |
17.36KB |
| Exporting-and-Importing-Modules.pdf |
489.51KB |
| Filtering.xlsm |
156.22KB |
| For-Each.xlsm |
18.25KB |
| For-Loop-Exercise.xlsm |
15.06KB |
| FormatDateTime-Function.pdf |
349.74KB |
| Formatting.xlsm |
253.10KB |
| Form-Controls.pdf |
372.83KB |
| Form-Events.pdf |
345.06KB |
| Form-Project.pdf |
530.38KB |
| For-Next-Loop-Exercise.pdf |
304.47KB |
| Get Bonus Downloads Here.url |
183B |
| Glossary.pdf |
380.07KB |
| GoTo.xlsm |
13.10KB |
| How-are-you-enjoying-the-Course.pdf |
25.99KB |
| Identifier-Type-Characters.pdf |
392.38KB |
| IfThen.xlsm |
13.04KB |
| InputBox.xlsm |
19.40KB |
| Input-Box-Exercise.pdf |
300.97KB |
| Inserting Columns and Rows.html |
458B |
| Keyboard-Shortcuts-for-the-VBA-Code-Window.pdf |
351.90KB |
| Logical Errors.html |
529B |
| Logical-Operators.pdf |
329.38KB |
| Message-Box.xlsm |
15.79KB |
| Message-Box-Buttons.pdf |
422.61KB |
| Message-Box-Exercise.pdf |
319.30KB |
| Moving Worksheets.html |
313B |
| PasteSpecial.xlsm |
17.25KB |
| Printing to PDF.html |
834B |
| Protecting-Code.pdf |
383.35KB |
| Quick Answer For Next Loops.html |
323B |
| Quick Questions For Next Loops.html |
407B |
| RemoveDuplicates.xlsm |
15.22KB |
| Reserved-Keywords.pdf |
370.61KB |
| Run-Time Errors.html |
773B |
| Scope.xlsm |
12.71KB |
| Searching-for-Text-Your-Code.pdf |
287.54KB |
| Section Summary.html |
1.48KB |
| Section Summary.html |
555B |
| Section Summary.html |
1.03KB |
| Section Summary.html |
2.41KB |
| Section Summary.html |
1.68KB |
| Section Summary.html |
2.59KB |
| Section Summary.html |
1.79KB |
| Section Summary.html |
1.67KB |
| Section Summary.html |
1.78KB |
| Section Summary.html |
1.54KB |
| Section Summary.html |
972B |
| Security-Settings.pdf |
368.51KB |
| Select-Case.xlsm |
19.46KB |
| Selecting.xlsm |
155.41KB |
| Setting the Focus of a Control.html |
371B |
| Showing and Hiding a Form Using VBA.html |
1.14KB |
| Sorting.xlsm |
163.73KB |
| Static-Arrays.xlsm |
15.76KB |
| String Concatenation.html |
247B |
| Suggested-Naming-Conventions-for-Controls.pdf |
396.82KB |
| Syntax Errors.html |
875B |
| Tab Order.html |
607B |
| Test-Your-Skills.pdf |
521.96KB |
| Test-Your-Skills-Loops.pdf |
526.50KB |
| Test-Your-Skills-User-Interaction.pdf |
451.86KB |
| The-Cells-Object-and-Operators.xlsx |
8.81KB |
| The Colon Operator.html |
298B |
| The-Format-Function-Using-Named-Format-Expressions.pdf |
365.60KB |
| The FormatNumber Function.html |
451B |
| The FormatPercent Function.html |
531B |
| The Line Continuation Operator.html |
752B |
| The Name Property.html |
203B |
| The-Object-Browser.pdf |
273.23KB |
| The PrintOut Method.html |
1.75KB |
| The PrintPreview Method.html |
633B |
| The-Range-Object.pdf |
330.52KB |
| The Select Method.html |
382B |
| The-Sort-Method.pdf |
374.33KB |
| The Value Property.html |
427B |
| The With Statement.html |
1021B |
| Tracing-Code-Execution.pdf |
248.49KB |
| Unreserved-Keywords.pdf |
254.48KB |
| Useful-Font-Object-Members.pdf |
399.57KB |
| Using-Byte-Variables.pdf |
367.30KB |
| Using-Currency-Variables.pdf |
338.84KB |
| Using-Date-Variables.pdf |
335.14KB |
| Using-Rows-and-Columns.pdf |
329.21KB |
| Using-String-Variables.pdf |
334.12KB |
| Using-the-Cells-Object-and-Operators.pdf |
391.76KB |
| VBA-Datatypes.pdf |
362.26KB |
| VBA-Keyboard-Shortcuts.pdf |
433.16KB |
| Workbook-Events.pdf |
370.45KB |
| Worksheet-Events.pdf |
357.13KB |
| xExitDo.xlsm |
18.32KB |
| XlAutoFilterOperator.pdf |
421.99KB |
| xlCellTypes-You-Can-Use-with-the-SpecialCells-Method.pdf |
375.72KB |