Description

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

course image

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

Course Images

Excel Working with Macros

By Underscore Group

Booking options

Highlights