Skip to main content

Top 25 Excel Tips and Tricks

11/19/2018

Summary

This video contains 25 basic Excel tricks that gives learners a glimpse of what Excel can do. Below is the list in numerical order that is shown in the video.

Key Points

  • Quick Tool Analysis
  • Filter
  • Drop-Down List
  • AutoFit Column Width
  • Transpose
  • Remove Duplicates
  • Goal Seek
  • VLOOKUP
  • Flash and Auto Fill
  • Paste Special Value
  • Images in Chart
  • IF Function
  • Insert Screenshot
  • Absolute Cell Reference
  • Show Formulas
  • Text to Columns
  • Conditional Formatting
  • PowerPivot
  • Freeze Panes
  • Ctrl-Arrow Keys
  • 3D References
  • Forecast Sheet
  • SUMMIFS Function
  • IFERROR Function
  • Filled Maps

Discussion Questions

  1. What business situations might require these functions? 

Link to full article