Trusted Training Partners
Home / Software & IT / Software & IT Courses / Writing Excel Macros with VBA Course
Quick Look Course Summary:Writing Excel Macros with VBA Course
-
Next Public Course Date:
-
Length: 3 day(s)
-
Price (at your venue): 1 Person R 12,711.88 EX VAT 3 Person R 10,220.05 EX VAT 10 Person R 7,415.44 EX VAT
-
Certification Type:Accredited
-
Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.
Get Free & personalised
Training Advice
Writing Excel Macros with VBA
Course Introduction
An Advanced course in Excel, not to be missed by participants who need to understand Excel Macros, VBA and programming. This is an excellent starter course in Visual Basic and programming for participants who work in Information Technology and want to learn programming. This is also for the new businessman who is setting up a domain or website.
Course Outline
1. An Introduction to Excel Macros with VBA
- Selecting Special cells
- Setting Point Labels in Chart Data
- Topics in Learning Excel Programming
2. A brief Introduction
- What is a programming language?
- Programming Style.
3. Visual Basic Editor Part 1
- Arranging the Windows
- The Code Window
- The Immediate Windows
- The Project Window
- The Properties Window
4. Visual Basic Editor Part 2
- Creating Procedures
- Debugging
- Errors
- Familiarising the IDE
- Help
- Macros
- Estimated Running Time, Design Time and Break Mode
5. Constants, Data Types and Variables
- Add Data Types
- Constants
- Inserting Comments
- Line continuation
- Variables
- VBA Operators
6. Subroutines and Functions
- Functions and Subroutines
- Parameters and Arguments
- Exiting a Procedure
- Public and Private Procedures
- Project References
7. Built-in Functions and Statements
- Introduction to programming language
- Programming Style
8. Control Statements
- If…Then Statements.
- Loop: For, For each and Do.
- Select Case Statement
- Conclusion of VBA
9. Object Models
- Objects, Properties and Methods
- Collection Objects and Model Hierarchies
- Object Model Syntax and Variables
10. Excel Applications
- Accessing an Application’s features
- Storing Applications and Add-Ins (With example)
11. Excel Events
- Enable Events Property
- Events and the Objects Model
- Accessing an Event Procedure
- Worksheet and Workbook Events
- Chart Events
- Application Events
- Query Table Refresh Events
12. Custom Menus and Toolbars
- Introduction
- Commands Bar
- Command-bar Controls
- Creating a New Menu Bar or Toolbar
- Built-In Command-Bar-Control ID’s
- Examples
- Augmenting the SRXUtils Application
13. Built-In Dialog Boxes
- The Show Method
14. Custom Dialog Boxes
- Introduction to User Form Object
- Creating a User Form Object.
- ActiveX Controls
- Adding User Form ODE3
- Excel’s Standard Controls
- ActiveX Controls on Worksheets
15. The Excel Object Model
- A brief perspective
- Excel Enumerations
- The VBA Object Browser
16. The Application Object
- Properties and Methods
- Descendants of the Application Object
17. The Workbook Object
- The Workbooks Collection
- The Workbook Object
- Descendants of the Workbook Object
- Sorting Sheets in a Workbook
18. The Worksheet Object
- Properties and Methods
- Descendants of the Worksheet Object
- Worksheet Protection
- Printing sheets
19. The Range Object
- The Range Object as a Collection
- Defining a Range Object
- Additional Applications of the Range Object
- Descendants of the Range Object
- Calculating the Used Range
- Selecting Special Cells
20. Pivot Tables
- Introduction to Pivot Tables
- The Pivot Table Wizard
- The Pivot Table Wizard Method
- The Pivot Table Object
- Properties and Methods of the Pivot Table Object
- Descendants of the Pivot Table Object
- The Pivot Field Object
- The Pivot Cache Object
- The Pivot Item Object
- The Pivot Cell and Pivot Item List Objects
- Calculated Items and Calculated Fields
- Printing Pivot Tables
21. The Chart Object
- Creating a Chart
- Chart Types
- Scrolling through Chart Types
- Dependants of the Chart Object
- Chart Object Objects
- The Axis Object
- The Axes Collection
- The Chart Area Object
- The Chart Group Object
- The Chart Title Object
- The Data Table Object
- The Floor Object
- The Legend Object
- The Page Setup Object
- The Plot Area Object
- The Series Object
- Properties and Methods of the Chart
- Printing Embedded Charts
- Setting Data Series Labels
22. Smart Tags
- Introduction to Smart Tags
- Smart Tag Recogniser Object
- Smart Tag Object
- Smart Tag Action Object
- Smart Tag Options Object
Benefits to attending: Writing Excel Macros with VBA Course
- Find out the best ways to automate tasks in Excel
- Understand the difference between macro recording and VBA and when to use which
- Understand ways to do easy VBA programs
- Significantly enhance effectiveness in the workplace relating to Excel
Course Duration
3 days
Who should attend
This course is intended for anyone who already has a working knowledge of Excel and would like to broaden their knowledge regarding macros including:
- Finance Personnel and supervisors
- Information administrators, experts and managers
- Project managers and Engineers Analysts
- Anybody working extensively with Microsoft Excel
- Delegates ought to have an affordable working understanding of MS Excel
Contact Us Now!
Please Phone Us Now To Speak to One of Our Friendly Consultants to Provide This Course around your schedule:
Tel:011-882-8853
Please Fill in the Form – We Will Get Back to You Within 15 minutes
Please Email Us Now – We Will Get Back to You Within 15 minutes
[email protected]
Realize incredible savings by sending more delegates
Duration: 3 day(s)
Delegates: 1
Cost (incl):