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

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

Description

About The Provider

Tags

Reviews