A quick keyboard shortcut puts you right into the Formula bar. You don't need the mouse at all! When entering formulas, you select a cell and start typing. To edit an existing formula, you probably ...

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 ...

Slow lookup formulas can kill productivity when working with large datasets. To cope with that, I've tested Excel's optimal lookup functions and their combinations for building lightning-fast formulas ...