Excel 2007’s new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you! Tables are new to Excel 2007 ...

Most spreadsheet problems come from static cell ranges—Excel tables replace them with dynamic, self-managing data structures.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn’t. Using an old function and a matrix tames the problem. The article How to easily ...

Regardless of whether your Excel spreadsheet contains a little or a lot of data, you may want to have cells that meet certain criteria stand out. Excel lets you set some conditional formatting rules ...

Turn a simple Excel grid into a dynamic project tracker with automated dates, progress bars, and weekend highlighting.

As an Excel pro, I could use the old Excel 2003 menus with my eyes closed. I knew where commands were located. I knew the Alt shortcut keys for the commands that I used frequently. Alt+E+S+V was Edit, ...