种子简介

种子名称： Lynda.com.Excel.VBA.in.Depth
文件类型： 视频
文件数目： 47个文件
文件大小： 183.79 MB
收录时间： 2017-2-6 10:37
已经下载： 3次
资源热度： 143
最近下载： 2024-12-16 18:21

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:794f3cbf6e531a12efec8a1daf712a5add82591a&dn=Lynda.com.Excel.VBA.in.Depth 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Lynda.com.Excel.VBA.in.Depth.torrent

00 Introduction/0001 Welcome.mov4.7MB

00 Introduction/0002 Using the exercise files.mov279.59KB

01 Introducing Visual Basic for Applications/0101 Introducing object-oriented programming.mov1.62MB

01 Introducing Visual Basic for Applications/0102 Examining the Excel object model.mov3.59MB

01 Introducing Visual Basic for Applications/0103 Working in the Visual Basic editor.mov4.98MB

01 Introducing Visual Basic for Applications/0104 Setting VBA project properties.mov2.38MB

01 Introducing Visual Basic for Applications/0105 Creating, exporting, and deleting code modules.mov6.57MB

01 Introducing Visual Basic for Applications/0106 Creating a subroutine or function.mov5.74MB

01 Introducing Visual Basic for Applications/0107 Controlling procedure scope and visibility.mov3.28MB

01 Introducing Visual Basic for Applications/0108 Adding comments to the code.mov3.54MB

01 Introducing Visual Basic for Applications/0109 Running a VBA routine.mov4.59MB

01 Introducing Visual Basic for Applications/0110 Adding code to a recorded macro.mov3.18MB

02 Defining Variables, Constants, and Calculations/0201 Introducing Excel VBA data types.mov6.72MB

02 Defining Variables, Constants, and Calculations/0202 Declaring variables and requiring declaration before use.mov4.19MB

02 Defining Variables, Constants, and Calculations/0203 Managing variable scope.mov3.71MB

02 Defining Variables, Constants, and Calculations/0204 Defining static variables and constants.mov5.07MB

02 Defining Variables, Constants, and Calculations/0205 Creating a calculation using mathematical operators.mov3.55MB

02 Defining Variables, Constants, and Calculations/0206 Defining arrays.mov7.06MB

02 Defining Variables, Constants, and Calculations/0207 Defining and using object variables.mov2.78MB

02 Defining Variables, Constants, and Calculations/0208 Streamlining code references using With End With statements.mov3.6MB

03 Adding Logic to Your VBA Code/0301 Repeating a task using a For Next loop.mov2.49MB

03 Adding Logic to Your VBA Code/0302 Stepping through all items of a collection using a For Each loop.mov3.05MB

03 Adding Logic to Your VBA Code/0303 Repeating a task with a Do loop.mov5.3MB

03 Adding Logic to Your VBA Code/0304 Performing a task when conditions are met using If Then.mov7.18MB

03 Adding Logic to Your VBA Code/0305 Selecting which action to take using a Case statement.mov1.76MB

04 Debugging You VBA Code/0401 Managing errors using On Error statements.mov4.68MB

04 Debugging You VBA Code/0402 Stepping through a subroutine or function.mov5.64MB

04 Debugging You VBA Code/0403 Setting breakpoints in the code.mov2.57MB

04 Debugging You VBA Code/0404 Verifying output using the Immediate window.mov3.82MB

04 Debugging You VBA Code/0405 Watching a value in a routine.mov2.94MB

05 Managing Workbook Elements and Data in VBA/0501 Writing a value to a cell.mov3.62MB

05 Managing Workbook Elements and Data in VBA/0502 Cutting, copying, and pasting cell data.mov5.14MB

05 Managing Workbook Elements and Data in VBA/0503 Finding values in cells.mov4.21MB

05 Managing Workbook Elements and Data in VBA/0504 Referring to cells using the Offset function.mov2.97MB

05 Managing Workbook Elements and Data in VBA/0505 Concatenating text strings.mov4.01MB

05 Managing Workbook Elements and Data in VBA/0506 Returning part of a string.mov2.83MB

05 Managing Workbook Elements and Data in VBA/0507 Managing worksheets with VBA.mov5.59MB

05 Managing Workbook Elements and Data in VBA/0508 Managing workbooks with VBA.mov3.89MB

06 Adding Advanced Elements to Your Workbook/0601 Turning off screen updating within a macro.mov2.54MB

06 Adding Advanced Elements to Your Workbook/0602 Using worksheet functions in a macro.mov2.38MB

06 Adding Advanced Elements to Your Workbook/0603 Acquiring values using an input box or message box.mov5.13MB

06 Adding Advanced Elements to Your Workbook/0604 Calling a subroutine from another subroutine.mov2.02MB

07 Using Excel Events in Your VBA Code/0701 Running a procedure when you open, close, or save a workbook.mov4.32MB

07 Using Excel Events in Your VBA Code/0702 Running a procedure when a cell range changes.mov4.58MB

07 Using Excel Events in Your VBA Code/0703 Triggering a procedure using a specific key sequence.mov3.71MB

08 Putting it All Together/0801 Applying techniques in a Capstone project.mov6.06MB

09 Conclusion/0901 Goodbye.mov250.85KB