This day long Excel VBA programming course introduces advanced Excel users to the process of writing and editing Macros in Excel. No prior programming experience is required. You will learn how to Record a Macro, Run a Macro, create a Standard Module, create a Sub Procedure, create a Function Procedure, create an Event Procedure and much more.
This course is suitable for anybody wanting to learn 2013, 2010 or 2007, as it cover all the aspects and differences between the versions.
Instructor led, group-paced, classroom-delivery learning model with structured... more details
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Target Students
This course will appeal to students looking to... more details
This course will appeal to students looking to be introduced to the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. It may also appeal to students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Prerequisites
Proficient knowledge of Microsoft Excel. Knowledge of PivotTables... more details
Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required.
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Course Objectives
Upon completion of the course, you will have... more details
Upon completion of the course, you will have gained and introduction to the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations.
Course Content
Lesson 1: Getting Started
Introducing Visual Basic for ApplicationsDisplaying... more details
Lesson 1: Getting Started
Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro Saving a Macro-Enabled Workbook Running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Closing the Visual Basic Editor Understanding Macro Security
Lesson 2: Working with Procedures and Functions
Understanding Modules Creating a Standard Module Understanding Procedures Creating a Sub Procedure Calling Procedures Using the Immediate Window to Call Procedures Creating a Function Procedure Naming Procedures Working with the Code Editor
Lesson 3: Understanding Objects
Understanding Objects Navigating the Excel Object Hierarchy Understanding Collections Using the Object Browser Working with Properties Using the With Statement Working with Methods Creating an Event Procedure
Locations
Training courses take place at the following locations... more details
Training courses take place at the following locations including Nottingham, London, Birmingham, Manchester, Leeds, Liverpool, Sheffield, Leicester or Your Office
What you get
Professional Microsoft Certified Trainer
Comfortable Premises, equipped with all the technology you need