IT Training

Excel 2019/365 – Macro

Do you want to save time on routine tasks in Microsoft Excel? Macros are the answer. In this course the instructor explains how macros can be used to automate tasks in Excel, and how you can create simple macros yourself. You will learn when and how to record a macro step-by-step, share macros between workbooks, set up keyboard shortcuts to execute macros quickly, and use Visual Basic for Applications (VBA) to code macros that cannot be recorded. The course ends with a macro project that brings all the elements together in a realistic scenario: converting mailing list data into a database-friendly format.

Who should attend this course?

This course is intended for advanced professionals wishing to automate some routine operations without having to make use of the VBA Excel programming language.

Prerequisites

Master Excel (Formulas, Functions, Sorting/Filtering, Pivot Tables, Charts)

Automate certain operations without having to resort to Excel VBA programming

Understand what macros can do for you

Introduction
Definitions
Macro Recorder Limitations

Show the Developer tab

To have access to all macro options and tools

Differences between General Macro’s (personal macro workbook) and local macros (workbook)

Specificities of general macros
- Print to a specific printer. + Put a staple
- Open a specific template / Daily file
Specificities of local macros (For others…)
- Refresh all PivotTables
- Multiple Sort keys and filter
How to choose the macro type