Excel Working with Macros

Learn how to use Macros in Excel to automate your work and start to see the power these can give you.

Course overview

Duration: 1 day (6.5 hours)

Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes.

This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course.

Objectives 

By the end of the course you will be able to:

  • Record and run macros
  • Navigate within the Visual Basic Environment
  • Edit pre-recorded macros
  • Create your own functions

Content

Recording macros  
  • Accessing the Developer Tab
  • Naming conventions and storage locations
  • Recording macros
  • Absolute and relative cell addressing
Running macros
  • Assigning macros to the Quick Access Toolbar
  • Assigning macros to objects
  • Creating new tabs
Workbook macros 
  • Recording macros in a specific workbook
  • Saving the workbook as an Excel Macro-Enabled Workbook
  • Creating quick access items specific to workbooks
Importing and manipulating data 
  • Importing Delimited Text Files
  • Importing Fixed Width Text Files
The Visual Basic environment 
  • Project explorer
  • Code window
  • Properties window
  • Renaming modules
  • Deleting modules
Working with code 
  • Code structure
  • Adding comments
  • Navigating within your code
  • Editing macro code
  • Getting help with syntax
Debugging 
  • Errors
  • Using debug
Function procedures
  • Creating function macros

Discover more about our courses

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

Check public dates

View our full catalogue of Leadership, Personal Development, Systems, Office Applications and Project Management courses

View our Leadership and Personal Development course catalogue
View our Systems and Office Applications course catalogue
View our Project Management course catalogue

Get in touch

Contact us

Do you have questions, suggestions, or feedback? We value your input and are here to assist you. Please don't hesitate to get in touch with us via email or phone:

Our dedicated team is ready to respond to your enquiries and provide the support you need. Feel free to reach out, and we'll do our best to assist you.

Thank you for visiting our website, and we look forward to hearing from you!