Denna kurs är schemalagd i England och USA, du kan välja mellan att resa dit eller delta live, online via
AnyWare. Kursen går även att hålla företagsinternt på plats hos er.
Ring 08-506 668 00 eller skicka oss en förfrågan genom att
klicka här.
You Will Learn How To
- 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 Benefits
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.
Who Should Attend
Anyone who needs to design and troubleshoot macros. A working knowledge of Excel is assumed.
Hands-On Training
- 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
Course Content
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
|
<< Tillbaka till Excel, Visio och Project för chefer
Excel is a registered trademark of Microsoft Corporation.
Learning Tree AnyWareTM är ett varumärke tillhörande Learning Tree International, Inc. i USA och andra länder, och omfattas av en pågående patentansökan i USA.
View in English
