English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 04m | 329 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
Table of Contents
1 Automating your work with Excel macros
2 Identifying applicable situations for using macros
3 How to play back, run, or execute a macro
4 Recording and testing a macro
5 Overview of VBA Altering macro code
6 Understanding security
7 Running a macro from the Developer tab or the View tab
8 Record a macro and play it back from the Quick Access Toolbar
9 Run a macro from a keystroke shortcut
10 Run a macro from a button or Clip Art image
11 The VBA window and VBA components
12 Creating the Personal Macro Workbook
13 Closing and updating the Personal Macro Workbook
14 Recording a simple macro
15 Expanding a macro with the If statement
16 Understanding when to use absolute or relative references
17 Using For and For…Next statements
18 Using Do While and Do Until statements
19 Creating interactive macros
20 Planning a macro
21 Recording partial code
22 Using loop structures in context
23 Testing a macro in step mode
24 Pulling the data together
25 Joining two macros
26 Streamlining macros
27 Next steps
Resolve the captcha to access the links!