< Intermediate Excel VBA (Course 2)

60 casts | 5:01:52 for the total course

created by Mammoth Interactive INC

• 1. 12 - Introduction to loops
  • Intermediate Excel VBA | Topics Overview | 12.0

  • Intermediate Excel VBA | Single Loop | 12.1

  • Intermediate Excel VBA | Double Loop | 12.2

  • Intermediate Excel VBA | Triple Loop | 12.3

  • Intermediate Excel VBA | Do While Loop | 12.4

  • Intermediate Excel VBA | Build a Commission Table | 12.5

• 2. 13 - Loop projects

  • Intermediate Excel VBA | Topics Overview | 13.0

  • Intermediate Excel VBA | Loop Through Defined Range | 13.1

  • Intermediate Excel VBA | Loop Through Entire Column | 13.2

  • Intermediate Excel VBA | Do Until Loop | 13.3

  • Intermediate Excel VBA | Use Step to Increment | 13.4

  • Intermediate Excel VBA | Build a Pattern Project | 13.5

  • Intermediate Excel VBA | How To Sort | 13.6

  • Intermediate Excel VBA | Sort by Related Data | 13.7

  • Intermediate Excel VBA | Delete Duplicate Values | 13.8

• 3. 14 - String manipulation

  • Intermediate Excel VBA | Topics Overview | 14.0

  • Intermediate Excel VBA | Join Strings | 14.1

  • Intermediate Excel VBA | Extract Substrings From Left or Right | 14.2

  • Intermediate Excel VBA | Extract Substring At Middle | 14.3

  • Intermediate Excel VBA | Get Length of a String | 14.4

  • Intermediate Excel VBA | Get Substring Position | 14.5

  • Intermediate Excel VBA | How to Split Strings | 14.6

  • Intermediate Excel VBA | Reverse Characters | 14.7

  • Intermediate Excel VBA | Change String Casing | 14.8

  • Intermediate Excel VBA | Count Words in a Range | 14.9

• 4. 15 - Build custom functions

  • Intermediate Excel VBA | Make and Use Your Own Function | 15.1

  • Intermedite Excel VBA | Pass Arguments to a Function | 15.2

  • Intermediate Excel VBA | Custom Calculator Function | 15.3

• 5. 16 - Build arrays

  • Intermediate Excel VBA | Topics Overview | 16.0

  • Intermediate Excel VBA | One Dimensional Array | 16.1

  • Intermediate Excel VBA | Two Dimensional Array | 16.2

  • Intermediate Excel VBA | Change Array Size | 16.3

  • Intermediate Excel VBA | Build an Array | 16.4

  • Intermediate Excel VBA | Populate Row With Array | 16.5

  • Intermediate Excel VBA | Array Length | 16.6

  • Intermediate Excel VBA | Split String Into an Array | 16.7

  • Intermediate Excel VBA | Join Array into a String | 16.8

• 6. 17 - Work with dates

  • Intermediate Excel VBA | Topics Overview | 17.0

  • Intermediate Excel VBA | Delay A Procedure | 17.1

  • Intermediate Excel VBA | Schedule A Procedure | 17.2

  • Intermediate Excel VBA | Count Years | 17.3

  • Intermediate Excel VBA | Count Days Between Dates | 17.4

  • Intermediate Excel VBA | Count Weekdays Between Dates | 17.5

  • Intermediate Excel VBA | Sort Dates | 17.6

• 7. 18 - Application Object

  • Intermediate Excel VBA | Topics Overview | 18.0

  • Intermediate Excel VBA | How to Access Excel Functions | 18.1

  • Intermediate Excel VBA | Disable Screen Updating | 18.2

  • Intermediate Excel VBA | Disable Alerts | 18.3

  • Intermediate Excel VBA | Show Progress Of Macro | 18.4

  • Intermediate Excel VBA | Read Data From A File | 18.5

  • Intermediate Excel VBA | Write Data to a File | 18.6

• 8. 19 - VBA Projects
  • Intermediate Excel VBA | Build A Table | 19.1

  • Intermediate Excel VBA | Build A Table of Contents | 19.2

  • Intermediate Excel VBA | Build A Table of Contents 2 | 19.3

  • Intermediate Excel VBA | Combine Worksheets | 19.4

  • Intermediate Excel VBA | Combine Worksheets By Column | 19.5

• 9. 20 - Programming Charts

  • Intermediate Excel VBA | Topics Overview | 20.0

  • Intermediate Excel VBA | Program A Chart | 20.1

  • Intermediate Excel VBA | Program An Embedded Chart | 20.2

  • Intermediate Excel VBA | Delete Charts Programatically | 20.3