The Ultimate Excel VBA Arrays Course (Udemy.com)
Learn To Manipulate Data Invisibly and At Lightning Speeds with Arrays!
Created by: Daniel Strong
Produced in 2019
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
Quality Score
Overall Score : 92 / 100
Course Description
Arrays are often a subject of confusion or irritation - it doesnt 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!
Ill show you the easiest way to understand this highly convoluted topic and once you understand the power of arrays, youll 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!
Youll receive 100% of the source code, downloadable materials and course workbooks instantly, yours to keep FOREVER. In addition, youll 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 Ill see you in the FORUMS!
Who this course is 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.
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.
Instructor Details
- 4.6 Rating
129 Reviews
Daniel Strong
Hi! My name is Daniel and i'm 31. I've lived most my life in Missouri, United States. I've been using Excel since my early teens, and very early on realized that I absolutely love it. After working on various projects in my spare time for years, improving the lives of those that used my programs, I knew this was more than just a hobby for me; it's my passion. A few years back, I got my first opportunity to program in Excel, but when I landed the job I was asked to re-write my predecessor's coded programs with fancy databases and automated Crystal reports! I found my Excel skills somewhat lacking. I HAD TO LEARN VBA! I studied and studied what I could online and in books, but I wasn't able to learn much that way. I had to dive into my first project for months and months - basically just teaching myself and "figuring it out". I realized that if only someone was out there teaching Excel VBA like Mike Girvin (ExcelIsFun) taught Excel, making everything simple and visual - then Anyone could learn VBA! I started a YouTube channel, mostly for myself as a reference tool, but people started to bite. People flooded my inbox with questions and comments that I was literally changing their lives for the better. My passion is and always has been teaching, and I've turned thousands of people into Excel programmers. Now, with Udemy, I'm going to teach the good stuff - the stuff I kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - tha
More courses by Daniel Strong
More excel courses
Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)
Provider: Udemy
Time: 7h
$11.99
Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)
- Provider: Udemy
- Time: 21h
$11.99
Reviews
- Video Duration:
3.5h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2019 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
