• Home
  • Course Library
  • Subscribe Now
  • Contact
      • Cart

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

          0

      IT & Software

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

      Microsoft Excel Macros & VBA Beginner Level 2

      Lana
      IT & Software, Microsoft, Popular
      (0 review)
      $7.99
      Subscribe for FREE 90 Days
      • 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
      Lana
      Lana 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
      $7.99
      Subscribe for FREE 90 Days
      • Share:

      You May Like

      Build a Great Presentation in Microsoft PowerPoint Read More
      Dave

      Build a Great Presentation in Microsoft PowerPoint

      72
      0
      $5.99
      Conditional Analysis for Power Excel Users Read More
      Dave

      Conditional Analysis for Power Excel Users

      72
      0
      $5.99
      What-If Analysis for Power Excel Users Read More
      Dave

      What-If Analysis for Power Excel Users

      129
      0
      $5.99
      Lists and Pivot Tables for Power Excel Users Read More
      Dave

      Lists and Pivot Tables for Power Excel Users

      162
      0
      $7.99
      Working with Dates in Microsoft Access Queries Read More
      Lana

      Working with Dates in Microsoft Access Queries

      196
      0
      $5.99

      All Courses

      • Adobe
      • Business
      • Coming Soon
      • IT & Software
      • Microsoft
      • Popular
      • Social Media
      • Soft Skills

      Latest Courses

      Microsoft Excel 2016 Intermediate Level 1

      Microsoft Excel 2016 Intermediate Level 1

      $11.99
      Microsoft Excel Macros & VBA Beginner Level 3

      Microsoft Excel Macros & VBA Beginner Level 3

      $7.99
      Microsoft Excel Macros & VBA Beginner Level 2

      Microsoft Excel Macros & VBA Beginner Level 2

      $7.99

      Copyright 2019 ontrackTV - A division of Quizam Media Corporation

      • Sign in
      • New account

      Show

      Forgot your password?

      Show
      Show

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

      Back to login

      close

      Login with your site account

      Lost your password?

      Not a member yet? Register now

      Register a new account

      Are you a member? Login now