Lynda com Excel 2010 Macros in Depth

/00. Introduction/

01. Welcome.mov

02. Using the exercise files.mov

/01. Getting Started/

01. Understanding what a macro does.mov

02. Reviewing macro examples.mov

04. Reviewing the recording method.mov

03. Understanding security.mov

05. Understanding other techniques for macros.mov

/02. Running a Macro (Execute, Play Back, Etc.)/

03. Running macros from the Quick Access toolbar button.mov

04. Running macros from an object or clip art.mov

01. Running macros from the View tab.mov

02. Running macros from a keyboard shortcut.mov

/03. Using Visual Basic for Applications (VBA)/

02. Viewing the VBA components.mov

01. Introducing the VBA environment.mov

/04. Recording a Macro in Stages/

02. Adding functionality to a macro.mov

01. Recording a simple macro.mov

/05. Creating Non-Recordable VBA Code/

01. Understanding absolute and relative references.mov

02. Using For and For...Next statements.mov

03. Using Do...While and Do...Until statements.mov

04. Creating interactive macros.mov

/06. Macro Project Converting a Mailing List into a Database List/

02. Recording partial code.mov

04. Testing a macro in Step mode.mov

05. Pulling the data together.mov

07. Streamlining macros.mov

06. Joining two macros.mov

01. Planning a macro.mov

/07. The Personal Macro Workbook/

01. Creating a personal macro workbook for macros with wide applicability.mov

02. Closing and updating the personal macro workbook.mov

/Conclusion/

74463_08_01_SC11_goodbye.mov

/Exercise Files/

Ex_Files_Ex10_Macros.zip

/

Torrent downloaded from Demonoid.me.txt

Total files 30