Excel 2003 VBA Introduction

Course Description
Course Outline

Course Overview

Your Excel skills have helped simplify business tasks like the creation of spreadsheets, graphs, charts, and formulas. You have moved your business or your organization from pencil and paper to the digital age. Now it is time to further simplify your work in the Excel environment by automating many of the repetitive tasks that are inherent to spreadsheet development.

Course Objective

Learn to use VBA to create macros for automating repetitive tasks in Excel 2003. Use Excel to make spreadsheet creation easier.

Target student

This course is for students who wish to learn how to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations.

Prerequisites

The Systematix course Microsoft Office Excel 2003: Level 2 course or equivalent knowledge or experience is recommended. Students should have knowledge of the basics of Excel like how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

We offer a range of Excel training courses

Developing Macros
Create a Macro with the Macro Recorder Customize Toolbars, Menus, and Hotkeys Debug a Macro Edit a Macro
Formatting Worksheets
Duplicate Data Format Text Generate a Report Insert Rows and Columns Insert Text Sort Data
Creating an Interactive Worksheet
Capture User Input Determine Dialog Box Type
Working with Multiple Worksheets
Insert, Copy, and Delete Worksheets Modify the Order of Worksheets Print Worksheets Rename Worksheets
Performing Calculations
Automate SUM Functions Create User-defined Functions

Publisher:	Microsoft
Version:	2003
Length:	1 day
Course-ID:	084263

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Each of us returned extremely positive and motivated - the arrangements, as usual, ran like clockwork - we certainly felt the course was of benefit

- Local Charity