Man on computer

Tips & Tricks for Using Microsoft Excel – Video

Join BEI President and self-professed Excel junkie, Mike Jennings, as he discusses and demonstrates intermediate skills in Microsoft Excel.
In this video we cover:

  • Freeze Panes
  • Find Duplicate Values
  • Copy/Move Worksheet
  • Integrating data from separate Worksheets/File (XLOOKUP)
  • Filtering
  • Selecting visible cells only
  • Date calculation (YEARFRAC)
  • Simple sorting
  • Customizing your Quick Access bar
  • Subtotaling filtered data
  • Flash fill
  • Sparklines