Course curriculum

    1. Segment - 01 - Course Overview

    2. Segment - 02 - How to Save Macros

    3. Source File

    1. Segment - 03 - Topics Overview

    2. Segment - 04 - Build a Simple Message

    3. Segment - 05 - Build an Advanced Message

    4. Segment - 06 - Empty a Sheet with the MsgBox Function

    5. Segment - 07 - Prompt User for Input

    6. 123

    1. Segment - 08 - Topics Overview

    2. Segment - 09 - Object Hierarchy

    3. Segment - 10 - Change Multiple Worksheets

    4. Segment - 11 - Add and Count Worksheets

    5. Segment - 12 - Get Path of a Workbook

    6. Segment - 13 - Open and Close Workbooks

    7. Segment - 14 - Loop Through Worksheets and Workbooks

    8. Segment - 15 - Build a Sales Calculator

    9. Segment - 16 - Change Charts

    10. Resources

    1. Segment - 17 - Topics Overview

    2. Segment - 18 - Program a Range of a Spreadsheet

    3. Segment - 19 - Use Cells instead of a Range

    4. Segment - 20 - Use a Range Variable

    5. Segment - 21 - Select a Range

    6. Segment - 22 - Access a Row

    7. Segment - 23 - Copy and Paste a Range

    8. Segment - 24 - Clear a Range

    9. Segment - 25 - Count a Range

    1. Segment - 26 - Topics Overview

    2. Segment - 27 - Find the current region of a cell

    3. Segment - 28 - Dynamic Range Program

    4. Segment - 29 - Resize a Range

    5. Segment - 30 - Select Entire Rows and Columns

    6. Segment - 31 - Offset Property

    7. Segment - 32 - End Property

    8. 123

    1. Segment - 33 - Topics Overview

    2. Segment - 34 - Union and Intersect of Ranges

    3. Segment - 35 - Detect Content

    4. Segment - 36 - Build a Range Program

    5. Segment - 37 - Change Text Color

    6. Segment - 38 - Bold a Range

    7. Segment - 39 - Change Cell Color

    8. Segment - 40 - Work with Areas

    9. Segment - 41 - Find Differences in Ranges

    10. 123

About this course

  • Free
  • 68 lessons
  • 4.5 hours of video content