The Ultimate Excel VBA Arrays Course

The Ultimate Excel VBA Arrays Course, available at $99.99, has an average rating of 4.31, with 48 lectures, based on 689 reviews, and has 3904 subscribers.

You will learn about Speed Up Your Macros in a Few Short Lessons! Create and Manipulate Data Invisibly in the Background Learn to populate Arrays several different ways Understand multiple ways to put Array data onto worksheets Store Data in Hidden Locations, Where only you can find and Manipulate it… Return Multiple Pieces of Information from a Single Function Pass Arrays into Subs and Functions to Manipulate Lots of Data at Once! Learn Special Built-In Functions specifically for Arrays as well as Custom Functions Master the Art of Array Sorting – (3 different Methods!) Glean information from and Manipulate text like never before Store MULTIPLE pieces of information in a single cell to keep your tables tidy Create your own functions that return more than one result!! Master Populating, Looping through and Manipulating Arrays for greater efficiency This course is ideal for individuals who are Take this course if you want to increase the SPEED of your macros and be more efficient. No prior programming knowledge is needed, but it helps. or If you want to learn the basic of Arrays – even if you don't use Excel VBA – Arrays work very similarly in other programs. This course primarily covers Excel VBA Arrays though. or If you want to know the hidden secrets of Excel for speed, and heightened data manipulation skills, this course is for you. or Anyone looking for the next step in their Excel Ninja skillset. or If you need a simple explanation for a complex topic (Arrays) in a way that you can take and immediately use. It is particularly useful for Take this course if you want to increase the SPEED of your macros and be more efficient. No prior programming knowledge is needed, but it helps. or If you want to learn the basic of Arrays – even if you don't use Excel VBA – Arrays work very similarly in other programs. This course primarily covers Excel VBA Arrays though. or If you want to know the hidden secrets of Excel for speed, and heightened data manipulation skills, this course is for you. or Anyone looking for the next step in their Excel Ninja skillset. or If you need a simple explanation for a complex topic (Arrays) in a way that you can take and immediately use.

Enroll now: The Ultimate Excel VBA Arrays Course

Summary

Title: The Ultimate Excel VBA Arrays Course

Price: $99.99

Average Rating: 4.31

Number of Lectures: 48

Number of Published Lectures: 48

Number of Curriculum Items: 48

Number of Published Curriculum Objects: 48

Original Price: $99.99

Quality Status: approved

Status: Live

What You Will Learn

Speed Up Your Macros in a Few Short Lessons!
Create and Manipulate Data Invisibly in the Background
Learn to populate Arrays several different ways
Understand multiple ways to put Array data onto worksheets
Store Data in Hidden Locations, Where only you can find and Manipulate it…
Return Multiple Pieces of Information from a Single Function
Pass Arrays into Subs and Functions to Manipulate Lots of Data at Once!
Learn Special Built-In Functions specifically for Arrays as well as Custom Functions
Master the Art of Array Sorting – (3 different Methods!)
Glean information from and Manipulate text like never before
Store MULTIPLE pieces of information in a single cell to keep your tables tidy
Create your own functions that return more than one result!!
Master Populating, Looping through and Manipulating Arrays for greater efficiency

Who Should Attend

Take this course if you want to increase the SPEED of your macros and be more efficient. No prior programming knowledge is needed, but it helps.
If you want to learn the basic of Arrays – even if you don't use Excel VBA – Arrays work very similarly in other programs. This course primarily covers Excel VBA Arrays though.
If you want to know the hidden secrets of Excel for speed, and heightened data manipulation skills, this course is for you.
Anyone looking for the next step in their Excel Ninja skillset.
If you need a simple explanation for a complex topic (Arrays) in a way that you can take and immediately use.

Target Audiences

Take this course if you want to increase the SPEED of your macros and be more efficient. No prior programming knowledge is needed, but it helps.
If you want to learn the basic of Arrays – even if you don't use Excel VBA – Arrays work very similarly in other programs. This course primarily covers Excel VBA Arrays though.
If you want to know the hidden secrets of Excel for speed, and heightened data manipulation skills, this course is for you.
Anyone looking for the next step in their Excel Ninja skillset.
If you need a simple explanation for a complex topic (Arrays) in a way that you can take and immediately use.

Arrays are present in many programming languages, but most people don’t take the time to master them and can get frustrated when their code seems sloppy, difficult to read, and often can take a long time to run.

Arrays are often a subject of confusion or irritation – it doesn’t make much sense when trying to understand using a huge blog post or cryptic book. What you need is a visual explanation of these concepts in bite sized pieces – something to make it REAL!

