FreeTutorials Us ultimate excel programmer | 426B789673CE9695B5353EE754FC88F4335D42B3

FreeTutorials Us ultimate excel programmer

Name	[FreeTutorials.Us] ultimate-excel-programmer	DOWNLOAD Copy Link
Total Size	1.4 GB
Total Files	199
Hash	426B789673CE9695B5353EE754FC88F4335D42B3

/01 The Range Object/
001 Intro and Course Workbooks download.mp4	37.7 MB
002 Get the Developer Tab and Intro to Developer Tab.mp4	3.8 MB
003 Getting started with Range object.mp4	2.1 MB
004 Creating Your First Macro From Scratch.mp4	4.5 MB
005 Adding a Secondary Command. . ..mp4	1.6 MB
006 Debugging in Excel VBA.mp4	2.6 MB
007 Saving a Macro-Enabled Workbook .xlsm.mp4	2.5 MB
008 Several Ways to trigger your Macro.mp4	2.2 MB
009 Affecting Multiple Cells with One Range Command - 2 Methods.mp4	3.2 MB
010 Adding Strings of Text to a Cell.mp4	2.7 MB
011 Using a Named Range with the Range Object.mp4	2.3 MB
/.../001 Intro and Course Workbooks download/
Excel-VBA-PC-vs-Mac-Help.pdf	421.4 KB
User-Defined-Functions.zip	11.7 KB
Workbooks-Download.zip	903.1 KB
/quizzes/
001 Range Object Quiz.html	5.6 KB
/02 Range Properties/
012 .VALUE Property.mp4	3.1 MB
013 .TEXT Property.mp4	1.7 MB
014 .ROW and .COLUMN Properties.mp4	2.2 MB
015 .SELECT Property.mp4	1.6 MB
016 .COUNT Property.mp4	4.0 MB
017 .ADDRESS Property.mp4	3.6 MB
018 .FORMULA Property.mp4	7.7 MB
019 .NUMBERFORMAT Property.mp4	3.8 MB
020 FONT.BOLD UNDERLINE or ITALIC Properties.mp4	5.0 MB
/quizzes/
002 Properties Quiz.html	5.4 KB
/03 The Cells Object/
021 The Cells Object.mp4	6.3 MB
022 Using Column Letters instead of Numbers.mp4	2.3 MB
023 Using Cells Positionally within a Range.mp4	4.0 MB
024 Affecting ALL Cells in a Worksheet.mp4	5.8 MB
025 Using Range Object with Cells Object.mp4	5.8 MB
/quizzes/
003 Cells Quiz.html	4.5 KB
/04 Variables/
026 Intro to Variables.mp4	2.4 MB
027 Declaring Variables - Variable Types.mp4	5.2 MB
028 Declaring Variables - Types Demo.mp4	5.7 MB
029 Calling a Procedure from Another.mp4	2.4 MB
030 Public and Private Variables.mp4	5.2 MB
031 Using Constants.mp4	3.5 MB
032 BONUS Passing Variables to Another Procedure - ByVal and ByRef.mp4	15.3 MB
/.../026 Intro to Variables/
How-To-Use-Variables-In-Excel-Sub-Procedures-In-Visual-Basic-For-Applications.pdf	169.0 KB
/.../032 BONUS Passing Variables to Another Procedure - ByVal and ByRef/
Passing-Variables-ByRef-and-ByVal.xlsm	13.6 KB
/04 Variables/quizzes/
004 Variables Quiz.html	5.7 KB
/05 Toolbars and Menus/
033 File Menu walkthrough.mp4	5.1 MB
034 Edit Menu walkthrough.mp4	10.5 MB
035 View Menu walkthrough.mp4	6.0 MB
036 View Menu2 - Watch Window Locals Window and Immediate Window.mp4	13.7 MB
037 Watch Window Wonders.mp4	10.4 MB
038 Insert and Format Menus.mp4	1.8 MB
039 Debug Menu Important.mp4	9.8 MB
040 Run and Tools Menus.mp4	7.9 MB
/quizzes/
005 Toolbars Quiz.html	4.2 KB
/06 Super Important Tools and Excel Logic/
041 Determining the Last Row in your Data Set.mp4	8.3 MB
042 Determining the Last Column in your Data Set.mp4	5.1 MB
043 Determining the Next Row in your Data Set.mp4	3.3 MB
044 Recording a Macro.mp4	7.6 MB
045 BONUS - Dynamic Sorting.mp4	17.4 MB
046 Absolute vs Relative References.mp4	8.3 MB
047 Using With and End With.mp4	6.7 MB
048 Comparison Operators in Excel VBA.mp4	2.0 MB
049 If Then Statement.mp4	4.2 MB
050 Using Is Not Equal To.mp4	1.6 MB
051 Logical Operator NOT.mp4	1.9 MB
052 If Then Else Statement.mp4	2.9 MB
053 If Then ElseIF Statement. . ..mp4	4.1 MB
054 Comparitive Operators with Text and Numbers.mp4	4.1 MB
055 Use If Then Statements in a One-Liner of code.mp4	3.0 MB
056 Using GOTO and Labels.mp4	3.1 MB
057 Select Case as Alternative to IF THEN Statements.mp4	4.4 MB
058 Message Box with Yes and No Buttons.mp4	10.4 MB
059 Relative Positioning using Offset.mp4	5.8 MB
060 BONUS - User Defined Functions 101.mp4	14.2 MB
061 BONUS - UDF Lesson 2.mp4	13.4 MB
/.../045 BONUS - Dynamic Sorting/
06-BONUS-Dynamic-Sorting.zip	32.2 KB
/.../048 Comparison Operators in Excel VBA/
Comparison-Operators-In-Excel-VBA.pdf	174.5 KB
/.../060 BONUS - User Defined Functions 101/
User-Defined-Functions.zip	11.7 KB
/quizzes/
006 Super Important Info Quiz.html	6.9 KB
/07 Loops and Report Writing Basics/
062 Intro to Loops the For Next Loop.mp4	4.2 MB
063 Fun with our For Next Loop.mp4	7.2 MB
064 Beginning our first Report using Loops.mp4	11.4 MB
065 Using an InputBox.mp4	5.3 MB
066 Adding InputBox to Our First Report to make it Dynamic.mp4	5.4 MB
067 Add a Button to Open Our Report.mp4	8.1 MB
068 Add a Cool Looking Button or Image to Open Report.mp4	6.4 MB
069 Our First Printable Report part 1 - Declaring and Setting the Sheets.mp4	9.3 MB
070 Printable Report Part 2 - Getting Items On Report Sheet.mp4	12.1 MB
071 Printable Report Part 3 - Clearing Last Report.mp4	13.0 MB
072 Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet.mp4	10.9 MB
073 Using PrintPreview Automatically.mp4	3.3 MB
074 Using PrintOut to Send Directly to Default Printer.mp4	5.6 MB
075 Handling Debug Error When Cancelling InputBox.mp4	7.4 MB
076 For Loop Going Backwards using STEP.mp4	8.2 MB
077 The FOR EACH Loop.mp4	10.0 MB
078 FOR EACH Loop - Practical Examples.mp4	6.7 MB
079 Intro to DO LOOPS.mp4	7.9 MB
080 DO Until.mp4	3.1 MB
081 Loop Until.mp4	2.4 MB
082 DO While.mp4	2.8 MB
083 Loop While.mp4	1.7 MB
084 EXIT DO - Multiple Exits using your own Criteria along the Way.mp4	2.5 MB
/quizzes/
007 Loops and Reports Quiz.html	5.7 KB
/08 EVENTS Worksheet Events made Easy/
085 Intro to Worksheet Events and Selection_Change.mp4	6.7 MB
086 Worksheet Activate Event.mp4	2.6 MB
087 Worksheet Deactivate Event.mp4	4.6 MB
088 BeforeDelete Event - for Worksheet Deletion.mp4	2.5 MB
089 BeforeDoubleClick Event - Trigger a Macro when Double Clicking.mp4	5.1 MB
090 BeforeRightClick Event - Trigger a Macro when Right-Clicking.mp4	2.8 MB
091 Calculate Event.mp4	6.2 MB
092 How to Disable Events on the Workbook.mp4	2.9 MB
093 Intro to Change Event.mp4	2.2 MB
094 Change Event with EnableEvents toggle - Avoid endless loop.mp4	8.1 MB
095 Change Event Triggered with Custom Range Using Intersect.mp4	5.8 MB
096 FollowHyperlinks Event.mp4	6.5 MB
097 Final Thoughts on Worksheet Events and Review Other Events.mp4	4.7 MB
098 Events Exercise 1.mp4	16.4 MB
/.../098 Events Exercise 1/
Events-Exercise1-Finished-Version-w-Source-Code.xlsm	24.3 KB
Events-Exercise1-Practice-Version.xlsm	19.4 KB
/quizzes/
008 Worksheet Events Quiz.html	4.8 KB
/09 WorkBook Events/
099 Workbook Open.mp4	9.3 MB
100 Workbook Activate.mp4	4.9 MB
101 Before Save.mp4	5.4 MB
102 After Save.mp4	7.8 MB
103 Before Close.mp4	10.3 MB
104 Before Print.mp4	3.7 MB
105 Deactivate.mp4	3.5 MB
106 NewChart.mp4	9.7 MB
107 NewSheet.mp4	4.5 MB
108 Sheet Activate.mp4	7.2 MB
109 Delete DoubleClick RightClick Calculate Change.mp4	13.0 MB
110 SheetDeactivate.mp4	7.4 MB
111 Follow Hyperlink.mp4	3.7 MB
112 SheetSelectionChange.mp4	4.6 MB
113 WindowActivate.mp4	3.5 MB
114 WindowDeactivate.mp4	2.5 MB
115 WindowResize.mp4	7.6 MB
/10 Activex Controls on Worksheets/
116 Activex Controls vs Forms Controls.mp4	6.1 MB
117 Button Click - Wage Calculator.mp4	6.9 MB
118 Keydown Event.mp4	6.4 MB
119 BONUS Capturing Shift Alt Ctrl or some combination using the Shift variable.mp4	7.1 MB
120 KeyPress Event.mp4	7.0 MB
121 MouseMove Event.mp4	3.6 MB
122 MouseMove Event with Application.Statusbar - fun and useful.mp4	6.7 MB
123 MouseUp and MouseDown Events - Left Middle Rightclick Shift Alt Ctrl.mp4	12.0 MB
124 GotFocus and LostFocus Events.mp4	2.4 MB
125 Use a Checkbox for its VALUE.mp4	4.8 MB
126 Checkbox Event Without a Button.mp4	3.0 MB
127 LinkedCell Property with a Checkbox.mp4	2.4 MB
128 Option Buttons Intro - What is an Option Button and Grouping.mp4	4.7 MB
129 Grouping Alignment and Aesthetics for Controls.mp4	4.7 MB
130 Homemade Quiz using Option Buttons and a Command Button.mp4	7.4 MB
131 Compliance Checker for your Forms or Quizzes Part 1.mp4	6.9 MB
132 Compliance check part 2.mp4	21.0 MB
133 SpinButton with Cell A1.mp4	7.0 MB
134 SpinButtons with Textboxes and Numbers.mp4	10.4 MB
135 SpinButton BONUS - Move Textbox Position with SpinButton.mp4	9.2 MB
136 SpinButton with Dates in a Textbox.mp4	7.2 MB
137 Activex Label Control - Basics.mp4	7.1 MB
138 ComboBox - Fill with ListFillRange.mp4	8.1 MB
139 Creating a Dynamic Range.mp4	9.1 MB
140 ComboBox - How to use Multiple Columns.mp4	6.6 MB
141 Using .ADDITEM to Get Specific items in your Combobox List.mp4	18.6 MB
142 Noteworthy Properties of a Combobox.mp4	12.6 MB
143 Multiple Columns in Combobox with .ADDITEM and List ListCount etc.mp4	17.0 MB
144 ListBox Basics using Dynamic Range.mp4	16.1 MB
145 Listbox Click event and Dynamic Options.mp4	7.5 MB
146 BONUS - Manipulating and Using Multiselect Items in a Listbox.mp4	11.0 MB
147 ListBox - Referencing Column 0 and 1 in a cell Dynamically.mp4	11.1 MB
148 Dynamic ListBoxes Using .ADDITEM and More.mp4	20.8 MB
149 Make and Utilize INVISIBLE Columns - Special Trick.mp4	6.8 MB
150 Using a Scroll Bar on a worksheet.mp4	4.9 MB
151 Pictures on a Worksheet plus using FollowHyperlink Method.mp4	14.6 MB
152 Toggle Button.mp4	4.8 MB
153 A Brief Note on Alternate 3rd Party Controls.mp4	3.0 MB
/.../118 Keydown Event/
Key-Code-Constants-Used-With-Key-Down-Events.pdf	111.6 KB
/.../120 KeyPress Event/
Ascii-Table.xls	59.9 KB
/.../123 MouseUp and MouseDown Events - Left Middle Rightclick Shift Alt Ctrl/
Mouse-Down-Event-Excel-VBA-Language-Reference-.pdf	152.0 KB
/.../143 Multiple Columns in Combobox with .ADDITEM and List ListCount etc/
List-Box-Combobox-LIST-Principles.pdf	141.2 KB
/.../147 ListBox - Referencing Column 0 and 1 in a cell Dynamically/
Additional-List-Index-And-List-Info.pdf	98.1 KB
/11 Userforms - the best thing. EVER/
154 Userform - Hide Show and Unload.mp4	9.6 MB
155 Sample Database and Creating a Data Entry Form.mp4	36.2 MB
156 Fill Status combobox with Rowsource when Userform starts - 2 methods.mp4	9.8 MB
157 New Employee Data Entry Form.mp4	38.3 MB
158 Format Textbox Numbers as Numerals Clearing out Form upon Submission.mp4	9.1 MB
159 Set the Tab Order for Userform Controls.mp4	5.8 MB
160 Set Default Values to Make Data Entry Easier.mp4	5.7 MB
161 Avoid Duplicate Employee ID and other Fun Automation Tricks.mp4	16.5 MB
162 Edit Mode for Employee Database - Part 1.mp4	39.1 MB
163 Edit Mode for Employee Database - Part 2.mp4	26.3 MB
164 Edit Mode Pt 3 - Adding Automation and Save Button.mp4	46.1 MB
165 Userform Report with Filters - Part 1.mp4	27.7 MB
166 Userform Report with Filters - Part 2.mp4	16.5 MB
167 Applying the Dynamic Filters to Reports.mp4	8.9 MB
168 Clear out Last Report.mp4	7.3 MB
169 Report Generation and Aesthetics Headers Footers Repeat Rows etc..mp4	11.2 MB
170 Concluding Thoughts. . ..mp4	3.5 MB
/12 BONUS Section - VBA Functions/
171 InStr Function - Search for Text Within Other Text.mp4	15.5 MB
172 The EVALUATE Function - Mac-Daddy of all functions.mp4	14.1 MB
173 Sum Function in Excel VBA - EASY.mp4	8.1 MB
174 Count Function in VBA.mp4	5.0 MB
/
Freetutorials.us.url	0.1 KB
[FreeTutorials.us].txt	0.1 KB
Total files 199