• 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 3

      Microsoft Excel Macros & VBA Beginner Level 3

      User Avatar
      Sarah
      IT & Software, Microsoft, Popular
      (0 review)
      Free
      Register for an account
      • Curriculum
      • Instructor
      • Reviews
      CoursesPopularMicrosoft Excel Macros & VBA Beginner Level 3
      • Getting Started 1

        • Lecture1.1
          Learning objectives
      • Variables and Constants 46

        • Lecture2.1
          Specifying a data type
        • Lecture2.2
          Specifying integral numeric data types
        • Lecture2.3
          Scientific notation – Part 1
        • Lecture2.4
          Scientific notation – Part 2
        • Lecture2.5
          Scientific Notation – Part 3
        • Lecture2.6
          Specifying non-integral numeric data types – Introduction
        • Lecture2.7
          Specifying non-integral numeric data types – Single
        • Lecture2.8
          Specifying non-integral numeric data types – Double
        • Lecture2.9
          Specifying non-integral numeric data types – Currency
        • Lecture2.10
          Floating point vs fixed point – Part 1
        • Lecture2.11
          Floating point vs fixed point – Part 2
        • Lecture2.12
          Floating point vs fixed point – Part 3
        • Lecture2.13
          Specifying non-numeric data types – String
        • Lecture2.14
          Specifying non-numeric data types – Boolean
        • Lecture2.15
          Specifying non-numeric data types – Date – Part 1
        • Lecture2.16
          Specifying non-numeric data types – Date – Part 2
        • Lecture2.17
          Specifying non-numeric data types – Date – Part 3
        • Lecture2.18
          Specifying non-numeric data types – Object – Part 1
        • Lecture2.19
          Specifying non-numeric data types – Object – Part 2
        • Lecture2.20
          Specifying non-numeric data types – Variant
        • Lecture2.21
          Review of data types
        • Lecture2.22
          Scope – Introduction
        • Lecture2.23
          Scope – Procedure level
        • Lecture2.24
          Scope – Module level
        • Lecture2.25
          Scope – Project level
        • Lecture2.26
          Scope – Global level
        • Lecture2.27
          Review of scope
        • Lecture2.28
          Declaring multiple variables with one statement
        • Lecture2.29
          Explicit vs implicit declarations – Part 1
        • Lecture2.30
          Explicit vs implicit declarations – Part 2
        • Lecture2.31
          Explicit vs implicit declarations – Part 3
        • Lecture2.32
          Explicit vs implicit declarations – Part 4
        • Lecture2.33
          Using the locals window
        • Lecture2.34
          Variables are initialized at run – Part 1
        • Lecture2.35
          Variables are initialized at run – Part 2
        • Lecture2.36
          Assigning data types to constants
        • Lecture2.37
          Declaring scope for constants
        • Lecture2.38
          Organizing variables and constants
        • Lecture2.39
          Predefined constants
        • Lecture2.40
          Enumerations
        • Lecture2.41
          Viewing information about a predefined constant
        • Lecture2.42
          Values that constants cannot be initalized to
        • Lecture2.43
          Practice assignment Part 1
        • Lecture2.44
          Practice assignment Part 2
        • Lecture2.45
          Practice assignment Part 3
        • Lecture2.46
          Practice assignment Part 4
      • Functions 12

        • Lecture3.1
          Introduction
        • Lecture3.2
          VBA function syntax
        • Lecture3.3
          Using VBA functions
        • Lecture3.4
          A function is a type of procedure
        • Lecture3.5
          Accessing help on VBA functions
        • Lecture3.6
          Qualifying a CBA function
        • Lecture3.7
          Using worksheet functions
        • Lecture3.8
          Qualifying worksheet functions
        • Lecture3.9
          MsgBox function – Syntax and arguments
        • Lecture3.10
          MsgBox function – Displaying a message only
        • Lecture3.11
          MsgBox function – Assigning the returned value to a variable
        • Lecture3.12
          MsgBox function – Coding tip!
      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

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

      Build a Great Presentation in Microsoft PowerPoint

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

      Conditional Analysis for Power Excel Users

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

      What-If Analysis for Power Excel Users

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

      Lists and Pivot Tables for Power Excel Users

      181
      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?