Microsoft Excel Macros & VBA Beginner Level 2

Teacher

Sarah

Categories

IT & Software, Microsoft, Popular

Review

(0 review)

Free

Getting Started 6
- Lecture1.1
  
  Learning VBA
- Lecture1.2
  
  Objectives
- Lecture1.3
  
  The object-oriented concept
- Lecture1.4
  
  The Excel VBA Object Model
- Lecture1.5
  
  Collections
- Lecture1.6
  
  Review
Object Referencing 12
- Lecture2.1
  
  Common Objects
- Lecture2.2
  
  Singular objects and collection objects
- Lecture2.3
  
  Referencing a collection member by object name
- Lecture2.4
  
  Referencing a collection member object by index number
- Lecture2.5
  
  Referencing active objects
- Lecture2.6
  
  Fully qualifying an object reference – Part 1
- Lecture2.7
  
  Fully qualifying an object reference – Part 2
- Lecture2.8
  
  Fully qualifying an object reference – Part 3
- Lecture2.9
  
  Creating a simplified object reference – Part 1
- Lecture2.10
  
  Creating a simplified object reference – Part 2
- Lecture2.11
  
  To simplify or not simplify
- Lecture2.12
  
  Review
Object Properties 16
- Lecture3.1
  
  Introduction
- Lecture3.2
  
  What is a property?
- Lecture3.3
  
  What can we do with a property?
- Lecture3.4
  
  Reference a property
- Lecture3.5
  
  Write to a property
- Lecture3.6
  
  Testing write-to property statements
- Lecture3.7
  
  How do I learn all the object properties?
- Lecture3.8
  
  Read / get a property
- Lecture3.9
  
  Properties can return objects – Part 1
- Lecture3.10
  
  Properties can return objects – Part 2
- Lecture3.11
  
  Properties can return objects – Part 3
- Lecture3.12
  
  Properties can return objects – Part 4
- Lecture3.13
  
  Properties can return objects – Part 5
- Lecture3.14
  
  Properties can return objects – Part 6
- Lecture3.15
  
  Properties can return objects – Part 7
- Lecture3.16
  
  Review
Object Methods 19
- Lecture4.1
  
  What are methods?
- Lecture4.2
  
  Calling an object method
- Lecture4.3
  
  Testing call method statements
- Lecture4.4
  
  What are method parameters / arguments?
- Lecture4.5
  
  Syntax Option 1 for method parameters – Part 1
- Lecture4.6
  
  Syntax Option 1 for method parameters – Part 2
- Lecture4.7
  
  Syntax Option 1 for method parameters – Part 3
- Lecture4.8
  
  Syntax Option 1 for method parameters – Part 4
- Lecture4.9
  
  Syntax Option 2 for method parameters – Part 1
- Lecture4.10
  
  Syntax Option 2 for method parameters – Part 2
- Lecture4.11
  
  Syntax Option 2 for method parameters – Part 3
- Lecture4.12
  
  Method behavior
- Lecture4.13
  
  Review
- Lecture4.14
  
  A note on the range object
- Lecture4.15
  
  Property or method?
- Lecture4.16
  
  Some properties take methods
- Lecture4.17
  
  Testing statements using the end property
- Lecture4.18
  
  Solution to the macro challenge
- Lecture4.19
  
  Summary
Analyzing VBA Code 20
- Lecture5.1
  
  Creating a macro to analyze
- Lecture5.2
  
  Learning the basics
- Lecture5.3
  
  Workbooks.OpenText – Part 1
- Lecture5.4
  
  Workbooks.OpenText – Part 2
- Lecture5.5
  
  Workbooks.OpenText – Part 3
- Lecture5.6
  
  End.Select – Part 1
- Lecture5.7
  
  End.Select – Part 2
- Lecture5.8
  
  ActiveCell.Offset – Part 1
- Lecture5.9
  
  ActiveCell.Offset – Part 2
- Lecture5.10
  
  ActiveCell.FormulaR1C1
- Lecture5.11
  
  Selection.AutoFill – Part 1
- Lecture5.12
  
  Selection.AutoFill – Part 2
- Lecture5.13
  
  ActiveCell VS Selection
- Lecture5.14
  
  Range.Select
- Lecture5.15
  
  Font.Bold
- Lecture5.16
  
  With – End With Constructs
- Lecture5.17
  
  Selection.Style
- Lecture5.18
  
  Range.Select (absolute)
- Lecture5.19
  
  Cells.Select
- Lecture5.20
  
  EntireColumn.AutoFit
Referencing Ranges 14
- Lecture6.1
  
  Range property of a worksheet object – Part 1
- Lecture6.2
  
  Range property of a worksheet object – Part 2
- Lecture6.3
  
  Range property of a range object – Part 1
- Lecture6.4
  
  Range property of a range object – Part 2
- Lecture6.5
  
  Offset property of a range object – Part 1
- Lecture6.6
  
  Offset property of a range object – Part 2
- Lecture6.7
  
  Current region property of a range object
- Lecture6.8
  
  Item property of a range object – Part 1
- Lecture6.9
  
  Item property of a range object – Part 2
- Lecture6.10
  
  Cells property of a worksheet object – Part 1
- Lecture6.11
  
  Cells property of a worksheet object – Part 2
- Lecture6.12
  
  Cells property of a range object
- Lecture6.13
  
  Item property VS Cells property
- Lecture6.14
  
  Review
Primer on Variables and Constants 5
- Lecture7.1
  
  Introduction
- Lecture7.2
  
  Declaring a variable
- Lecture7.3
  
  Initializing a variable
- Lecture7.4
  
  Declaring and initializing a constant
- Lecture7.5
  
  Final review and remarks

Sarah

Sarah has been teaching for over two decades in all areas spanning IT with a particular focus on data management and business intelligence. She is one of the most demanded instructors in the nation, and is reputed for her ability to share her deep knowledge in a clear, thorough, and engaging format. We promise you'll love her videos which students have evaluated as some of the best ones online!