en
fr
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 designed to train advanced users who wish to automate certain routine operations without having to resort to the Excel VBA 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 (personal macro workbook) and local macros (workbook)

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

Recording macros

  • How to correctly name the macro
  • Choosing where to store the macro
  • Description of the macro
  • How to record the macro correctly
  • Stop recording

Assigning macros

  • Different types of media running (icon key, button or shortcut)

Using relative references in macros

  • To create a local macro (workbook) that has as a general macro in the file

Access VBA code

  • Without knowing VBA there are simple changes that can be made:
  • Rename a macro
  • Merge macros
  • Splitting a macro into multiple macros
  • Deleting commands
  • Modifying commands
  • Reorganization of orders

Deleting macros

  • Deleting a local macro
  • If the personal macro workbook to delete a general macro

Scenario exercise + tips & tricks

 

Practical information

Duration

1 Day

Languages

FR / NL

Price

€350,00 + 3% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

French courses
21/1Book
25/2Book
18/3Book
25/4Book
20/5Book
17/6Book
15/7Book
19/8Book
16/9Book
21/10Book
25/11Book
16/12Book

Share this course on

Book your training

Enter your information to confirm your booking.

    You might also be interested in

    ExcelExcel
    Excel 2019/365 – Level 1
    22/9 - 23/9, 20/1 - 21/1, 10 ...
    Being able to create tables and manage the calculations, formatting and page layout of the tables. The new Office interface,…
    ExcelExcel
    Excel 2019/365 – Level 2
    27/1 - 28/1, 24/2 - 25/2, 24 ...
    Dealing with the important basic functions. Nesting functions. Using the powerful analysis tools. Creating automated templates and macros. The new…
    ExcelExcel
    Excel 2019/365 Power Pivot
    20/1, 24/2, 17/3, 24/4, 19/5 ...
    By the end of this course, you will be able to determine which of the two tools, PivotTables and PowerPivot,…
    ExcelExcel
    Excel 2019/365 Power Query – Level 1
    10/2, 20/4, 16/6, 15/9, 17/1 ...
    Forget VBA and discover Power Query to automate your data collection. This tool allows you to create complex queries without…

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training