Microsoft Excel Essentials Level VBA Programming Macros | 9B48B0E68AE06A19F9BDBEBEBF4F473037F2E438

Microsoft Excel Essentials Level VBA Programming Macros

Name	Microsoft Excel Essentials Level 3 - VBA Programming+Macros	DOWNLOAD Copy Link
Total Size	3.1 GB
Total Files	249
Hash	9B48B0E68AE06A19F9BDBEBEBF4F473037F2E438

/attached files/
074 A-really-useful-article-from-Microsoft-on-the-different-Types-you-can-use-with-this-Method.txt	0.1 KB
075 Message-Boxes.xlsx	9.8 KB
072 Input-Boxes.xlsm	17.0 KB
046 Variables.xlsx	17.4 KB
058 Logical-Testing.xlsx	17.6 KB
077 Arrays.xlsx	82.1 KB
046 Variables.pdf	257.0 KB
067 Doing-The-Math.xlsx	905.6 KB
/attached files/
012 Microsoft-Complete-List-Of-Excel-Keyboard-Shortcuts.txt	0.1 KB
004 Excel-3-Sales-Data.xlsx	24.3 KB
012 Excel-Keyboard-Shortcuts.pdf	205.9 KB
/attached files/
015 ModText.txt	0.3 KB
015 ModLooping.txt	0.8 KB
015 ModCopyAndPaste.txt	2.0 KB
015 ModLogicalTesting.txt	9.6 KB
044 Open-Write-Close.xlsx	10.5 KB
036 The-Rainbow.xlsx	10.9 KB
015 Mod01-TheBasics.txt	13.2 KB
015 My-Macro-Book.xlsx	15.4 KB
015 Level-3-HR-File.xls	257.0 KB
/attached files/
176 SQA-14-Magic-Sheet-Sizer.xlsx	9.2 KB
173 Katrina.xlsx	10.0 KB
170 SQA-Pascal-Data-Set.xlsx	10.5 KB
179 VLookUps-In-Code.xlsx	10.7 KB
177 Sean-Destination-File.xlsx	11.1 KB
170 SQA-Pascal-Run-Me-From-Here.xlsx	12.4 KB
174 Sequential-PDF-Creation-With-Pictures.xlsx	12.8 KB
175 Latest-Month.xlsx	13.0 KB
175 All-Months.xlsx	13.0 KB
177 Sean-Source-File.xlsx	13.5 KB
165 Project-Tracker.xlsx	13.8 KB
169 SQA-Neil.xlsx	15.9 KB
166 Territory-Managers.xlsx	16.0 KB
172 Protecting-Specific-Cells-and-Data-Validation.xlsx	16.1 KB
168 Animated-Charts.xlsx	19.6 KB
175 Lisas-Report-Builder.xlsx	20.1 KB
174 CW1.jpg	23.1 KB
167 Territory-Managers-Part-2.xlsx	23.8 KB
174 DJ1.jpg	26.6 KB
174 EF1.jpg	32.8 KB
174 AS1.jpg	33.2 KB
174 CS1.jpg	34.0 KB
178 Gantt-Charts-With-A-Little-More-Sophisticaton.xlsx	76.6 KB
163 Question-1.xlsx	580.1 KB
171 SQA-Neil-MPAN-Data-Set.xlsx	837.7 KB
/attached files/
158 E612-Eastern-Region.xlsx	9.3 KB
158 E611-Eastern-Region.xlsx	9.3 KB
158 E612-Southern-Region.xlsx	10.3 KB
158 E611-Southern-Region.xlsx	10.3 KB
158 E611-Western-Region.xlsx	10.4 KB
158 E612-Northern-Region.xlsx	11.3 KB
158 E611-Northern-Region.xlsx	11.3 KB
158 E612-Western-Region.xlsx	11.6 KB
158 Mass-Data-Getterer.xlsx	19.4 KB
/attached files/
128 User-Defined-Functions.xlsx	11.0 KB
/attached files/
133 Folder-Creation-Gizmo.xlsx	13.8 KB
/attached files/
084 Monthly-Reporting.xlsx	16.4 KB
084 E601-East.xlsx	24.2 KB
084 E601-West.xlsx	26.6 KB
084 E601-North.xlsx	27.4 KB
084 E601-South.xlsx	30.7 KB
084 E601-North-Excel-E6.xlsm	46.9 KB
/attached files/
137 eMail-Automation.xlsx	21.6 KB
/attached files/
115 Workbook-Events.xlsx	26.5 KB
/attached files/
106 SuperWebQuery.xlsx	33.0 KB
/attached files/
141 9000-Word-Automation.xlsx	38.9 KB
/attached files/
148 Northern-Sales-Report-PowerPoint.xlsx	77.9 KB
/attached files/
003 The-Golden-Rules-Of-Coding.pdf	124.9 KB
/attached files/
180 Level-3-Get-Your-Next-Course.pdf	307.1 KB
/09 Bonus Section Controlling Windows - Folder Creation Gizmo/
134 Creating A New Folder With A Single Line Of Code.mp4	2.1 MB
133 Intro To Folder Creation Gizmo.mp4	6.3 MB
135 A Single Level Folder Structure.mp4	15.2 MB
136 Folders Within Folders.mp4	15.5 MB
/11 Bonus Section Word Automation - Controlling Word From Excel/
141 Intro To The Word Section.mp4	2.7 MB
142 Understanding The Word Routine.mp4	5.3 MB
145 Efficient Sorting.mp4	12.8 MB
143 Deconstructing How We Capture All The Data.mp4	13.4 MB
144 Formula Modifications With Unique Values.mp4	17.8 MB
146 Building The Text And Wrap Up.mp4	18.2 MB
/04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/
053 An Introduction To Looping.mp4	2.9 MB
045 Introduction To The Programmers Toolbox.mp4	4.6 MB
058 An Introduction To Logical Testing.mp4	5.0 MB
051 A Neat Trick To Force Variable Declaration.mp4	6.1 MB
056 Looping With A Stepped For...Next.mp4	7.1 MB
055 Looping With For...Next.mp4	8.0 MB
064 Logical Testing - Testing If One Is True And One Is False.mp4	8.8 MB
077 Arrays - An Introduction.mp4	9.1 MB
049 Variables - Project Level Variables.mp4	9.1 MB
070 Maths - Using Excels Built-in Functions.mp4	10.4 MB
050 Bonus - Calling A Sub Stored In A DIFFERENT Workbook.mp4	10.6 MB
071 Maths - Built-in Functions With Defined Ranges.mp4	11.0 MB
067 Maths - Doing Simple Maths In Code.mp4	11.6 MB
047 Variables - Local Variables With A Twist.mp4	12.4 MB
048 Variables - Module Level Variables.mp4	12.7 MB
075 Message Boxes - Simple Message Boxes.mp4	13.0 MB
061 Logical Testing - If Then Else.mp4	13.7 MB
054 Looping With Do...Loop.mp4	14.0 MB
076 Message Boxes - Testing Which Button Was Pressed.mp4	15.1 MB
065 Logical Testing - Testing If Either Value Is True.mp4	15.1 MB
063 Logical Testing - Testing Multiple Criteria.mp4	15.3 MB
060 Logical Testing - A Simple If Test Using Cells.mp4	16.3 MB
072 InputBox - Getting User Input Using The InputBox Function.mp4	16.8 MB
080 Arrays - A Simple Two Dimensional Static Array.mp4	17.5 MB
046 Variables - Local Variables.mp4	18.8 MB
079 Arrays - A Simple One Dimensional Dynamic Array.mp4	19.0 MB
062 Logical Testing - If Then Else Using Cells.mp4	19.3 MB
052 Variables - All The Techie Bits.mp4	19.3 MB
073 Manipulating The User Input With Casing.mp4	19.6 MB
074 InputBox - Getting User Input Using The InputBox Method.mp4	20.9 MB
068 Maths - Writing Formulas To Single Cells.mp4	20.9 MB
069 Maths - Writing Formulas To Ranges Of Cells.mp4	21.0 MB
066 Logical Testing - Select Case.mp4	21.6 MB
081 Arrays - The Most Efficient Way To Capture An Array.mp4	21.7 MB
078 Arrays - A Simple One Dimensional Static Array.mp4	22.4 MB
059 Logical Testing - A Simple If Test.mp4	24.0 MB
057 Looping With While...Wend.mp4	27.1 MB
082 Arrays - Extracting Useful Data Based On User Input.mp4	27.3 MB
083 Arrays - Using An Array As A Data Source For A VLookup.mp4	45.7 MB
/07 Workbook Events You Dont Have To Run Code To Have Code Run/
118 WorkBook SheetChange.mp4	3.2 MB
115 Intro To The Events Section.mp4	4.8 MB
123 WorkSheet Activate - You Cant Pick This.mp4	5.8 MB
125 WorkSheet Change.mp4	6.8 MB
124 WorkSheet Activate - You Might Pick This.mp4	7.6 MB
122 WorkBook BeforeClose.mp4	8.3 MB
117 WorkBook BeforePrint.mp4	8.7 MB
127 WorkSheet Activate - Top Secret Classified Information.mp4	11.9 MB
116 WorkBook SheetActivate.mp4	12.7 MB
120 WorkBook Open - Creating A Splash Screen.mp4	12.8 MB
126 WorkSheet Change - A More Useful Use.mp4	15.7 MB
119 WorkBook Open - Creating An Auto-Back Up.mp4	18.2 MB
121 WorkBook Open - Calling Other Code.mp4	19.4 MB
/12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/
147 Intro To PowerPoint Section.mp4	3.3 MB
156 Final Slide And Wrap Up.mp4	7.8 MB
152 Prettying Up The Formatting (More Lego Coding).mp4	7.8 MB
149 Setting Up The Shell Of The Code.mp4	8.9 MB
150 Whos Presenting This....mp4	10.0 MB
153 Using Slide 1 To Create Slide 2.mp4	17.2 MB
148 A Run Through The PowerPoint Base Code.mp4	26.8 MB
151 Adding A Slide With A Logo And Text.mp4	31.7 MB
154 Adding A Chart As A Picture.mp4	32.8 MB
155 Adding Pivot Tables (And Another Chart).mp4	36.1 MB
/03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/
038 The Row and Column Properties.mp4	3.6 MB
027 ACTIVATE vs. SELECT.mp4	4.5 MB
039 Capturing The Column Letter.mp4	4.6 MB
017 Protecting Your Code.mp4	5.0 MB
022 The ActiveCell Property.mp4	5.1 MB
036 CODING EXERCISE The Rainbow.mp4	6.1 MB
035 Commonly Used Properties.mp4	6.4 MB
021 The Cells Object.mp4	6.5 MB
028 Between The Sheets.mp4	6.6 MB
041 Even More Useful Properties.mp4	7.1 MB
020 The Range Object.mp4	7.4 MB
026 The CurrentRegion Property.mp4	8.4 MB
019 Understanding The Hierarchy.mp4	8.9 MB
031 Getting Around The Workbooks.mp4	9.2 MB
037 The Address Property.mp4	9.3 MB
023 The Offset Property.mp4	9.3 MB
040 More Useful Properties.mp4	9.3 MB
044 CODING EXERCISE OpenWriteClose.mp4	9.4 MB
030 Sheets Vs. Worksheets.mp4	9.7 MB
033 The Value Property - Reading And Writing Data.mp4	9.8 MB
043 Closing Workbooks Programmatically.mp4	10.0 MB
014 Introduction To The Coding Section.mp4	10.5 MB
034 Copy and Paste.mp4	11.1 MB
016 Changing Your VBE Settings.mp4	11.8 MB
029 Calling A Sheet By Its VB Name.mp4	12.0 MB
024 The End Property.mp4	13.6 MB
025 Dynamic Range Selection.mp4	15.2 MB
042 Opening Another Workbook Programmatically.mp4	17.3 MB
018 Objects Methods And Properties.mp4	17.6 MB
032 The Value Property - Writing Data.mp4	19.0 MB
015 Getting All The Code For This Section.mp4	21.1 MB
/08 User Defined Functions...What To Do If The Function You Need Isnt In Excel/
129 Using A UDF To Return Information.mp4	3.8 MB
132 Calling A UDF From A Different Workbook.mp4	4.0 MB
131 A Custom UDF For Calculating Volume Discount.mp4	8.5 MB
128 User Defined Functions...What They Are And How You Make Them.mp4	12.6 MB
130 Creating A Countdown Timer With A UDF.mp4	17.1 MB
/02 Introducing Your Personal Built In Translator...the Macro Recorder/
012 Keyboard Shortcuts And Why I Dont Use Them.mp4	4.4 MB
011 A Little Privacy Please.mp4	15.4 MB
006 Moving Code Around.mp4	16.4 MB
005 Saving Macro-Enabled Workbooks And Security Settings.mp4	19.0 MB
010 Combining Your Code.mp4	25.4 MB
007 Stepping Out. Well In Actually - Debugging Made Easy ).mp4	27.1 MB
009 Streamlining You Code Or Get Rid Of What You Dont Need.mp4	31.4 MB
013 Why You Cant Get By With Just Recording Macros.mp4	37.6 MB
004 Introducing The Visual Basic Editor Recording Our First Macro.mp4	42.3 MB
008 With And End With.mp4	43.1 MB
/05 Automating All Your Reports/
088 Deconstructing The Profit By Day Code.mp4	4.8 MB
085 A Special Note For Office E0 Users.mp4	5.1 MB
092 POWER USER - Sizing Your Charts Precisely.mp4	9.5 MB
093 Changing The Chart Title (And Why We Do It Separately).mp4	9.6 MB
084 Introduction To Report Automation Section.mp4	9.9 MB
104 Prettying Up Our Pie Chart.mp4	11.7 MB
101 INSTR And Paying Attention To Detail.mp4	12.4 MB
090 Creating The Run Order and Data Capture Subs.mp4	14.4 MB
091 Solving That Naming Problem.mp4	14.7 MB
100 POWER USER - INSTR...A Very Useful Function.mp4	15.0 MB
086 Recording The Bones Of The Code.mp4	15.8 MB
095 Titles Money And Sorting.mp4	16.6 MB
102 Tidy Up The Title.mp4	17.6 MB
096 Butchering One Table To Create Another.mp4	20.5 MB
098 Adding The Comentary Using Data From The Sheet Were On.mp4	21.7 MB
105 Putting It All Together.mp4	21.8 MB
089 Building Source Data Strings Dynamically At Runtime.mp4	22.4 MB
087 Streamlining The Add New Sheet Code.mp4	23.0 MB
099 POWER USER - How DO You Make Specific Words Bold.mp4	23.1 MB
094 Deconstructing The Pivot Tables (Its Slightly Different).mp4	23.8 MB
103 Easy As Pie (Chart).mp4	25.6 MB
097 Adding The Commentary - Building Strings Dynamically At Runtime.mp4	29.4 MB
/14 Thank You And Congratulations On Finishing The Course/
162 Congratulations You Finished The Course.mp4	5.5 MB
/16 Thank You - Your Special Bonus/
180 Get Your Next Course Now.mp4	8.1 MB
/13 Importing Specific Data From Multiple Files/
160 A More Useful Loop Through Files.mp4	8.3 MB
157 Intro To Importing Data From A Folder Full Of Files.mp4	10.5 MB
159 The Folder Picker.mp4	11.4 MB
158 Looping Through All Excel Files In A Folder.mp4	15.1 MB
161 The Data Grabber(er).mp4	48.2 MB
/06 The Data Is Out There...On The Internet That Is/
110 A Simple Find And Replace.mp4	9.1 MB
106 Introduction To Web Query Section.mp4	10.3 MB
114 Putting It All Together.mp4	11.5 MB
113 POWER USER - Displaying Messages In The Status Bar (Cool).mp4	11.5 MB
109 Data Clean Up.mp4	14.7 MB
107 Pulling Data From The Internet - Capturing The Data For Rome.mp4	18.0 MB
111 Getting Our Formulas Right.mp4	21.2 MB
112 Streamlining The Formulas Code.mp4	22.9 MB
108 Getting To Cancun And London From Rome.mp4	23.7 MB
/10 Bonus Section eMail Automation...Why WRITE emails/
137 Intro To The Emailing Section.mp4	9.4 MB
140 The eMail Loop.mp4	16.4 MB
138 Understanding The eMail Routine.mp4	18.0 MB
139 Deconstructing How We Capture All The Data.mp4	33.7 MB
/01 Whats It All About Alan/
001 Before We Start...Viewing The Lectures And Following Along On A Single Screen.mp4	10.0 MB
003 The 15 Golden Rules Of Coding.mp4	13.0 MB
002 Why Should I Learn How To Code.mp4	49.4 MB
/15 Student Questions Answered/
164 Emailing Routine Adding a Specific Attachment Based On a Criteria.mp4	13.1 MB
170 Finding A Search String in Another Workbook With Multiple Sheets.mp4	15.3 MB
173 Dynamically Populating A Reusable Array While Looping Through A Table.mp4	16.0 MB
163 Get Rid Of Rows In An Array.mp4	17.5 MB
165 Adding A Date Stamp And Going To The Insertion Point AUTOMATICALLY.mp4	18.3 MB
168 Animated Charts...With A Little Something Extra.mp4	25.5 MB
176 Help My File Has Got HUGE.mp4	27.6 MB
177 Finding Updated Values In One Workbook And Adding Them To Another Workbook.mp4	30.8 MB
166 Saving An Individual Sheet To A Specific Folder.mp4	31.2 MB
172 Protecting Specific Cells and Data Validation.mp4	34.1 MB
178 Gantt Charts...With A Little More Sophistication.mp4	34.8 MB
169 Extracting Specific Data From A Big File To A Bunch Of Little Ones.mp4	40.0 MB
171 Extracting Unique Tables to Unique Sheets From A Big Data Set.mp4	47.1 MB
174 Sequential PDF Creation With Pictures.mp4	51.4 MB
175 File Picker And Report Generator With Intelligent Filing.mp4	61.3 MB
167 Saving Multiple Sheets To A Single Workbook In A Specific Folder.mp4	84.9 MB
179 VLookups (Or Any Application.WorksheetFunction) Over Ranges.mp4	142.7 MB
Total files 249