For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Basic Macros in Excel

Overview

Basic Macros in Excel is an indispensable course that demystifies automation for Excel users, providing a solid foundation in creating and utilising macros.

You will embark on a hands-on journey to understand the fundamentals of macros, exploring the Macro Recorder to automate tasks with a single click. By the end of the course, you will be able to create macros that save time and improve the accuracy and consistency of your Excel work.

Learning Outcomes

  • Discover how to set your security settings to allow you to use macros and save workbooks containing macros.
  • Understand how to record the exact steps of a process for reuse and save as a simple macro.
  • Explore how to assign a macro to the Quick Access Toolbar to make it more accessible and easier to run when required.

Audience

Individuals looking to further their knowledge of Excel.