种子简介

种子名称： [FreeTutorials.Us] ultimate-excel-programmer
文件类型： 视频
文件数目： 174个文件
文件大小： 1.29 GB
收录时间： 2017-12-18 02:40
已经下载： 3次
资源热度： 159
最近下载： 2024-5-27 19:53

下载BT种子文件

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

磁力链接下载

magnet:?xt=urn:btih:426b789673ce9695b5353ee754fc88f4335d42b3&dn=[FreeTutorials.Us] ultimate-excel-programmer 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeTutorials.Us] ultimate-excel-programmer.torrent

01 The Range Object/001 Intro and Course Workbooks download.mp435.99MB

01 The Range Object/002 Get the Developer Tab and Intro to Developer Tab.mp43.58MB

01 The Range Object/003 Getting started with Range object.mp41.98MB

01 The Range Object/004 Creating Your First Macro From Scratch.mp44.26MB

01 The Range Object/005 Adding a Secondary Command. . ..mp41.57MB

01 The Range Object/006 Debugging in Excel VBA.mp42.5MB

01 The Range Object/007 Saving a Macro-Enabled Workbook .xlsm.mp42.38MB

01 The Range Object/008 Several Ways to trigger your Macro.mp42.12MB

01 The Range Object/009 Affecting Multiple Cells with One Range Command - 2 Methods.mp43.06MB

01 The Range Object/010 Adding Strings of Text to a Cell.mp42.54MB

01 The Range Object/011 Using a Named Range with the Range Object.mp42.16MB

02 Range Properties/012 .VALUE Property.mp42.98MB

02 Range Properties/013 .TEXT Property.mp41.62MB

02 Range Properties/014 .ROW and .COLUMN Properties.mp42.11MB

02 Range Properties/015 .SELECT Property.mp41.53MB

02 Range Properties/016 .COUNT Property.mp43.78MB

02 Range Properties/017 .ADDRESS Property.mp43.41MB

02 Range Properties/018 .FORMULA Property.mp47.36MB

02 Range Properties/019 .NUMBERFORMAT Property.mp43.64MB

02 Range Properties/020 FONT.BOLD UNDERLINE or ITALIC Properties.mp44.75MB

03 The Cells Object/021 The Cells Object.mp46.03MB

03 The Cells Object/022 Using Column Letters instead of Numbers.mp42.17MB

03 The Cells Object/023 Using Cells Positionally within a Range.mp43.78MB

03 The Cells Object/024 Affecting ALL Cells in a Worksheet.mp45.53MB

03 The Cells Object/025 Using Range Object with Cells Object.mp45.5MB

04 Variables/026 Intro to Variables.mp42.34MB

04 Variables/027 Declaring Variables - Variable Types.mp44.96MB

04 Variables/028 Declaring Variables - Types Demo.mp45.48MB

04 Variables/029 Calling a Procedure from Another.mp42.33MB

04 Variables/030 Public and Private Variables.mp45MB

04 Variables/031 Using Constants.mp43.35MB

04 Variables/032 BONUS Passing Variables to Another Procedure - ByVal and ByRef.mp414.56MB

05 Toolbars and Menus/033 File Menu walkthrough.mp44.89MB

05 Toolbars and Menus/034 Edit Menu walkthrough.mp410.03MB

05 Toolbars and Menus/035 View Menu walkthrough.mp45.7MB

05 Toolbars and Menus/036 View Menu2 - Watch Window Locals Window and Immediate Window.mp413.1MB

05 Toolbars and Menus/037 Watch Window Wonders.mp49.9MB

05 Toolbars and Menus/038 Insert and Format Menus.mp41.68MB

05 Toolbars and Menus/039 Debug Menu Important.mp49.33MB

05 Toolbars and Menus/040 Run and Tools Menus.mp47.55MB

06 Super Important Tools and Excel Logic/041 Determining the Last Row in your Data Set.mp47.92MB

06 Super Important Tools and Excel Logic/042 Determining the Last Column in your Data Set.mp44.82MB

06 Super Important Tools and Excel Logic/043 Determining the Next Row in your Data Set.mp43.15MB

06 Super Important Tools and Excel Logic/044 Recording a Macro.mp47.26MB

06 Super Important Tools and Excel Logic/045 BONUS - Dynamic Sorting.mp416.57MB

06 Super Important Tools and Excel Logic/046 Absolute vs Relative References.mp47.89MB

