[FreeCourseLab.com] Udemy - Excel Essentials The Complete Excel Series - Level 1, 2 & 3

磁力链接/BT种子名称

[FreeCourseLab.com] Udemy - Excel Essentials The Complete Excel Series - Level 1, 2 & 3

磁力链接/BT种子简介

种子哈希：afaa67c9276c8154ea874708fcef20dc45ff9755
文件大小： 5.2G
已经下载：4958次
下载速度：极快
收录时间：2021-03-10
最近下载：2025-02-18

移花宫入口

移花宫.com邀月.com怜星.com花无缺.comyhgbt.icuyhgbt.top

磁力链接下载

magnet:?xt=urn:btih:AFAA67C9276C8154EA874708FCEF20DC45FF9755
推荐使用PIKPAK网盘下载资源，10TB超大空间，不限制资源，无限次数离线下载，视频在线观看

下载BT种子文件

磁力链接 迅雷下载 PIKPAK在线播放 91视频 含羞草 欲漫涩 逼哩逼哩 成人快手 51品茶 抖阴破解版 暗网禁地 91短视频 TikTok成人版 PornHub 草榴社区 乱伦社区 少女初夜 萝莉岛

最近搜索

文件列表

  • 33. Student Questions Answered/17. Vlookups (Or Any Application.WorksheetFunction) Over Ranges.mp4 142.8 MB
  • 33. Student Questions Answered/5. Saving Multiple Sheets To A Single Workbook In A Specific Folder.mp4 84.9 MB
  • 18. Student Questions Answered!/11. Data Validation With Dependent Drop downs (Dynamic Named Range Workaround).mp4 81.4 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/14. WorkSheet Events - BONUS - 4 New Things To Try.mp4 81.1 MB
  • 33. Student Questions Answered/13. File Picker, And Report Generator With Intelligent Filing.mp4 61.3 MB
  • 18. Student Questions Answered!/12. Using 2 Labels As A Lookup From Drop-downs.mp4 58.3 MB
  • 10. Bonus Section Student Questions Answered!/1. Reverse Engineering A Sample Spreadsheet.mp4 56.5 MB
  • 3. Start Here - All The Basics/2. The Anatomy Of A Workbook Where Everything Is, And What It Does!.mp4 52.0 MB
  • 33. Student Questions Answered/12. Sequential PDF Creation With Pictures.mp4 51.4 MB
  • 14. Project 3 - Named Ranges/7. 3035 - POWER USER - Dynamic Charts.mp4 51.0 MB
  • 33. Student Questions Answered/18. Adding A Date Stamp If A Change Has Been Made.mp4 49.7 MB
  • 32. Importing Specific Data From Multiple Files/5. The Data Grabber(er).mp4 48.2 MB
  • 33. Student Questions Answered/9. Extracting Unique Tables to Unique Sheets From A Big Data Set.mp4 47.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/39. Arrays - Using An Array As A Data Source For A VLookup.mp4 45.7 MB
  • 10. Bonus Section Student Questions Answered!/2. Casing And Text Functions.mp4 45.6 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/16. Building Text Strings With A Formula.mp4 45.6 MB
  • 14. Project 3 - Named Ranges/8. 3040 - Horizontal Dynamic Named Ranges For Charts.mp4 44.7 MB
  • 18. Student Questions Answered!/4. What Is The CHOOSE Function Really Used For.mp4 42.5 MB
  • 19. Excel Essentials Level 3 - VBA Programming/1. Why Should I Learn How To Code.mp4 41.6 MB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/9. Adding Pivot Tables (And Another Chart).mp4 40.6 MB
  • 18. Student Questions Answered!/2. Calls Text Data 2 - This Time Using Text!.mp4 40.5 MB
  • 33. Student Questions Answered/7. Extracting Specific Data From A Big File, To A Bunch Of Little Ones.mp4 40.0 MB
  • 18. Student Questions Answered!/10. Data Validation With Dependent Drop-downs.mp4 39.2 MB
  • 18. Student Questions Answered!/6. Dynamic Charting From A Drop Down.mp4 39.2 MB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/5. With And End With.mp4 38.9 MB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/10. Why You Can't Get By With Just Recording Macros.mp4 37.6 MB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/1. Introducing The Visual Basic Editor, & Recording Our First Macro.mp4 37.1 MB
  • 8. Bonus Section - The Keyboard Shortcuts/2. Bonus 2 Keyboard Shortcuts.mp4 37.1 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/9. Creating A Template From An Image.mp4 36.4 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/19. Auto-populating Check Boxes.mp4 35.8 MB
  • 33. Student Questions Answered/16. Gantt Charts...With A Little More Sophistication!.mp4 34.8 MB
  • 33. Student Questions Answered/10. Protecting Specific Cells and Data Validation.mp4 34.1 MB
  • 13. Project 2 - Building A Database With Excel/21. POWER USER - The Holy Grail - How To Return Multiple Values From A Single Look U.mp4 34.0 MB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/8. Adding A Chart As A Picture.mp4 32.8 MB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/5. Adding A Slide With A Logo And Text.mp4 31.7 MB
  • 33. Student Questions Answered/4. Saving An Individual Sheet To A Specific Folder.mp4 31.2 MB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/5. Gantt Charts Using The Built In Charting Tools.mp4 31.0 MB
  • 29. Bonus Section eMail Automation...Why WRITE emails!/3. Deconstructing How We Capture All The Data.mp4 31.0 MB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/3. Multiple Logical Tests At Once Using AND.mp4 30.9 MB
  • 33. Student Questions Answered/15. Finding Updated Values In One Workbook, And Adding Them To Another Workbook.mp4 30.8 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/18. A Tick Box Exercise (Of Sorts).mp4 29.6 MB
  • 13. Project 2 - Building A Database With Excel/16. POWER USER - Dealing With Inconsistencies In User Entry.mp4 29.5 MB
  • 13. Project 2 - Building A Database With Excel/25. Putting It All Together.mp4 29.4 MB
  • 24. Automating All Your Reports!/14. Adding The Commentary - Building Strings Dynamically At Runtime.mp4 29.4 MB
  • 17. Bonus Section - Just For Fun/1. How I Created Randomly Generated License Plate Numbers!.mp4 29.1 MB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/6. Streamlining You Code, Or, Get Rid Of What You Don't Need.mp4 28.3 MB
  • 33. Student Questions Answered/14. Help! My File Has Got HUGE!.mp4 27.6 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/38. Arrays - Extracting Useful Data Based On User Input.mp4 27.3 MB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/4. Stepping Out. Well, In Actually! - Debugging Made Easy ).mp4 27.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/13. Looping With While...Wend.mp4 27.1 MB
  • 13. Project 2 - Building A Database With Excel/18. POWER USER - Vlook-Ups With Multiple Inputs.mp4 27.0 MB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/2. A Run Through The PowerPoint Base Code.mp4 26.8 MB
  • 24. Automating All Your Reports!/20. Easy As Pie (Chart).mp4 25.6 MB
  • 33. Student Questions Answered/6. Animated Charts...With A Little Something Extra!.mp4 25.5 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/7. WorkBook Open - Calling Other Code.mp4 24.2 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/15. Logical Testing - A Simple If Test.mp4 24.0 MB
  • 24. Automating All Your Reports!/11. Deconstructing The Pivot Tables (It's Slightly Different).mp4 23.8 MB
  • 25. The Data Is Out There...On The Internet, That Is/3. Getting To Cancun And London From Rome.mp4 23.7 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/15. Simple Logical Testing And Nested Logical Testing.mp4 23.7 MB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/7. Combining Your Code.mp4 23.4 MB
  • 24. Automating All Your Reports!/16. POWER USER - How DO You Make Specific Words Bold.mp4 23.1 MB
  • 24. Automating All Your Reports!/4. Streamlining The Add New Sheet Code.mp4 23.0 MB
  • 3. Start Here - All The Basics/9. Changing Appearance Of Text With Formatting - Fonts.mp4 22.9 MB
  • 25. The Data Is Out There...On The Internet, That Is/7. Streamlining The Formulas Code.mp4 22.9 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/34. Arrays - A Simple One Dimensional Static Array.mp4 22.4 MB
  • 24. Automating All Your Reports!/6. Building Source Data Strings Dynamically At Runtime.mp4 22.4 MB
  • 24. Automating All Your Reports!/22. Putting It All Together.mp4 21.8 MB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/1. Creating A Gantt Chart Using A Worksheet.mp4 21.8 MB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/5. A UDF For Getting All Your Sheet Names.mp4 21.7 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/37. Arrays - The Most Efficient Way To Capture An Array.mp4 21.7 MB
  • 24. Automating All Your Reports!/15. Adding The Comentary Using Data From The Sheet We're On.mp4 21.7 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/22. Logical Testing - Select Case.mp4 21.6 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/5. WorkBook Open - Creating An Auto-Back Up.mp4 21.4 MB
  • 18. Student Questions Answered!/9. Vlookups With Pictures!.mp4 21.3 MB
  • 25. The Data Is Out There...On The Internet, That Is/6. Getting Our Formulas Right.mp4 21.2 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2. Getting All The Code For This Section.mp4 21.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/25. Maths - Writing Formulas To Ranges Of Cells.mp4 21.0 MB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/6. SQA - Gantt Charts With Different Colours For Different Categories.mp4 21.0 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/24. Maths - Writing Formulas To Single Cells.mp4 20.9 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/30. InputBox - Getting User Input Using The InputBox Method.mp4 20.9 MB
  • 8. Bonus Section - The Keyboard Shortcuts/1. Bonus 1 Whizzing Around Excel.mp4 20.5 MB
  • 24. Automating All Your Reports!/13. Butchering One Table, To Create Another.mp4 20.5 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/6. More (Useful) Calculations With Time.mp4 20.4 MB
  • 13. Project 2 - Building A Database With Excel/4. Let's Build Our Database!.mp4 19.9 MB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/4. Conditional Formatting...Where The Magic Happens.mp4 19.7 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/29. Manipulating The User Input With Casing.mp4 19.6 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/8. Variables - All The Techie Bits.mp4 19.3 MB
  • 14. Project 3 - Named Ranges/5. POWER USER - Dynamic Named Ranges.mp4 19.3 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/12. WorkSheet Change - A More Useful Use.mp4 19.2 MB
  • 15. Project 4 - What Can I Have For Dinner/9. Building Strings For Indirect Sheet And Cell References.mp4 19.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/35. Arrays - A Simple One Dimensional Dynamic Array.mp4 19.0 MB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/2. Saving Macro-Enabled Workbooks, And Security Settings.mp4 19.0 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/19. The Value Property - Writing Data.mp4 19.0 MB
  • 3. Start Here - All The Basics/13. POWER USER - Adding Your Own Lists To Autofill.mp4 18.9 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/2. Variables - Local Variables.mp4 18.8 MB
  • 3. Start Here - All The Basics/1. Opening Excel, and Creating a Shortcut.mp4 18.7 MB
  • 13. Project 2 - Building A Database With Excel/2. Step 1 - Get Some Data In, And Split It.mp4 18.3 MB
  • 33. Student Questions Answered/3. Adding A Date Stamp, And Going To The Insertion Point AUTOMATICALLY.mp4 18.3 MB
  • 25. The Data Is Out There...On The Internet, That Is/2. Pulling Data From The Internet - Capturing The Data For Rome.mp4 18.0 MB
  • 18. Student Questions Answered!/1. Calls Text Data - Or How To Return a Column Title If Value is 1.mp4 18.0 MB
  • 3. Start Here - All The Basics/3. A Quick Review Of What's Where.mp4 17.9 MB
  • 7. A Few More Essentials/11. Filters.mp4 17.8 MB
  • 24. Automating All Your Reports!/19. Tidy Up The Title.mp4 17.6 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/5. Objects, Methods And Properties.mp4 17.6 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/36. Arrays - A Simple Two Dimensional Static Array.mp4 17.5 MB
  • 33. Student Questions Answered/1. Get rid of rows in a array.mp4 17.5 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/14. Calculating Time Out Of House Using Travel Time.mp4 17.5 MB
  • 18. Student Questions Answered!/8. SUMIF With Dynamic Sum Range.mp4 17.4 MB
  • 13. Project 2 - Building A Database With Excel/8. Using OTHER Look-Ups To Look Up!.mp4 17.4 MB
  • 14. Project 3 - Named Ranges/6. POWER USER - What To Do With Dynamic Names Ranges With Titles.mp4 17.4 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/29. Opening Another Workbook Programmatically.mp4 17.3 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/18. Logical Testing - If Then Else Using Cells.mp4 17.3 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/7. It's About Time (And Dates!).mp4 17.2 MB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/7. Using Slide 1 To Create Slide 2.mp4 17.2 MB
  • 28. Bonus Section Controlling Windows - Folder Creation Gizmo/3. A Single Level Folder Structure.mp4 17.2 MB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/3. Creating A Countdown Timer With A UDF.mp4 17.1 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/1. Proof Of Concept.mp4 17.1 MB
  • 5. Rearranging Things/1. Inserting New Columns And Rows.mp4 17.0 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/11. Converting Time To A Decimal.mp4 16.9 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/21. Defining A Working Area, And Protecting Your Work.mp4 16.9 MB
  • 13. Project 2 - Building A Database With Excel/23. The Fastest Way To Modify Your Column Numbers.mp4 16.9 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/28. InputBox - Getting User Input Using The InputBox Function.mp4 16.8 MB
  • 24. Automating All Your Reports!/12. Titles, Money And Sorting.mp4 16.6 MB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/4. Formula Modifications With Unique Values.mp4 16.5 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/13. Simple Conditional Formatting For A Cleaner View.mp4 16.5 MB
  • 29. Bonus Section eMail Automation...Why WRITE emails!/4. The eMail Loop.mp4 16.4 MB
  • 29. Bonus Section eMail Automation...Why WRITE emails!/2. Understanding The eMail Routine.mp4 16.3 MB
  • 6. Formulas Learning The Clever Stuff!/1. ROUNDing Functions.mp4 16.0 MB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/6. Building The Text And Wrap Up.mp4 16.0 MB
  • 33. Student Questions Answered/11. Dynamically Populating A Reusable Array While Looping Through A Table.mp4 16.0 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/2. WorkBook SheetActivate.mp4 15.8 MB
  • 28. Bonus Section Controlling Windows - Folder Creation Gizmo/4. Folders Within Folders.mp4 15.5 MB
  • 13. Project 2 - Building A Database With Excel/19. POWER USER - Looking Up Multiple Inputs Using An Array Formula.mp4 15.4 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/6. WorkBook Open - Creating A Splash Screen.mp4 15.4 MB
  • 33. Student Questions Answered/8. Finding A Search String in Another Workbook With Multiple Sheets.mp4 15.4 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/19. Logical Testing - Testing Multiple Criteria.mp4 15.3 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/12. Dynamic Range Selection.mp4 15.2 MB
  • 32. Importing Specific Data From Multiple Files/2. Looping Through All Excel Files In A Folder.mp4 15.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/21. Logical Testing - Testing If Either Value Is True.mp4 15.1 MB
  • 18. Student Questions Answered!/5. Casing And Text Functions.mp4 15.1 MB
  • 24. Automating All Your Reports!/17. POWER USER - INSTR...A Very Useful Function.mp4 15.0 MB
  • 13. Project 2 - Building A Database With Excel/14. The Other Way Of Looking Up Backwards.mp4 14.9 MB
  • 24. Automating All Your Reports!/8. Solving That Naming Problem.mp4 14.7 MB
  • 13. Project 2 - Building A Database With Excel/11. Some Common Reasons VLook-Ups Fail.mp4 14.7 MB
  • 25. The Data Is Out There...On The Internet, That Is/4. Data Clean Up.mp4 14.7 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/16. Logical Testing - A Simple If Test Using Cells.mp4 14.7 MB
  • 7. A Few More Essentials/1. Sorting.mp4 14.6 MB
  • 7. A Few More Essentials/9. Freezing For An Easier View.mp4 14.4 MB
  • 24. Automating All Your Reports!/7. Creating The Run Order and Data Capture Subs.mp4 14.4 MB
  • 18. Student Questions Answered!/7. Extracting a Unique List, And Summing The Money!.mp4 14.1 MB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/3. Moving Code Around.mp4 14.0 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/10. Looping With Do...Loop.mp4 14.0 MB
  • 13. Project 2 - Building A Database With Excel/13. POWER USER - A Breakdown Of Looking Up Backwards.mp4 13.9 MB
  • 4. Doing The (Simple) Math/2. Sums - Using Autosum.mp4 13.8 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/10. Importing A Template From An Existing Excel File.mp4 13.8 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/4. (Custom) Formatting Dates And Time.mp4 13.7 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/17. Logical Testing - If Then Else.mp4 13.7 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/11. The End Property.mp4 13.6 MB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/2. Building The First Part Of Our Logical Test.mp4 13.6 MB
  • 7. A Few More Essentials/8. Simple Printing.mp4 13.5 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/32. Message Boxes - Testing Which Button Was Pressed.mp4 13.4 MB
  • 15. Project 4 - What Can I Have For Dinner/3. Creating Our First Macro.mp4 13.3 MB
  • 24. Automating All Your Reports!/3. Recording The Bones Of The Code.mp4 13.2 MB
  • 13. Project 2 - Building A Database With Excel/26. The Finishing Touch - How Many Records Did I Find.mp4 13.2 MB
  • 4. Doing The (Simple) Math/10. The Order Of Mathematical Operation.mp4 13.2 MB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/8. A Little Privacy Please.vtt 13.2 MB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/8. A Little Privacy Please.mp4 13.1 MB
  • 33. Student Questions Answered/2. Emailing Routine Adding a Specific Attachment Based On a Criteria.mp4 13.1 MB
  • 13. Project 2 - Building A Database With Excel/20. VLOOKUPs Brother...HLOOKUP.mp4 12.9 MB
  • 1. Excel Essentials Level 1 Basics - Master Excel Step-By-Step/1. Intro To Level 1.mp4 12.9 MB
  • 7. A Few More Essentials/4. Creating A Simple Chart.mp4 12.9 MB
  • 15. Project 4 - What Can I Have For Dinner/12. POWER USER - The HYPERLINK Function (And Problem).mp4 12.7 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/4. Variables - Module Level Variables.mp4 12.7 MB
  • 5. Rearranging Things/3. Cutting, Copying, Inserting And Deleting.mp4 12.7 MB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/1. User Defined Functions...What They Are, And How You Make Them.mp4 12.6 MB
  • 24. Automating All Your Reports!/18. INSTR And Paying Attention To Detail.mp4 12.4 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/3. Variables - Local Variables With A Twist.mp4 12.4 MB
  • 13. Project 2 - Building A Database With Excel/3. Using Data Validation To Get The Right Input.mp4 12.1 MB
  • 13. Project 2 - Building A Database With Excel/15. Backwards Look-Ups In Action.mp4 12.0 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/16. Calling A Sheet By Its VB Name.mp4 12.0 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/16. Calling A Sheet By Its VB Name.vtt 12.0 MB
  • 20. What's It All About, Alan/1. The 15 Golden Rules Of Coding.mp4 11.9 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/13. WorkSheet Activate - Top Secret Classified Information!.mp4 11.9 MB
  • 6. Formulas Learning The Clever Stuff!/4. Buliding a Compex Formula.mp4 11.8 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/3. Changing Your VBE Settings.mp4 11.8 MB
  • 24. Automating All Your Reports!/21. Prettying Up Our Pie Chart.mp4 11.7 MB
  • 7. A Few More Essentials/2. Wrapping Text And Soft Enter.mp4 11.7 MB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/3. Deconstructing How We Capture All The Data.mp4 11.7 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/23. Maths - Doing Simple Maths In Code.mp4 11.6 MB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/5. Efficient Sorting.mp4 11.6 MB
  • 3. Start Here - All The Basics/12. Saving Time With AutoFilling Sequences.mp4 11.5 MB
  • 13. Project 2 - Building A Database With Excel/6. Importing Data From A Word File.mp4 11.5 MB
  • 25. The Data Is Out There...On The Internet, That Is/8. POWER USER - Displaying Messages In The Status Bar (Cool).mp4 11.5 MB
  • 25. The Data Is Out There...On The Internet, That Is/9. Putting It All Together.mp4 11.5 MB
  • 32. Importing Specific Data From Multiple Files/3. The Folder Picker.mp4 11.4 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/21. Copy And Paste.mp4 11.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/31. Message Boxes - Simple Message Boxes.mp4 11.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/27. Maths - Built-in Functions With Defined Ranges.mp4 11.0 MB
  • 13. Project 2 - Building A Database With Excel/17. POWER USER - Fuzzy Vlook-Ups.mp4 10.9 MB
  • 4. Doing The (Simple) Math/11. POWER USER - Evaluate Formula.mp4 10.9 MB
  • 14. Project 3 - Named Ranges/4. POWER USER - A Magic Trick Using Row And Column Labels.mp4 10.8 MB
  • 13. Project 2 - Building A Database With Excel/22. What To Look For When THAT Formula Didn't Work.mp4 10.7 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/6. Bonus - Calling A Sub Stored In A DIFFERENT Workbook!.mp4 10.6 MB
  • 15. Project 4 - What Can I Have For Dinner/6. Using A Conditional Format To Know When A Value Is Missing.mp4 10.6 MB
  • 13. Project 2 - Building A Database With Excel/7. Pulling Data From Multiple Sources.mp4 10.6 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/1. Introduction To The Coding Section.mp4 10.5 MB
  • 32. Importing Specific Data From Multiple Files/1. Intro To Importing Data From A Folder Full Of Files.mp4 10.5 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/26. Maths - Using Excel's Built-in Functions.mp4 10.4 MB
  • 15. Project 4 - What Can I Have For Dinner/4. Assigning A Macro To A Button.mp4 10.4 MB
  • 25. The Data Is Out There...On The Internet, That Is/1. Introduction To Web Query Section.mp4 10.3 MB
  • 13. Project 2 - Building A Database With Excel/10. Data Arrays Don't Have To Start At A!.mp4 10.1 MB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/4. Who's Presenting This....mp4 10.0 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/30. Closing Workbooks Programmatically.mp4 10.0 MB
  • 1. Excel Essentials Level 1 Basics - Master Excel Step-By-Step/2. Before We Start...Viewing The Lectures, And Following Along On A Single Screen.mp4 10.0 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/3. Creating Our Data Entry Screen.mp4 9.9 MB
  • 24. Automating All Your Reports!/1. Introduction To Report Automation Section.mp4 9.9 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/20. The Value Property - Reading And Writing Data.mp4 9.8 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/17. Sheets Vs. Worksheets.mp4 9.7 MB
  • 24. Automating All Your Reports!/10. Changing The Chart Title (And Why We Do It Separately).mp4 9.6 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/12. A Little Bit Of Simple Data Entry.mp4 9.6 MB
  • 24. Automating All Your Reports!/9. POWER USER - Sizing Your Charts Precisely.mp4 9.5 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/31. CODING EXERCISE OpenWriteClose.mp4 9.4 MB
  • 29. Bonus Section eMail Automation...Why WRITE emails!/1. Intro To The Emailing Section.mp4 9.4 MB
  • 11. Excel Essentials Level 2 - IntermediateAdvanced/1. Intro To Level 2.mp4 9.4 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/27. More Useful Properties.mp4 9.3 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/8. Adding Time.mp4 9.3 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/10. The Offset Property.mp4 9.3 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/24. The Address Property.mp4 9.3 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/18. Getting Around The Workbooks.mp4 9.2 MB
  • 13. Project 2 - Building A Database With Excel/5. Importing Data From A Text File.mp4 9.2 MB
  • 14. Project 3 - Named Ranges/1. A Simple Static Named Range Using A Single Cell.mp4 9.2 MB
  • 25. The Data Is Out There...On The Internet, That Is/5. A Simple Find And Replace.mp4 9.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/5. Variables - Project Level Variables.mp4 9.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/33. Arrays - An Introduction.mp4 9.1 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/10. WorkSheet Activate - You Might Pick This!.mp4 9.1 MB
  • 13. Project 2 - Building A Database With Excel/1. Simple VLOOKUPs.mp4 9.0 MB
  • 15. Project 4 - What Can I Have For Dinner/11. Working The Percentages And Adding Traffic Lights.mp4 9.0 MB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/3. Setting Up The Shell Of The Code.mp4 8.9 MB
  • 7. A Few More Essentials/12. Highlighting Cells.mp4 8.9 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/6. Understanding The Hierarchy.mp4 8.9 MB
  • 15. Project 4 - What Can I Have For Dinner/2. Hyperlinking To A Different Sheet In The Same Workbook.mp4 8.8 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/20. Logical Testing - Testing If One Is True, And One Is False.mp4 8.8 MB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/10. Final Slide, And Wrap Up.mp4 8.8 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/3. WorkBook BeforePrint.mp4 8.7 MB
  • 3. Start Here - All The Basics/18. Entering Data - A Couple Of Shortcuts.mp4 8.7 MB
  • 7. A Few More Essentials/6. Adding Borders.mp4 8.6 MB
  • 5. Rearranging Things/4. Hiding Columns And Rows.mp4 8.5 MB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/4. A Custom UDF For Calculating Volume Discount.mp4 8.5 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/13. The CurrentRegion Property.mp4 8.4 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/8. WorkBook BeforeClose.mp4 8.3 MB
  • 32. Importing Specific Data From Multiple Files/4. A More Useful Loop Through Files.mp4 8.3 MB
  • 4. Doing The (Simple) Math/4. Copying Formulas.mp4 8.1 MB
  • 6. Formulas Learning The Clever Stuff!/2. Formatting Numbers.mp4 8.0 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/11. Looping With For...Next.mp4 8.0 MB
  • 13. Project 2 - Building A Database With Excel/24. POWER USER - Vlook-Ups With Moving Columns.mp4 7.9 MB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/6. Prettying Up The Formatting (More Lego Coding!).mp4 7.8 MB
  • 3. Start Here - All The Basics/15. Changing The Column Width.mp4 7.7 MB
  • 4. Doing The (Simple) Math/5. SUMming Horizontally.mp4 7.7 MB
  • 14. Project 3 - Named Ranges/3. Using Row Labels To Name Multiple Ranges.mp4 7.6 MB
  • 4. Doing The (Simple) Math/9. Average Function.mp4 7.5 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/7. The Range Object.mp4 7.4 MB
  • 3. Start Here - All The Basics/11. Formatting Text - Alignment.mp4 7.2 MB
  • 18. Student Questions Answered!/3. Extracting Phone Numbers From A Cell.mp4 7.2 MB
  • 15. Project 4 - What Can I Have For Dinner/7. Copying Conditional Formats And Creating Our Drop-Downs.mp4 7.2 MB
  • 7. A Few More Essentials/7. Customizing the Quick Access Toolbar.mp4 7.2 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/12. Looping With A Stepped For...Next.mp4 7.1 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/28. Even More Useful Properties.mp4 7.1 MB
  • 9. Bonus Section Absolute and Relative Cell References/2. $A$1 Style - Absolute Absolute.mp4 6.9 MB
  • 3. Start Here - All The Basics/14. Saving Time With Format Painter.mp4 6.9 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/7. A Neat Trick To Force Variable Declaration.mp4 6.8 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/11. WorkSheet Change.mp4 6.8 MB
  • 14. Project 3 - Named Ranges/2. Creating A Named Range Using A Range Of Cells.mp4 6.6 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/20. PRACTICE EXERCISE 1 - Time To Add A New Entry.mp4 6.6 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/15. Between The Sheets.mp4 6.6 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/8. The Cells Object.mp4 6.5 MB
  • 3. Start Here - All The Basics/17. Tidy Large Titles With Merge And Centre.mp4 6.5 MB
  • 6. Formulas Learning The Clever Stuff!/3. A Primer In Building Complex Formulas.mp4 6.4 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/22. Commonly Used Properties.mp4 6.4 MB
  • 4. Doing The (Simple) Math/1. Sums - The Old Fashioned Way!.mp4 6.4 MB
  • 28. Bonus Section Controlling Windows - Folder Creation Gizmo/1. Intro To Folder Creation Gizmo.mp4 6.3 MB
  • 13. Project 2 - Building A Database With Excel/9. LOOKUP From A LOOKUP With No Intermediary Step.mp4 6.2 MB
  • 5. Rearranging Things/2. Moving Existing Columns And Rows.mp4 6.2 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/23. CODING EXERCISE The Rainbow.mp4 6.1 MB
  • 15. Project 4 - What Can I Have For Dinner/8. Building Our Formula...INDIRECT Function.mp4 5.9 MB
  • 15. Project 4 - What Can I Have For Dinner/5. Creating A List For Our Dropdown Using A Dynamic Named Range.mp4 5.9 MB
  • 4. Doing The (Simple) Math/6. Basic Formulas - Subtraction.mp4 5.8 MB
  • 9. Bonus Section Absolute and Relative Cell References/1. A1 Style - Relative Relative.mp4 5.8 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/9. WorkSheet Activate - You Can't Pick This!.mp4 5.8 MB
  • 7. A Few More Essentials/10. Getting Help.mp4 5.7 MB
  • 15. Project 4 - What Can I Have For Dinner/10. It's A One Or A Zero.mp4 5.4 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/5. Simple Calculations With Time.mp4 5.3 MB
  • 24. Automating All Your Reports!/2. A Special Note For Office 2010 Users.mp4 5.1 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/9. The ActiveCell Property.mp4 5.1 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/17. Before We Move On...Accessing The Developer Ribbon.mp4 5.0 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/14. An Introduction To Logical Testing.mp4 5.0 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/4. Protecting Your Code.mp4 5.0 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/2. Planning Ahead.mp4 5.0 MB
  • 3. Start Here - All The Basics/4. Always Do This First! - Save Your New Workbook!.mp4 4.9 MB
  • 9. Bonus Section Absolute and Relative Cell References/3. $A1 Style - Absolute Relative.mp4 4.9 MB
  • 15. Project 4 - What Can I Have For Dinner/15. PRACTICE EXERCISE 3 - Create A VLOOKUP Using A Built String With INDIRECT.mp4 4.9 MB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/2. Understanding The Word Routine.mp4 4.9 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/1. Intro To The Events Section.mp4 4.9 MB
  • 24. Automating All Your Reports!/5. Deconstructing The Profit By Day Code.mp4 4.8 MB
  • 9. Bonus Section Absolute and Relative Cell References/4. A$1 Style - Relative Absolute.mp4 4.6 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/26. Capturing The Column Letter.mp4 4.6 MB
  • 34. Thank You - Your Special Bonus!/1. Get Your Next Course Now!.mp4 4.6 MB
  • 15. Project 4 - What Can I Have For Dinner/14. PRACTICE EXERCISE 2 - Pretty It Up (With A Macro).mp4 4.5 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/14. ACTIVATE vs. SELECT.mp4 4.5 MB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/9. Keyboard Shortcuts, And Why I Don't Use Them.mp4 4.3 MB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/6. Calling A UDF From A Different Workbook.mp4 4.0 MB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/22. PRACTICE EXERCISE 2 - Set Up A Working Area, And Limit User Entry.mp4 4.0 MB
  • 7. A Few More Essentials/3. Adding A New Worksheet.mp4 4.0 MB
  • 7. A Few More Essentials/14. Closing.mp4 3.9 MB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/2. Using A UDF To Return Information.mp4 3.8 MB
  • 13. Project 2 - Building A Database With Excel/12. One Inherent Flaw In Vlook Up.mp4 3.7 MB
  • 4. Doing The (Simple) Math/7. Basic Formulas - Multiplication.mp4 3.7 MB
  • 3. Start Here - All The Basics/10. A Quick Word On Formatting.mp4 3.7 MB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/25. The Row and Column Properties.mp4 3.6 MB
  • 2. An Introduction To Level 1/1. Where Are My Practice Files.mp4 3.6 MB
  • 3. Start Here - All The Basics/5. Let's Enter Some Data.mp4 3.4 MB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/1. Intro To PowerPoint Section.mp4 3.3 MB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/4. WorkBook SheetChange.mp4 3.2 MB
  • 3. Start Here - All The Basics/7. Editing Data.mp4 3.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/1. Introduction To The Programmers Toolbox.mp4 3.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/9. An Introduction To Looping.mp4 2.9 MB
  • 4. Doing The (Simple) Math/8. Basic Formulas - Division.mp4 2.9 MB
  • 15. Project 4 - What Can I Have For Dinner/1. Welcome to What Can I Have For Dinner or...What Would I Use THAT for.mp4 2.6 MB
  • 3. Start Here - All The Basics/8. Ooops. I Made A Mistake - Undo and Redo.mp4 2.5 MB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/1. Intro To The Word Section.mp4 2.3 MB
  • 15. Project 4 - What Can I Have For Dinner/13. PRACTICE EXERCISE 1 - Fill In The Blanks.mp4 2.1 MB
  • 28. Bonus Section Controlling Windows - Folder Creation Gizmo/2. Creating A New Folder With A Single Line Of Code.mp4 2.1 MB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/23.1 Doing The Math.xlsx.xlsx 905.6 kB
  • 33. Student Questions Answered/9.1 SQA Neil MPAN Data Set.xlsx.xlsx 837.7 kB
  • 33. Student Questions Answered/1.1 Question 1.xlsx.xlsx 580.1 kB
  • 4. Doing The (Simple) Math/10.1 The Order Of Mathematical Operation.pdf.pdf 444.8 kB
  • 18. Student Questions Answered!/9.2 VLookUps With Pictures! (After).xlsx.xlsx 420.2 kB
  • 3. Start Here - All The Basics/3.1 The Anatomy Of A Workbook.pdf.pdf 379.3 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2.6 Level 3 - HR File.xls.xls 257.0 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/2.2 Variables.pdf.pdf 257.0 kB
  • 18. Student Questions Answered!/9.1 VLookUps With Pictures! (Before).xlsx.xlsx 210.7 kB
  • 34. Thank You - Your Special Bonus!/1.2 123 Get Your Next Course.pdf.pdf 206.6 kB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/9.2 1045 - Excel Keyboard Shortcuts.pdf.pdf 205.9 kB
  • 3. Start Here - All The Basics/1.1 Cells, Columns and Rows.pdf.pdf 190.6 kB
  • 8. Bonus Section - The Keyboard Shortcuts/2.3 The Most Popular Excel Keyboard Shortcuts.pdf.pdf 187.6 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/1.1 Time Sheet & Expenses Master.xlsx.xlsx 156.4 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/9.1 Time Sheet Blank.jpg.jpg 125.6 kB
  • 20. What's It All About, Alan/1.1 0010 - The 15 Golden Rules Of Coding.pdf.pdf 124.9 kB
  • 34. Thank You - Your Special Bonus!/1.1 Code Demo Solution File (Using Level 3 - HR File).xlsx.xlsx 101.7 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/33.1 Arrays.xlsx.xlsx 82.1 kB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/2.1 Northern Sales Report PowerPoint.xlsx.xlsx 77.9 kB
  • 33. Student Questions Answered/16.1 Gantt Charts - With A Little More Sophisticaton.xlsx.xlsx 76.6 kB
  • 13. Project 2 - Building A Database With Excel/2.2 HR Database Master.xlsx.xlsx 62.8 kB
  • 15. Project 4 - What Can I Have For Dinner/2.1 What To Have For Dinner.xlsx.xlsx 42.6 kB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/1.1 9000 - Word Automation.xlsx.xlsx 38.9 kB
  • 33. Student Questions Answered/12.5 CS1.jpg.jpg 34.0 kB
  • 33. Student Questions Answered/12.1 AS1.jpg.jpg 33.2 kB
  • 33. Student Questions Answered/5. Saving Multiple Sheets To A Single Workbook In A Specific Folder.vtt 33.1 kB
  • 25. The Data Is Out There...On The Internet, That Is/1.1 SuperWebQuery.xlsx.xlsx 33.0 kB
  • 33. Student Questions Answered/12.2 EF1.jpg.jpg 32.8 kB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/1.1 Gantt Charts.xlsx.xlsx 32.1 kB
  • 24. Automating All Your Reports!/1.5 201601 - South.xlsx.xlsx 30.7 kB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/6.1 Gantt Charts With Different Colours For Different Reasons.xlsx.xlsx 28.5 kB
  • 24. Automating All Your Reports!/1.2 201601 - North.xlsx.xlsx 27.4 kB
  • 33. Student Questions Answered/12.6 DJ1.jpg.jpg 26.6 kB
  • 24. Automating All Your Reports!/1.1 201601 - West.xlsx.xlsx 26.6 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/1.1 Workbook Events.xlsx.xlsx 26.5 kB
  • 13. Project 2 - Building A Database With Excel/2.1 HR File.xlsx.xlsx 24.9 kB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/1.1 1005 - Excel 3 - Sales Data.xlsx.xlsx 24.3 kB
  • 24. Automating All Your Reports!/1.4 201601 - East.xlsx.xlsx 24.2 kB
  • 33. Student Questions Answered/5.1 Territory Managers Part 2.xlsx.xlsx 23.8 kB
  • 3. Start Here - All The Basics/1.3 Excel Level 1 Practice File.xlsx.xlsx 23.6 kB
  • 10. Bonus Section Student Questions Answered!/1. Reverse Engineering A Sample Spreadsheet.vtt 23.5 kB
  • 33. Student Questions Answered/12.4 CW1.jpg.jpg 23.1 kB
  • 29. Bonus Section eMail Automation...Why WRITE emails!/1.1 eMail Automation.xlsx.xlsx 21.6 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/10.1 Expenses Form.xlsx.xlsx 21.2 kB
  • 13. Project 2 - Building A Database With Excel/18.1 Lookup Up From Multiple Inputs.xlsx.xlsx 21.1 kB
  • 3. Start Here - All The Basics/2. The Anatomy Of A Workbook Where Everything Is, And What It Does!.vtt 20.3 kB
  • 33. Student Questions Answered/13.3 Lisa's Report Builder.xlsx.xlsx 20.1 kB
  • 33. Student Questions Answered/12. Sequential PDF Creation With Pictures.vtt 19.9 kB
  • 14. Project 3 - Named Ranges/8.1 Horizontal Dynamic Named Ranges.xlsx.xlsx 19.8 kB
  • 33. Student Questions Answered/6.1 Animated Charts.xlsx.xlsx 19.6 kB
  • 32. Importing Specific Data From Multiple Files/2.9 Mass Data Getterer.xlsx.xlsx 19.4 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/14.1 Worksheet Events - BONUS.xlsx.xlsx 19.1 kB
  • 3. Start Here - All The Basics/1.2 My Fruit And Veg Shop.xlsx.xlsx 19.0 kB
  • 14. Project 3 - Named Ranges/7.1 Dynamic Charts.xlsx.xlsx 18.6 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/14.1 Logical Testing.xlsx.xlsx 17.6 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/2.1 Variables.xlsx.xlsx 17.4 kB
  • 18. Student Questions Answered!/4. What Is The CHOOSE Function Really Used For.vtt 17.3 kB
  • 18. Student Questions Answered!/4.1 CHOOSE Function.xlsx.xlsx 17.0 kB
  • 33. Student Questions Answered/9. Extracting Unique Tables to Unique Sheets From A Big Data Set.vtt 17.0 kB
  • 18. Student Questions Answered!/6.1 5 - Dynamic Tables.xlsx.xlsx 17.0 kB
  • 33. Student Questions Answered/13. File Picker, And Report Generator With Intelligent Filing.vtt 16.9 kB
  • 24. Automating All Your Reports!/1.3 Monthly Reporting.xlsx.xlsx 16.4 kB
  • 32. Importing Specific Data From Multiple Files/5. The Data Grabber(er).vtt 16.4 kB
  • 33. Student Questions Answered/10.1 Protecting Specific Cells and Data Validation.xlsx.xlsx 16.1 kB
  • 33. Student Questions Answered/4.1 Territory Managers.xlsx.xlsx 16.0 kB
  • 13. Project 2 - Building A Database With Excel/21. POWER USER - The Holy Grail - How To Return Multiple Values From A Single Look U.vtt 15.9 kB
  • 33. Student Questions Answered/7.1 SQA - Neil.xlsx.xlsx 15.9 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2.1 My Macro Book.xlsx.xlsx 15.4 kB
  • 8. Bonus Section - The Keyboard Shortcuts/2. Bonus 2 Keyboard Shortcuts.vtt 15.0 kB
  • 13. Project 2 - Building A Database With Excel/6.1 Addresses.docx.docx 14.8 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/9. Creating A Template From An Image.vtt 14.7 kB
  • 33. Student Questions Answered/17. Vlookups (Or Any Application.WorksheetFunction) Over Ranges.vtt 14.7 kB
  • 33. Student Questions Answered/10. Protecting Specific Cells and Data Validation.vtt 14.7 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/19. Auto-populating Check Boxes.vtt 14.6 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/16. Building Text Strings With A Formula.vtt 14.4 kB
  • 13. Project 2 - Building A Database With Excel/21.1 Returning Multiple Results.xlsx.xlsx 14.4 kB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/5. With And End With.vtt 13.9 kB
  • 28. Bonus Section Controlling Windows - Folder Creation Gizmo/1.1 Folder Creation Gizmo.xlsx.xlsx 13.8 kB
  • 33. Student Questions Answered/4. Saving An Individual Sheet To A Specific Folder.vtt 13.8 kB
  • 33. Student Questions Answered/3.1 Project Tracker.xlsx.xlsx 13.8 kB
  • 33. Student Questions Answered/15.2 Sean Source File.xlsx.xlsx 13.5 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2.5 Mod01_TheBasics.txt.txt 13.2 kB
  • 14. Project 3 - Named Ranges/1.1 Static Named Ranges.xlsx.xlsx 13.1 kB
  • 33. Student Questions Answered/13.1 All Months.xlsx.xlsx 13.0 kB
  • 33. Student Questions Answered/13.2 Latest Month.xlsx.xlsx 13.0 kB
  • 33. Student Questions Answered/16. Gantt Charts...With A Little More Sophistication!.vtt 12.9 kB
  • 9. Bonus Section Absolute and Relative Cell References/1.1 Absolute And Relative Cell References.xlsx.xlsx 12.9 kB
  • 33. Student Questions Answered/12.3 Sequential PDF Creation With Pictures.xlsx.xlsx 12.8 kB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/1. Introducing The Visual Basic Editor, & Recording Our First Macro.vtt 12.7 kB
  • 29. Bonus Section eMail Automation...Why WRITE emails!/3. Deconstructing How We Capture All The Data.vtt 12.6 kB
  • 14. Project 3 - Named Ranges/8. 3040 - Horizontal Dynamic Named Ranges For Charts.vtt 12.6 kB
  • 14. Project 3 - Named Ranges/7. 3035 - POWER USER - Dynamic Charts.vtt 12.4 kB
  • 33. Student Questions Answered/8.1 SQA - Pascal - Run Me From Here.xlsx.xlsx 12.4 kB
  • 3. Start Here - All The Basics/9. Changing Appearance Of Text With Formatting - Fonts.vtt 12.4 kB
  • 18. Student Questions Answered!/8.1 SUMIF With Dynamic Sum Range Column - Completed.xlsx.xlsx 12.4 kB
  • 13. Project 2 - Building A Database With Excel/25. Putting It All Together.vtt 12.3 kB
  • 19. Excel Essentials Level 3 - VBA Programming/1. Why Should I Learn How To Code.vtt 12.2 kB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/10. Why You Can't Get By With Just Recording Macros.vtt 12.2 kB
  • 18. Student Questions Answered!/6. Dynamic Charting From A Drop Down.vtt 12.2 kB
  • 18. Student Questions Answered!/8.2 SUMIF With Dynamic Sum Range Column - Data Set.xlsx.xlsx 11.8 kB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/1.1 User Defined Functions.xlsx.xlsx 11.6 kB
  • 32. Importing Specific Data From Multiple Files/2.3 201612 - Western Region.xlsx.xlsx 11.6 kB
  • 18. Student Questions Answered!/1.1 1.0 - Calls Text Data.xlsx.xlsx 11.6 kB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/2. A Run Through The PowerPoint Base Code.vtt 11.6 kB
  • 32. Importing Specific Data From Multiple Files/2.5 201611 - Northern Region.xlsx.xlsx 11.3 kB
  • 32. Importing Specific Data From Multiple Files/2.6 201612 - Northern Region.xlsx.xlsx 11.3 kB
  • 14. Project 3 - Named Ranges/5.1 Dynamic Named Ranges.xlsx.xlsx 11.3 kB
  • 18. Student Questions Answered!/12.1 L2 SQA12 - Using 2 Labels As A Lookup From Drop-downs.xlsx.xlsx 11.3 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/8. Variables - All The Techie Bits.vtt 11.2 kB
  • 13. Project 2 - Building A Database With Excel/18. POWER USER - Vlook-Ups With Multiple Inputs.vtt 11.1 kB
  • 33. Student Questions Answered/15.1 Sean Destination File.xlsx.xlsx 11.1 kB
  • 33. Student Questions Answered/15. Finding Updated Values In One Workbook, And Adding Them To Another Workbook.vtt 11.0 kB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/9. Adding Pivot Tables (And Another Chart).vtt 10.9 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/23.1 The Rainbow.xlsx.xlsx 10.9 kB
  • 13. Project 2 - Building A Database With Excel/17.1 Fuzzy VLook-Ups.xlsx.xlsx 10.8 kB
  • 18. Student Questions Answered!/11.1 Data Validation - Dependent Dropdowns (Dynamic Named Range Work Around).xlsx.xlsx 10.8 kB
  • 33. Student Questions Answered/17.1 VLookUps In Code....xlsx.xlsx 10.7 kB
  • 13. Project 2 - Building A Database With Excel/15.1 Looking Up Backwards.xlsx.xlsx 10.7 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/7.1 It's About Time.xlsx.xlsx 10.6 kB
  • 33. Student Questions Answered/8.2 SQA - Pascal - Data Set.xlsx.xlsx 10.5 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/31.1 Open Write Close.xlsx.xlsx 10.5 kB
  • 32. Importing Specific Data From Multiple Files/2.1 201611 - Western Region.xlsx.xlsx 10.4 kB
  • 32. Importing Specific Data From Multiple Files/2.7 201611 - Southern Region.xlsx.xlsx 10.3 kB
  • 32. Importing Specific Data From Multiple Files/2.4 201612 - Southern Region.xlsx.xlsx 10.3 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/15. Simple Logical Testing And Nested Logical Testing.vtt 10.2 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/6. More (Useful) Calculations With Time.vtt 10.2 kB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/3. Creating A Countdown Timer With A UDF.vtt 10.1 kB
  • 18. Student Questions Answered!/2. Calls Text Data 2 - This Time Using Text!.vtt 10.0 kB
  • 33. Student Questions Answered/7. Extracting Specific Data From A Big File, To A Bunch Of Little Ones.vtt 10.0 kB
  • 33. Student Questions Answered/11.1 Katrina.xlsx.xlsx 10.0 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/14. WorkSheet Events - BONUS - 4 New Things To Try.vtt 10.0 kB
  • 33. Student Questions Answered/18.1 Level 3 SQA 18 - Adding A Date Stamp If A Change Has Been Made.xlsx.xlsx 9.9 kB
  • 10. Bonus Section Student Questions Answered!/2.1 Casing.xlsx.xlsx 9.8 kB
  • 18. Student Questions Answered!/5.1 Casing.xlsx.xlsx 9.8 kB
  • 13. Project 2 - Building A Database With Excel/16. POWER USER - Dealing With Inconsistencies In User Entry.vtt 9.8 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/31.1 Message Boxes.xlsx.xlsx 9.8 kB
  • 18. Student Questions Answered!/10.1 Data Validation - Dependent Dropdowns.xlsx.xlsx 9.8 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/38. Arrays - Extracting Useful Data Based On User Input.vtt 9.7 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/18. A Tick Box Exercise (Of Sorts).vtt 9.7 kB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/3. Multiple Logical Tests At Once Using AND.vtt 9.7 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/28.1 Input Boxes.xlsx.xlsx 9.6 kB
  • 13. Project 2 - Building A Database With Excel/24.1 VLOOKUPS With Moving Columns.xlsx.xlsx 9.6 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2.4 ModLogicalTesting.txt.txt 9.6 kB
  • 14. Project 3 - Named Ranges/5. POWER USER - Dynamic Named Ranges.vtt 9.5 kB
  • 13. Project 2 - Building A Database With Excel/1.1 Simple VLOOKUPS.xlsx.xlsx 9.5 kB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/5. Adding A Slide With A Logo And Text.vtt 9.4 kB
  • 18. Student Questions Answered!/11. Data Validation With Dependent Drop downs (Dynamic Named Range Workaround).vtt 9.4 kB
  • 24. Automating All Your Reports!/14. Adding The Commentary - Building Strings Dynamically At Runtime.vtt 9.3 kB
  • 32. Importing Specific Data From Multiple Files/2.2 201611 - Eastern Region.xlsx.xlsx 9.3 kB
  • 32. Importing Specific Data From Multiple Files/2.8 201612 - Eastern Region.xlsx.xlsx 9.3 kB
  • 8. Bonus Section - The Keyboard Shortcuts/1. Bonus 1 Whizzing Around Excel.vtt 9.3 kB
  • 33. Student Questions Answered/14. Help! My File Has Got HUGE!.vtt 9.2 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/7. It's About Time (And Dates!).vtt 9.2 kB
  • 33. Student Questions Answered/14.1 SQA 14 - Magic Sheet Sizer.xlsx.xlsx 9.2 kB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/1. Creating A Gantt Chart Using A Worksheet.vtt 9.1 kB
  • 18. Student Questions Answered!/3.1 3.0 - Extracting Phone Numbers From A Cell.xlsx.xlsx 9.1 kB
  • 13. Project 2 - Building A Database With Excel/23. The Fastest Way To Modify Your Column Numbers.vtt 9.0 kB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/6. SQA - Gantt Charts With Different Colours For Different Categories.vtt 8.9 kB
  • 33. Student Questions Answered/3. Adding A Date Stamp, And Going To The Insertion Point AUTOMATICALLY.vtt 8.9 kB
  • 24. Automating All Your Reports!/11. Deconstructing The Pivot Tables (It's Slightly Different).vtt 8.9 kB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/6. Streamlining You Code, Or, Get Rid Of What You Don't Need.vtt 8.7 kB
  • 24. Automating All Your Reports!/6. Building Source Data Strings Dynamically At Runtime.vtt 8.6 kB
  • 5. Rearranging Things/1. Inserting New Columns And Rows.vtt 8.5 kB
  • 4. Doing The (Simple) Math/10. The Order Of Mathematical Operation.vtt 8.4 kB
  • 15. Project 4 - What Can I Have For Dinner/9. Building Strings For Indirect Sheet And Cell References.vtt 8.4 kB
  • 17. Bonus Section - Just For Fun/1. How I Created Randomly Generated License Plate Numbers!.vtt 8.4 kB
  • 5. Rearranging Things/3. Cutting, Copying, Inserting And Deleting.vtt 8.4 kB
  • 6. Formulas Learning The Clever Stuff!/1. ROUNDing Functions.vtt 8.3 kB
  • 13. Project 2 - Building A Database With Excel/13. POWER USER - A Breakdown Of Looking Up Backwards.vtt 8.3 kB
  • 20. What's It All About, Alan/1. The 15 Golden Rules Of Coding.vtt 8.3 kB
  • 3. Start Here - All The Basics/3. A Quick Review Of What's Where.vtt 8.3 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/13. Looping With While...Wend.vtt 8.2 kB
  • 18. Student Questions Answered!/5. Casing And Text Functions.vtt 8.1 kB
  • 10. Bonus Section Student Questions Answered!/2. Casing And Text Functions.vtt 8.1 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/2. Variables - Local Variables.vtt 8.0 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/29. Opening Another Workbook Programmatically.vtt 8.0 kB
  • 13. Project 2 - Building A Database With Excel/5.1 Department Structure.txt.txt 8.0 kB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/8. Adding A Chart As A Picture.vtt 8.0 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2. Getting All The Code For This Section.vtt 8.0 kB
  • 13. Project 2 - Building A Database With Excel/14. The Other Way Of Looking Up Backwards.vtt 7.9 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/24. Maths - Writing Formulas To Single Cells.vtt 7.8 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/15. Logical Testing - A Simple If Test.vtt 7.8 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/5. Objects, Methods And Properties.vtt 7.7 kB
  • 7. A Few More Essentials/11. Filters.vtt 7.6 kB
  • 13. Project 2 - Building A Database With Excel/11. Some Common Reasons VLook-Ups Fail.vtt 7.6 kB
  • 33. Student Questions Answered/1. Get rid of rows in a array.vtt 7.6 kB
  • 18. Student Questions Answered!/12. Using 2 Labels As A Lookup From Drop-downs.vtt 7.5 kB
  • 4. Doing The (Simple) Math/2. Sums - Using Autosum.vtt 7.5 kB
  • 24. Automating All Your Reports!/20. Easy As Pie (Chart).vtt 7.4 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/34. Arrays - A Simple One Dimensional Static Array.vtt 7.4 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/22. Logical Testing - Select Case.vtt 7.3 kB
  • 13. Project 2 - Building A Database With Excel/4. Let's Build Our Database!.vtt 7.3 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/4. (Custom) Formatting Dates And Time.vtt 7.2 kB
  • 33. Student Questions Answered/6. Animated Charts...With A Little Something Extra!.vtt 7.2 kB
  • 24. Automating All Your Reports!/4. Streamlining The Add New Sheet Code.vtt 7.1 kB
  • 25. The Data Is Out There...On The Internet, That Is/3. Getting To Cancun And London From Rome.vtt 7.1 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/11. Converting Time To A Decimal.vtt 7.0 kB
  • 18. Student Questions Answered!/1. Calls Text Data - Or How To Return a Column Title If Value is 1.vtt 6.9 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/30. InputBox - Getting User Input Using The InputBox Method.vtt 6.9 kB
  • 18. Student Questions Answered!/8. SUMIF With Dynamic Sum Range.vtt 6.8 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/36. Arrays - A Simple Two Dimensional Static Array.vtt 6.8 kB
  • 33. Student Questions Answered/11. Dynamically Populating A Reusable Array While Looping Through A Table.vtt 6.8 kB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/1. User Defined Functions...What They Are, And How You Make Them.vtt 6.8 kB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/7. Combining Your Code.vtt 6.8 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/19. The Value Property - Writing Data.vtt 6.8 kB
  • 28. Bonus Section Controlling Windows - Folder Creation Gizmo/4. Folders Within Folders.vtt 6.8 kB
  • 3. Start Here - All The Basics/13. POWER USER - Adding Your Own Lists To Autofill.vtt 6.8 kB
  • 15. Project 4 - What Can I Have For Dinner/3. Creating Our First Macro.vtt 6.8 kB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/4. Conditional Formatting...Where The Magic Happens.vtt 6.7 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/1. Introduction To The Coding Section.vtt 6.7 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/7. WorkBook Open - Calling Other Code.vtt 6.7 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/5. WorkBook Open - Creating An Auto-Back Up.vtt 6.6 kB
  • 29. Bonus Section eMail Automation...Why WRITE emails!/4. The eMail Loop.vtt 6.6 kB
  • 33. Student Questions Answered/8. Finding A Search String in Another Workbook With Multiple Sheets.vtt 6.5 kB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/6. Building The Text And Wrap Up.vtt 6.4 kB
  • 3. Start Here - All The Basics/12. Saving Time With AutoFilling Sequences.vtt 6.4 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/28. InputBox - Getting User Input Using The InputBox Function.vtt 6.4 kB
  • 4. Doing The (Simple) Math/11. POWER USER - Evaluate Formula.vtt 6.4 kB
  • 14. Project 3 - Named Ranges/6. POWER USER - What To Do With Dynamic Names Ranges With Titles.vtt 6.4 kB
  • 33. Student Questions Answered/18. Adding A Date Stamp If A Change Has Been Made.vtt 6.3 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/25. Maths - Writing Formulas To Ranges Of Cells.vtt 6.3 kB
  • 28. Bonus Section Controlling Windows - Folder Creation Gizmo/3. A Single Level Folder Structure.vtt 6.3 kB
  • 13. Project 2 - Building A Database With Excel/8. Using OTHER Look-Ups To Look Up!.vtt 6.2 kB
  • 29. Bonus Section eMail Automation...Why WRITE emails!/2. Understanding The eMail Routine.vtt 6.2 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/1. Proof Of Concept.vtt 6.2 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/21. Defining A Working Area, And Protecting Your Work.vtt 6.2 kB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/4. Stepping Out. Well, In Actually! - Debugging Made Easy ).vtt 6.1 kB
  • 24. Automating All Your Reports!/13. Butchering One Table, To Create Another.vtt 6.0 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/35. Arrays - A Simple One Dimensional Dynamic Array.vtt 6.0 kB
  • 24. Automating All Your Reports!/17. POWER USER - INSTR...A Very Useful Function.vtt 5.9 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/12. WorkSheet Change - A More Useful Use.vtt 5.9 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/10. Looping With Do...Loop.vtt 5.9 kB
  • 24. Automating All Your Reports!/12. Titles, Money And Sorting.vtt 5.9 kB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/5. Gantt Charts Using The Built In Charting Tools.vtt 5.9 kB
  • 18. Student Questions Answered!/9. Vlookups With Pictures!.vtt 5.8 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/13. Simple Conditional Formatting For A Cleaner View.vtt 5.7 kB
  • 7. A Few More Essentials/1. Sorting.vtt 5.7 kB
  • 13. Project 2 - Building A Database With Excel/19. POWER USER - Looking Up Multiple Inputs Using An Array Formula.vtt 5.7 kB
  • 14. Project 3 - Named Ranges/4. POWER USER - A Magic Trick Using Row And Column Labels.vtt 5.7 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/32. Message Boxes - Testing Which Button Was Pressed.vtt 5.7 kB
  • 24. Automating All Your Reports!/16. POWER USER - How DO You Make Specific Words Bold.vtt 5.6 kB
  • 25. The Data Is Out There...On The Internet, That Is/7. Streamlining The Formulas Code.vtt 5.6 kB
  • 24. Automating All Your Reports!/22. Putting It All Together.vtt 5.6 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/16. Logical Testing - A Simple If Test Using Cells.vtt 5.6 kB
  • 13. Project 2 - Building A Database With Excel/1. Simple VLOOKUPs.vtt 5.6 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/37. Arrays - The Most Efficient Way To Capture An Array.vtt 5.5 kB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/3. Moving Code Around.vtt 5.5 kB
  • 7. A Few More Essentials/9. Freezing For An Easier View.vtt 5.5 kB
  • 13. Project 2 - Building A Database With Excel/20. VLOOKUPs Brother...HLOOKUP.vtt 5.4 kB
  • 6. Formulas Learning The Clever Stuff!/4. Buliding a Compex Formula.vtt 5.4 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/14. Calculating Time Out Of House Using Travel Time.vtt 5.4 kB
  • 15. Project 4 - What Can I Have For Dinner/4. Assigning A Macro To A Button.vtt 5.4 kB
  • 15. Project 4 - What Can I Have For Dinner/6. Using A Conditional Format To Know When A Value Is Missing.vtt 5.4 kB
  • 25. The Data Is Out There...On The Internet, That Is/2. Pulling Data From The Internet - Capturing The Data For Rome.vtt 5.4 kB
  • 3. Start Here - All The Basics/1. Opening Excel, and Creating a Shortcut.vtt 5.3 kB
  • 7. A Few More Essentials/4. Creating A Simple Chart.vtt 5.3 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/2. WorkBook SheetActivate.vtt 5.3 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/31. Message Boxes - Simple Message Boxes.vtt 5.3 kB
  • 3. Start Here - All The Basics/18. Entering Data - A Couple Of Shortcuts.vtt 5.2 kB
  • 24. Automating All Your Reports!/3. Recording The Bones Of The Code.vtt 5.2 kB
  • 7. A Few More Essentials/2. Wrapping Text And Soft Enter.vtt 5.2 kB
  • 24. Automating All Your Reports!/15. Adding The Comentary Using Data From The Sheet We're On.vtt 5.1 kB
  • 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/2. Building The First Part Of Our Logical Test.vtt 5.1 kB
  • 13. Project 2 - Building A Database With Excel/26. The Finishing Touch - How Many Records Did I Find.vtt 5.1 kB
  • 7. A Few More Essentials/8. Simple Printing.vtt 5.1 kB
  • 25. The Data Is Out There...On The Internet, That Is/4. Data Clean Up.vtt 5.0 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/24. The Address Property.vtt 5.0 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/29. Manipulating The User Input With Casing.vtt 5.0 kB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/7. Using Slide 1 To Create Slide 2.vtt 5.0 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/26. Maths - Using Excel's Built-in Functions.vtt 5.0 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/6. WorkBook Open - Creating A Splash Screen.vtt 5.0 kB
  • 13. Project 2 - Building A Database With Excel/2. Step 1 - Get Some Data In, And Split It.vtt 5.0 kB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/4. A Custom UDF For Calculating Volume Discount.vtt 4.9 kB
  • 32. Importing Specific Data From Multiple Files/2. Looping Through All Excel Files In A Folder.vtt 4.9 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/6. Bonus - Calling A Sub Stored In A DIFFERENT Workbook!.vtt 4.8 kB
  • 15. Project 4 - What Can I Have For Dinner/11. Working The Percentages And Adding Traffic Lights.vtt 4.8 kB
  • 13. Project 2 - Building A Database With Excel/15. Backwards Look-Ups In Action.vtt 4.8 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/3. Creating Our Data Entry Screen.vtt 4.8 kB
  • 3. Start Here - All The Basics/15. Changing The Column Width.vtt 4.7 kB
  • 15. Project 4 - What Can I Have For Dinner/2. Hyperlinking To A Different Sheet In The Same Workbook.vtt 4.7 kB
  • 13. Project 2 - Building A Database With Excel/3. Using Data Validation To Get The Right Input.vtt 4.6 kB
  • 13. Project 2 - Building A Database With Excel/22. What To Look For When THAT Formula Didn't Work.vtt 4.6 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/30. Closing Workbooks Programmatically.vtt 4.6 kB
  • 14. Project 3 - Named Ranges/1. A Simple Static Named Range Using A Single Cell.vtt 4.6 kB
  • 1. Excel Essentials Level 1 Basics - Master Excel Step-By-Step/2. Before We Start...Viewing The Lectures, And Following Along On A Single Screen.vtt 4.5 kB
  • 3. Start Here - All The Basics/11. Formatting Text - Alignment.vtt 4.4 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/13. WorkSheet Activate - Top Secret Classified Information!.vtt 4.4 kB
  • 25. The Data Is Out There...On The Internet, That Is/6. Getting Our Formulas Right.vtt 4.4 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/4. Variables - Module Level Variables.vtt 4.4 kB
  • 24. Automating All Your Reports!/7. Creating The Run Order and Data Capture Subs.vtt 4.4 kB
  • 33. Student Questions Answered/2. Emailing Routine Adding a Specific Attachment Based On a Criteria.vtt 4.4 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/6. Understanding The Hierarchy.vtt 4.3 kB
  • 4. Doing The (Simple) Math/5. SUMming Horizontally.vtt 4.3 kB
  • 32. Importing Specific Data From Multiple Files/1. Intro To Importing Data From A Folder Full Of Files.vtt 4.3 kB
  • 13. Project 2 - Building A Database With Excel/7. Pulling Data From Multiple Sources.vtt 4.3 kB
  • 13. Project 2 - Building A Database With Excel/17. POWER USER - Fuzzy Vlook-Ups.vtt 4.2 kB
  • 32. Importing Specific Data From Multiple Files/3. The Folder Picker.vtt 4.2 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/18. Logical Testing - If Then Else Using Cells.vtt 4.2 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/8. Adding Time.vtt 4.1 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/27. More Useful Properties.vtt 4.1 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/27. Maths - Built-in Functions With Defined Ranges.vtt 4.1 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/3. Variables - Local Variables With A Twist.vtt 4.1 kB
  • 29. Bonus Section eMail Automation...Why WRITE emails!/1. Intro To The Emailing Section.vtt 4.1 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/19. Logical Testing - Testing Multiple Criteria.vtt 4.0 kB
  • 3. Start Here - All The Basics/14. Saving Time With Format Painter.vtt 4.0 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/31. CODING EXERCISE OpenWriteClose.vtt 4.0 kB
  • 6. Formulas Learning The Clever Stuff!/3. A Primer In Building Complex Formulas.vtt 4.0 kB
  • 32. Importing Specific Data From Multiple Files/4. A More Useful Loop Through Files.vtt 4.0 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/21. Logical Testing - Testing If Either Value Is True.vtt 4.0 kB
  • 4. Doing The (Simple) Math/4. Copying Formulas.vtt 3.9 kB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/4. Formula Modifications With Unique Values.vtt 3.9 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/17. Logical Testing - If Then Else.vtt 3.9 kB
  • 18. Student Questions Answered!/10. Data Validation With Dependent Drop-downs.vtt 3.9 kB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/3. Setting Up The Shell Of The Code.vtt 3.9 kB
  • 24. Automating All Your Reports!/19. Tidy Up The Title.vtt 3.9 kB
  • 15. Project 4 - What Can I Have For Dinner/12. POWER USER - The HYPERLINK Function (And Problem).vtt 3.8 kB
  • 3. Start Here - All The Basics/17. Tidy Large Titles With Merge And Centre.vtt 3.8 kB
  • 24. Automating All Your Reports!/18. INSTR And Paying Attention To Detail.vtt 3.8 kB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/5. Efficient Sorting.vtt 3.8 kB
  • 4. Doing The (Simple) Math/1. Sums - The Old Fashioned Way!.vtt 3.8 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/12. A Little Bit Of Simple Data Entry.vtt 3.8 kB
  • 5. Rearranging Things/4. Hiding Columns And Rows.vtt 3.7 kB
  • 25. The Data Is Out There...On The Internet, That Is/8. POWER USER - Displaying Messages In The Status Bar (Cool).vtt 3.7 kB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/2. Saving Macro-Enabled Workbooks, And Security Settings.vtt 3.7 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/39. Arrays - Using An Array As A Data Source For A VLookup.vtt 3.6 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/18. Getting Around The Workbooks.vtt 3.6 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/5. Variables - Project Level Variables.vtt 3.6 kB
  • 24. Automating All Your Reports!/9. POWER USER - Sizing Your Charts Precisely.vtt 3.6 kB
  • 24. Automating All Your Reports!/21. Prettying Up Our Pie Chart.vtt 3.6 kB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/5. A UDF For Getting All Your Sheet Names.vtt 3.6 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/22. Commonly Used Properties.vtt 3.6 kB
  • 13. Project 2 - Building A Database With Excel/24. POWER USER - Vlook-Ups With Moving Columns.vtt 3.6 kB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/3. Deconstructing How We Capture All The Data.vtt 3.6 kB
  • 7. A Few More Essentials/6. Adding Borders.vtt 3.5 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/21. Copy And Paste.vtt 3.5 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/8. WorkBook BeforeClose.vtt 3.5 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/28. Even More Useful Properties.vtt 3.5 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/11. The End Property.vtt 3.5 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/3. Changing Your VBE Settings.vtt 3.5 kB
  • 4. Doing The (Simple) Math/9. Average Function.vtt 3.5 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/7. The Range Object.vtt 3.5 kB
  • 1. Excel Essentials Level 1 Basics - Master Excel Step-By-Step/1. Intro To Level 1.vtt 3.4 kB
  • 24. Automating All Your Reports!/8. Solving That Naming Problem.vtt 3.4 kB
  • 24. Automating All Your Reports!/10. Changing The Chart Title (And Why We Do It Separately).vtt 3.4 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/5. Simple Calculations With Time.vtt 3.4 kB
  • 13. Project 2 - Building A Database With Excel/10. Data Arrays Don't Have To Start At A!.vtt 3.3 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/10. WorkSheet Activate - You Might Pick This!.vtt 3.3 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/33. Arrays - An Introduction.vtt 3.3 kB
  • 15. Project 4 - What Can I Have For Dinner/8. Building Our Formula...INDIRECT Function.vtt 3.3 kB
  • 6. Formulas Learning The Clever Stuff!/2. Formatting Numbers.vtt 3.3 kB
  • 15. Project 4 - What Can I Have For Dinner/7. Copying Conditional Formats And Creating Our Drop-Downs.vtt 3.3 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/12. Dynamic Range Selection.vtt 3.2 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/8. The Cells Object.vtt 3.2 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/15. Between The Sheets.vtt 3.2 kB
  • 5. Rearranging Things/2. Moving Existing Columns And Rows.vtt 3.2 kB
  • 14. Project 3 - Named Ranges/2. Creating A Named Range Using A Range Of Cells.vtt 3.1 kB
  • 13. Project 2 - Building A Database With Excel/6. Importing Data From A Word File.vtt 3.1 kB
  • 28. Bonus Section Controlling Windows - Folder Creation Gizmo/1. Intro To Folder Creation Gizmo.vtt 3.1 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/3. WorkBook BeforePrint.vtt 3.1 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/23. Maths - Doing Simple Maths In Code.vtt 3.0 kB
  • 18. Student Questions Answered!/3. Extracting Phone Numbers From A Cell.vtt 3.0 kB
  • 18. Student Questions Answered!/7. Extracting a Unique List, And Summing The Money!.vtt 3.0 kB
  • 4. Doing The (Simple) Math/6. Basic Formulas - Subtraction.vtt 3.0 kB
  • 14. Project 3 - Named Ranges/3. Using Row Labels To Name Multiple Ranges.vtt 3.0 kB
  • 24. Automating All Your Reports!/1. Introduction To Report Automation Section.vtt 3.0 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/2. Planning Ahead.vtt 3.0 kB
  • 9. Bonus Section Absolute and Relative Cell References/2. $A$1 Style - Absolute Absolute.vtt 2.9 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/20. The Value Property - Reading And Writing Data.vtt 2.9 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/10. Importing A Template From An Existing Excel File.vtt 2.9 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/9. The ActiveCell Property.vtt 2.9 kB
  • 30. Bonus Section Word Automation - Controlling Word From Excel/2. Understanding The Word Routine.vtt 2.9 kB
  • 15. Project 4 - What Can I Have For Dinner/10. It's A One Or A Zero.vtt 2.9 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/23. CODING EXERCISE The Rainbow.vtt 2.8 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/11. Looping With For...Next.vtt 2.8 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/10. The Offset Property.vtt 2.8 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/11. WorkSheet Change.vtt 2.8 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/20. Logical Testing - Testing If One Is True, And One Is False.vtt 2.8 kB
  • 25. The Data Is Out There...On The Internet, That Is/5. A Simple Find And Replace.vtt 2.8 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/4. Protecting Your Code.vtt 2.8 kB
  • 7. A Few More Essentials/7. Customizing the Quick Access Toolbar.vtt 2.7 kB
  • 7. A Few More Essentials/12. Highlighting Cells.vtt 2.7 kB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/4. Who's Presenting This....vtt 2.7 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/1. Intro To The Events Section.vtt 2.7 kB
  • 24. Automating All Your Reports!/5. Deconstructing The Profit By Day Code.vtt 2.7 kB
  • 9. Bonus Section Absolute and Relative Cell References/1. A1 Style - Relative Relative.vtt 2.6 kB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/10. Final Slide, And Wrap Up.vtt 2.6 kB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/6. Prettying Up The Formatting (More Lego Coding!).vtt 2.6 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/26. Capturing The Column Letter.vtt 2.5 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/13. The CurrentRegion Property.vtt 2.5 kB
  • 13. Project 2 - Building A Database With Excel/9. LOOKUP From A LOOKUP With No Intermediary Step.vtt 2.5 kB
  • 9. Bonus Section Absolute and Relative Cell References/3. $A1 Style - Absolute Relative.vtt 2.5 kB
  • 11. Excel Essentials Level 2 - IntermediateAdvanced/1. Intro To Level 2.vtt 2.5 kB
  • 3. Start Here - All The Basics/4. Always Do This First! - Save Your New Workbook!.vtt 2.5 kB
  • 25. The Data Is Out There...On The Internet, That Is/9. Putting It All Together.vtt 2.5 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/12. Looping With A Stepped For...Next.vtt 2.5 kB
  • 13. Project 2 - Building A Database With Excel/5. Importing Data From A Text File.vtt 2.4 kB
  • 9. Bonus Section Absolute and Relative Cell References/4. A$1 Style - Relative Absolute.vtt 2.4 kB
  • 15. Project 4 - What Can I Have For Dinner/15. PRACTICE EXERCISE 3 - Create A VLOOKUP Using A Built String With INDIRECT.vtt 2.3 kB
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/9. Keyboard Shortcuts, And Why I Don't Use Them.vtt 2.3 kB
  • 25. The Data Is Out There...On The Internet, That Is/1. Introduction To Web Query Section.vtt 2.3 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/9. WorkSheet Activate - You Can't Pick This!.vtt 2.2 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/17. Sheets Vs. Worksheets.vtt 2.2 kB
  • 3. Start Here - All The Basics/7. Editing Data.vtt 2.2 kB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/6. Calling A UDF From A Different Workbook.vtt 2.1 kB
  • 7. A Few More Essentials/10. Getting Help.vtt 2.1 kB
  • 3. Start Here - All The Basics/5. Let's Enter Some Data.vtt 2.1 kB
  • 7. A Few More Essentials/14. Closing.vtt 2.1 kB
  • 4. Doing The (Simple) Math/7. Basic Formulas - Multiplication.vtt 2.1 kB
  • 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/2. Using A UDF To Return Information.vtt 2.1 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/14. An Introduction To Logical Testing.vtt 2.1 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/20. PRACTICE EXERCISE 1 - Time To Add A New Entry.vtt 2.0 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2.7 ModCopyAndPaste.txt.txt 2.0 kB
  • 15. Project 4 - What Can I Have For Dinner/14. PRACTICE EXERCISE 2 - Pretty It Up (With A Macro).vtt 1.9 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/25. The Row and Column Properties.vtt 1.9 kB
  • 15. Project 4 - What Can I Have For Dinner/5. Creating A List For Our Dropdown Using A Dynamic Named Range.vtt 1.9 kB
  • 15. Project 4 - What Can I Have For Dinner/1. Welcome to What Can I Have For Dinner or...What Would I Use THAT for.vtt 1.9 kB
  • 4. Doing The (Simple) Math/8. Basic Formulas - Division.vtt 1.8 kB
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/14. ACTIVATE vs. SELECT.vtt 1.8 kB
  • 3. Start Here - All The Basics/10. A Quick Word On Formatting.vtt 1.7 kB
  • 26. Workbook Events You Don't Have To Run Code To Have Code Run!/4. WorkBook SheetChange.vtt 1.6 kB
  • 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/1. Intro To PowerPoint Section.vtt 1.6 kB
  • 3. Start Here - All The Basics/8. Ooops. I Made A Mistake - Undo and Redo.vtt 1.5 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/22. PRACTICE EXERCISE 2 - Set Up A Working Area, And Limit User Entry.vtt 1.5 kB
  • 24. Automating All Your Reports!/2. A Special Note For Office 2010 Users.vtt 1.5 kB
  • 34. Thank You - Your Special Bonus!/1. Get Your Next Course Now!.vtt 1.5 kB
  • 7. A Few More Essentials/3. Adding A New Worksheet.vtt 1.4 kB
  • 13. Project 2 - Building A Database With Excel/12. One Inherent Flaw In Vlook Up.vtt 1.4 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/9. An Introduction To Looping.vtt 1.3 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/7. A Neat Trick To Force Variable Declaration.vtt 1.2 kB
  • 15. Project 4 - What Can I Have For Dinner/13. PRACTICE EXERCISE 1 - Fill In The Blanks.vtt 1.1 kB
  • 2. An Introduction To Level 1/1. Where Are My Practice Files.vtt 1.1 kB
  • 28. Bonus Section Controlling Windows - Folder Creation Gizmo/2. Creating A New Folder With A Single Line Of Code.vtt 1.1 kB
  • 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/17. Before We Move On...Accessing The Developer Ribbon.vtt 1.1 kB
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/1. Introduction To The Programmers Toolbox.vtt 999 Bytes
  • 30. Bonus Section Word Automation - Controlling Word From Excel/1. Intro To The Word Section.vtt 979 Bytes
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2.3 ModLooping.txt.txt 833 Bytes
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2.2 ModText.txt.txt 345 Bytes
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/9.1 A link to the Official Microsoft Keyboard Shortcuts.html 181 Bytes
  • 8. Bonus Section - The Keyboard Shortcuts/2.1 Keyboards Shortcuts For Mac Users.html 179 Bytes
  • 21. Introducing Your Personal Built In Translator...the Macro Recorder/11. Section 2 Quiz.html 155 Bytes
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/32. Let's See How You're Doing....html 155 Bytes
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/40. Time For A Quick Quiz....html 155 Bytes
  • 3. Start Here - All The Basics/16. Quiz Number 2.html 155 Bytes
  • 3. Start Here - All The Basics/6. Quiz 1.html 155 Bytes
  • 4. Doing The (Simple) Math/3. Quiz Number 3.html 155 Bytes
  • 5. Rearranging Things/5. Quiz Number 4.html 155 Bytes
  • 7. A Few More Essentials/13. Quiz Number 6.html 155 Bytes
  • 7. A Few More Essentials/5. Quiz Number 5.html 155 Bytes
  • [FreeCourseLab.com].url 126 Bytes
  • 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/30.1 A really useful article from Microsoft on the different Types you can use with this Method.html 122 Bytes
  • 8. Bonus Section - The Keyboard Shortcuts/2.2 Microsoft Complete List Of Excel Keyboard Shortcuts.txt.txt 120 Bytes

随机展示

相关说明

本站不存储任何资源内容，只收集BT种子元数据(例如文件名和文件大小)和磁力链接(BT种子标识符)，并提供查询服务，是一个完全合法的搜索引擎系统。 网站不提供种子下载服务，用户可以通过第三方链接或磁力链接获取到相关的种子资源。本站也不对BT种子真实性及合法性负责，请用户注意甄别！
>