Description

This course will teach you how to use Excel's macro recorder to automate repetitive tasks. You will know how to run your macros by clicking a button. You will discover the VBA editor and thus discover how to customize your macro-commands.

Who is this training for ?

For whom ?

Excel users who want to learn about Excel macros.

Prerequisites

Training objectives

Automate repetitive tasks with Excel Record and run macro commands Use add-ins Understand the saved VBA code and make changes to it

Training program

• Overview of Excel macro commands
  • Discover the macro command recorder.
  • Show the Developer tab.
  • Preparing to record a macro, pitfalls to avoid.
  • Save relative or absolute.
  • Understand the objectives of macros, their limits.
  • Use the personal macro workbook, discover its particularities.
  • Choose the correct file format (xls, xlsx, xlsm).
  • Answer macro security questions, use approved folders.
• Executing macro commands
  • Execute a macro using the macro list.
  • Customize the interface: assign a macro to a button, an image, an icon on the Quick Access toolbar .
  • Choose a keyboard shortcut for a macro.
  • Run a macro automatically when opening a workbook: the Auto_Open macro.
• Automation tools built into Excel
  • Custom displays (or Views): use multiple layouts on the same worksheet.
  • Use custom cell styles.
  • Save a space
  • Use an add-in.
• Overview of the VBA programming interface
  • Discover the VBA environment: the module sheets, the VBA project explorer, the Properties window.
  • Access the code generated by recording.
  • React in case of runtime error.
  • What is debugging? Exit.
  • Modify a saved procedure: understand the code, clean up unnecessary instructions.
  • Document a macro-command.
  • Add a dialog box (MsgBox or InputBox).
  • Program simple conditions.
  • Automate filters, sorting.