zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
[FreeTutorials.Us] ultimate-excel-programmer
magnet:?xt=urn:btih:426b789673ce9695b5353ee754fc88f4335d42b3&dn=[FreeTutorials.Us] ultimate-excel-programmer
磁力链接详情
Hash值:
426b789673ce9695b5353ee754fc88f4335d42b3
点击数:
171
文件大小:
1.29 GB
文件数量:
174
创建日期:
2017-12-18 02:40
最后访问:
2024-7-20 16:31
访问标签:
FreeTutorials
Us
ultimate-excel-programmer
文件列表详情
01 The Range Object/001 Intro and Course Workbooks download.mp4 35.99 MB
01 The Range Object/002 Get the Developer Tab and Intro to Developer Tab.mp4 3.58 MB
01 The Range Object/003 Getting started with Range object.mp4 1.98 MB
01 The Range Object/004 Creating Your First Macro From Scratch.mp4 4.26 MB
01 The Range Object/005 Adding a Secondary Command. . ..mp4 1.57 MB
01 The Range Object/006 Debugging in Excel VBA.mp4 2.5 MB
01 The Range Object/007 Saving a Macro-Enabled Workbook .xlsm.mp4 2.38 MB
01 The Range Object/008 Several Ways to trigger your Macro.mp4 2.12 MB
01 The Range Object/009 Affecting Multiple Cells with One Range Command - 2 Methods.mp4 3.06 MB
01 The Range Object/010 Adding Strings of Text to a Cell.mp4 2.54 MB
01 The Range Object/011 Using a Named Range with the Range Object.mp4 2.16 MB
02 Range Properties/012 .VALUE Property.mp4 2.98 MB
02 Range Properties/013 .TEXT Property.mp4 1.62 MB
02 Range Properties/014 .ROW and .COLUMN Properties.mp4 2.11 MB
02 Range Properties/015 .SELECT Property.mp4 1.53 MB
02 Range Properties/016 .COUNT Property.mp4 3.78 MB
02 Range Properties/017 .ADDRESS Property.mp4 3.41 MB
02 Range Properties/018 .FORMULA Property.mp4 7.36 MB
02 Range Properties/019 .NUMBERFORMAT Property.mp4 3.64 MB
02 Range Properties/020 FONT.BOLD UNDERLINE or ITALIC Properties.mp4 4.75 MB
03 The Cells Object/021 The Cells Object.mp4 6.03 MB
03 The Cells Object/022 Using Column Letters instead of Numbers.mp4 2.17 MB
03 The Cells Object/023 Using Cells Positionally within a Range.mp4 3.78 MB
03 The Cells Object/024 Affecting ALL Cells in a Worksheet.mp4 5.53 MB
03 The Cells Object/025 Using Range Object with Cells Object.mp4 5.5 MB
04 Variables/026 Intro to Variables.mp4 2.34 MB
04 Variables/027 Declaring Variables - Variable Types.mp4 4.96 MB
04 Variables/028 Declaring Variables - Types Demo.mp4 5.48 MB
04 Variables/029 Calling a Procedure from Another.mp4 2.33 MB
04 Variables/030 Public and Private Variables.mp4 5 MB
04 Variables/031 Using Constants.mp4 3.35 MB
04 Variables/032 BONUS Passing Variables to Another Procedure - ByVal and ByRef.mp4 14.56 MB
05 Toolbars and Menus/033 File Menu walkthrough.mp4 4.89 MB
05 Toolbars and Menus/034 Edit Menu walkthrough.mp4 10.03 MB
05 Toolbars and Menus/035 View Menu walkthrough.mp4 5.7 MB
05 Toolbars and Menus/036 View Menu2 - Watch Window Locals Window and Immediate Window.mp4 13.1 MB
05 Toolbars and Menus/037 Watch Window Wonders.mp4 9.9 MB
05 Toolbars and Menus/038 Insert and Format Menus.mp4 1.68 MB
05 Toolbars and Menus/039 Debug Menu Important.mp4 9.33 MB
05 Toolbars and Menus/040 Run and Tools Menus.mp4 7.55 MB
06 Super Important Tools and Excel Logic/041 Determining the Last Row in your Data Set.mp4 7.92 MB
06 Super Important Tools and Excel Logic/042 Determining the Last Column in your Data Set.mp4 4.82 MB
06 Super Important Tools and Excel Logic/043 Determining the Next Row in your Data Set.mp4 3.15 MB
06 Super Important Tools and Excel Logic/044 Recording a Macro.mp4 7.26 MB
06 Super Important Tools and Excel Logic/045 BONUS - Dynamic Sorting.mp4 16.57 MB
06 Super Important Tools and Excel Logic/046 Absolute vs Relative References.mp4 7.89 MB
06 Super Important Tools and Excel Logic/047 Using With and End With.mp4 6.34 MB
06 Super Important Tools and Excel Logic/048 Comparison Operators in Excel VBA.mp4 1.94 MB
06 Super Important Tools and Excel Logic/049 If Then Statement.mp4 4.01 MB
06 Super Important Tools and Excel Logic/050 Using Is Not Equal To.mp4 1.52 MB
06 Super Important Tools and Excel Logic/051 Logical Operator NOT.mp4 1.86 MB
06 Super Important Tools and Excel Logic/052 If Then Else Statement.mp4 2.77 MB
06 Super Important Tools and Excel Logic/053 If Then ElseIF Statement. . ..mp4 3.91 MB
06 Super Important Tools and Excel Logic/054 Comparitive Operators with Text and Numbers.mp4 3.95 MB
06 Super Important Tools and Excel Logic/055 Use If Then Statements in a One-Liner of code.mp4 2.82 MB
06 Super Important Tools and Excel Logic/056 Using GOTO and Labels.mp4 2.95 MB
06 Super Important Tools and Excel Logic/057 Select Case as Alternative to IF THEN Statements.mp4 4.18 MB
06 Super Important Tools and Excel Logic/058 Message Box with Yes and No Buttons.mp4 9.95 MB
06 Super Important Tools and Excel Logic/059 Relative Positioning using Offset.mp4 5.5 MB
06 Super Important Tools and Excel Logic/060 BONUS - User Defined Functions 101.mp4 13.5 MB
06 Super Important Tools and Excel Logic/061 BONUS - UDF Lesson 2.mp4 12.78 MB
07 Loops and Report Writing Basics/062 Intro to Loops the For Next Loop.mp4 4 MB
07 Loops and Report Writing Basics/063 Fun with our For Next Loop.mp4 6.85 MB
07 Loops and Report Writing Basics/064 Beginning our first Report using Loops.mp4 10.91 MB
07 Loops and Report Writing Basics/065 Using an InputBox.mp4 5.06 MB
07 Loops and Report Writing Basics/066 Adding InputBox to Our First Report to make it Dynamic.mp4 5.19 MB
07 Loops and Report Writing Basics/067 Add a Button to Open Our Report.mp4 7.75 MB
07 Loops and Report Writing Basics/068 Add a Cool Looking Button or Image to Open Report.mp4 6.07 MB
07 Loops and Report Writing Basics/069 Our First Printable Report part 1 - Declaring and Setting the Sheets.mp4 8.87 MB
07 Loops and Report Writing Basics/070 Printable Report Part 2 - Getting Items On Report Sheet.mp4 11.55 MB
07 Loops and Report Writing Basics/071 Printable Report Part 3 - Clearing Last Report.mp4 12.37 MB
07 Loops and Report Writing Basics/072 Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet.mp4 10.35 MB
07 Loops and Report Writing Basics/073 Using PrintPreview Automatically.mp4 3.16 MB
07 Loops and Report Writing Basics/074 Using PrintOut to Send Directly to Default Printer.mp4 5.34 MB
07 Loops and Report Writing Basics/075 Handling Debug Error When Cancelling InputBox.mp4 7.1 MB
07 Loops and Report Writing Basics/076 For Loop Going Backwards using STEP.mp4 7.86 MB
07 Loops and Report Writing Basics/077 The FOR EACH Loop.mp4 9.5 MB
07 Loops and Report Writing Basics/078 FOR EACH Loop - Practical Examples.mp4 6.41 MB
07 Loops and Report Writing Basics/079 Intro to DO LOOPS.mp4 7.51 MB
07 Loops and Report Writing Basics/080 DO Until.mp4 2.95 MB
07 Loops and Report Writing Basics/081 Loop Until.mp4 2.28 MB
07 Loops and Report Writing Basics/082 DO While.mp4 2.66 MB
07 Loops and Report Writing Basics/083 Loop While.mp4 1.57 MB
07 Loops and Report Writing Basics/084 EXIT DO - Multiple Exits using your own Criteria along the Way.mp4 2.37 MB
08 EVENTS Worksheet Events made Easy/085 Intro to Worksheet Events and Selection_Change.mp4 6.38 MB
08 EVENTS Worksheet Events made Easy/086 Worksheet Activate Event.mp4 2.44 MB
08 EVENTS Worksheet Events made Easy/087 Worksheet Deactivate Event.mp4 4.35 MB
08 EVENTS Worksheet Events made Easy/088 BeforeDelete Event - for Worksheet Deletion.mp4 2.38 MB
08 EVENTS Worksheet Events made Easy/089 BeforeDoubleClick Event - Trigger a Macro when Double Clicking.mp4 4.86 MB
08 EVENTS Worksheet Events made Easy/090 BeforeRightClick Event - Trigger a Macro when Right-Clicking.mp4 2.63 MB
08 EVENTS Worksheet Events made Easy/091 Calculate Event.mp4 5.93 MB
08 EVENTS Worksheet Events made Easy/092 How to Disable Events on the Workbook.mp4 2.81 MB
08 EVENTS Worksheet Events made Easy/093 Intro to Change Event.mp4 2.14 MB
08 EVENTS Worksheet Events made Easy/094 Change Event with EnableEvents toggle - Avoid endless loop.mp4 7.74 MB
08 EVENTS Worksheet Events made Easy/095 Change Event Triggered with Custom Range Using Intersect.mp4 5.54 MB
08 EVENTS Worksheet Events made Easy/096 FollowHyperlinks Event.mp4 6.19 MB
08 EVENTS Worksheet Events made Easy/097 Final Thoughts on Worksheet Events and Review Other Events.mp4 4.5 MB
08 EVENTS Worksheet Events made Easy/098 Events Exercise 1.mp4 15.61 MB
09 WorkBook Events/099 Workbook Open.mp4 8.85 MB
09 WorkBook Events/100 Workbook Activate.mp4 4.64 MB
09 WorkBook Events/101 Before Save.mp4 5.12 MB
09 WorkBook Events/102 After Save.mp4 7.45 MB
09 WorkBook Events/103 Before Close.mp4 9.81 MB
09 WorkBook Events/104 Before Print.mp4 3.53 MB
09 WorkBook Events/105 Deactivate.mp4 3.37 MB
09 WorkBook Events/106 NewChart.mp4 9.22 MB
09 WorkBook Events/107 NewSheet.mp4 4.26 MB
09 WorkBook Events/108 Sheet Activate.mp4 6.83 MB
09 WorkBook Events/109 Delete DoubleClick RightClick Calculate Change.mp4 12.39 MB
09 WorkBook Events/110 SheetDeactivate.mp4 7.02 MB
09 WorkBook Events/111 Follow Hyperlink.mp4 3.49 MB
09 WorkBook Events/112 SheetSelectionChange.mp4 4.36 MB
09 WorkBook Events/113 WindowActivate.mp4 3.38 MB
09 WorkBook Events/114 WindowDeactivate.mp4 2.36 MB
09 WorkBook Events/115 WindowResize.mp4 7.28 MB
10 Activex Controls on Worksheets/116 Activex Controls vs Forms Controls.mp4 5.84 MB
10 Activex Controls on Worksheets/117 Button Click - Wage Calculator.mp4 6.59 MB
10 Activex Controls on Worksheets/118 Keydown Event.mp4 6.09 MB
10 Activex Controls on Worksheets/119 BONUS Capturing Shift Alt Ctrl or some combination using the Shift variable.mp4 6.77 MB
10 Activex Controls on Worksheets/120 KeyPress Event.mp4 6.67 MB
10 Activex Controls on Worksheets/121 MouseMove Event.mp4 3.39 MB
10 Activex Controls on Worksheets/122 MouseMove Event with Application.Statusbar - fun and useful.mp4 6.41 MB
10 Activex Controls on Worksheets/123 MouseUp and MouseDown Events - Left Middle Rightclick Shift Alt Ctrl.mp4 11.41 MB
10 Activex Controls on Worksheets/124 GotFocus and LostFocus Events.mp4 2.27 MB
10 Activex Controls on Worksheets/125 Use a Checkbox for its VALUE.mp4 4.54 MB
10 Activex Controls on Worksheets/126 Checkbox Event Without a Button.mp4 2.84 MB
10 Activex Controls on Worksheets/127 LinkedCell Property with a Checkbox.mp4 2.28 MB
10 Activex Controls on Worksheets/128 Option Buttons Intro - What is an Option Button and Grouping.mp4 4.53 MB
10 Activex Controls on Worksheets/129 Grouping Alignment and Aesthetics for Controls.mp4 4.52 MB
10 Activex Controls on Worksheets/130 Homemade Quiz using Option Buttons and a Command Button.mp4 7.01 MB
10 Activex Controls on Worksheets/131 Compliance Checker for your Forms or Quizzes Part 1.mp4 6.54 MB
10 Activex Controls on Worksheets/132 Compliance check part 2.mp4 20.01 MB
10 Activex Controls on Worksheets/133 SpinButton with Cell A1.mp4 6.66 MB
10 Activex Controls on Worksheets/134 SpinButtons with Textboxes and Numbers.mp4 9.94 MB
10 Activex Controls on Worksheets/135 SpinButton BONUS - Move Textbox Position with SpinButton.mp4 8.74 MB
10 Activex Controls on Worksheets/136 SpinButton with Dates in a Textbox.mp4 6.85 MB
10 Activex Controls on Worksheets/137 Activex Label Control - Basics.mp4 6.79 MB
10 Activex Controls on Worksheets/138 ComboBox - Fill with ListFillRange.mp4 7.73 MB
10 Activex Controls on Worksheets/139 Creating a Dynamic Range.mp4 8.63 MB
10 Activex Controls on Worksheets/140 ComboBox - How to use Multiple Columns.mp4 6.25 MB
10 Activex Controls on Worksheets/141 Using .ADDITEM to Get Specific items in your Combobox List.mp4 17.73 MB
10 Activex Controls on Worksheets/142 Noteworthy Properties of a Combobox.mp4 12 MB
10 Activex Controls on Worksheets/143 Multiple Columns in Combobox with .ADDITEM and List ListCount etc.mp4 16.21 MB
10 Activex Controls on Worksheets/144 ListBox Basics using Dynamic Range.mp4 15.37 MB
10 Activex Controls on Worksheets/145 Listbox Click event and Dynamic Options.mp4 7.11 MB
10 Activex Controls on Worksheets/146 BONUS - Manipulating and Using Multiselect Items in a Listbox.mp4 10.54 MB
10 Activex Controls on Worksheets/147 ListBox - Referencing Column 0 and 1 in a cell Dynamically.mp4 10.61 MB
10 Activex Controls on Worksheets/148 Dynamic ListBoxes Using .ADDITEM and More.mp4 19.8 MB
10 Activex Controls on Worksheets/149 Make and Utilize INVISIBLE Columns - Special Trick.mp4 6.47 MB
10 Activex Controls on Worksheets/150 Using a Scroll Bar on a worksheet.mp4 4.72 MB
10 Activex Controls on Worksheets/151 Pictures on a Worksheet plus using FollowHyperlink Method.mp4 13.91 MB
10 Activex Controls on Worksheets/152 Toggle Button.mp4 4.57 MB
10 Activex Controls on Worksheets/153 A Brief Note on Alternate 3rd Party Controls.mp4 2.9 MB
11 Userforms - the best thing. EVER/154 Userform - Hide Show and Unload.mp4 9.13 MB
11 Userforms - the best thing. EVER/155 Sample Database and Creating a Data Entry Form.mp4 34.48 MB
11 Userforms - the best thing. EVER/156 Fill Status combobox with Rowsource when Userform starts - 2 methods.mp4 9.39 MB
11 Userforms - the best thing. EVER/157 New Employee Data Entry Form.mp4 36.52 MB
11 Userforms - the best thing. EVER/158 Format Textbox Numbers as Numerals Clearing out Form upon Submission.mp4 8.69 MB
11 Userforms - the best thing. EVER/159 Set the Tab Order for Userform Controls.mp4 5.51 MB
11 Userforms - the best thing. EVER/160 Set Default Values to Make Data Entry Easier.mp4 5.47 MB
11 Userforms - the best thing. EVER/161 Avoid Duplicate Employee ID and other Fun Automation Tricks.mp4 15.76 MB
11 Userforms - the best thing. EVER/162 Edit Mode for Employee Database - Part 1.mp4 37.32 MB
11 Userforms - the best thing. EVER/163 Edit Mode for Employee Database - Part 2.mp4 25.05 MB
11 Userforms - the best thing. EVER/164 Edit Mode Pt 3 - Adding Automation and Save Button.mp4 43.94 MB
11 Userforms - the best thing. EVER/165 Userform Report with Filters - Part 1.mp4 26.37 MB
11 Userforms - the best thing. EVER/166 Userform Report with Filters - Part 2.mp4 15.71 MB
11 Userforms - the best thing. EVER/167 Applying the Dynamic Filters to Reports.mp4 8.46 MB
11 Userforms - the best thing. EVER/168 Clear out Last Report.mp4 6.99 MB
11 Userforms - the best thing. EVER/169 Report Generation and Aesthetics Headers Footers Repeat Rows etc..mp4 10.65 MB
11 Userforms - the best thing. EVER/170 Concluding Thoughts. . ..mp4 3.36 MB
12 BONUS Section - VBA Functions/171 InStr Function - Search for Text Within Other Text.mp4 14.78 MB
12 BONUS Section - VBA Functions/172 The EVALUATE Function - Mac-Daddy of all functions.mp4 13.47 MB
12 BONUS Section - VBA Functions/173 Sum Function in Excel VBA - EASY.mp4 7.74 MB
12 BONUS Section - VBA Functions/174 Count Function in VBA.mp4 4.75 MB
其他位置