Excel 2010: Macros in Depth

Product type
Level

Excel 2010: Macros in Depth

Lynda
Logo Lynda

Need more information? Get more details on the site of the provider.

Description

Explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros.In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also covers advanced topics such as making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario. Exercise files are incl…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros.In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also covers advanced topics such as making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario. Exercise files are included with the course. Topics include: Understanding what a macro does Recording and adding functionality to a macro Running macros Creating non-recordable VBA code Testing a macro in Step mode Joining two macros Using loop structures Streamlining macros Creating a Personal Macro Workbook

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.