The Ultimate Excel VBA Arrays Course
Learn To Manipulate Data Invisibly and At Lightning Speeds with Arrays!
4.44 (713 reviews)
4 054
students
4 hours
content
Nov 2021
last update
$99.99
regular price
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
Course Gallery
Loading charts...
Comidoc Review
Our Verdict
The Ultimate Excel VBA Arrays Course lives up to its name, providing an in-depth look at Array manipulation with various techniques. While some real-world examples could help illustrate the concepts further, the course's comprehensive nature and focus on efficiency render it a valuable resource for anyone wanting to master Arrays in Excel VBA.
What We Liked
- The course starts with the basics but quickly moves to advanced topics, providing a comprehensive understanding of Arrays in Excel VBA.
- Includes practical examples and exercises to help students grasp complex concepts, such as populating, looping through, and manipulating arrays.
- Covers built-in functions specific to Arrays and custom functions for enhanced efficiency and functionality.
- Demonstrates array sorting using multiple methods and manipulation of text data.
Potential Drawbacks
- Some users suggest that more in-depth explanations of the functions used to support the main subs could be beneficial.
- There is a need for examples showing how to work through columns of data with an unknown size or varying column count.
- A few users express a desire for more real-world examples and detailed explanations to better understand array implementation.
1427134
udemy ID
09/11/2017
course created date
22/11/2019
course indexed date
Bot
course submited by