Excel Macro and VBA course, London

Excel Macro and VBA course, London

From £350 - FAQ's - Included - Course outline - Bespoke Course

Microsoft Excel Macros and Excel VBA Course, Private 1-to-1, Pc and Mac Versions 2007 upwards

Course Outline

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
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

Other Excel Courses

What is included in this Excel Macros and VBA Course:

Excel Macros and VBA Course Certificate on completion (assessment based)
Excel Macros and VBA Course notes
Practical Excel Macros and VBA Course exercises, Excel Macros and VBA Course Homework / Excel Macros and VBA Course Revision work
Tea, coffees, but no lunch
To assist after the course, 1 free session for questions online Excel Macros and VBA Course via Skype or Teamviewer.
Max group size on this Excel Macros and VBA Course is 4.

Is this the course for you? Book today and start preparing for the course

PCWorkshops specialises in Java Courses, Database courses and MS Project Courses.