Intermediate Excel VBA
Intermediate Excel VBA
Created by John Bura
01
Skill level
All levels
02
Sections
10
03
Lectures
72
04
Instructor
John Bura
What's inside
This course includes.
✓
10
Sections
✓
72
Lectures
✓
72
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ Intermediate Course Intro 1 lecture
12.00.00 Course Overview
Locked
+ 12 Introduction to Loops 7 lectures
12.00 Topics Overview
Locked
12.01 Single Loop
Locked
12.02 Double Loop
Locked
12.03 Triple Loop
Locked
12.04 Do While Loop
Locked
12.05 Build A Commission Table
Locked
12 Source Files
Locked
+ 13 Loop Projects 10 lectures
13.00 Topics Overview
Locked
13.01 Loop Through Defined Range
Locked
13.02 Loop Through Entire Column
Locked
13.03 Do Until Loop
Locked
13.04 Use Step To Increment
Locked
13.05 Build A Pattern Project
Locked
13.06 How To Sort
Locked
13.07 Sort By Related Data
Locked
13.08 Delete Duplicate Values
Locked
Source Files
Locked
+ 14 String Manipulation 11 lectures
14.00 Topics Overview
Locked
14.01 Join Strings
Locked
14.02 Extract Substrings From Left Or Right
Locked
14.03 Extract Substring At Middle
Locked
14.04 Get Length Of A String
Locked
14.05 Get Substring Position
Locked
14.06 How To Split Strings
Locked
14.07 Reverse Characters
Locked
14.08 Change String Casing
Locked
14.09 Count Words In A Range
Locked
14 Source Files
Locked
+ 15 Build Custom Functions 5 lectures
15.00 Topics Overview
Locked
15.01 Make And Use Your Own Function
Locked
15.02 Pass Arguments To A Function
Locked
15.03 Custom Calculator Function
Locked
15 Source Files
Locked
+ 16 Build Arrays 10 lectures
16.00 Topics Overview
Locked
16.01 One Dimensional Array
Locked
16.02 Two Dimensional Array
Locked
16.03 Change Array Size
Locked
16.04 Build An Array
Locked
16.05 Populate Row With Array
Locked
16.06 Array Length
Locked
16.07 Split String Into An Array
Locked
16.08 Join Array Into A String
Locked
16 Source Files
Locked
+ 17 Work with Dates 8 lectures
17.00 Topics Overview
Locked
17.01 Delay A Procedure
Locked
17.02 Schedule A Procedure
Locked
17.03 Count Years
Locked
17.04 Count Days Between Dates
Locked
17.05 Count Weekdays Between Dates
Locked
17.06 Sort Dates
Locked
17 Source Files
Locked
+ 18 Application Object 8 lectures
18.00 Topics Overview
Locked
18.01 How To Access Excel Functions
Locked
18.02 Disable Screen Updating
Locked
18.03 Disable Alerts
Locked
18.04 Show Progress Of Macro_1
Locked
18.05 Read Data From A File
Locked
18.06 Write Data To A File
Locked
18 Source Files
Locked
+ 19 VBA Projects 7 lectures
19.00 Topics Overview
Locked
19.01 Build A Table
Locked
19.02 Build A Table Of Contents
Locked
19.03 Build A Table Of Contents 2
Locked
19.04 Combine Worksheets
Locked
19.05 Combine Worksheets By Column
Locked
19 Source Files
Locked
+ 20 Programming Charts 5 lectures
20.00 Topics Overview
Locked
20.01 Program A Chart
Locked
20.02 Program An Embedded Chart
Locked
20.03 Delete Charts Programatically
Locked
20 Source Files
Locked
Description
About this course.
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 rule the future.
Instructors
Taught by people who ship.
John Bura
Founder and CEO of Mammoth Club and Course Pro, the #1 AI-powered Learning Management System for course and content development, training and evaluation.
Ready to start building?
Intermediate Excel VBA