Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence CBT
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Programming Languages Excel VBA

The Ultimate Excel VBA Arrays Course

Learn To Manipulate Data Invisibly and At Lightning Speeds with Arrays!
Rating: 4.3 out of 54.3 (445 ratings)
2,612 students
Created by Daniel Strong
Last updated 4/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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 content

4 sections • 47 lectures • 3h 43m total length

  • Preview01:30
  • What's An Array - Overview and Sheet Demonstration
    02:54
  • Preview04:47
  • More On One-Dimensional Declaration
    02:14
  • Declaring Non-Traditional Boundaries and Thresholds
    00:37
  • Preview04:08
  • Cells Object Lesson and Comparison
    02:13
  • Multidimensional Arrays
    05:21

  • Populating an Array with Array() Function
    03:09
  • Populating an Array with Split() Function
    04:28
  • Section 02 Exercise
    00:12
  • Exercise - Solution
    05:53
  • Populating an Array with a Range Via (FOR NEXT) Loop
    05:00
  • Populating an Array with a Range Via (FOR EACH) Loop
    07:35
  • Populating an Array with a Range Directly
    03:37
  • Getting the Start and End Boundaries
    02:44
  • Looping Through a 1 Dimensional Array
    03:36
  • FOR EACH Loop Through an Array
    01:53
  • Looping Through a 2 Dimensional Array
    05:45
  • Subscript Out Of Range - Reasons for Run-time error 9
    01:59
  • Static vs Dynamic
    01:56
  • Change The Size (on the Fly)!
    05:54
  • Resize Array Without Losing Everything
    03:52
  • Returning Array to a Worksheet
    08:37
  • Preview09:07
  • Storing Array Data...
    04:31
  • Storing Array in Names
    05:18
  • Accessing Array from Invisible Name in Names Manager
    02:07

  • Using WorksheetFunctions on Arrays
    06:14
  • Passing an Array Into a Function or Sub
    07:25
  • Passing an Array Into a Function or Sub (Advanced Example)
    11:19
  • Returning an Array FROM a Function
    09:06
  • IsArray Function
    03:27
  • Filter() Function
    05:37
  • Join() Function
    03:05
  • Join() Function - Practical Example
    09:04
  • The Erase Method
    03:10
  • Transposing an Array
    05:19
  • Determining Worksheet Range from Array Size
    07:01
  • Dynamic Sorting 01 - 2d Array On Sheet Dynamically
    05:16
  • Dynamic Sorting 02 - Dynamic Sort Record, Syntax and Explanation
    13:20
  • BONUS - ReDim Preserving a Multi Dimensional Array - Part 1
    03:29
  • BONUS - ReDim Preserving a MD Array - 02 Transpose Method
    04:57
  • BONUS - ReDim Preserving a MD Array - 03 Custom Function
    04:46

  • Bubble Sorting
    03:45
  • Quick Sorting
    06:25
  • BONUS LECTURE
    00:03

Requirements

  • You should already have Microsoft Excel (version 2003, 2007, 2010, 2013 or 2016). Obviously the newer the better, but VBA works the same in all versions. It's just that newer versions have more options, thus more VBA Commands to control those options.
  • Basic Excel skills needed for this course. Everything I do is explained thoroughly.
  • Everything is explained in detail, but any Excel VBA experience you have will help.

Description

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!

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.

Featured review

Consuelo Palmas
Consuelo Palmas
31 courses
7 reviews
Rating: 5.0 out of 5a year ago
This course is awesome! The instructor explains everything very clearly and the pace is just right. All the information I was looking for is covered. I certainly have benefited greatly from this course, highly recommended.

Instructor

Daniel Strong
Excel Instructor/Programmer
Daniel Strong
  • 4.5 Instructor Rating
  • 15,444 Reviews
  • 121,791 Students
  • 10 Courses

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 - that make you irresistable and irreplacable. Building REAL Programs, Advanced Reporting and Data Analysis. Dashboards and live data. Automation. My main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems and change Real Lives.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.