Microsoft Excel: Advanced

Show more Microsoft Training Courses

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.

This training may be available onsite; please contact us if you are interested.

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

By the end of this course you will be able to...

• 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

Optional follow-on classes

• VBA for Excel

Microsoft Excel: Advanced / cm65115

(C) AquinasTraining.co.uk - Contact Us