Microsoft Excel 2016/19
Macros Introduction

Course Overview

This course is an introduction to recording macros and modifying macros in Visual Basics. You will learn how to combine macros and how to use recorded macro statements to create a longer macro.

Please Note: This course is a prerequisite for the Excel Macros Intermediate course.

Course InformationRelated Training

Duration: One-Day Course
Platform: Windows Only
Fee: Call for information

We recommend one to eight people for this course.

Course Content Download PDF (57kb)

Record a Macro

Recording a macro which you can use in one workbook or in all your Excel files.

Understanding Why You Declare a Variable

Creating or declare a variable with the use of the Dim keyword.

Combining Recorded Macros

Combining or copying many small macros into one larger macro that will perform multiple repetitive actions in an Excel file.

Creating a Macro

Using the VBA language to modify a recorded macro and create a macro directly in a VBA module. For example:
Using an Input Box to indicate variable information such as the name of a file.

Debugging a Macro

Getting familiar with different methods of debugging or fixing your macro.

Managing Modules

Copying macros and modules from one file to another.

Storing Macros

Storing macros in a Toolbar command button, in a picture or in a shape.

Application Overview: Microsoft Excel 2016/19

Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, and calculate data. You can use advanced features to manage, track, and chart critical business data to create rich data visualization, PivotTable views, and professional-looking charts. You can compile your company’s data into Microsoft Office Excel by retyping or by copying and pasting. But importing is most effective when you're working with large amounts of data that would be time-consuming to enter manually or too large to copy and paste. In addition, if you import your data, Excel can automatically update your reports and summaries whenever the original source database is updated. Your data is always current.

Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create and edit spreedsheets that can be searched, sorted, analysed, reported, updated and shared with other users.

Microsoft Excel 2016/19 Macros Introduction