Microsoft Excel 2003: Advanced Course (1 day)

About this class

Everyone understands how important spreadsheets are but being able to automate processes within them can save a business time and money. Learning how to develop and use macros supports this process.

Who will the lesson benefit?

Those who wish to create their own customised functions to perform calculations specific or unique to task and get greater control of the Excel environment by learning the Excel programming language, Visual Basic, in order to write and debug their own routines

What delegates will learn

• Create and use templates
• Describe programming fundamentals
• Customise different aspects of Excel

Contents of this class

• Templates
• The Data Analysis Toolpak
• Recording & Running Macros
• Working in the Visual Basic environment
• Managing Visual Basic Projects
• How Visual Basic, interacts with Excel, and Stores its Information.
• Debugging Visual Basic
• Interacting with the User
• Displaying a Message Box
• Displaying an Input Box
• Displaying a Form
• Designing a Custom Form
• Making Decisions
• The IF-Then-Else Structure
• Select Case Structure
• The For-Next Structure
• Do-Loops
• Custom Help Systems
• Custom Menus and Toolbars
• Custom Functions