06 Super Important Tools and Excel Logic/047 Using With and End With.mp46.34MB

06 Super Important Tools and Excel Logic/048 Comparison Operators in Excel VBA.mp41.94MB

06 Super Important Tools and Excel Logic/049 If Then Statement.mp44.01MB

06 Super Important Tools and Excel Logic/050 Using Is Not Equal To.mp41.52MB

06 Super Important Tools and Excel Logic/051 Logical Operator NOT.mp41.86MB

06 Super Important Tools and Excel Logic/052 If Then Else Statement.mp42.77MB

06 Super Important Tools and Excel Logic/053 If Then ElseIF Statement. . ..mp43.91MB

06 Super Important Tools and Excel Logic/054 Comparitive Operators with Text and Numbers.mp43.95MB

06 Super Important Tools and Excel Logic/055 Use If Then Statements in a One-Liner of code.mp42.82MB

06 Super Important Tools and Excel Logic/056 Using GOTO and Labels.mp42.95MB

06 Super Important Tools and Excel Logic/057 Select Case as Alternative to IF THEN Statements.mp44.18MB

06 Super Important Tools and Excel Logic/058 Message Box with Yes and No Buttons.mp49.95MB

06 Super Important Tools and Excel Logic/059 Relative Positioning using Offset.mp45.5MB

06 Super Important Tools and Excel Logic/060 BONUS - User Defined Functions 101.mp413.5MB

06 Super Important Tools and Excel Logic/061 BONUS - UDF Lesson 2.mp412.78MB

07 Loops and Report Writing Basics/062 Intro to Loops the For Next Loop.mp44MB

07 Loops and Report Writing Basics/063 Fun with our For Next Loop.mp46.85MB

07 Loops and Report Writing Basics/064 Beginning our first Report using Loops.mp410.91MB

07 Loops and Report Writing Basics/065 Using an InputBox.mp45.06MB

07 Loops and Report Writing Basics/066 Adding InputBox to Our First Report to make it Dynamic.mp45.19MB

07 Loops and Report Writing Basics/067 Add a Button to Open Our Report.mp47.75MB

07 Loops and Report Writing Basics/068 Add a Cool Looking Button or Image to Open Report.mp46.07MB

07 Loops and Report Writing Basics/069 Our First Printable Report part 1 - Declaring and Setting the Sheets.mp48.87MB

07 Loops and Report Writing Basics/070 Printable Report Part 2 - Getting Items On Report Sheet.mp411.55MB

07 Loops and Report Writing Basics/071 Printable Report Part 3 - Clearing Last Report.mp412.37MB

07 Loops and Report Writing Basics/072 Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet.mp410.35MB

07 Loops and Report Writing Basics/073 Using PrintPreview Automatically.mp43.16MB

07 Loops and Report Writing Basics/074 Using PrintOut to Send Directly to Default Printer.mp45.34MB

07 Loops and Report Writing Basics/075 Handling Debug Error When Cancelling InputBox.mp47.1MB

07 Loops and Report Writing Basics/076 For Loop Going Backwards using STEP.mp47.86MB

07 Loops and Report Writing Basics/077 The FOR EACH Loop.mp49.5MB

07 Loops and Report Writing Basics/078 FOR EACH Loop - Practical Examples.mp46.41MB

07 Loops and Report Writing Basics/079 Intro to DO LOOPS.mp47.51MB

07 Loops and Report Writing Basics/080 DO Until.mp42.95MB

07 Loops and Report Writing Basics/081 Loop Until.mp42.28MB

07 Loops and Report Writing Basics/082 DO While.mp42.66MB

07 Loops and Report Writing Basics/083 Loop While.mp41.57MB

07 Loops and Report Writing Basics/084 EXIT DO - Multiple Exits using your own Criteria along the Way.mp42.37MB

08 EVENTS Worksheet Events made Easy/085 Intro to Worksheet Events and Selection_Change.mp46.38MB

08 EVENTS Worksheet Events made Easy/086 Worksheet Activate Event.mp42.44MB

08 EVENTS Worksheet Events made Easy/087 Worksheet Deactivate Event.mp44.35MB

08 EVENTS Worksheet Events made Easy/088 BeforeDelete Event - for Worksheet Deletion.mp42.38MB

08 EVENTS Worksheet Events made Easy/089 BeforeDoubleClick Event - Trigger a Macro when Double Clicking.mp44.86MB

