Excel VBA SUPER STRONG ARRAYS Series4

In-depth study of Arrays from basic level to Extreme Advance

3.80 (18 reviews)
Udemy
platform
English
language
Programming Languages
category
instructor
100
students
5.5 hours
content
Nov 2021
last update
$19.99
regular price

What you will learn

You will learn the Use of Powerful Arrays from Basics to Advance.

How to Define Arrays in VBA using Dim and Redim statements.

What are One dimensional arrays and multi-dimensional arrays

How to use Loops inside Arrays to fill its indexes.

By default what is the index of arrays and how to change it using Option Base1

Interview related questions discussion on Arrays - Learn how to Crack it.

What is the Role of Redim statement in Arrays. When you should declare dim and Redim - Practical knowledge

Know the Importance of Preserve keyword in Arrays. What is the role of PRESERVE.

How to declare static and dynamic arrays - Using constants and variables - Static and Dynamic

How to Resize arrays in program as per the requirement

How to supply large real type data into arrays without running complex loops.

How to use Vlookup in arrays and make your lookup tasks very easy.

What does SPLIT Function does and why we need it.

Things you need to take care in Defining Arrays using SPLIT Function.

Real time based projects solutions for you to see actual use of Arrays

Why errors like Subscript Out of Range and Constant Expression required comes in the program - Full discussion on same

Description

  • What are arrays . Why we use them? Why they are so powerful and holds so much weightage in VBA learning.

  • What is their by-default index system and how we can change it using option base. 

  • What are static and dynamic arrays.

  • how to use arrays with VBA loops and if functions . They work like magic together. 

  • What is the use of Preserve word in arrays and how we can use it in projects.

  • Complete tutorial with in-depth discussion.

  • How to use split function in arrays and what are the key things to be taken care while using split in arrays.

  • Questions discussed from  VBA interview perspective as well.

  • As usual- Assignments are also added to give you confidence and to check the progress.

  • how to use Dim or Redim Statements .Their real use in projects. How to use variable value in Arrays and what is the purpose of using them in arrays.

  • How to use split function ,one of the best function we can use in arrays. How arrays work under split function.

  • How option Base-1 works for arrays created by split function.

  • What is the use of preserve word in arrays and how we can use it to hold the values. What happens if we do not use them.

  • How and where we use them . Complete discussion on its use.

  • For more understanding on arrays tutorial we are discussing amazing Projects. Only for you. In-depth discussion.

Content

Introduction to Excel VBA ARRAYS

A quick demonstration - free
Introduction to Excel VBA ARRAYS - Chapter1
Introduction to Excel VBA ARRAYS- Chapter2
Project for your study - Chapter3
Project for your study - Chapter4
Fantastic Projects on One dimensional and Two -dimensional Arrays

Screenshots

Excel VBA SUPER STRONG ARRAYS Series4 - Screenshot_01Excel VBA SUPER STRONG ARRAYS Series4 - Screenshot_02Excel VBA SUPER STRONG ARRAYS Series4 - Screenshot_03Excel VBA SUPER STRONG ARRAYS Series4 - Screenshot_04

Reviews

Jose
June 1, 2022
The presentation was not prepared, the topic was covered on the fly, I expected coding to be more professional, two loops where it could be one, high volume data processing becomes slow with multiple loops, and his presentation was repetitive circling back to what he said already, kind of boring.
Hiralal
May 30, 2021
I really liked your course, presentation. I learnt a lot from your course. your explanation, the style is lucid and easily understood. in fact I selected 4 specific chapters from your course totally costing Rs. 9500/-. but I could not pay for the selected topics in the course. please note that macro writing is my hobby but the utilities I have made are very successful and useful to my office staff.

Charts

Price

Excel VBA SUPER STRONG ARRAYS Series4 - Price chart

Rating

Excel VBA SUPER STRONG ARRAYS Series4 - Ratings chart

Enrollment distribution

Excel VBA SUPER STRONG ARRAYS Series4 - Distribution chart

Related Topics

1624202
udemy ID
3/31/2018
course created date
2/8/2020
course indexed date
Bot
course submited by