Microsoft Excel: Macros Increasing Productivity Through Automation

Course Overview

Excel macros improve productivity and streamline your workflow by automating multistep tasks. In this course, you learn how to identify processes to be automated and gain practical experience creating and troubleshooting automated solutions to save time and be more productive.

• Easing repetitive tasks through macros
• Adding functionality and troubleshooting a macro
• Identifying data types and initialising variables
• Automating changes in multiple PivotTables
• Developing an interactive interface with form controls

This Microsoft training course will help you stay competitive, sharpen your skills and could enhance your Microsoft career prospects.

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

Anyone who needs to design and troubleshoot macros. A working knowledge of Excel is assumed.

Skills Gained

• Create macros to simplify workbook tasks
• Identify Excel workflow processes for automation
• Troubleshoot code in the Visual Basic Editor (VBE)
• Identify cells in code and extract values from cells
• Build dynamic user interfaces with form controls, toolbar buttons and keystrokes
• Expand the capabilities of a macro using variables

Course Outline

Identifying Workbook Processes for Automation

• Repetition
• External data sources
• Complex sequence of actions
• Determining issues with inherited workbooks

Automating Processes with Macros

Creating and troubleshooting macros

• Exploring the recording process
• Mapping a macro to the interface
• Working with the Visual Basic Editor
• Identifying code components of a macro
• Interpreting lines of code
• Investigating troubleshooting techniques

Enhancing your macro

• Incorporating variables into the solution
• Identifying the context of data types
• Expanding your workbook models through form controls
• Leveraging list box and state value controls
• Adding functionality through user dialogs