Course curriculum

  • 1

    Welcome to the course!

    • Instructor bio - John Bura
    • Key pointers for this program
    • Joining the Alumni Community
  • 2

    Introduction to Intermediate Level

    • Segment - 01 - Course Overview
  • 3

    Introduction to Loops

    • Segment - 02 - Topics Overview
    • Segment - 03 - Single Loop
    • Segment - 04 - Double Loop
    • Segment - 05 - Triple Loop
    • Segment - 06 - Do While Loop
    • Segment - 07 - Build a Commission Table
    • Source File
  • 4

    Loop Projects

    • Segment - 08 - Topics Overview
    • Segment - 09 - Loop Through Defined Range
    • Segment - 10 - Loop Through Entire Column
    • Segment - 11 - Do Until Loop
    • Segment - 12 - Use Step to Increment
    • Segment - 13 - Build a Pattern Project
    • Segment - 14 - How to Sort
    • Segment - 15 - Sort by Related Data
    • Segment - 16 - Delete Duplicate Values
    • Source File
  • 5

    String Manipulation

    • Segment - 17 - Topics Overview
    • Segment - 18 - Join Strings
    • Segment - 19 - Extract Substrings from Left or Right
    • Segment - 20 - Extract Substring at Middle
    • Segment - 21 - Get Length of a String
    • Segment - 22 - Get Substring Position
    • Segment - 23 - How to Split Strings
    • Segment - 24 - Reverse Characters
    • Segment - 25 - Change String Casing
    • Segment - 26 - Count Words in a Range
    • Source File
  • 6

    Build Custom Functions

    • Segment - 27 - Topics Overview
    • Segment - 28 - Make and Use Your Own Function
    • Segment - 29 - Pass Arguments to a Function
    • Segment - 30 - Custom Calculator Function
    • Source File
  • 7

    Build Arrys

    • Segment - 31 - Topics Overview
    • Segment - 32 - One Dimensional Array
    • Segment - 33 - Two Dimensional Array
    • Segment - 34 - Change Array Size
    • Segment - 35 - Build an Array
    • Segment - 36 - Populate Row with Array
    • Segment - 37 - Array Length
    • Segment - 38 - Split String Into an Array
    • Segment - 39 - Join Array Into a String
    • Source File
  • 8

    Work with Dates

    • Segment - 40 - Topics Overview
    • Segment - 41 - Delay a Procedure
    • Segment - 42 - Schedule a Procedure
    • Segment - 43 - Count Years
    • Segment - 44 - Count Days between Dates
    • Segment - 45 - Count Weekdays between Dates
    • Segment - 46 - Sort Dates
    • Source File
  • 9

    Application Object

    • Segment - 47 - Topics Overview
    • Segment - 48 - How to Access Excel Functions
    • Segment - 49 - Disable Screen Updating
    • Segment - 50 - Write Data to a File
    • Source File
  • 10

    VBA Projects

    • Segment - 51 - Topics Overview
    • Segment - 52 - Build a Table
    • Segment - 53 - Build a Table of Contents
    • Segment - 54 - Build a Table of Contents 2
    • Segment - 55 - Combine Worksheets
    • Segment - 56 - Combine Worksheets by Column
    • Source File
  • 11

    Programming Charts

    • Segment - 57 - Topics Overview
    • Segment - 58 - Program a Chart
    • Segment - 59 - Program an Embedded Chart
    • Segment - 60 - Delete Charts Programmatically
    • Source File