MS Excel Macros and VBA 1-Day Course, Birmingham

COVID-19: many events have been canceled or postponed, please check with the organizer the event status.
MS Excel Macros and VBA 1-Day Course, Birmingham
Image from eventbrite.co.uk
Fri 10 April 2020
Friday 10 April 2020
11:00 AM - 6:00 PM
Ended

MICROSOFT EXCEL MACROS AND EXCEL VBA COURSE, PRIVATE 1-TO-1, 
COURSE OUTLINE

Recording and Running Macros in Excel
Create simple macrosusing 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

WHAT IS INCLUDED:
  • Certificate on completion (assessment based) 
  • Course notes 
  • Practical Class exercises, Homework / Revision work 
  • Tea, coffees, but no lunch 
  • To assist after the course, 1 free session for questions online via Skype or Teamviewer. 
  • Max group size is 4. 
  • Bring you own laptop or arrange to use ours

519 Views - 11/04/2020 Last update
culture courses
One Victoria Square
Birmingham, B1 1BD, United Kingdom

Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event

Nearby hotels and apartments

Birmingham, B1 1BD, United Kingdom

Browse other venues in Birmingham
Discover now

Nearby events

See more events

Discover more events in Birmingham
Discover now



One Victoria Square
Birmingham, B1 1BD, United Kingdom


Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event
  1. Birmingham
  2. PCWorkshops
  3. MS Excel Macros and VBA 1-Day Course, Birmingham
 
 
 
 
Your changes have been saved.