Lynda com Excel VBA in Depth | B303149F9A0B9A920D1322DD4D89A3C89CA9D44C

Lynda com Excel VBA in Depth

Name	Lynda.com - Excel. VBA in Depth	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	193.9 MB
Total Files	48
Hash	B303149F9A0B9A920D1322DD4D89A3C89CA9D44C

/00 Introduction/
0001 Welcome.mov	4.9 MB
0002 Using the exercise files.mov	286.3 KB
/01 Introducing Visual Basic for Applications/
0105 Creating, exporting, and deleting code modules.mov	6.9 MB
0106 Creating a subroutine or function.mov	6.0 MB
0103 Working in the Visual Basic editor.mov	5.2 MB
0109 Running a VBA routine.mov	4.8 MB
0102 Examining the Excel object model.mov	3.8 MB
0108 Adding comments to the code.mov	3.7 MB
0107 Controlling procedure scope and visibility.mov	3.4 MB
0110 Adding code to a recorded macro.mov	3.3 MB
0104 Setting VBA project properties.mov	2.5 MB
0101 Introducing object-oriented programming.mov	1.7 MB
/02 Defining Variables, Constants, and Calculations/
0206 Defining arrays.mov	7.4 MB
0201 Introducing Excel VBA data types.mov	7.0 MB
0204 Defining static variables and constants.mov	5.3 MB
0202 Declaring variables and requiring declaration before use.mov	4.4 MB
0203 Managing variable scope.mov	3.9 MB
0208 Streamlining code references using With End With statements.mov	3.8 MB
0205 Creating a calculation using mathematical operators.mov	3.7 MB
0207 Defining and using object variables.mov	2.9 MB
/03 Adding Logic to Your VBA Code/
0304 Performing a task when conditions are met using If Then.mov	7.5 MB
0303 Repeating a task with a Do loop.mov	5.6 MB
0302 Stepping through all items of a collection using a For Each loop.mov	3.2 MB
0301 Repeating a task using a For Next loop.mov	2.6 MB
0305 Selecting which action to take using a Case statement.mov	1.8 MB
/04 Debugging You VBA Code/
0402 Stepping through a subroutine or function.mov	5.9 MB
0401 Managing errors using On Error statements.mov	4.9 MB
0404 Verifying output using the Immediate window.mov	4.0 MB
0405 Watching a value in a routine.mov	3.1 MB
0403 Setting breakpoints in the code.mov	2.7 MB
/05 Managing Workbook Elements and Data in VBA/
0507 Managing worksheets with VBA.mov	5.9 MB
0502 Cutting, copying, and pasting cell data.mov	5.4 MB
0503 Finding values in cells.mov	4.4 MB
0505 Concatenating text strings.mov	4.2 MB
0508 Managing workbooks with VBA.mov	4.1 MB
0501 Writing a value to a cell.mov	3.8 MB
0504 Referring to cells using the Offset function.mov	3.1 MB
0506 Returning part of a string.mov	3.0 MB
/06 Adding Advanced Elements to Your Workbook/
0603 Acquiring values using an input box or message box.mov	5.4 MB
0601 Turning off screen updating within a macro.mov	2.7 MB
0602 Using worksheet functions in a macro.mov	2.5 MB
0604 Calling a subroutine from another subroutine.mov	2.1 MB
/07 Using Excel Events in Your VBA Code/
0702 Running a procedure when a cell range changes.mov	4.8 MB
0701 Running a procedure when you open, close, or save a workbook.mov	4.5 MB
0703 Triggering a procedure using a specific key sequence.mov	3.9 MB
/08 Putting it All Together/
0801 Applying techniques in a Capstone project.mov	6.4 MB
/09 Conclusion/
0901 Goodbye.mov	256.9 KB
/Exercise Files/
Ex_Files_Excel_VBA.zip	1.2 MB
Total files 48