With over three hours of over the shoulder, real-world training, this course will show you how to increase the speed of your VBA applications, build code that is easier to read and maintain – using less lines of code than you ever imagined!

I’ll show you the easiest way to understand this highly convoluted topic and once you understand the power of arrays, you’ll be able to:

Glean information from and Manipulate text like never before
Store MULTIPLE pieces of information in a single cell to keep your tables tidy
MASSIVELY speed up your macros that deal with worksheets or cells!
Understand multiple ways to put Array data onto worksheets
Create your own functions that return more than one result!!
Store Data in Hidden Locations, Where only you can find and Manipulate it…
Master Populating, Looping through and Manipulating Arrays for greater efficiency
Learn special built-in Array functions as well as custom ones Included in the course
Best methods of Sorting Array data
And much more!

You’ll receive 100% of the source code, downloadable materials and course workbooks instantly, yours to keep FOREVER. In addition, you’ll receive LIFETIME ACCESS to the course videos, including updates, BONUS videos and lectures as they come out and any future source code and workbooks – Yours to keep – FREE.

All students will receive LIFETIME ACCESS to ask me any questions about the materials in the FORUM section – as well as chat with other students and help each other. As always, this is backed by a 30 day 100% No questions asked refund as well.

So Join today – and increase your Excel Mastery and I’ll see you in the FORUMS!

Course Curriculum

Chapter 1: I Need Arrays, Boss!

Lecture 1: Introduction and Workbooks Download

Lecture 2: Getting FAST Help and Other Freebies with Excel Ninjas Group

Lecture 3: What's An Array – Overview and Sheet Demonstration

Lecture 4: What's An Array – Technical Demonstration With Code

Lecture 5: More On One-Dimensional Declaration

Lecture 6: Declaring Non-Traditional Boundaries and Thresholds

Lecture 7: Data Types in Arrays

Lecture 8: Cells Object Lesson and Comparison

Lecture 9: Multidimensional Arrays

Chapter 2: Populating and Manipulating Arrays

Lecture 1: Populating an Array with Array() Function

Lecture 2: Populating an Array with Split() Function

Lecture 3: Section 02 Exercise

Lecture 4: Exercise – Solution

Lecture 5: Populating an Array with a Range Via (FOR NEXT) Loop

Lecture 6: Populating an Array with a Range Via (FOR EACH) Loop

Lecture 7: Populating an Array with a Range Directly

Lecture 8: Getting the Start and End Boundaries

Lecture 9: Looping Through a 1 Dimensional Array

Lecture 10: FOR EACH Loop Through an Array

Lecture 11: Looping Through a 2 Dimensional Array

Lecture 12: Subscript Out Of Range – Reasons for Run-time error 9

Lecture 13: Static vs Dynamic

Lecture 14: Change The Size (on the Fly)!

Lecture 15: Resize Array Without Losing Everything

Lecture 16: Returning Array to a Worksheet

Lecture 17: BONUS – Real World Speed Comparison – Case Study

Lecture 18: Storing Array Data…

Lecture 19: Storing Array in Names

Lecture 20: Accessing Array from Invisible Name in Names Manager

Chapter 3: Functions, Arrays and You – A Magical Combination

Lecture 1: Using WorksheetFunctions on Arrays

Lecture 2: Passing an Array Into a Function or Sub

Lecture 3: Passing an Array Into a Function or Sub (Advanced Example)

Lecture 4: Returning an Array FROM a Function

Lecture 5: IsArray Function

Lecture 6: Filter() Function

Lecture 7: Join() Function

Lecture 8: Join() Function – Practical Example

Lecture 9: The Erase Method

Lecture 10: Transposing an Array

Lecture 11: Determining Worksheet Range from Array Size

Lecture 12: Dynamic Sorting 01 – 2d Array On Sheet Dynamically

Lecture 13: Dynamic Sorting 02 – Dynamic Sort Record, Syntax and Explanation

Lecture 14: BONUS – ReDim Preserving a Multi Dimensional Array – Part 1

Lecture 15: BONUS – ReDim Preserving a MD Array – 02 Transpose Method

Lecture 16: BONUS – ReDim Preserving a MD Array – 03 Custom Function

Chapter 4: Custom Functions – Because Microsoft Can't Think Of It All

Lecture 1: Bubble Sorting

Lecture 2: Quick Sorting

Lecture 3: BONUS LECTURE

Instructors

Daniel Strong
Excel Instructor/Programmer

Rating Distribution

1 stars: 5 votes
2 stars: 10 votes
3 stars: 55 votes
4 stars: 227 votes
5 stars: 392 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu