Excel Macros and VBA

by PCWorkshops

This course covers Excel Macro Recording and Coding Excal VBA. For Excel users. Extend the capabilities of Excel with Macros and VBA code.

$185

Contact the Institutes

Fill this form

Advertisement

PCWorkshops Logo

img Duration

1 Day

Course Details

Excel Macros and VBA Course summary

For Excel users. Extend the capabilities of Excel with Macros and VBA code.

 

Outline:
Record simple Excel macros with shortcuts or buttons

  • Setting Excel Macro Options

  • Record and Run Macros

  • The Quick Access Toolbar

Excel VBA Editor

  • Use the VBA Editor

  • Create, copy and import/export modules

  • Starting the Visual Basic Editor, Use Project Explorer

Creating Procedures and Functions
Create macro procedures in code using variables  

  • Creating Sub and Function Procedures

  • Declare and Use Variables

  • Displaying Messages

  • Getting Input from the User

Controlling Program Flow

  • IF Statement

  • Select Case Statement

  • For Next Loops and Do Loops

Interacting with a spreadsheet :

  • Referencing Cells and Ranges

  • Gathering Cell and Range Information

  • The Offset Method

  • With Blocks

  • Referencing Workbooks and Worksheets

Functions

  • Standard Excel Functions in VBA

  • Custom functions

  • Calling functions and sub procedures

User Forms

  • Basic design, display and interaction with forms

  • WC2N Branch

    Golden Cross House, 8 Duncannon Street, WC2N, London
  • M2 Branch

    53 Fountain Street, M2, Manchester
  • MK9 Branch

    Exchange House, 494 Midsummer Boulevard, MK9 , Milton Keynes
  • City Centre Branch

    One Victoria Square, City Centre, Birmingham
  • Cosham Branch

    Ground Floor, Building 1000, Lakeside North Harbour, Western Road, Cosham, Portsmouth
  • Teacher's Name
  • Mary Smith
  • Teacher's Experience
  • 10 Years Softwware development and 10 years software training
  • Gender
  • N/A
  • Teacher's Nationality
  • British

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy