8 Excel tricks that I wish I knew when I had just started using it
www.makeuseof.com/excel-tricks-wish-i-knew-when-just-started-using-it/
- Flash Fill can save you from writing complex formulas. It detects patterns and fills data for you
- Freeze Panes keeps your headers visible. Don’t scroll back to the top every time you lose track of a column
- Paste Special lets you paste only what you need.
- Lock your cell references with the dollar sign.
- Conditional formatting makes data stand out.
- Master the Ctrl + Arrow shortcuts for navigation.
- Quick Analysis tool lets you visualize data in seconds.
- Data Validation helps you prevent errors.