Request availability or book by selecting a date: Scotland
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview 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. Audience 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 Skills Gained By the end of this course you will be able to... - Create and use templates
- Describe programming fundamentals
- Customise different aspects of Excel
Course Outline - 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
How to make a booking for the MEX03-21 course
|
