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


File Information

File Size:   5.32 GB
Creat Time:   2024-07-15
Active Degree:   42
Last Active:   2024-11-09
Magnet Link:    Magnet LinkMagnet Link
Statement:   This site does not provide download links, only text displays, and does not contain any infringement.

File List

  1. 33. Student Questions Answered/17. Vlookups (Or Any Application.WorksheetFunction) Over Ranges.mp4 139.46 MB
  2. 33. Student Questions Answered/5. Saving Multiple Sheets To A Single Workbook In A Specific Folder.mp4 82.88 MB
  3. 18. Student Questions Answered!/11. Data Validation With Dependent Drop downs (Dynamic Named Range Workaround).mp4 79.46 MB
  4. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/14. WorkSheet Events - BONUS - 4 New Things To Try.mp4 79.21 MB
  5. 33. Student Questions Answered/13. File Picker, And Report Generator With Intelligent Filing.mp4 59.90 MB
  6. 18. Student Questions Answered!/12. Using 2 Labels As A Lookup From Drop-downs.mp4 56.97 MB
  7. 10. Bonus Section Student Questions Answered!/1. Reverse Engineering A Sample Spreadsheet.mp4 55.20 MB
  8. 3. Start Here - All The Basics/2. The Anatomy Of A Workbook Where Everything Is, And What It Does!.mp4 50.76 MB
  9. 33. Student Questions Answered/12. Sequential PDF Creation With Pictures.mp4 50.17 MB
  10. 14. Project 3 - Named Ranges/7. 3035 - POWER USER - Dynamic Charts.mp4 49.77 MB
  11. 33. Student Questions Answered/18. Adding A Date Stamp If A Change Has Been Made.mp4 48.55 MB
  12. 32. Importing Specific Data From Multiple Files/5. The Data Grabber(er).mp4 47.06 MB
  13. 33. Student Questions Answered/9. Extracting Unique Tables to Unique Sheets From A Big Data Set.mp4 45.95 MB
  14. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/39. Arrays - Using An Array As A Data Source For A VLookup.mp4 44.64 MB
  15. 10. Bonus Section Student Questions Answered!/2. Casing And Text Functions.mp4 44.54 MB
  16. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/16. Building Text Strings With A Formula.mp4 44.50 MB
  17. 14. Project 3 - Named Ranges/8. 3040 - Horizontal Dynamic Named Ranges For Charts.mp4 43.63 MB
  18. 18. Student Questions Answered!/4. What Is The CHOOSE Function Really Used For.mp4 41.50 MB
  19. 19. Excel Essentials Level 3 - VBA Programming/1. Why Should I Learn How To Code.mp4 40.60 MB
  20. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/9. Adding Pivot Tables (And Another Chart).mp4 39.62 MB
  21. 18. Student Questions Answered!/2. Calls Text Data 2 - This Time Using Text!.mp4 39.58 MB
  22. 33. Student Questions Answered/7. Extracting Specific Data From A Big File, To A Bunch Of Little Ones.mp4 39.02 MB
  23. 18. Student Questions Answered!/10. Data Validation With Dependent Drop-downs.mp4 38.28 MB
  24. 18. Student Questions Answered!/6. Dynamic Charting From A Drop Down.mp4 38.24 MB
  25. 21. Introducing Your Personal Built In Translator...the Macro Recorder/5. With And End With.mp4 37.95 MB
  26. 21. Introducing Your Personal Built In Translator...the Macro Recorder/10. Why You Can't Get By With Just Recording Macros.mp4 36.71 MB
  27. 21. Introducing Your Personal Built In Translator...the Macro Recorder/1. Introducing The Visual Basic Editor, & Recording Our First Macro.mp4 36.21 MB
  28. 8. Bonus Section - The Keyboard Shortcuts/2. Bonus 2 Keyboard Shortcuts.mp4 36.19 MB
  29. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/9. Creating A Template From An Image.mp4 35.54 MB
  30. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/19. Auto-populating Check Boxes.mp4 34.97 MB
  31. 33. Student Questions Answered/16. Gantt Charts...With A Little More Sophistication!.mp4 33.97 MB
  32. 33. Student Questions Answered/10. Protecting Specific Cells and Data Validation.mp4 33.34 MB
  33. 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 33.24 MB
  34. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/8. Adding A Chart As A Picture.mp4 32.00 MB
  35. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/5. Adding A Slide With A Logo And Text.mp4 30.92 MB
  36. 33. Student Questions Answered/4. Saving An Individual Sheet To A Specific Folder.mp4 30.43 MB
  37. 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/5. Gantt Charts Using The Built In Charting Tools.mp4 30.29 MB
  38. 29. Bonus Section eMail Automation...Why WRITE emails!/3. Deconstructing How We Capture All The Data.mp4 30.28 MB
  39. 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/3. Multiple Logical Tests At Once Using AND.mp4 30.21 MB
  40. 33. Student Questions Answered/15. Finding Updated Values In One Workbook, And Adding Them To Another Workbook.mp4 30.08 MB
  41. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/18. A Tick Box Exercise (Of Sorts).mp4 28.90 MB
  42. 13. Project 2 - Building A Database With Excel/16. POWER USER - Dealing With Inconsistencies In User Entry.mp4 28.83 MB
  43. 13. Project 2 - Building A Database With Excel/25. Putting It All Together.mp4 28.74 MB
  44. 24. Automating All Your Reports!/14. Adding The Commentary - Building Strings Dynamically At Runtime.mp4 28.68 MB
  45. 17. Bonus Section - Just For Fun/1. How I Created Randomly Generated License Plate Numbers!.mp4 28.44 MB
  46. 21. Introducing Your Personal Built In Translator...the Macro Recorder/6. Streamlining You Code, Or, Get Rid Of What You Don't Need.mp4 27.59 MB
  47. 33. Student Questions Answered/14. Help! My File Has Got HUGE!.mp4 26.91 MB
  48. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/38. Arrays - Extracting Useful Data Based On User Input.mp4 26.68 MB
  49. 21. Introducing Your Personal Built In Translator...the Macro Recorder/4. Stepping Out. Well, In Actually! - Debugging Made Easy ).mp4 26.45 MB
  50. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/13. Looping With While...Wend.mp4 26.43 MB