Lynda Excel 2013 Macros In Depth Tutorial-kEISO

Lynda Excel 2013 Macros In Depth Tutorial-kEISO

AUTHOR: DENNIS TAYLOR RELEASE
DATE: 2014.02.17
FORMAT: ISO
STORE DATE: 2014.02.13
LEVEL: INTERMEDIATE ISO
CHECKSUM: 4F5463D5
ISO SIZE: 458.436.608 B
RUNTIME: 02H 43M

TUTORIAL

Want to save time on routine tasks in Microsoft Excel? Macros
are your answer. In this course, author Dennis Taylor explains
how macros can be used to automate tasks in Excel, and how you
can create simple macros of your own. Learn how to record a macro
in stages, share macros between workbooks, set up keyboard
shortcuts to run macros quickly, and use Visual Basic for
Applications (VBA) to code macros 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: converting mailing list
data into a database-friendly format

Topics include:

* Understanding what macros can do for you

* Running macros

* Creating a Personal Macro Workbook

* Recording macros

* Creating nonrecordable VBA code

* Expanding a macro with statements

* Using absolute and relative references

* Testing a macro in Step mode

* Joining two macros

* Using loop structures

* Streamlining macros