08 EVENTS Worksheet Events made Easy/090 BeforeRightClick Event - Trigger a Macro when Right-Clicking.mp42.63MB

08 EVENTS Worksheet Events made Easy/091 Calculate Event.mp45.93MB

08 EVENTS Worksheet Events made Easy/092 How to Disable Events on the Workbook.mp42.81MB

08 EVENTS Worksheet Events made Easy/093 Intro to Change Event.mp42.14MB

08 EVENTS Worksheet Events made Easy/094 Change Event with EnableEvents toggle - Avoid endless loop.mp47.74MB

08 EVENTS Worksheet Events made Easy/095 Change Event Triggered with Custom Range Using Intersect.mp45.54MB

08 EVENTS Worksheet Events made Easy/096 FollowHyperlinks Event.mp46.19MB

08 EVENTS Worksheet Events made Easy/097 Final Thoughts on Worksheet Events and Review Other Events.mp44.5MB

08 EVENTS Worksheet Events made Easy/098 Events Exercise 1.mp415.61MB

09 WorkBook Events/099 Workbook Open.mp48.85MB

09 WorkBook Events/100 Workbook Activate.mp44.64MB

09 WorkBook Events/101 Before Save.mp45.12MB

09 WorkBook Events/102 After Save.mp47.45MB

09 WorkBook Events/103 Before Close.mp49.81MB

09 WorkBook Events/104 Before Print.mp43.53MB

09 WorkBook Events/105 Deactivate.mp43.37MB

09 WorkBook Events/106 NewChart.mp49.22MB

09 WorkBook Events/107 NewSheet.mp44.26MB

09 WorkBook Events/108 Sheet Activate.mp46.83MB

09 WorkBook Events/109 Delete DoubleClick RightClick Calculate Change.mp412.39MB

09 WorkBook Events/110 SheetDeactivate.mp47.02MB

09 WorkBook Events/111 Follow Hyperlink.mp43.49MB

09 WorkBook Events/112 SheetSelectionChange.mp44.36MB

09 WorkBook Events/113 WindowActivate.mp43.38MB

09 WorkBook Events/114 WindowDeactivate.mp42.36MB

09 WorkBook Events/115 WindowResize.mp47.28MB

10 Activex Controls on Worksheets/116 Activex Controls vs Forms Controls.mp45.84MB

10 Activex Controls on Worksheets/117 Button Click - Wage Calculator.mp46.59MB

10 Activex Controls on Worksheets/118 Keydown Event.mp46.09MB

10 Activex Controls on Worksheets/119 BONUS Capturing Shift Alt Ctrl or some combination using the Shift variable.mp46.77MB

10 Activex Controls on Worksheets/120 KeyPress Event.mp46.67MB

10 Activex Controls on Worksheets/121 MouseMove Event.mp43.39MB

10 Activex Controls on Worksheets/122 MouseMove Event with Application.Statusbar - fun and useful.mp46.41MB

10 Activex Controls on Worksheets/123 MouseUp and MouseDown Events - Left Middle Rightclick Shift Alt Ctrl.mp411.41MB

10 Activex Controls on Worksheets/124 GotFocus and LostFocus Events.mp42.27MB

10 Activex Controls on Worksheets/125 Use a Checkbox for its VALUE.mp44.54MB

10 Activex Controls on Worksheets/126 Checkbox Event Without a Button.mp42.84MB

10 Activex Controls on Worksheets/127 LinkedCell Property with a Checkbox.mp42.28MB

10 Activex Controls on Worksheets/128 Option Buttons Intro - What is an Option Button and Grouping.mp44.53MB

10 Activex Controls on Worksheets/129 Grouping Alignment and Aesthetics for Controls.mp44.52MB

10 Activex Controls on Worksheets/130 Homemade Quiz using Option Buttons and a Command Button.mp47.01MB

10 Activex Controls on Worksheets/131 Compliance Checker for your Forms or Quizzes Part 1.mp46.54MB

10 Activex Controls on Worksheets/132 Compliance check part 2.mp420.01MB

10 Activex Controls on Worksheets/133 SpinButton with Cell A1.mp46.66MB

10 Activex Controls on Worksheets/134 SpinButtons with Textboxes and Numbers.mp49.94MB

10 Activex Controls on Worksheets/135 SpinButton BONUS - Move Textbox Position with SpinButton.mp48.74MB

