BROWSE COLLECTIONS
DISCOVER
MY BOOKING MY BOOKING
LOGIN
CONCERTS FESTIVALS SPORTS NIGHTLIFE THEATER

MS Excel Macros And VBA 1-Day Course, Birmingham

Friday, 02 Oct 2020 @ 11:00 Past Event
MS Excel Macros and VBA 1-Day Course, Birmingham
{"https:\/\/d2dzi65yjecjnt.cloudfront.net\/2587-7.jpg":"GavinWarrins^:^https:\/\/commons.wikimedia.org\/wiki\/File:BirminghamTownHallVictoriaSquare.jpg^:^https:\/\/en.wikipedia.org\/wiki\/Public_domain"}
MICROSOFT EXCEL MACROS AND EXCEL VBA COURSE, PRIVATE 1-TO-1,

COURSE OUTLINE

Recording and Running Macros in ExcelCreate 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 FunctionsCreate 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 FlowUsing 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
Have an issue with this listing? Report it here.
0
0
X
playlist Close
arrow
Click
- Playlist
Click Click
Click