• Home
  • Course Library
  • Contact
      • Cart

        0
    Have any questions?
    learn@ontracktv.com
    Login
    ontrackTVontrackTV
    • Home
    • Course Library
    • Contact
        • Cart

          0

      IT & Software

      • Home
      • All courses
      • IT & Software
      • Microsoft Excel Macros & VBA Beginner Level 2

      Microsoft Excel Macros & VBA Beginner Level 2

      User Avatar
      Sarah
      IT & Software, Microsoft, Popular
      (0 review)
      Free
      Register for an account
      • Curriculum
      • Instructor
      • Reviews
      CoursesPopularMicrosoft Excel Macros & VBA Beginner Level 2
      • 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
      author avatar
      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!

      Reviews

      Average Rating

      0
      0 rating

      Detailed Rating

      5 Star
      0%
      4 Star
      0%
      3 Star
      0%
      2 Star
      0%
      1 Star
      0%
      • Curriculum
      • Instructor
      • Reviews
      Free
      Register for an account
      • Share:

      You May Like

      Building Your Social Media Presence – Instagram Read More
      Georgia

      Building Your Social Media Presence - Instagram

      35
      0
      Free
      Build a Great Presentation in Microsoft PowerPoint Read More
      Dave

      Build a Great Presentation in Microsoft PowerPoint

      125
      0
      Free
      Conditional Analysis for Power Excel Users Read More
      Dave

      Conditional Analysis for Power Excel Users

      123
      0
      Free
      What-If Analysis for Power Excel Users Read More
      Dave

      What-If Analysis for Power Excel Users

      180
      0
      Free
      Lists and Pivot Tables for Power Excel Users Read More
      Dave

      Lists and Pivot Tables for Power Excel Users

      213
      1
      Free

      All Courses

      • Adobe
      • IT & Software
      • Microsoft
      • Popular
      • Social Media

      Latest Courses

      Microsoft Excel 2016 Intermediate Level 1

      Microsoft Excel 2016 Intermediate Level 1

      Free
      Microsoft Excel Macros & VBA Beginner Level 3

      Microsoft Excel Macros & VBA Beginner Level 3

      Free
      Microsoft Excel Macros & VBA Beginner Level 2

      Microsoft Excel Macros & VBA Beginner Level 2

      Free

      Copyright 2020 ontrackTV - A division of Quizam Media Corporation

      • Sign in

      Forgot your password?

      Lost your password? Please enter your email address. You will receive mail with link to set new password.

      Back to login

      Login with your site account

      Lost your password?