Numbers by themselves seldom convey the big picture. Excel Charts makes it easy to illustrate trends in your business, from past expenses and profit to sales forecasts based on previous sales. T*o* ...

These four overlooked Excel features completely changed how I design spreadsheets.

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.

Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use those ...