Use these materials to explore how to record and store macros using Excel, and how to edit macros using Visual Basic. We'll also discuss security concerns about macros.
- Create simple macros to automate complex actions
- Learn about macro security issues
- Assign a macro to the Quick Access toolbar and a keyboard shortcut
- Edit macros
- Enter data into cells
- Use built-in functions
- Sort and filter lists
For a more in-depth look at the content of Excel: Basic Automation Using Macros, view the title contents below.
Important note for participants not affiliated with IU
- This course contains training material only.
- Participants who are not affiliated with Indiana University will need your own access to installed and licensed software, according to the training topic. This will allow you to follow along and participate in the hands-on exercises.
- If you do not have access to the needed software, you can still enroll in the online course and read the course content.
More information about this course
This online course is free to everyone and available for enrollment through IU Expand.
This course consists of a series of short lessons, examples, demonstrations, practice quizzes, and hands-on exercises.
To complete the course content, you will need:
- a web browser and internet access to use the course material on IU Expand.
- a copy of the software relevant to the training installed on your computer.
Expand the accordion folds to see a detailed description of the content.
Explore the contents of Excel: Basic Automation Using Macros:
Open files and prepare to proceed through the course.
Use Excel's Macro Recorder to record a macro and save the workbook as a macro-enabled workbook.
Explore various ways to run a macro.
Create an auto_open macro.
Review best practices concerning macro security.
Record and run a macro.
Utilize the Visual Basic Editor to find an error in the macro.
Use the Visual Basic Editor to correct errors in the macro and to copy and paste code.