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
