Visual Basic for Applications in Excel 2007 [3 CPE Credits]
Category: Specialized Knowledge & Computer Applications
Summary: Author: Jay R. Carlson and Jill A. Trehearne
Experience Level: Basic
Prerequisites: None
Delivery Method: Interactive Self-Study
Course Formats: Online / CD-ROM / Textbook / Audio
Course ID: SK-103
CPE Credits: 3
Course Description:
This training is designed as an introductory course to Visual Basic for Applications (VBA) for Excel 2007. You will learn what VBA is, and how it is used in Excel to create programs that will enhance your daily grind. You will learn how to write the code to create a calculator, how to add new worksheets to a workbook that duplicates an existing worksheet, and you will learn how to create a time logging application (DayLogger) that allows you to start and end time as you work on a client’s job, and then calculates the time spent and logs it to a spreadsheet.
Experience Level: Basic
Prerequisites: None
Delivery Method: Interactive Self-Study
Course Formats: Online / CD-ROM / Textbook / Audio
Course ID: SK-103
CPE Credits: 3
Course Description:
This training is designed as an introductory course to Visual Basic for Applications (VBA) for Excel 2007. You will learn what VBA is, and how it is used in Excel to create programs that will enhance your daily grind. You will learn how to write the code to create a calculator, how to add new worksheets to a workbook that duplicates an existing worksheet, and you will learn how to create a time logging application (DayLogger) that allows you to start and end time as you work on a client’s job, and then calculates the time spent and logs it to a spreadsheet.
Start Date:
Monday, 06 February 2012
Enrolment duration: Unlimited
