Download Lynda - Excel VBA in Depth with Curt Frye Torrent

Movie: Lynda
Detected quality: 480p
IMDb link: 7144896
IMDb rating: 10 (15 votes) Search
Genres: Mystery, Short
Director: Hamzah Tarzan

Release date: 1 Aug 2013
Release year: 2013
Country: United States
Budget: $3,000

Available in versions:
720p 480p

Torrent Contents Size: 185.07 MB

Lynda - Excel VBA in Depth with Curt Frye

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

0801 Applying techniques in a Capstone project.mov

MOV

6.06 MB

09 Conclusion

0901 Goodbye.mov

MOV

250.85 KB

Exercise Files

Ch01

Comments.xlsm	XLSM	39.93 KB
Commission.xlsm	XLSM	37.55 KB
ModulesManaged.xlsm	XLSM	9.9 KB
ProjectProperties.xlsm	XLSM	15.95 KB
RecordFirst.xlsm	XLSM	17.88 KB
RunAMacro.xlsm	XLSM	39.1 KB
Scope.xlsm	XLSM	41.37 KB
Scope.xlsx	XLSX	37.45 KB
VBEditor.xlsm	XLSM	13.86 KB
VBEditor.xlsx	XLSX	9.81 KB

Ch02

ConstantStatic.xlsm	XLSM	39.81 KB
DimVariables.xlsm	XLSM	39.04 KB
MonthlySales.xlsm	XLSM	18.4 KB
Operators.xlsm	XLSM	40.74 KB
ShippingCharges.xlsm	XLSM	18.27 KB
Types.xlsm	XLSM	15.95 KB
VariableScope.xlsm	XLSM	37.72 KB
WithExample.xlsm	XLSM	8.98 KB

Ch03

Case.xlsm	XLSM	38.94 KB
ForEach.xlsm	XLSM	18.46 KB
ForNext.xlsm	XLSM	17.45 KB
IfThen.xlsm	XLSM	39.46 KB
Suggestions.xlsm	XLSM	40.44 KB

Ch04

Breaking.xlsm	XLSM	41.93 KB
CheckError.xlsm	XLSM	13.46 KB
Immediate.xlsm	XLSM	42.31 KB
Stepping.xlsm	XLSM	42.6 KB
Watch.xlsm	XLSM	16.77 KB

Ch05

Concatenate.xlsm	XLSM	15.42 KB
CutPaste.xlsm	XLSM	17.31 KB
CutStrings.xlsm	XLSM	12.46 KB
Find.xlsm	XLSM	13.39 KB
Offset.xlsm	XLSM	39.83 KB
Workbooks.xlsm	XLSM	12.44 KB
Worksheets.xlsm	XLSM	38.42 KB
Writing.xlsm	XLSM	39.84 KB

Ch06

Boxes.xlsm	XLSM	40.83 KB
Calling.xlsm	XLSM	40.46 KB
Flashing.xlsm	XLSM	41.41 KB
WorksheetFunctions.xlsm	XLSM	38.79 KB

Ch07

ChangeRange.xlsm	XLSM	39.41 KB
ManipulateWorkbook.xlsm	XLSM	41.33 KB
OnKey.xlsm	XLSM	39.55 KB

Ch08

Capstone.xlsm

XLSM

45.5 KB

Description

									Show full description
								

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Lynda - Setting Up a Database in Excel 2010 with Dennis Taylor Posted by 2boweb in Movies - Other Movies Posted in Movies - Other Movies 1 111.81 MB 11 years ago 2boweb	Size 111.81 MB	Files 18	Age 11 years ago	Seeds 1	Leechs 0	Source
Lynda com - Financial Analysis Analyzing the Top Line with Excel Posted by pitsosnikos in Movies - Other Movies Posted in Movies - Other Movies 2 534.35 MB 12 years ago pitsosnikos	Size 534.35 MB	Files 49	Age 12 years ago	Seeds 2	Leechs 0	Source
Excel for Mac 2011 Essential Training - Lynda Posted by doduykhuong in Movies - Other Movies Posted in Movies - Other Movies 1 918.67 MB 13 years ago doduykhuong	Size 918.67 MB	Files 1	Age 13 years ago	Seeds 1	Leechs 0	Source
Lynda - Excel 2010 Tutorial Collection (4 courses) Posted by azda in Movies - Other Movies Posted in Movies - Other Movies 0 2.42 GB 13 years ago azda	Size 2.42 GB	Files 435	Age 13 years ago	Seeds 0	Leechs 1	Source
Lynda - Excel 2010 Macros In Depth Posted by arman258 in Movies - Other Movies Posted in Movies - Other Movies 0 378.72 MB 13 years ago arman258	Size 378.72 MB	Files 29	Age 13 years ago	Seeds 0	Leechs 0	Source

Lynda - Excel VBA in Depth with Curt Frye

Torrent Contents Size: 185.07 MB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
udp://tracker.coppersurfer.tk:6969/announce
udp://9.rarbg.me:2850/announce
udp://9.rarbg.to:2920/announce
udp://tracker.opentrackr.org:1337
udp://tracker.leechers-paradise.org:6969/announce