Excel 2007 Cheat Sheet PowerPoint 2007 Cheat Sheet If you’ve spent years getting to know Excel’s old interface, you’ll likely be frustrated at having to learn a whole new interface.

Use the Insert Function button under the Formulas tab to select a function from Excel’s menu list: =COUNT(B4:B13) Counts the numbers in a range (ignores blank/empty cells).

If you need a refresher, see our Excel 2010 cheat sheet. As in Excel 2013, ... head to Microsoft’s helpful “6 new Excel functions that simplify your formula editing experience” post.