Excel Macro and VBA course
-
I am more confident with macros now thank you!
← | →
-
Good explanation from the teacher and good exercises.
← | →
-
I'm sure many people have said this but Sarah really is an excellent teacher. She doesn't give up on you and makes sure you understand any concept.
← | →
Short course
In Manchester, London, Milton Keynes and 2 other venues
Description
-
Type
Short course
-
Level
Advanced
-
Location
-
Duration
1 Day
Many Excel tasks become tedious and repetitive. To create macros will automate these repeated actions and saves you the time of doing it. You will learn to record Excel macros, create macros in Excel by coding in Excel VBA. The we add the macros to icons on a custom toolbar, and you have transformed your work in Excel to the click of a button.
Facilities
Location
Start date
Start date
Start date
Start date
Start date
Start date
About this course
Spreaddsheet automation. Saving time. Getting more from Excel.
Intermediate to advanced Excel users
Excel intermediate
Reviews
-
I am more confident with macros now thank you!
← | →
-
Good explanation from the teacher and good exercises.
← | →
-
I'm sure many people have said this but Sarah really is an excellent teacher. She doesn't give up on you and makes sure you understand any concept.
← | →
Course rating
Recommended
Centre rating
Reka Musan
Craig Johnson
Vaida Peldene
Zaid Desai
Greya Taylor
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- Excel
- Microsoft Excel
- Spreadsheet
- MS Excel
- Spreadsheets
- VBA
- Macros
- Automation
- Coding
- Calculation
- Excel VBA
Teachers and trainers (1)
Sarah Barnard
Coder, Instructor
Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.
Course programme
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
Excel Macro and VBA course