10 Activex Controls on Worksheets/136 SpinButton with Dates in a Textbox.mp46.85MB

10 Activex Controls on Worksheets/137 Activex Label Control - Basics.mp46.79MB

10 Activex Controls on Worksheets/138 ComboBox - Fill with ListFillRange.mp47.73MB

10 Activex Controls on Worksheets/139 Creating a Dynamic Range.mp48.63MB

10 Activex Controls on Worksheets/140 ComboBox - How to use Multiple Columns.mp46.25MB

10 Activex Controls on Worksheets/141 Using .ADDITEM to Get Specific items in your Combobox List.mp417.73MB

10 Activex Controls on Worksheets/142 Noteworthy Properties of a Combobox.mp412MB

10 Activex Controls on Worksheets/143 Multiple Columns in Combobox with .ADDITEM and List ListCount etc.mp416.21MB

10 Activex Controls on Worksheets/144 ListBox Basics using Dynamic Range.mp415.37MB

10 Activex Controls on Worksheets/145 Listbox Click event and Dynamic Options.mp47.11MB

10 Activex Controls on Worksheets/146 BONUS - Manipulating and Using Multiselect Items in a Listbox.mp410.54MB

10 Activex Controls on Worksheets/147 ListBox - Referencing Column 0 and 1 in a cell Dynamically.mp410.61MB

10 Activex Controls on Worksheets/148 Dynamic ListBoxes Using .ADDITEM and More.mp419.8MB

10 Activex Controls on Worksheets/149 Make and Utilize INVISIBLE Columns - Special Trick.mp46.47MB

10 Activex Controls on Worksheets/150 Using a Scroll Bar on a worksheet.mp44.72MB

10 Activex Controls on Worksheets/151 Pictures on a Worksheet plus using FollowHyperlink Method.mp413.91MB

10 Activex Controls on Worksheets/152 Toggle Button.mp44.57MB

10 Activex Controls on Worksheets/153 A Brief Note on Alternate 3rd Party Controls.mp42.9MB

11 Userforms - the best thing. EVER/154 Userform - Hide Show and Unload.mp49.13MB

11 Userforms - the best thing. EVER/155 Sample Database and Creating a Data Entry Form.mp434.48MB

11 Userforms - the best thing. EVER/156 Fill Status combobox with Rowsource when Userform starts - 2 methods.mp49.39MB

11 Userforms - the best thing. EVER/157 New Employee Data Entry Form.mp436.52MB

11 Userforms - the best thing. EVER/158 Format Textbox Numbers as Numerals Clearing out Form upon Submission.mp48.69MB

11 Userforms - the best thing. EVER/159 Set the Tab Order for Userform Controls.mp45.51MB

11 Userforms - the best thing. EVER/160 Set Default Values to Make Data Entry Easier.mp45.47MB

11 Userforms - the best thing. EVER/161 Avoid Duplicate Employee ID and other Fun Automation Tricks.mp415.76MB

11 Userforms - the best thing. EVER/162 Edit Mode for Employee Database - Part 1.mp437.32MB

11 Userforms - the best thing. EVER/163 Edit Mode for Employee Database - Part 2.mp425.05MB

11 Userforms - the best thing. EVER/164 Edit Mode Pt 3 - Adding Automation and Save Button.mp443.94MB

11 Userforms - the best thing. EVER/165 Userform Report with Filters - Part 1.mp426.37MB

11 Userforms - the best thing. EVER/166 Userform Report with Filters - Part 2.mp415.71MB

11 Userforms - the best thing. EVER/167 Applying the Dynamic Filters to Reports.mp48.46MB

11 Userforms - the best thing. EVER/168 Clear out Last Report.mp46.99MB

11 Userforms - the best thing. EVER/169 Report Generation and Aesthetics Headers Footers Repeat Rows etc..mp410.65MB

11 Userforms - the best thing. EVER/170 Concluding Thoughts. . ..mp43.36MB

12 BONUS Section - VBA Functions/171 InStr Function - Search for Text Within Other Text.mp414.78MB

12 BONUS Section - VBA Functions/172 The EVALUATE Function - Mac-Daddy of all functions.mp413.47MB

12 BONUS Section - VBA Functions/173 Sum Function in Excel VBA - EASY.mp47.74MB

12 BONUS Section - VBA Functions/174 Count Function in VBA.mp44.75MB