The Ultimate Excel VBA
Arrays Course

Learn To Manipulate Data Invisibly and At Lightning Speeds with Arrays!

$44

Great news! You already have access to this course! 👇

48

Lectures

4:00H

Duration

ALL

Skill Level

ENGLISH

Language

COURSE OVERVIEW

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!

What's Included In The Course

Know the hidden secrets of Excel for speed, and heightened data manipulation skills!

DOWNLOADABLE MATERIALS

You’ll receive 100% of the source code, downloadable materials and course workbooks instantly, yours to keep FOREVER.

LIFETIME COURSE ACCESS

You’ll receive LIFETIME ACCESS to the course videos, including updates, BONUS videos and lectures as they come out.

LEARNING PATH

  • Introduction and Workbooks Download 
  • Getting Fast Help and Other Freebies with Excel Ninjas Group
  • What’s An Array – Overview and Sheet Demonstration
  • What’s An Array – Technical Demonstration With Code
  • More On One-Dimensional Declaration
  • Declaring Non-Traditional Boundaries and Thresholds
  • Data Types In Arrays
  • Cells Object Lesson and Comparison
  • Multidimensional Arrays

Video: 26 minutes, 9 lectures   

  • Populating an Array with Array() Function
  • Populating an Array with Split() Function
  • Section 02 Exercise
  • Exercise – Solution
  • Populating an Array with a Range Via (FOR NEXT) Loop
  • Populating an Array with a Range Via (FOR EACH) Loop
  • Populating an Array with a Range Directly
  • Getting the Start and End Boundaries
  • Looping Through a 1 Dimensional Array
  • For Each Loop Through an Array
  • Looping Through a 2 Dimensional Array 
  • Subscript Out Of Range – Reasons for Run-time error 9
  • Static Vs Dynamic
  • Change The Size (on the Fly)
  • Resize Array Without Losing Everything
  • Returning Array to a Worksheet
  • BONUS – Real World Speed Comparison – Case Study
  • Storing Array Data
  • Storing Array in Names
  • Accessing Array from Invisible Name in Names Manage

Video: 1 hour & 27 minutes, 20 lectures   

  • Using Worksheet Functions on Arrays
  • Passing an Array Into a Function or Sub
  • Passing an Array Into a Function or Sub (Advanced Example)
  • Returning an Array From a Function
  • Is Array Function
  • Filter() Function
  • Join() Function
  • Join() Function – Practical Example
  • The Erase Method
  • Transposing An Array
  • Determining Worksheet Range from Array Size
  • Dynamic Sorting 01 – 2d Array On Sheet Dynamically
  • Dynamic Sorting 02 – Dynamic Sort Record, Syntax and Explanation
  • BONUS – ReDim Preserving a Multi Dimensional Array – Part 1
  • BONUS – ReDim Preserving a MD Array – 02 Transpose Method
  • BONUS – ReDim Preserving a MD Array – 03 Custom Function

Video: 1 hour & 43 minutes, 16 lectures   

  • Bubble Sorting
  • Quick Sorting
  • BONUS LECTURE

Video: 10 minutes, 3 lectures

WHO THIS COURSE IS FOR

  1. 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.

  2. 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

  3. Anyone looking for the next step in their Excel Ninja skillset.

  4. If you need a simple explanation for a complex topic (Arrays) in a way that you can take and immediately use.

WHAT YOU'LL LEARN

Join today – and increase your Excel Mastery!

What Students Say About The Course

STUDENTS' TESTIMONIALS

30-DAY MONEY BACK GUARANTEE

This is backed by a 30-day money back guarantee. No questions asked! 

Frequently Asked Questions

  • You should already have Microsoft Excel (version 2003 and up). 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.
  • The course will start right away upon signing up, you get instant access.

How would you like access to ALL our Excel courses?

  • Excel Ninja Pro is a subscription streaming service that offers a wide variety of Excel resources, including premium online courses, code vault, swipe files, downloadable workbooks, projects, events, and a results-driven community of Automators.

  • You can watch as much as you want, commercial free – all for one low monthly price. There’s always something new coming soon and Ninja Pro members get to help decide what comes next!

Learn more HERE.

Visit the My Courses link at the top left of the site menu. You can also visit the Member’s Area and click on Courses tab.

NOTE: You should have an email with a username and link to reset password initially. If not, please check spam folder (if none, contact us immediately or see “How do I change/update my password?” above).

  • Today’s World is full of busy people that want to better themselves, so self-paced programs are popular. Yes, you can learn at your own speed, so that you can focus on things that you find challenging and breeze past things that you already know. You will be the one to decide when to start accessing the course materials and when to finish.
  • Yes, definitely! If you have questions about the lesson, we will answer all your questions as soon as possible.
  • If you want to speed up your macros then this course is definitely for you!
  • Does lifetime access sounds good to you? You’ll have unlimited access to the course once you’ve enrolled. This means you can re-watch lessons whenever you need and complete the course at your own pace.

Every course in the member’s area comes with a ‘Certificate of Completion’ that you can add to your LinkedIn bio, to your resume or even brag to your friends.

You also get achievement badges the more you participate, comment, and share with the group. You can check out our achievement’s dashboard!

© 2023 – Strong Software Solutions LLC | ExcelVbaIsFun – Privacy PolicyTerms and Conditions
This site is not a part of the Facebook website or Facebook Inc. Additionally, This site is NOT endorsed by Facebook in any way.

FACEBOOK is a trademark of FACEBOOK, Inc.
X

Forgot Password?

Join Us

0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    Wait A Second!

    Thank you for visiting! Here's a FREE gift for you!

    Enroll In My FREE VBA Crash Course For FREE!

    Learn how to write macros from scratch, make buttons and simple procedures to automate tasks.