Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
Solving Problems with Writing Excel Macros And Visual Basic Course (VBA) Course
Become an Excel Super Hero and Solve Business’ Problems!
This course at BOTI todayWriting Excel Macros with VBA (3 days)
The current course runs at your offices anywhere in South Africa, live online or at a BOTI venue. The course page has the up-to-date outline and group prices.
See the current courseGet a quote for your teamSee all Microsoft Office and Computer Skills courses
Learning on your own? Self-paced e-learning from R595 (excl. VAT) · Ask your employer to pay
The first day of this workshop is dedicated to problem solving. This workshop will give participants a good general overview of the creative problem solving process. We teach participants tools such as brainstorming, information gathering, identifying solutions after considering options. This module forms the basis for the next part of the workshop – i.e. Using Excel and VBA proficiently to solve business problems.
Excel has the ability to make your business more efficient and competitive- however you need to be able to harness its full capability by learning to write macros and VBA. This will allow you to become more efficient and automate repetitive tasks.
This Advanced course is 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 are setting up a domain or website and indeed anyone (managers, supervisors etc.) who wishes to automate repetitive tasks to improve efficiencies.
Benefits to attending: Writing Excel Macros with VBA Course
- Learn structured problem solving techniques.
- Find out the best ways to automate tasks in Excel.
- Comprehend the difference between macro recording and VBA and when to use which option.
- Understand ways to do easy VBA programs.
- Significantly enhance effectiveness in the workplace by using Excel.
- Create consistency in processes.
- Constantly and accurately perform routine tasks.
- Speed up processes – Excel can do the job much faster than you can do it by hand.
- Be able to do things in Excel that are otherwise difficult/ impossible- which can make you hero in the workplace.
Writing Excel Macros with VBA Course :Course Outline
Day 1 : Creative Problem Solving Course
- Problem Solving Methodology.
- Information gathering.
- Problem definition.
- Preparing for brainstorming.
- Generating solutions- Brainstorming basics; Duncker Diagrams; Mind Mapping; The 6 Thinking Hats.
- Analyzing & selecting a solution.
- Planning your next steps.
Day 2 – 3:Writing Excel Macros with VBA Course
- An introduction to excel macros with VBA.
- Visual Basic Editor .
- Constants, data types and variables.
- Subroutines and functions.
- Built-in functions and statements.
- Control statements.
- Object models.
- Excel applications.
- Excel events.
- Custom menus and toolbars.
- Built-in dialog boxes.
- The show method.
- Custom dialog boxes.
- The excel object model.
- The application object.
- The workbook object & worksheet object.
- The range object.
- Pivot tables.
- The chart object.
- Smart tags.
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 / VBA including:
- Finance personnel and supervisors.
- Information administrators, experts and managers.
- Project managers.
- Engineers & Analysts.
- Anybody working extensively with Microsoft Excel.
Upcoming Public Courses
Please click on link below for related public course/s:
Accredited Computer Courses
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
Book Now! View Calendar for the latest course
Please Phone Us Now To Speak to One of Our Friendly Consultants
Tel:011-882-8853
OR
FOR CELL PHONES CLICK TO CALL
Please Fill in the Form – We Will Get Back to You Within 15 minutes