Microsoft Excel: Advanced

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.

Some Microsoft courses can also be delivered in-house or at a venue of your choice, please click here to send an enquiry and find out more

Related Courses

• Microsoft Excel: Introduction for Beginners (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (1 day)
• Microsoft Excel: Visual Basic For Applications (VBA) Programming (2 day)
• Microsoft Excel: Formulae & Functions (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (2 day)
• Microsoft Excel: Visual Basic for Applications (VBA) Programming (4 day)
• Microsoft Excel: Charts, Pivot Tables & Macros (1 day)
• Microsoft Excel: Financial Modelling (2 day)
• Microsoft Excel: Business Modelling for Telecoms (2 day)
• Microsoft Office: Word, Excel & PowerPoint: Introduction for Beginners (1 day)

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