RKG Logo training-ITBiz
RKG Logo
Home Courses Fees Schedule REGISTER NOW Corporate Training Locations
Microsoft Office Tools
Adobe Acrobat Courses
SharePoint Training
Microsoft Dynamics
Social Media Courses
Project Management
Application Devp Tools
Oracle Developer Tools
Data Warehouse & BI
Data Base & System Admin
Programming Languages
Reporting Tools
Networking & Security
Web Technologies
Medical Records
Business Skills
ERP Training
Corporate Training On-Site
Excel VBA
Excel VBA
Microsoft Excel VBA – Introduction
Software Version Microsoft Office Excel 2003 and 2007
Course Duration 2 Days
Course Type Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training
Course Overview In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. This course is designed to automate many of the repetitive tasks that are part of the spreadsheet development and gives introduction to Visual Basic for Applications (VBA) programming language to simplify many of the tasks.
Intended Audience for this course Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Course Topics
Developing Macros

    Topic 1A: Create a Macro with the Macro Recorder
    Topic 1B: Edit a Macro
    Topic 1C: Debug a Macro
    Topic 1D: Customize Toolbars, Menus, and Hotkeys

Formatting Worksheets

    Topic 2A: Sort Data
    Topic 2B: Insert Rows and Columns
    Topic 2C: Insert Text
    Topic 2D: Format Text
    Topic 2E: Duplicate Data
    Topic 2F: Generate a Report

Creating an Interactive Worksheet

    Topic 3A: Determine Dialog Box Type
    Topic 3B: Capture User Input

Working with Multiple Worksheets

    Topic 4A: Insert, Copy, and Delete Worksheets
    Topic 4B: Rename Worksheets
    Topic 4C: Modify the Order of Worksheets
    Topic 4D: Print Worksheets

Performing Calculations

    Topic 5A: Create User-defined Functions
    Topic 5B: Automate SUM Functions

Enroll Online   

Live Chat
Enroll Online
Enroll By Fax
Fee & Schedule
Send Message
Follow us on .....
For further information call 949-387-3772 or FAX 949-681-8247 or email to info@SONUtraining.com
SONU Training is the training wing of RKG Technologies Inc
Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
Copyright © 2004 RKG Technologies Inc. All rights reserved.