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

磁力链接/BT种子名称

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

磁力链接/BT种子简介

种子哈希：f3619551cb2ee247597330a8e2d5e1a9d0d9b266
文件大小： 5.2G
已经下载：877次
下载速度：极快
收录时间：2022-02-04
最近下载：2025-09-25

移花宫入口

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

磁力链接下载

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

下载BT种子文件

磁力链接 迅雷下载 PIKPAK在线播放 世界之窗 91视频 含羞草 欲漫涩 逼哩逼哩 成人快手 51品茶 抖阴破解版 极乐禁地 91短视频 抖音Max 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
  • 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
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2.5 Mod01_TheBasics.txt.txt 12.7 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
  • 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
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2.4 ModLogicalTesting.txt.txt 9.2 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
  • 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
  • 13. Project 2 - Building A Database With Excel/5.1 Department Structure.txt.txt 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
  • 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
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2.7 ModCopyAndPaste.txt.txt 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 766 Bytes
  • [DesireCourse.Com].txt 754 Bytes
  • 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2.2 ModText.txt.txt 331 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
  • 8. Bonus Section - The Keyboard Shortcuts/2.2 Microsoft Complete List Of Excel Keyboard Shortcuts.txt.txt 120 Bytes
  • [DesireCourse.Com].url 51 Bytes

随机展示

相关说明

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