8 hours 33 minutes
in this. Listen, we're going to talk about what kind of variables you can have in macros and essentially because
make Rosa part of Excel.
They have the same data type types of, like those exhibit that exist in Excel, plus more So we have numbers. We have text. We have logical or 1,000,000,000 as it's called in the visual basic for applications. We have a date, and then we have a raise.
And there is can have one dimension two dimensions, like in Excel but even the Maur,
so there could be,
in theory, up to 60 dimensions for a raise.
But in real life, you can hardly find more than three dimensions necessary for any kind of task. Sometimes when you have some calculations with some
ranges and, uh, you have different parameters that can influence, then you can have maybe 34 maybe five dimensions of a raise
that you have to understand one thing
if you have just the smaller raid that is like Fifth has five dimensions.
It is huge because it's it's if it's only 10 by 10 in 10 in each dimension, it is actually tend to the power of five. When you look at how many cells can be that kind of array. So it's big. It takes a lot of memory, can slow down calculations,
and you you should use it only absolutely necessary.
So when we talk about,
um, America variables in Micro's, they're slightly different than don't those who haven't excel because you can define them. Yeah, to be of a different type. So first of all, we have bite. And by, uh,
is exactly that
takes up one bite of information,
and it's ranges from 0 to 255 now.
The practical usage of bite is, ah,
very small, except if you're using it is a counter in Lopes,
and the problem is that you have to be sure that you will limit yourself with 225
And it was mostly used in the past when memory was scarce and that this space was scarce because it consumes twice is a little off disk space and memory, as in regular integer,
which is the next type of data, and the regular integer can have values between miners 32,768 2 plus 32,767. And, um,
that's it that's doing to Joe and and pretty much good enough for any kind of calculation which is usual. If you need it bigger. You have long one
between minus two point something 1,000,000 2 up, two plus two point something 1,000,000.
And then you can have Ah,
decimal numbers on the 1st 1 is single,
and it can be
Ah, very big. You see the numbers on the screen? I I won't
read them. And you can have double,
which can go from,
um, you know, up to 10 to the power 308 which is pretty much
enough for any kind of normal calculation. Then you can have hard currency, and currency can have four decimal places,
and it can go up to 900 trillion
better minus or a plus. Ah,
and you can have a decimal number, which can be
with the up to 29 digits. So if it's ah, just the one number and then 28 decimal places or 29
numbers. If no decimals air used
went to one digit. Sorry.
So this is for numeric data and for non numeric data you can have string, which has fixed link, and it goes up to 65,400 characters, which is
usually quite more than enough.
Then you can have variable ink string that can go up to two billion characters,
unimaginable. Why would you need that much? But maybe sometimes
you can have 1,000,000,000 or a logical which can be just rule falls. You can have date and date can go from January 1st of the year. 100 to December
31st off year 9999
so BC Rilya's of date. They cannot be used in Excel.
You can have object, which is any embedded object, and you have can have very in data type,
which, uh, can be an American. Then it has any value as largest double or you can have text, which can
be as very bowling strength, which means up to two billion characters. So
that is about
the data types.
And let's just have a small example
off how these data types are
here we have mackerels types of data and I will first run it
and you get runtime error
and let's go to debug screen just for you to see
we're talking about. So this is the code off
and we have defined eye as Bite J is integer and K is double.
And what happened? We have given I really of 300
which is about 255 so it won't work. The same is J saying it was K.
So this is just the example that these things actually do have limitations. So if you try to assign
toe bite something that's lodging in tow have 55 it just won't work.
that's ahh pretty much all
regarding this lesson. So there won't be,
um, and the
examples regarding this particular being it Justin reminder
to know how to define your variables in in a
my crew's and also to see the way
wearables are defined so
to command dim.
Then you put the name of the variable. You have to be aware that the name of the variable cannot be the same as any function that exists
in excel, including those functions that you have
defined by yourself by writing back rose
And then you put as and then you define to date the type
and this is how you define data types in Excel
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand