Excel Tips and Tricks

In this step-by-step tutorial, learn the best 11 Microsoft Excel Tips and Tricks that are sure to make your work easier and more efficient. As a few examples, with these hacks, you can move columns with just a simple drag and drop, sum up all the values with just a simple shortcut key, and pick out just the information you want from a column.

• Additional resources
  • Sample workbook to follow along
  • Full course on formulas and functions in Microsoft Excel
• Timestamps
  • 0:00 Introduction
  • 0:34 Drag and drop to move columns
  • 2:38 Auto sum with ALT + =
  • 4:01 Calculations with paste special
  • 5:52 Unique count
  • 7:06 Complicated functions
  • 8:45 Custom lists
  • 10:34 Named ranges
  • 12:33 Status bar metrics
  • 13:39 Flash fill
  • 15:00 CTRL + Enter
  • 17:27 Quick access toolbar
  • 18:57 Wrap up