种子简介

种子名称： [FreeCourseLab.com] Udemy - Excel VBA Programming - The Complete Guide
文件类型： 视频
文件数目： 154个文件
文件大小： 2.37 GB
收录时间： 2019-1-30 01:33
已经下载： 3次
资源热度： 82
最近下载： 2024-4-15 07:32

下载BT种子文件

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

磁力链接下载

magnet:?xt=urn:btih:6bb99b06475352382a24625cf536495854a267f7&dn=[FreeCourseLab.com] Udemy - Excel VBA Programming - The Complete Guide 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeCourseLab.com] Udemy - Excel VBA Programming - The Complete Guide.torrent

1. Getting Started/1. Introduction.mp422.75MB

1. Getting Started/10. The Visual Basic Editor.mp415.88MB

1. Getting Started/3. Enable the Developer Tab.mp415.59MB

1. Getting Started/4. Excel File Types.mp48.18MB

1. Getting Started/5. Macro Security.mp417.31MB

1. Getting Started/6. The Macro Recorder.mp428.49MB

1. Getting Started/8. Absolute vs. Relative References I.mp415.43MB

1. Getting Started/9. Absolute vs. Relative References II.mp416.52MB

10. Conditionals/1. Boolean Expressions.mp410.38MB

10. Conditionals/3. The If Then Statement.mp46.89MB

10. Conditionals/4. The ElseIf and Else Statements.mp420.4MB

10. Conditionals/5. Select Case.mp420.73MB

10. Conditionals/6. The AND & OR Logical Operators.mp412.52MB

10. Conditionals/8. The NOT Operator.mp413.86MB

11. Iteration/1. The For Next Loop.mp425.89MB

11. Iteration/2. The Step Keyword.mp413.54MB

11. Iteration/3. Deleting Rows.mp416.06MB

11. Iteration/5. The For Each-Next Construct.mp414.82MB

11. Iteration/6. Iterating over a Range of Cells with For Each.mp410.47MB

11. Iteration/7. The With-End With Construct.mp410.82MB

11. Iteration/8. Exit For and Review of Exit Sub.mp419.5MB

12. Miscellaneous Features/1. The MsgBox Method In Depth, Part I.mp444.02MB

12. Miscellaneous Features/2. The MsgBox Method In Depth, Part II.mp449.54MB

12. Miscellaneous Features/4. StatusBar.mp436.64MB

12. Miscellaneous Features/5. The Application.ScreenUpdating Property.mp46.24MB

12. Miscellaneous Features/6. SpecialCells.mp48.26MB

12. Miscellaneous Features/7. The InputBox Function.mp412.29MB

12. Miscellaneous Features/8. The Application.InputBox Method.mp414.47MB

13. Arrays/1. Intro to Arrays.mp48.03MB

13. Arrays/2. Alternate Syntax for Fixed-Size Arrays.mp46.15MB

13. Arrays/3. The Option Base 1 Syntax and Write Array Values to Cells.mp46.32MB

13. Arrays/4. Initialize Arrays within a For Loop.mp411.16MB

13. Arrays/5. The LBound and UBound Methods.mp49.61MB

13. Arrays/6. Dynamic Arrays.mp417.87MB

13. Arrays/7. The Range.RemoveDuplicates Method.mp48.17MB

14. Functions/1. VBA Functions, Part I.mp416.16MB

14. Functions/2. VBA Functions, Part II.mp49.52MB

14. Functions/3. The Split Function.mp48.21MB

14. Functions/4. The Is Family of Functions.mp478.98MB

14. Functions/5. Date and Time Functions.mp430.37MB

14. Functions/6. More Date and Time Functions.mp430.45MB

14. Functions/7. Excel Worksheet Functions.mp412.45MB

14. Functions/8. Custom Functions.mp415.31MB

15. Debugging/1. Intro to Error Handling.mp412.27MB

15. Debugging/2. The OnError and GoTo Keywords.mp413.13MB

15. Debugging/3. The OnError Resume Next Keywords.mp410.04MB

15. Debugging/4. Error and Err.Number.mp416.27MB

15. Debugging/5. Stepping Through Code.mp411.75MB

15. Debugging/6. Breakpoints.mp48.77MB

16. Events/1. Introduction to Events.mp429.28MB

16. Events/2. The Worksheet_SelectionChange Event.mp412.47MB

16. Events/3. Review of Application.EnableEvents.mp45.12MB

16. Events/4. The Worksheet_Change Event.mp419.18MB

16. Events/5. The Worksheet_Activate Event.mp44.15MB

16. Events/7. Workbook Events and The Sh Argument.mp413.43MB

16. Events/8. The Workbook_Open Event.mp45.61MB

16. Events/9. Procedures with Boolean Arguments + The Workbook_BeforePrint Event.mp46.03MB

17. User Forms/1. Create UserForm, Toolbox, Properties, Controls.mp410.51MB

17. User Forms/10. Activate a UserForm from Procedure.mp45.56MB

17. User Forms/11. The initialize Event.mp411.4MB

17. User Forms/12. The ListBox Control I - Wire up the Form.mp412.83MB

17. User Forms/13. The ListBox Control II - React to User Selection.mp415MB

17. User Forms/14. The ListBox Control III - Select Multiple Items.mp419.5MB

17. User Forms/15. The ComboBox Control I.mp49.63MB

17. User Forms/16. The ComboBox Control II.mp417.51MB

17. User Forms/17. The CheckBox Control.mp419.91MB

17. User Forms/2. The Label and TextBox Controls.mp49.38MB

17. User Forms/3. Naming Conventions.mp44.83MB

17. User Forms/5. Design Aesthetics.mp49.52MB

17. User Forms/6. The CommandButton Control.mp47.37MB

17. User Forms/7. Add Event Procedure to Control.mp48.05MB

17. User Forms/8. Unload and Hide a UserForm.mp412.59MB

17. User Forms/9. Submit the UserForm.mp417.14MB

2. The Fundamentals of the Excel Object Model/1. Object-Oriented Programming in Real Life.mp419.54MB

2. The Fundamentals of the Excel Object Model/3. Collection Objects in Real Life.mp410.41MB

2. The Fundamentals of the Excel Object Model/4. Objects As Properties.mp415.83MB

2. The Fundamentals of the Excel Object Model/5. The Excel Object Model.mp424.23MB

2. The Fundamentals of the Excel Object Model/6. Access Object from Collection by Name.mp47.44MB

2. The Fundamentals of the Excel Object Model/7. Default Properties.mp46.67MB

2. The Fundamentals of the Excel Object Model/8. The Name Property on Workbook and Worksheet Objects.mp47.41MB

3. The Visual Basic Editor/1. Visual Basic Editor Options.mp417.2MB

3. The Visual Basic Editor/2. Create and Delete a Procedure.mp415.44MB

3. The Visual Basic Editor/4. The Immediate Window and Debug.Print Method.mp416.11MB

3. The Visual Basic Editor/5. The MsgBox Method.mp425.92MB

3. The Visual Basic Editor/6. Comments.mp410.04MB

4. Objects and Methods/1. Methods without Arguments.mp45.09MB

4. Objects and Methods/3. Methods with Arguments.mp420.08MB

4. Objects and Methods/5. Methods with Multiple Arguments.mp412.59MB

4. Objects and Methods/6. The Object Browser.mp411.62MB

4. Objects and Methods/7. Ways to Invoke A Procedure.mp416.4MB

4. Objects and Methods/8. The TypeName Method.mp410.06MB

5. Variables and Data Types/1. Syntax Tips.mp414.56MB

5. Variables and Data Types/11. The Boolean Data Type.mp47.29MB

5. Variables and Data Types/12. The Date Data Type.mp411.91MB

5. Variables and Data Types/13. The Variant Data Type.mp410.27MB

5. Variables and Data Types/14. The Object Data Type.mp414.98MB

5. Variables and Data Types/15. Default Values for Declared Variables.mp44.9MB

5. Variables and Data Types/2. Variable Declarations and Assignments.mp418.5MB

5. Variables and Data Types/3. Multiple Variable Declarations.mp48.18MB

5. Variables and Data Types/4. The Option Explicit Setting.mp47.42MB

5. Variables and Data Types/5. The Byte, Integer and Long Data Types.mp413.16MB

5. Variables and Data Types/7. Mathematical Operations.mp410.26MB

5. Variables and Data Types/8. The Single and Double Data Types.mp410.28MB

5. Variables and Data Types/9. The String Data Type.mp48.48MB

6. Procedures/1. Variable Scope.mp413.25MB

6. Procedures/2. Call A Procedure from Another one.mp46.66MB

6. Procedures/3. Procedures with Arguments.mp414.06MB

6. Procedures/4. Procedure Scope (Public vs. Private).mp413.22MB

6. Procedures/5. The Exit Sub Keywords.mp43MB

6. Procedures/6. Constants.mp411.44MB

6. Procedures/7. Predefined Constants.mp422.49MB

7. Object Deep Dive/1. The Application Object.mp424.87MB

7. Object Deep Dive/11. The Worksheets.Add Method.mp440.12MB

7. Object Deep Dive/13. The Worksheet.Visible Property.mp435.07MB

7. Object Deep Dive/14. The Worksheet.Copy Method.mp428.71MB

7. Object Deep Dive/15. The Worksheet.Delete Method.mp422.34MB

7. Object Deep Dive/16. The Worksheet.Move Method.mp424.43MB

7. Object Deep Dive/2. The Application.DisplayAlerts Property.mp447.26MB

7. Object Deep Dive/3. The Workbooks.Count and Worksheets.Count Properties.mp414.26MB

7. Object Deep Dive/4. The Workbooks.Open Method and Workbook.Path Property.mp437.13MB

7. Object Deep Dive/5. The Workbooks.Close Method.mp49.56MB

7. Object Deep Dive/6. The Workbooks.Add Method.mp434.51MB

7. Object Deep Dive/7. The Workbook.SaveAs and Workbook.Save Methods.mp455.99MB

7. Object Deep Dive/8. The Workbook.Activate Method.mp442.08MB

7. Object Deep Dive/9. The Workbook.Close Method.mp433.03MB

8. Range References/1. The Range.Select Method.mp416MB

8. Range References/10. The Range.CurrentRegion Property.mp49.83MB

8. Range References/11. The Range.End Property.mp412.3MB

8. Range References/12. The Range.Count and Range.CountLarge Properties.mp46.36MB

8. Range References/13. The Range.Row and Range.Column Properties.mp44.5MB

8. Range References/14. The Range.Rows and Range.Columns Properties.mp445.44MB

8. Range References/15. The Range.EntireRow and Range.EntireColumn Properties.mp45.55MB

8. Range References/16. Get Last Row of Data in Worksheet.mp411.78MB

8. Range References/2. The Value vs. Text Properties.mp47.1MB

8. Range References/3. R1C1 Notation, Part I.mp418.3MB

8. Range References/4. R1C1 Notation, Part II.mp414.73MB

8. Range References/5. The Formula and FormulaR1C1 Properties.mp412.65MB

8. Range References/6. The Range.Offset Property.mp49.37MB

8. Range References/7. The Range.Resize Property.mp45.46MB

8. Range References/9. The Cells Property.mp48.65MB

9. Range Actions/1. The Range.FillDown Method.mp49.48MB

9. Range Actions/10. The Range.Clear, Range.ClearContents and Range.ClearFormats Methods.mp47.76MB

9. Range Actions/11. The Range.Delete Method.mp410.96MB

9. Range Actions/12. The Range.Copy and Range.Cut Methods.mp427.83MB

9. Range Actions/13. The Paste and PasteSpecial Methods on the Worksheet Object.mp49.18MB

9. Range Actions/14. The Parent Property on All Objects.mp47.37MB

9. Range Actions/2. The Range.Replace Method.mp48.97MB

9. Range Actions/3. The Range.TextToColumns Method.mp418.87MB

9. Range Actions/4. The Range.Worksheet Property.mp43.94MB

9. Range Actions/5. The Range.Sort Method.mp424.14MB

9. Range Actions/6. The Range.Font Property.mp417.31MB

9. Range Actions/7. The Range.Interior Property.mp412.8MB

9. Range Actions/8. The Range.ColumnWidth and Range.RowHeight Properties.mp412.19MB

9. Range Actions/9. The Range.AutoFit Method.mp45.69MB