thumbnail
IT Skills

MS Excel VBA (ITS15EO)

profile
Instructor

Savvy

Reviews 0 (0 Reviews)

Course Overview

Course Content

  • Academy Topics

    • About This Course

    • Developing Macros

    • Get to Know Macros

    • Create a Macro

    • Edit a Macro

    • Debug a Macro

    • Customize the Quick Access Toolbar and Hotkeys

    • Set Macro Security

    • Formatting Worksheets Using Macros

    • Insert Text

    • Format Text

    • Sort Data

    • Creating An Interactive Worksheet

    • Determine the Dialog Box Type

    • Capture User Input

    • Working With Multiple Worksheets

    • Insert, Copy, and Delete Worksheets

    • Rename Worksheets

    • Modify the Order of Worksheets

    • Print Worksheets

    • Performing Calculations

    • Create User-Defined Functions

    • Automate SUM Functions

    • Course Summary

    • Post-Course Assessment

Paid
  • Lessons 24
  • Skill Beginner
  • Last Update 27/02/2025