-
Getting Started 1
-
Learning objectivesLecture1.1
-
-
Variables and Constants 46
-
Specifying a data typeLecture2.1
-
Specifying integral numeric data typesLecture2.2
-
Scientific notation – Part 1Lecture2.3
-
Scientific notation – Part 2Lecture2.4
-
Scientific Notation – Part 3Lecture2.5
-
Specifying non-integral numeric data types – IntroductionLecture2.6
-
Specifying non-integral numeric data types – SingleLecture2.7
-
Specifying non-integral numeric data types – DoubleLecture2.8
-
Specifying non-integral numeric data types – CurrencyLecture2.9
-
Floating point vs fixed point – Part 1Lecture2.10
-
Floating point vs fixed point – Part 2Lecture2.11
-
Floating point vs fixed point – Part 3Lecture2.12
-
Specifying non-numeric data types – StringLecture2.13
-
Specifying non-numeric data types – BooleanLecture2.14
-
Specifying non-numeric data types – Date – Part 1Lecture2.15
-
Specifying non-numeric data types – Date – Part 2Lecture2.16
-
Specifying non-numeric data types – Date – Part 3Lecture2.17
-
Specifying non-numeric data types – Object – Part 1Lecture2.18
-
Specifying non-numeric data types – Object – Part 2Lecture2.19
-
Specifying non-numeric data types – VariantLecture2.20
-
Review of data typesLecture2.21
-
Scope – IntroductionLecture2.22
-
Scope – Procedure levelLecture2.23
-
Scope – Module levelLecture2.24
-
Scope – Project levelLecture2.25
-
Scope – Global levelLecture2.26
-
Review of scopeLecture2.27
-
Declaring multiple variables with one statementLecture2.28
-
Explicit vs implicit declarations – Part 1Lecture2.29
-
Explicit vs implicit declarations – Part 2Lecture2.30
-
Explicit vs implicit declarations – Part 3Lecture2.31
-
Explicit vs implicit declarations – Part 4Lecture2.32
-
Using the locals windowLecture2.33
-
Variables are initialized at run – Part 1Lecture2.34
-
Variables are initialized at run – Part 2Lecture2.35
-
Assigning data types to constantsLecture2.36
-
Declaring scope for constantsLecture2.37
-
Organizing variables and constantsLecture2.38
-
Predefined constantsLecture2.39
-
EnumerationsLecture2.40
-
Viewing information about a predefined constantLecture2.41
-
Values that constants cannot be initalized toLecture2.42
-
Practice assignment Part 1Lecture2.43
-
Practice assignment Part 2Lecture2.44
-
Practice assignment Part 3Lecture2.45
-
Practice assignment Part 4Lecture2.46
-
-
Functions 12
-
IntroductionLecture3.1
-
VBA function syntaxLecture3.2
-
Using VBA functionsLecture3.3
-
A function is a type of procedureLecture3.4
-
Accessing help on VBA functionsLecture3.5
-
Qualifying a CBA functionLecture3.6
-
Using worksheet functionsLecture3.7
-
Qualifying worksheet functionsLecture3.8
-
MsgBox function – Syntax and argumentsLecture3.9
-
MsgBox function – Displaying a message onlyLecture3.10
-
MsgBox function – Assigning the returned value to a variableLecture3.11
-
MsgBox function – Coding tip!Lecture3.12
-
This content is protected, please login and enroll course to view this content!