Microsoft Excel 2013
Macros Introduction

Course Overview

Now that you have been working with the advanced features in Microsoft Excel, you are ready to take your skills to the next level. Please note that you should know how to use the commands shown in the Excel Intermediate and Advanced course plus the Excel Formulas course before attending this Macros course. This course will show you how easily you can record repetitive actions using the Record Macro command and how to modify and create macros using VBA statements.

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

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

Combine Recorded Macros

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

Create a Macro

Use the VBA language to modify a recorded macro and create a macro directly in the VBA module. For example: Use an Input Box to indicate variable information.

Debugging

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

Manage Modules

Copy macros and modules from one file to another.

Store Macros

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

Application Overview: Microsoft Excel 2013

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 2013 Macros Introduction