Course details
In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development. In this course, you will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel.
Objectives
You will apply automation to job tasks in Microsoft Office Excel.
Target Student
Advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).
Prerequisites
Knowledge of Microsoft Office Excel, including how to create, edit, format, and print worksheets that contain charts, and sorted and filtered data. To ensure your success, we recommend the following courses, or equivalent knowledge in Microsoft Office Excel Basic, Microsoft Office Excel Intermediate and Microsoft Office Excel Advanced.
Course Outline
Day 1
- Visual Basic Editor
- Programming basics
Day 2
- Control structures
- Custom dialog boxes
- Debugging and error handling
Requirements
Knowledge of Microsoft Office Excel, including how to create, edit, format, and print worksheets that contain charts, and sorted and filtered data. To ensure your success, we recommend the following courses, or equivalent knowledge in Microsoft Office Excel Basic, Microsoft Office Excel Intermediate and Microsoft Office Excel Advanced.
Updated on 22 March, 2016Course Location
About ExecuTrain - South Africa
With over 29 years in the training business, ExecuTrain is the trusted and internationally recognized training provider for many companies. We address the training needs from top-level executives to entry-level employees. Keeping in touch with the business needs of our clients allows us to recommend and deliver short term courses for immediate implementation and roll-out into the workplace.
At ExecuTrain, our goal is to listen and deliver “ Training As Unique As You Are.” To achieve this goal we provide business and computer training products and services designed to offer flexible training alternatives that result in the most effective skills transfer. In other words, our training helps you and your company “get the job done”.
Serving People by Increasing Their Effectiveness Through
QUALITY TRAINING AND SUPPORT
The ability to perform, to work efficiently, communicate clearly and lead effectively, determines your company's success. It's up to management to ensure that staff are prepared to excel on the job, and to help them progress so that the company can succeed.
With over 29 years in the training business, ExecuTrain has seen it all; from top-level executives who need to keep up with technology trends, to entry-level employees who need an introduction to computers with keyboard and typing skills. With the ever-increasing demands brought on by fierce competition in your market your employees will benefit from a blended training solution. Even minor shortcomings that the most experienced businessperson may have, can be addressed to help them continue to move your company in the right direction.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Data Analysis, Fintech, Python, Science Mastery NextGen LearningZAR 980Duration: Upto 20 Hours
- ZAR 271Duration: Upto 6 Hours