Give Us A Call +2711 882 8853

Writing Excel Macros with VBA Course

Quick Look Course Summery: Writing Excel Macros with VBA Course
  • Next Public Course Date: 06/09/2019

  • Length:3 day

  • Price: 1 Person R ex vat3 Person R 0 ex vat10 Person R 0 ex vat

  • Certification Type: Certificate of Attendence

  • Locations & Venues: Call Centre Training Courses are held in JHB, Cape Town, Durban, Port Elizabeth

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.

Benefits to attending: Writing Excel Macros with VBA Course

Find out the best ways to automate tasks in Excel Comprehend 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

Writing Excel Macros with VBA Course :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

Writing Excel Macros with VBA Course: Course Duration

3 day/s

Who should attend: Writing Excel Macros with VBA Course

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
**Quote does not include Any Exam Fees (if applicable) IMPORTANT ACTION: Do Not Wait To Improve Your Skills.   Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

Get Free & personalised Training Advice

Enjoy incredible savings the more delegates you send. See for yourself...

BOTi COURSE COST CALCULATOR

Simply Select a date to see cost

 
m banner