Download Lynda.com - Excel: VBA in Depth [2010, ENG] Torrent

Lynda.com - Excel: VBA in Depth [2010, ENG]

00 Introduction

	0001 Welcome.mov	MOV	4.7 MB
	0002 Using the exercise files.mov	MOV	279.59 KB

01 Introducing Visual Basic for Applications

0101 Introducing object-oriented programming.mov	MOV	1.62 MB
0102 Examining the Excel object model.mov	MOV	3.59 MB
0103 Working in the Visual Basic editor.mov	MOV	4.98 MB
0104 Setting VBA project properties.mov	MOV	2.38 MB
0105 Creating, exporting, and deleting code modules.mov	MOV	6.57 MB
0106 Creating a subroutine or function.mov	MOV	5.74 MB
0107 Controlling procedure scope and visibility.mov	MOV	3.28 MB
0108 Adding comments to the code.mov	MOV	3.54 MB
0109 Running a VBA routine.mov	MOV	4.59 MB
0110 Adding code to a recorded macro.mov	MOV	3.18 MB

02 Defining Variables, Constants, and Calculations

0201 Introducing Excel VBA data types.mov	MOV	6.72 MB
0202 Declaring variables and requiring declaration before use.mov	MOV	4.19 MB
0203 Managing variable scope.mov	MOV	3.71 MB
0204 Defining static variables and constants.mov	MOV	5.07 MB
0205 Creating a calculation using mathematical operators.mov	MOV	3.55 MB
0206 Defining arrays.mov	MOV	7.06 MB
0207 Defining and using object variables.mov	MOV	2.78 MB
0208 Streamlining code references using With End With statements.mov	MOV	3.6 MB

03 Adding Logic to Your VBA Code

0301 Repeating a task using a For Next loop.mov	MOV	2.49 MB
0302 Stepping through all items of a collection using a For Each loop.mov	MOV	3.05 MB
0303 Repeating a task with a Do loop.mov	MOV	5.3 MB
0304 Performing a task when conditions are met using If Then.mov	MOV	7.18 MB
0305 Selecting which action to take using a Case statement.mov	MOV	1.76 MB

04 Debugging You VBA Code

0401 Managing errors using On Error statements.mov	MOV	4.68 MB
0402 Stepping through a subroutine or function.mov	MOV	5.64 MB
0403 Setting breakpoints in the code.mov	MOV	2.57 MB
0404 Verifying output using the Immediate window.mov	MOV	3.82 MB
0405 Watching a value in a routine.mov	MOV	2.94 MB

05 Managing Workbook Elements and Data in VBA

0501 Writing a value to a cell.mov	MOV	3.62 MB
0502 Cutting, copying, and pasting cell data.mov	MOV	5.14 MB
0503 Finding values in cells.mov	MOV	4.21 MB
0504 Referring to cells using the Offset function.mov	MOV	2.97 MB
0505 Concatenating text strings.mov	MOV	4.01 MB
0506 Returning part of a string.mov	MOV	2.83 MB
0507 Managing worksheets with VBA.mov	MOV	5.59 MB
0508 Managing workbooks with VBA.mov	MOV	3.89 MB

06 Adding Advanced Elements to Your Workbook

0601 Turning off screen updating within a macro.mov	MOV	2.54 MB
0602 Using worksheet functions in a macro.mov	MOV	2.38 MB
0603 Acquiring values using an input box or message box.mov	MOV	5.13 MB
0604 Calling a subroutine from another subroutine.mov	MOV	2.02 MB

07 Using Excel Events in Your VBA Code

0701 Running a procedure when you open, close, or save a workbook.mov	MOV	4.32 MB
0702 Running a procedure when a cell range changes.mov	MOV	4.58 MB
0703 Triggering a procedure using a specific key sequence.mov	MOV	3.71 MB

08 Putting it All Together

MOV

6.06 MB

09 Conclusion

0901 Goodbye.mov

MOV

250.85 KB

Exercise Files

Ex_Files_Excel_VBA.zip

ZIP

1.12 MB

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
[Lynda.com].Laravel 9.0 Essential Training.(2022).[MP4] Posted by Midiablooo in Other Posted in Other 0 496.73 MB 3 years ago Midiablooo	Size 496.73 MB	Files 90	Age 3 years ago	Seeds 0	Leechs 0	Source
[TutorialPace] Lynda.com - CorelDRAW Essential Training - [TP] Posted by TutorialPace in Other Posted in Other 0 1 GB 6 years ago TutorialPace	Size 1 GB	Files 54	Age 6 years ago	Seeds 0	Leechs 1	Source
[Lynda.com] - Foundations of Programming : Fundamentals (2011) [WebDL mov 540p EN] Posted by Hrund in Other Posted in Other 0 1.07 GB 6 years ago Hrund	Size 1.07 GB	Files 162	Age 6 years ago	Seeds 0	Leechs 0	Source
[Lynda.com] - Foundations of Programming : Web Security (2014) [WebDL MP4 720p EN ] Posted by Imadiano in Other Posted in Other 6 299.07 MB 6 years ago Imadiano	Size 299.07 MB	Files 51	Age 6 years ago	Seeds 6	Leechs 0	Source
[Lynda.com] - Foundations of Programming : Databases (2015) [WebDL - WMV En] Posted by Hrund in Other Posted in Other 0 916.21 MB 6 years ago Hrund	Size 916.21 MB	Files 40	Age 6 years ago	Seeds 0	Leechs 0	Source

Lynda.com - Excel: VBA in Depth [2010, ENG]

Tracker name
http://bt4.t-ru.org/ann?magnet
http://bt2.t-ru.org/ann
http://bt3.t-ru.org/ann
http://bt4.t-ru.org/ann
udp://tracker.opentrackr.org:1337
udp://open.stealth.si:80/announce
udp://tracker.torrent.eu.org:451/announce
udp://exodus.desync.com:6969
udp://open.demonii.com:1337/announce
udp://tracker.coppersurfer.tk:6969
udp://p4p.arenabg.com:1337
udp://tracker.internetwarriors.net:1337