Doctoral Academy Programme Bookings


Welcome Guest
Home > Browse > IT Skills > Excel: Using Macros to Automate Tasks,Microsoft > Details
In order to register for a session, you must first log in. You will be returned to the workshop session, once logged in.
Details
Excel: Using Macros to Automate Tasks,Microsoft
Domain: A1 Knowledge base

Format of workshop: Information and Practical
Suitable for: All

Macros can be used to automate the process of repetitive tasks when working with worksheets and workbooks. This session will look at how macros can be recorded in Microsoft Excel and how they can be attached to both toolbars and menus to customise the working environment. At the end of this session you will be able to create macros by recording tasks and play them back directly or via toolbar buttons or menu items. You will be expected to be a competent Excel user as time will also be spent looking at how the VBA code recorded can be modified to tailor the operation of a macro without re-recording when changes occur.

Presenters
Dr David Atkins


Sessions
21/06/2018 (Thursday) / 09:30 - 12:30 / Training Room 2, 3rd Floor, Julian Hodge Building
available after 01/04/2018