GBP 380.00
Details
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. We add the macros to icons
on a custom toolbar, and you have transformed your work in Excel to the click of a button.
What is included in this excel macros and VBA course:
- MS Excel macros and VBA course certificate on completion (assessment based)
- MS Excel macros and VBA course notes
- Please bring your own laptop
- 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.
What is included in this excel macros and VBA course:
- MS Excel macros and VBA course certificate on completion (assessment based)
- MS Excel macros and VBA course notes
- Please bring your own laptop
- 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.
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 putting 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
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 putting 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
Reviews
Be the first to write a review about this course.
Write a Review
PCWorkshops is a specialist provider of training courses in Java programming, databases and MS Project.
Customisation:- We can tailor courses. In addition, we are able to offer in-house training.
- What makes us different: all our Access Database, Excel, Word, Publisher, PowerPoint are offered as a standard on a 1-1 basis.
- The Excel VBA, Database Design, SQL, SSRS, SQL Report Builder and Java Courses are in groups of 4, but could also be 1-1.
- Software companies, testing companies,companies who employ software developers
- Coders and new coders who need Accredited Java qualification
- Data analysts and all others who use large sets of data
- Up-to-date relevant courses for todays’ business world
- Trainers with professional experience
- Award Winning Trainer
- 21 Years In Business
- Excellent Client References
- Classroom training with max class-size 4 people, virtual classrooms, 1-1 mentoring
- Customised training
- Assessment-based certificate, Oracle exam vouchers
- Weekdays, Evenings and Weekends
- At PCWorkshops, we love out job!
- MS Project Training.
- Database design and Data Normalisation.
- SQL Courses. ...