Become a true Excel spreadsheet power user with this introduction to macros and Visual Basic. ‘Hands-on’ training that will enable you to automate repetitive tasks and customize the Excel environment. Gain confidence and develop skills that can be transferred immediately to the workplace.
Convenient and cost-effective training at your offices or online. The course is run by an experienced Data Analyst and Microsoft Master Instructor. Each participant will receive a manual and completion certificate.
Certificates
Certificate of Completion
Digital certificate - Included
Description
This one day course has an emphasis on developing practical, real-world skills. It is suitable for people in any type of business.
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
Create macros using the Visual Basic Editor
Create a user-defined function
Respond to user input
Create a user form
Debug a macro
Using ChatGPT
Who is this course for?
This course is for people who wish to become skilled at automating repetitive tasks with Microsoft Excel. It also provides an introduction to Microsoft Excel programming with Visual Basic.