Your Excel formulas cheat sheet: 22 tips for calculations and common tasks. Max Productivity By JD Sartain, Dec 29, ... This one is easy: Select DATEVALUE from the formula list.

Conditional Formatting is your Friend. If formulas aren’t your thing, here’s an easy way to duplicate data between two columns. Highlight the columns and select Excel’s Conditional ...

But it’s easy to find them. Use our Excel 2007 quick ... so it’s fortunate that Excel 2007 lets you drag the corner of the formula bar to expand it. Excel 2007 ... Excel 2007 Cheat Sheet; ...

To learn more about Excel functions and formulas, read my past stories, including an Excel formula cheat sheet and a guide to the most popular Excel formulas. JD Sartain / IDG Worldwide.