About this Course
Microsoft Excel 2010 is an extremely powerful tool that you can use to manipulate, analyze and present data. Sometimes though despite the rich set of features in the standard Excel User Interface (UI), you might want to find an easier way to perform a mundane, repetitive task or to perform some task that the UI does not seem to address. Fortunately, Office applications like Excel have Visual Basic for Applications (VBA), a programming language that gives you the ability to extend these applications.
Learn Excel VBA 2010 easily with our step by step, practical, hands on workshop in Singapore.
After attending the VBA Macro Training course using Microsoft Excel 2010, you will be able:
- Write VBA Code Manually using Microsoft Excel 2010
- Perform Loops, Controls and Error Handling in Excel Macros
- Create User Forms and Sheet Controls in Excel 2010
- Use Events to trigger specific VBA code
- Create a simple macro VBA project
Course Outline :
Lesson 1 : Overview of Object-oriented Programming• What is "Object-oriented Programming"?
• What is Object model - Properties
• What is Object model - Methods
• What is Object model - Collections
Lesson 2 : Variables, Data Types and Constants
• What is Variable
• How to assign values to Variables
• Why you need Variables
• Understanding different Data Types
• Variable Declaration
- Understanding a Variable's scope
- What is Constant
Lesson 3 : Understanding Objects and Collections
• What is Workbooks
• What is Worksheets
• What is Cells and Ranges
Lesson 4 : Making Decision with VBA
• Understanding Logical Operators
• Choosing Between This or That
• Getting Users to Make Decisions
Lesson 5 : Repeating Actions with Loops
• What is a Loop
• Type of Loops - For....Next
• Type of Loops - For....Each....Next
• Type of Loops - Exiting a For....Loop
• Type of Loops - Do....While
• Type of Loops - Do....Until
• Type of Loops - Do....Loop....While
• Type of Loops - Do....Loop....Until
• Nesting Loops
Lesson 6 : Programming Pivot Tables and Pivot Charts
• Creating a Pivot Table Report
• Creating a Pivot Chart
• Understanding Pivot Caches
• Changing Pivot Fields in VBA
• Changing Pivot Items with VBA
Lesson 7 : User Defined Functions
• What is a User Defined Function
• Volatile Functions - Name of active worksheet and workbook
• Volatile Functions - UDFs with Conditions Formatting
• Volatile Functions - Calling Your Function from a Macro
Lesson 8 : Debugging Your Code
• What is Debugging
• What Causes Errors?
• Tools for Debugging
• How to handle errors?
Lesson 9 : Creating UserForms
• What is a UserForm
• Creating a UserForm
• Designing a UserForm
• Showing a UserForm
• Where Does the UserForm's Code go?
• Closing a UserForm
Lesson 10 : UserForm Controls and their Functions
• Understanding Userform Control - Command Buttons
• Understanding UserForm Control - Labels
• Understanding UserForm Control - TextBoxes
• Understanding UserForm Control - ListBoxes
• Understanding UserForm Control - ComboBoxes
• Understanding UserForm Control - CheckBoxes
• Understanding UserForm Control - OptionButtons
• Understanding UserForm Control - Frames
• Understanding UserForm Control - MultiPages
Lesson 11 : Project on VBA Solution
• Objective of Project
• Approach to VBA Solution
• VBA Coding of Project
• Testing of Project
• Completion of Project
Course Duration : 21 Hours
Target Audience
If you are experienced Excel users who wish to automate repetitive tasks or simplify more complex tasks using Excel 2010 Macros and Visual Basic for Applications (VBA) programming language.
Pre-requisites
If you are non-programmer, you must attend Basic Excel 2010 VBA course. Otherwise, you must have good Excel skills and understand key concepts of Excel spreadsheets.
Certification
Successful trainees will receive Certificate of Attainment from Genetic Computer School
Course Pathway
Any other courses.
Course Rating
- /5 from users
Course Enquiry
Course Info
- Course Provider GENETIC COMPUTER SCHOOL PTE LTD
- Course Category Technology
- Course Price $580
Comments