Course curriculum

  • 1

    Welcome to the course!

    • Instructor bio - John Bura
    • Key pointers for this program
    • Joining the Alumni Community
  • 2

    Course Introduction

    • Segment - 01 - Course Overview
    • Segment - 02 - How to Save Macros
    • Source File
  • 3

    Send Messages with MsgBox

    • Segment - 03 - Topics Overview
    • Segment - 04 - Build a Simple Message
    • Segment - 05 - Build an Advanced Message
    • Segment - 06 - Empty a Sheet with the MsgBox Function
    • Segment - 07 - Prompt User for Input
    • 123
  • 4

    Workbook and Worksheet Objects

    • Segment - 08 - Topics Overview
    • Segment - 09 - Object Hierarchy
    • Segment - 10 - Change Multiple Worksheets
    • Segment - 11 - Add and Count Worksheets
    • Segment - 12 - Get Path of a Workbook
    • Segment - 13 - Open and Close Workbooks
    • Segment - 14 - Loop Through Worksheets and Workbooks
    • Segment - 15 - Build a Sales Calculator
    • Segment - 16 - Change Charts
    • Resources
  • 5

    Work with the Range Object

    • Segment - 17 - Topics Overview
    • Segment - 18 - Program a Range of a Spreadsheet
    • Segment - 19 - Use Cells instead of a Range
    • Segment - 20 - Use a Range Variable
    • Segment - 21 - Select a Range
    • Segment - 22 - Access a Row
    • Segment - 23 - Copy and Paste a Range
    • Segment - 24 - Clear a Range
    • Segment - 25 - Count a Range
  • 6

    Work with Range Properties

    • Segment - 26 - Topics Overview
    • Segment - 27 - Find the current region of a cell
    • Segment - 28 - Dynamic Range Program
    • Segment - 29 - Resize a Range
    • Segment - 30 - Select Entire Rows and Columns
    • Segment - 31 - Offset Property
    • Segment - 32 - End Property
    • 123
  • 7

    More Range Projects

    • Segment - 33 - Topics Overview
    • Segment - 34 - Union and Intersect of Ranges
    • Segment - 35 - Detect Content
    • Segment - 36 - Build a Range Program
    • Segment - 37 - Change Text Color
    • Segment - 38 - Bold a Range
    • Segment - 39 - Change Cell Color
    • Segment - 40 - Work with Areas
    • Segment - 41 - Find Differences in Ranges
    • 123
  • 8

    Variables

    • Segment -42 - Topics Overview
    • Segment - 43 - Integer Data Type
    • Segment - 44 - String Data Type
    • Segment - 45 - Double Data Type
    • Segment - 46 - Boolean Data Type
    • Segment - 47 - Retain Variable Value
    • Source File
  • 9

    Work with Conditionals

    • Segment - 48 - Conditionals
    • Segment - 49 - If then Statement
    • Segment - 50 - Else Statement
    • Source File
  • 10

    Module Ten

    • Segment - 51 - Topics Overview
    • Segment - 52 - Greeting Program Logical Operator and
    • Segment - 53 - Logical Operator or
    • Segment - 54 - Logical Operator not
    • 123
  • 11

    Module Eleven

    • Segment - 55 - Topics Overview
    • Segment - 56 - Select Case
    • Segment - 57 - Build a Commission Calculator Project
    • Segment - 58 - Find Remainder with Mod
    • Segment - 59 - Check Number Program
    • 123