Excel Visual Basic Applications - Intermediate Level
This course is a comprehensive overview of what effective business analysts really do - their strategies, techniques, tools, and methods – all of which apply to any process whether it’s a traditional large project, an Agile or DevOps project.
1
Segment - 01 - Course Overview
2
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
3
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
4
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
5
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
6
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
7
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
8
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
9
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
10
Segment - 57 - Topics Overview
Segment - 58 - Program a Chart
Segment - 59 - Program an Embedded Chart
Segment - 60 - Delete Charts Programmatically
Source File