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

In Excel 2007, no features or functions are where they used to be. But it’s easy to find them. Use our Excel 2007 quick reference charts for an extensive list of where to find your old friends.

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.

Excel isn't the sexiest application in the world—it has an unfortunate association with the type of Milton-esque office drones we all wish we weren't. All ...

B ecause Microsoft Excel has many tabs, groups, and menus on the ribbon, it can sometimes be difficult to quickly find the command you're looking for. To help you with this, we've created a cheat ...

Excel 101: Foundational formulas These are the Excel skills I first introduce to new hires who are expected to take on performance reporting and bulk sheet builds .

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite ...

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

Finding the length of a cell isn’t that useful for SEO, though. Normally, we’d want to apply a function to an entire column! In Excel, this would be achieved by selecting the formula cell on ...