Excel Introduction to Macros – 1 Day

5.0
1 review
  • .
    |

Course

In London

Price on request

Description

  • Type

    Course

  • Location

    London

With our Excel Introduction to Macros training you can learn a little bit of VBA to create macros to take you from simple recording to more advanced editing to speed up and automate your spreadsheets. Anything be automated when you know how.

If you want more in depth training try our full 2 day Excel VBA course

Facilities

Location

Start date

London
See map
99 Bishopsgate, EC2M 3XD

Start date

Different dates availableEnrolment now closed

About this course

We recommend that you attend or check that you are familiar with the majority of the topics in the Advanced Excel course before attending this course.

Our courses run from 9.30 am to approximately 4.15pm. While you are with us we are focused on offering you a relaxed and productive learning environment. When you book a course with use you get the following:

A full colour training manual/book.
The exercises that you have worked on during your course to allow you to practice afterwards.
USB stick to take the exercises away.
Certificate of attendance
Freshly prepared lunch.
Refreshments throughout the day.
Training in fully air conditioned facilities from an experienced instructor.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

5.0
  • .
    |
100%
4.9
excellent

Course rating

Recommended

Centre rating

Jackie Joseph

5.0
07/01/2018
About the course: .
What I would highlight: I found the course amazing and our trainer Lucinda brilliant. She was a bunch of positive vibes. I learnt so much of excel which would help me a lot with my career. Overall I enjoyed my experience.
What could be improved: Nothing
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 10 years

Subjects

  • Excel
  • Excel for Accounting
  • Computing
  • IT
  • Technology
  • IT risk
  • Programming
  • Excel Formula
  • Excel Sheet
  • MS Excel

Course programme

Course detailsRecorded Macros
  • Understanding Excel Macros
  • Setting Macro Security
  • Saving a Document as Macro Enabled
  • Recording a Simple Macro
  • Running a Recorded Macro
  • Relative Cell References
  • Running a Macro With Relative References
  • Viewing a Macro
  • Editing a Macro
  • Assigning a Macro to the Toolbar
  • Running a Macro From the Toolbar
  • Assigning a Macro to the Ribbon
  • Assigning a Keyboard Shortcut to a Macro
  • Deleting a Macro
  • Copying a Macro
Recorder Workshop
  • Preparing Data for an Application
  • Recording a Summation Macro
  • Recording Consolidations
  • Recording Divisional Macros
  • Testing Macros
  • Creating Objects to Run Macros
  • Assigning a Macro to an Object
Understanding Excel VBA
  • Programming in Microsoft Excel
  • VBA Terminology
  • Displaying the DEVELOPER Tab
  • The VBA Editor Screen
  • Opening and Closing the Editor
  • Understanding Objects
  • Viewing the Excel Object Model
  • Using the Immediate Window
  • Working With Object Collections
  • Setting Property Values
  • Working With Worksheets
  • Using the Object Browser
  • Programming With the Object Browser
  • Accessing Help
  • Code Glossary
Starting With Excel VBA
  • Using the Project Explorer
  • Working With the Properties Window
  • Using the Work Area
  • Viewing Other Panes
  • Working With Toolbars
  • Working With a Code Module
  • Running Code From the Editor
  • Setting Breakpoints in Code
  • Stepping Through Code
Functions in VBA
  • Understanding Functions
  • Creating User-Defined Functions
  • Using a User-Defined Function in a Worksheet
  • Setting Function Data Types
  • Using Multiple Arguments
  • Modifying a User-Defined Function
  • Creating a Function Library
  • Referencing a Function Library
  • Importing a VBA Module
  • Using a Function in VBA Code
  • Code Glossary
Programming Techniques
  • The MsgBox Function
  • Using MsgBox
  • InputBox Techniques
  • Using the InputBox Function
  • Using the InputBox Method
  • The IF Statement
  • Using IF for Single Conditions
  • Using IF for Multiple Conditions
  • The Select Case Statement
  • Using the Select Case Statement
  • For Loops
  • Looping With Specified Iterations
  • The Do Loop Statement
  • Looping With Unknown Iterations
  • Code Glossary
Using Excel Objects
  • The Application Object
  • The Workbook Objects
  • Program Testing With the Editor
  • Using Workbook Objects
  • The Worksheets Object
  • Using the Worksheets Object
  • The Range Object
  • Using Range Objects
  • Using Objects in a Procedure
  • Code Glossary

Excel Introduction to Macros – 1 Day

Price on request