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.
Excel: Basic Automation Using 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
Enroll in the online course
Follow the appropriate enrollment method below, depending on your IU status.
IU faculty, staff, and students
Join using the self-enroll feature of Canvas (requires IU username and passphrase).Enroll in Excel: Basic Automation Using Macros (IU: No cost)
Join via IU Expand at a low cost (requires an IU Guest account, a free sign-up for anyone).Enroll in Excel: Basic Automation Using Macros (Non-IU: $16.99)
This course is part of an IT Training Certificate Series, which awards a certificate on successful completion of a final online exam. Learn more about the Excel End-User Certificate Series.