Impress your coworkers with these nifty tricks.

Please note: This item is from our archives and was published in 2006. It is provided for historical reference. The content may be out of date and links may no longer function. Is there a way to ...

Formulas are one of the most important components of an Excel sheet and as such, deserve–warrant–protection. You don’t want users accidentally changing formulas and impacting the purpose of your work.

Excel formulas are a powerful way to quickly manipulate and display the data in your spreadsheets to your exact specifications. Once you've created an effective formula for your data, you may want to ...

These four overlooked Excel features completely changed how I design spreadsheets.

In Microsoft Excel, the Formula Bar is the toolbar at the top of the spreadsheet that lets you enter or view the information in a cell; instead of calculating a long formula in your cell, it can be ...

Have you ever stared at a sprawling Excel spreadsheet, wondering how to make sense of the chaos? For many, Excel formulas feel like a secret language, powerful yet elusive. But here’s the truth: ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...