CPE Online Course Detail


Visual Basic for Applications in Excel 2007

Price :   $27.95
CPE Credits :   3.0
Course Code :   S009-0225
Category :   Computer Software
  

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.


Delivery Method: Online Self Study


Level: Overview


Prerequisites: None


Advanced Preparation: None


Policies: Click here


Author: Jay R. Carlson


Category: Computer Software


Field of Study: NA


Passing Score: 70%


Publication Date: 01/13/2009


For More Detail: Click here



Objectives:
Module 1: Introduction to VBA
1. Enable VBA within Excel.
2. Use the Code Window to write code.
3. Run the program you created.
4. Stop (reset) the program.
5. Add a variable to the program code.
6. Build a form.
7. Add controls to the form.
8. Add code to the command buttons.
9. Save the program.


For More Objectives: Click here


NASBA: Yes


QAS: Yes


CPA: Suitable for all CPAs


IRS: Enrolled Agents Program Number




© 2016 MasterCPE LLC
7683 SE 27th St., #216
Mercer Island, WA 98040
    

MasterCPE

Continuing Education for Smart Professionals