FreeTutorials Us ultimate excel programmer | ACEAD443380665C90E2D1D60AC645E27972AEBF9

FreeTutorials Us ultimate excel programmer

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

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