Book now

Excel Macros and VBA Course, Private 1-1

Course summary

Recording and Running Macros in Excel

Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon

  • Setting Excel Macro Options
  • Record and Run Simple Macros
  • Assign Macros to the Quick Access Toolbar

Introduction to the Excel VBA Editor

Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules

  • Starting the Visual Basic Editor
  • Using the Project Explorer
  • Using the Properties Window
  • Creating, Importing and Exporting Modules
  • Explore Recorded Macros

Creating Procedures and Functions

Create simple macro procedures in code that use variable to store data and communicate with the user

  • Creating Sub and Function Procedures
  • Declare and Use Variables
  • Displaying Message to the User
  • Getting Input from the User

Working with the Excel Object Model

Explore a variety of ways our code can manipulate data within cells, create and navigate around worksheets and workbooks

  • Understanding Objects, Properties and Methods

Interacting with the spreadsheet :

  • Referencing Cells and Ranges
  • Gathering Cell and Range Information
  • Using the Offset Method
  • Using With Blocks
  • Referencing Workbooks and Worksheets
  • Updating values in the spreadsheet and putiing values into the spreadsheet

Functions

  • Using standard Excel functions in VBA
  • Creating new custom functions

Controlling Program Flow

Using decision making and looping structures to control the way your program works

  • Using the IF Statement
  • Using the Select Case Statement
  • Using For Next Loops
  • Using Do Loops
  • Using For Next Loops

Practical project and examples

Book this course

Choose from the start dates and other options below. Click on each row to get more information. When you have found your ideal combination click "Book now" to proceed.

Buy a voucher
Starting How long Where Price

Mon 30th Oct
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£350.00 17% off
£290.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 30th Oct
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£350.00 17% off
£290.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 30th Oct
11:00am - 6:00pm

1 day
Full time
Manchester,
M2 2AN
Map

£350.00 17% off
£290.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 30th Oct
11:00am - 6:00pm

1 day
Full time
Southend-On-Sea,
SS1 1NE
Map

£350.00 17% off
£290.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 31st Oct
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£350.00 17% off
£290.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 31st Oct
11:00am - 6:00pm

1 day
Full time
Southend-On-Sea,
SS1 1NE
Map

£350.00 17% off
£290.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 31st Oct
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£350.00 17% off
£290.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 31st Oct
11:00am - 6:00pm

1 day
Full time
Manchester,
M2 2AN
Map

£350.00 17% off
£290.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 01st Nov
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£350.00 17% off
£290.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 01st Nov
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£350.00 17% off
£290.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher