种子简介

种子名称： [Tutorialsplanet.NET] Udemy - Excel VBA Programming - The Complete Guide
文件类型： 视频
文件数目： 155个文件
文件大小： 2.39 GB
收录时间： 2021-4-20 09:05
已经下载： 3次
资源热度： 190
最近下载： 2024-11-19 18:10

下载BT种子文件

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

磁力链接下载

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

喜欢这个种子的人也喜欢

种子包含的文件

[Tutorialsplanet.NET] Udemy - Excel VBA Programming - The Complete Guide.torrent

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

1. Getting Started/10. Absolute vs. Relative References II.mp416.51MB

1. Getting Started/11. The Visual Basic Editor.mp415.89MB

1. Getting Started/2. About Me.mp421.31MB

1. Getting Started/4. Enable the Developer Tab.mp415.58MB

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

1. Getting Started/6. Macro Security.mp417.32MB

1. Getting Started/7. The Macro Recorder.mp428.5MB

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

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

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

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

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

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

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

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.83MB

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

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

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

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

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

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

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

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

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.16MB

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

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

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

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

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

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

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

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

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.46MB

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.49MB

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

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

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

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

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

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

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

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

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

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.53MB

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

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

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

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.42MB

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

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

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.91MB

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.63MB

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

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.3MB

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.99MB

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

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

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

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.17MB

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

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

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

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

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

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

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

6. Procedures/5. The Exit Sub Keywords.mp43.01MB

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

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

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

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

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

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

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

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.27MB

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

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

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

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

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

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

8. Range References/1. The Range.Select Method.mp416.01MB

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

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

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

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

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.79MB

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.66MB

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.64MB

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

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

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

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

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

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

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

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

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

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.2MB

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