Excel Level 4: Macros & Visual Basic

November 15 & 16 – 2PM to 5PM 

Instructor: Mike Rhodes, MediaTek

Format: Virtual

CPE Credits: 6

Field of Study: Computer Software & Applications

This is a one day course split into two half days.

Become a true Excel power user. Learn to automate repetitive tasks and customize the Excel environment with macros and Visual Basic.

Prerequisites: Excel3 or advanced level skills.

Topics Covered:

• Configure macro security settings
• The Macro Recorder
• Record workbook macros for cell operations
• Run a workbook macro
• Display macro instructions
• Edit a workbook macro
• Add a macro button to a worksheet
• Record personal macros to automate workbooks
• Run a personal macro
• Edit a personal macro
• Include relative cell references in a macro
• Add a macro button to the Ribbon
• Share personal macros
• Create macros using the Visual Basic Editor
• Respond to user input
• Create a user-defined function
• Automate functions
• Debug a macro

REGISTER HERE