Introduction to Excel Macros

Summary

This advanced course will show you how to record your own macros in Excel, which can be a huge timesaver - automating simple, repeated tasks. The course will also show you some of the pitfalls users often encounter with macros, as well as the security risks associated with using this Excel feature.  Created & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €50.00  (€50.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
2.00
CPD hours:  
2.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This course is suitable for advanced learners who are very familiar with writing formulas and performing analysis in Microsoft Excel. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 9 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • What are Macros & VBA?
  • Add multiple tasks to a Macro
  • Undo, saving & distributing Macros
  • Macros & security settings
  • Editing and deleting Macros
  • Remove blank cells with Macros
  • Absolute & relative references
  • Problems with pasting text
  • Should I learn to program in Visual Basic?

Key Outcomes

Once you have completed this course you will know how to record your own macros. You will know the security risks and setting related to macros and you will know how to quickly debug some basic macro problems in Visual Basic.