Microsoft Excel 2013
Macros Intermediate

Course Overview

Once you have taken the Excel 2013 Macros One Day Introduction course you will be ready to learn how to utilize Visual Basic in creating advanced macros.

Course InformationRelated Training

Duration: One-Day Course
Platform: Windows Only
Fee: Call for information

We recommend one to eight people for this course.

Course Content Download PDF (57kb)

If then Else Statement

Use an If then Else statement to control the statements in a macro (similar to using the IF function in Excel).

Loop Structure

Use the Do Loop structure to repeat a macro multiple times.

If then ElseIf Statement

Use nested If then ElseIf Statements in a macro.

Case Statement

Discover the use of Case statements that are an alternative to using IF macro statements.

For Next

Use the For Next Loop to repeat a macro multiple times.

User-Defined Function

Create your own function if Excel has not provided one for calculations that you do repetitively.

Events

Call macros automatically when a file is opened or when a file is closed

Application Overview: Microsoft Excel 2013

Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, and calculate data. You can use advanced features to manage, track, and chart critical business data to create rich data visualization, PivotTable views, and professional-looking charts. You can compile your company’s data into Microsoft Office Excel by retyping or by copying and pasting. But importing is most effective when you're working with large amounts of data that would be time-consuming to enter manually or too large to copy and paste. In addition, if you import your data, Excel can automatically update your reports and summaries whenever the original source database is updated. Your data is always current.

Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create and edit spreedsheets that can be searched, sorted, analysed, reported, updated and shared with other users.

Microsoft Excel 2013 Macros Intermediate