Microsoft Excel

Learning Objectives

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:27

Variables and Constants

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:04

Variables and Constants Specifying Integral Numeric Data Types

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:37

Math Break Scientific Notation Part 1

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:33

Math Break Scientific Notation Part 2

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:33

Math Break Scientific Notation Part 3

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:57

Variables and Constants Specifying Nonintegral Numeric Data Types

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:33

Specifying Nonintegral Numeric Data Types Single

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:20

Specifying Nonintegral Numeric Data Types Double

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:16

Specifying Nonintegral Numeric Data Types Currency

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:38

Floating Point Vs Fixed Point Part 1

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:23

Floating Point Vs Fixed Point Part 2

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:34

Floating Point Vs Fixed Point Part 3

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:56

Specifying Non Numeric Data Types String

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:39

Specifying Non Numeric Data Types Boolean

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:49

Specifying Non Numeric Data Types Date Part 1

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:56

Specifying Non Numeric Data Types Date Part 2

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:28

Specifying Non Numeric Data Types Date Part 3

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:59

Specifying Non Numeric Data Types Object Part 1

Channel: Microsoft Excel

Instructor: Lee

Duration: 1:43

Specifying Non Numeric Data Types Object Part 2

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:13

Specifying Non Numeric Data Types Variant

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:06

Review of Data Types

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:24

Scope Introduction

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:06

Procedure Level

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:17

Module Level

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:10

Scope Project Level

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:32

Scope Global Level

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:07

Review of Scope

Channel: Microsoft Excel

Instructor: Lee

Duration: 1:47

Declaring Multiple Variables with One Statement

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:17

Explicit Vs Implicit Declarations Part 1

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:03

Explicit Vs Implicit Declarations Part 2

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:56

Explicit Vs Implicit Declarations Part 3

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:07

Explicit Vs Implicit Declarations Part 4

Channel: Microsoft Excel

Instructor: Lee

Duration: 1:38

Using the Locals Window

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:48

Variables Are Initialized at Run Part 1

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:22

Variables Are Initialized at Run Part 2

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:50

Assigning Data Types to Constants

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:35

Declaring Scope for Constants

Channel: Microsoft Excel

Instructor: Lee

Duration: 1:43

Predefined Constants

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:15

Values That Constants Cannot Be Intialized To

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:16

Organizing Variables and Constants

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:20

Practice Assignment Part 1

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:00

Practice Assignment Part 2

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:39

Predefined Constants

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:15

Enumerations

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:21

Practice Assignment Part 3

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:36

Practice Assignment Part 4

Channel: Microsoft Excel

Instructor: Lee

Duration: 5:32

Viewing Information About a Predefined Constant

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:34

Functions

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:14

Accessing Help on VBA Functions

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:06

Qualifying a VBA Function

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:36

Using Worksheet Functions

Channel: Microsoft Excel

Instructor: Lee

Duration: 5:05

Qualifying Worksheet Functions

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:51

Introduction to Functions

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:03

VBA Function Syntax

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:16

MsgBox Syntax and Arguments

Channel: Microsoft Excel

Instructor: Lee

Duration: 7:08

Using VBA Functions

Channel: Microsoft Excel

Instructor: Lee

Duration: 2:16

Displaying a Message Only

Channel: Microsoft Excel

Instructor: Lee

Duration: 5:13

A Function is a Type of Procedure

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:14

Assigning the Returned Value to a Variable

Channel: Microsoft Excel

Instructor: Lee

Duration: 3:47

Coding Tip

Channel: Microsoft Excel

Instructor: Lee

Duration: 4:51