Intermediate Excel Skills, Tips, and Tricks

Intermediate Excel Skills, Tips, and Tricks

Technology for Teachers and Students via YouTube Direct link

Beginners Guide to Excel Macros - Create Excel Shortcuts

17 of 115

17 of 115

Beginners Guide to Excel Macros - Create Excel Shortcuts

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Intermediate Excel Skills, Tips, and Tricks

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Intermediate Excel Skills, Tips, and Tricks Tutorial
  2. 2 Excel Tutorial - Using the Split Option to See Your Data
  3. 3 Excel Find and Replace Tutorial
  4. 4 Navigating Within an Excel Spreadsheet
  5. 5 Excel Print Options, Tips and Tricks Tutorial
  6. 6 Sorting in Excel
  7. 7 Linking Shapes to Data in Excel
  8. 8 Using the Screenshot Tool in Word, PowerPoint and Excel
  9. 9 Excel for Mac Intermediate Skills, Tips, and Tricks
  10. 10 Hiding Data in Excel
  11. 11 Excel Conditional Formatting in Depth
  12. 12 Excel Conditional Formatting Advanced Technique
  13. 13 Fixing Improper Capitalization in Excel Using the Proper Function
  14. 14 Adding a Scroll Bar in Excel
  15. 15 Using the Trim Function in Excel
  16. 16 Using Find and Replace and Wildcards in Excel
  17. 17 Beginners Guide to Excel Macros - Create Excel Shortcuts
  18. 18 Beginner's Guide to Excel Dashboards
  19. 19 Using the Excel Today Function to Set Target Dates
  20. 20 Using Excel Slicers to Filter Data
  21. 21 Combining Data From Multiple Cells in Excel
  22. 22 Advanced Excel - Using "Recommended Pivot Tables"
  23. 23 Most Useful Excel Keyboard Shortcuts
  24. 24 Excel Split Names Tutorial
  25. 25 Creating Your Own Excel Templates
  26. 26 Advanced Excel - Protecting a Sheet - Excel Tutorial
  27. 27 Dealing with Duplicates in Excel and Finding Unique Data
  28. 28 Using Checkboxes in Excel - Part 1
  29. 29 Using Checkboxes in Excel - Part 2
  30. 30 Quickly Enter Current Date and Time in Excel
  31. 31 Creating Easy Data Entry Forms in Excel
  32. 32 Fixing Common Excel Errors - Part 1: DIV/0, N/A, & NAME?
  33. 33 Benefits of Naming Cells in Excel
  34. 34 Advanced Excel - Flash Fill Tutorial
  35. 35 Fixing Common Excel Errors - Part 2: NULL, NUM & #####
  36. 36 Fixing Common Excel Errors - Part 3: REF and VALUE
  37. 37 Using the New IFS Function in Excel
  38. 38 Using LEFT RIGHT & MID Functions in Excel
  39. 39 Using the Camera Tool in Excel
  40. 40 Using Watch Windows in Excel
  41. 41 Intermediate Guide to Excel Dashboards
  42. 42 Using Spin Buttons in Excel
  43. 43 Creating Pie Charts in Excel
  44. 44 Generating Random Numbers in Excel
  45. 45 Automatically Open Several Excel Files
  46. 46 Mail Merge from Excel to Microsoft Word
  47. 47 Beginner's Guide to Excel Get & Transform / Power Query
  48. 48 Intermediate Guide to Excel Get & Transform / Power Query
  49. 49 Customize the Excel AutoFill Handle
  50. 50 Inserting Excel Data into Microsoft Word
  51. 51 Creating Organization Charts in Excel
  52. 52 Using the Excel Data Types Tools
  53. 53 Excel's LARGE Function and SMALL Function
  54. 54 Using Excel Hyperlinks
  55. 55 The Excel FORECAST Function
  56. 56 The Excel Quartile Function
  57. 57 Mail Merge Envelopes in Microsoft Word
  58. 58 The Excel TRANSPOSE Function
  59. 59 Compare and Contrast Excel Ranges
  60. 60 Combining Excel Data by using TEXTJOIN or Flash Fill
  61. 61 Create an Excel Macro from Scratch: AutoFit Columns
  62. 62 Excel: INDEX and MATCH
  63. 63 Excel Relative vs Absolute Cell References
  64. 64 Create Interactive Worksheets in Excel by Using the IF and COUNTIF Functions
  65. 65 Create a Go Full Screen Macro in Excel and How to Create Custom Excel Buttons
  66. 66 Two Excel Dynamic Array Functions: UNIQUE and SORT
  67. 67 Using Excel's XLOOKUP Function
  68. 68 Create an Excel Macro that Highlights Rows
  69. 69 Using Linked Data Types in Excel
  70. 70 Making Excel Spreadsheets Hidden or Very Hidden
  71. 71 Create a Map Chart in Excel
  72. 72 How to Break Password Protection from a Protected Excel Sheet
  73. 73 Convert Excel Data into a Google Map
  74. 74 The Excel Format Painter - Basics and Beyond
  75. 75 Automatically Highlight Blank Cells and Errors in Excel
  76. 76 How to Add a Check Mark or Tick Mark Symbol in Excel
  77. 77 Shortcuts for Editing Text in Excel
  78. 78 Date Functions and Formulas in Excel
  79. 79 Excel Formatting Shortcuts
  80. 80 Use the Excel TEXT Function to Display Numbers as Words
  81. 81 The Excel IFERROR Function: Clean up Your Excel Errors
  82. 82 Create Random Student Picker or Raffle Picker in Excel
  83. 83 Combining Excel's LEFT and Find Functions
  84. 84 Adding Videos, Sounds, and Documents into Excel
  85. 85 Create an XY Scatter Chart in Excel
  86. 86 Spruce up Your Excel Spreadsheets with Find and Replace
  87. 87 Three Ways to Create Excel Shortcuts
  88. 88 Create Dynamic Dropdown Lists in Excel
  89. 89 Grouping Rows and Columns in Excel
  90. 90 Using the Excel ROMAN and ARABIC Functions
  91. 91 Using the Excel SUBSTITUTE Function
  92. 92 The Excel HYPERLINK Function
  93. 93 Excel Sparklines - Charts within Cells
  94. 94 Using the Excel ROUND Functions
  95. 95 Using the Excel LARGE and SMALL Functions
  96. 96 Using the Excel RANDARRAY Function
  97. 97 Convert Photos into Data in Excel
  98. 98 Using the Excel SUBTOTAL Function
  99. 99 Excel VSTACK and HSTACK Functions
  100. 100 Sorting by Custom Lists in Excel
  101. 101 Excel for Intermediate Users - The Complete Course
  102. 102 Use the LEN and SUBSTITUTE Functions to Make an Excel Formula for Word Count
  103. 103 Trick Out Your Excel Quick Access Toolbar with these Hidden Powerful Features
  104. 104 Use ChatGPT and Artificial Intelligence to Unlock the Hidden Power of Excel
  105. 105 The Excel COUNTIF and COUNTIFS Functions
  106. 106 How to Combine Multiple Excel Workbooks into One
  107. 107 Five Microsoft Excel Settings You MUST Change (Save Time & Stress!)
  108. 108 The Excel TRIMMEAN Function
  109. 109 The Excel DAYS Function is INCREDIBLE (Easy Tutorial)
  110. 110 Unlock Excel Sorting Secrets with the SORTBY Function
  111. 111 How to Hide and Lock Your Excel Formulas
  112. 112 The Excel DGET Function is Better Than XLOOKUP!
  113. 113 How to Easily Build Excel Pivot Tables from Scratch!
  114. 114 Hot Excel Keyboard Shortcuts - Beyond the Basics
  115. 115 Fix Improper Capitalization with the Excel PROPER Function #shorts

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.