Course code Title Language Price # Unit Startdate Hour Enddate Location Signup
MSVIC02 VBA for MS Excel 2010 on your request on your request Contact Us

VBA for MS Excel 2010

VBA for MS Excel 2010

Overview

Course code: 
MSVIC02
Duration: 
3
Time Unit: 
Day(s)
Overview: 

This course is aimed to help good Excel users to automate their daily tasks.
We will be Using data/tables in an automated way: Importing data, filtering, formatting, applying tables, exporting. Learn to edit the recorded macro’s and program in Visual Basic yourself is included.

Topics

Topics: 

1. Recording Simple macro’s, steps and explanation of results.
2. Recording Complex macro’s. Launching different macro’s as one.
3. Using Inputbox – Msgbox – Using Variables (Naming, scope, data type)
4. Decision structures in VBA (If then – Select case)
5. Looping in VBA (Do Loop – For Next)
6. Creating Functions in VBA / Creating Worksheet UserDefinedFunctions (UDF)
7. Using Error handling – Trappable errors
8. Using Objects: Application Object
9. Using Objects: Workbooks – Worksheets
10. Using Objects: Range family - Cells
11. Handling Sorting - Data Lists – Tables
12. Handling PivotTables
13. Using & Building Forms (Basic)

Prerequisites

Prerequisites: 

This course assumes that you have a good working knowledge of Excel.
No previous programming experience is needed.

Audience

Audience: 

Anybody who wants to automate the work in Excel with the use of recorded macros.
Those who want to further edit their existing macros in Visual Basic.
Everybody who is starting with Visual Basic in Excel.