«My 6 favorite Excel features that almost nobody talks about»

My 6 favorite Excel features that almost nobody talks about
www.makeuseof.com/favorite-excel-features-that-almost-nobody-talks-about/

  1. F4 to repeat your last action. The fastest way to apply formatting without touching your mouse
  2. The Filled Map. Turn location data into a real map in two clicks 
  3. Show All Formulas (Ctrl + `). One shortcut to audit a sheet without clicking cell-by-cell
  4. Start with an apostrophe to force text entry. When you want Excel to stop helping and keep what you typed
  5. Convert your data range into a table (Ctrl + T). The easiest way to keep your data structured and expandable
  6. Name Manager (Ctrl + F3). Keep your formulas readable