Excel: Macros in Depth (Office 365/Excel 2019)
This post was published 6 years ago. Download links are most likely obsolete. If that's the case, try asking the uploader to re-upload.
MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Duration: 2h 4m
Skill Level: Intermediate | Genre: eLearning | Language: English + Subtitles | Size: 325 MB
Learn about how to use macros to automate tasks in Excel and see how to create simple macros of your own. Veteran Excel trainer Dennis Taylor shows 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 a mailing list into a database-friendly format.
Topics include:
Automating work with Excel macros
Identifying applicable situations for using macros
Creating multi-action macros
Ways to run macros
Using Visual Basic for Applications (VBA)
Recording a macro in stages
Creating nonrecordable VBA code
Creating interactive macros
Joining two macros
Streamlining macros
Homepage
Screenshots
Bookmark my blog to get more stuff every day!
Newest course ==>> Training for all <<== Newest course
Latest OS ===>> Share for Progressive <<=== Latest OS
Huge book blog ====>> Books <<==== Huge book blog
Quick check before we show the links
Helps us keep automated scrapers from hammering the filehosts.