Intermediate Excel VBA (Course 2)

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

Excel VBA

Description

This course is project-based so you will not be learning a bunch of useless coding practices. At the end of this course you will have real world apps to use in your portfolio. We feel that project based training content is the best way to get from A to B. Taking this course means that you learn practical, employable skills immediately. You can use the projects you build in this course to add to your LinkedIn profile. Give your portfolio fuel to take your career to the next level.

Learn intermediate VBA skills in this hands-on course. Only beginners VBA skills are required.

Hands On Lectures Including:

Build projects with loops, a fundamental programming concept.

Learn to manipulate strings to automate your Excel workflow.

Build custom functions, including a calculator, to maximize your Excel potential.

Build arrays, a key programming data structure, in VBA.

Learn to work with dates to schedule procedures and much more.

Work with the Application object to show progress, read and write data, and more.

Learn to build a table of contents project to organize your worksheets.

Build charts programatically.

And much more!

Learning how to code is a great way to jump in a new career or enhance your current career.

Coding is the new math and learning how to code will propel you forward for any situation.

Learn it today and get a head start for tomorrow. People who can master technology will rulethe future.

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

      0:57

    • Intermediate Excel VBA | Single Loop | 12.1

      6:00

    • Intermediate Excel VBA | Double Loop | 12.2

      5:15

    • Intermediate Excel VBA | Triple Loop | 12.3

      6:24

    • Intermediate Excel VBA | Do While Loop | 12.4

      5:34

    • Intermediate Excel VBA | Build a Commission Table | 12.5

      5:33

  • 2. 13 - Loop projects
    • Intermediate Excel VBA | Topics Overview | 13.0

      1:41

    • Intermediate Excel VBA | Loop Through Defined Range | 13.1

      3:37

    • Intermediate Excel VBA | Loop Through Entire Column | 13.2

      3:29

    • Intermediate Excel VBA | Do Until Loop | 13.3

      3:22

    • Intermediate Excel VBA | Use Step to Increment | 13.4

      4:23

    • Intermediate Excel VBA | Build a Pattern Project | 13.5

      4:50

    • Intermediate Excel VBA | How To Sort | 13.6

      5:33

    • Intermediate Excel VBA | Sort by Related Data | 13.7

      8:16

    • Intermediate Excel VBA | Delete Duplicate Values | 13.8

      6:11

  • 3. 14 - String manipulation
    • Intermediate Excel VBA | Topics Overview | 14.0

      1:28

    • Intermediate Excel VBA | Join Strings | 14.1

      3:14

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

      3:08

    • Intermediate Excel VBA | Extract Substring At Middle | 14.3

      4:12

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

      2:40

    • Intermediate Excel VBA | Get Substring Position | 14.5

      3:16

    • Intermediate Excel VBA | How to Split Strings | 14.6

      4:57

    • Intermediate Excel VBA | Reverse Characters | 14.7

      4:11

    • Intermediate Excel VBA | Change String Casing | 14.8

      3:29

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

      8:17

  • 4. 15 - Build custom functions
    • Intermediate Excel VBA | Make and Use Your Own Function | 15.1

      6:33

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

      7:44

    • Intermediate Excel VBA | Custom Calculator Function | 15.3

      6:23

  • 5. 16 - Build arrays
    • Intermediate Excel VBA | Topics Overview | 16.0

      1:19

    • Intermediate Excel VBA | One Dimensional Array | 16.1

      5:47

    • Intermediate Excel VBA | Two Dimensional Array | 16.2

      6:26

    • Intermediate Excel VBA | Change Array Size | 16.3

      4:54

    • Intermediate Excel VBA | Build an Array | 16.4

      5:09

    • Intermediate Excel VBA | Populate Row With Array | 16.5

      3:22

    • Intermediate Excel VBA | Array Length | 16.6

      6:48

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

      4:29

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

      3:49

  • 6. 17 - Work with dates
    • Intermediate Excel VBA | Topics Overview | 17.0

      1:13

    • Intermediate Excel VBA | Delay A Procedure | 17.1

      4:12

    • Intermediate Excel VBA | Schedule A Procedure | 17.2

      4:19

    • Intermediate Excel VBA | Count Years | 17.3

      5:21

    • Intermediate Excel VBA | Count Days Between Dates | 17.4

      2:42

    • Intermediate Excel VBA | Count Weekdays Between Dates | 17.5

      4:52

    • Intermediate Excel VBA | Sort Dates | 17.6

      6:27

  • 7. 18 - Application Object
    • Intermediate Excel VBA | Topics Overview | 18.0

      1:36

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

      4:28

    • Intermediate Excel VBA | Disable Screen Updating | 18.2

      3:19

    • Intermediate Excel VBA | Disable Alerts | 18.3

      3:38

    • Intermediate Excel VBA | Show Progress Of Macro | 18.4

      5:37

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

      6:36

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

      5:10

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

      4:47

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

      11:47

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

      4:43

    • Intermediate Excel VBA | Combine Worksheets | 19.4

      17:42

    • Intermediate Excel VBA | Combine Worksheets By Column | 19.5

      15:49

  • 9. 20 - Programming Charts
    • Intermediate Excel VBA | Topics Overview | 20.0

      1:21

    • Intermediate Excel VBA | Program A Chart | 20.1

      6:13

    • Intermediate Excel VBA | Program An Embedded Chart | 20.2

      5:00

    • Intermediate Excel VBA | Delete Charts Programatically | 20.3

      2:20

Created By

Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more. Over 11 years, Mammoth Interactive has built a global student community with 3.3 million

US$19.98

  US$199.00

Buy Now (US$19.98) ➔

Lifetime Access
30-Day Money-Back Guarantee.

Reviews
No reviews yet