Lynda – Excel 2016: Macros in Depth

Description

Excel 2016: Macros in Depth is a macro application video for Excel 2016 software from Lynda site. Macros can help you save a lot of time, but are unknown to many Excel users. In this lesson, using Dennis Taylor, an Excel expert, you can see how to create simple macros to automate duplicate tasks in Excel 2016. With this tutorial you can learn how to record a macro in different steps, share macros between textbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Application (VBA) to encode macros that can not Learn to record them easily.

Features of Excel 2016: Macros in Depth

Understand the security of macros

Run macros

Capture macros

Join two macros

Macro optimization

Expand the macro using the If statement

Use Visual Basic for Application (VBA) for macro application

Use for Next, Do While and run until they are repeated

Course details:

Duration: 3 hours and 33 minutes

English language

Movie format: AVC 1280 720

Audio: AAC 48KHz 2ch

Instructor: Dennis Taylor

Chapters of this course:

Introduction 1. Getting Started 2. Running a Macro 3. Using VBA 4. Recording a Macro in Stages 5. Creating Nonrecordable VBA Code 6. Macro Project: Converting a Mailing List into a Database List Conclusion

Requirements

Does not have

Installation

After Extract, watch with your favorite Player.