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

Numbers by themselves seldom convey the big picture. Excel Charts makes it easy to illustrate trends in your business, from past expenses and profit to sales forecasts based on previous sales. T*o* ...

Array constants can only contain text in double quotes, plain numbers (no currency symbols or percent signs), or Boolean ...

By default, when you select a formula or source field in a dialog box, Enter mode is activated. You can see this in the ...

Microsoft Excel is an incredibly capable and complex spreadsheet program. If you’re just getting your feet wet, these tips will help you get started on making a spreadsheet and writing a formula. Once ...

Excel can feel like a maze of endless rows, columns, and formulas, especially when you’re trying to create something as detailed as a loan repayment report. If you’ve ever found yourself overwhelmed ...

Fractions are enough to make you cry if you’re not a math whiz, but Microsoft Excel handles them very well. In fourth-grade math, you learned fraction basics: Fractions are a numerical representation ...

Susan Harkins shows you how to format and unlock input cells in Excel at the same time by assigning a modified style. It’s common to highlight input cells so users know which values to change, and ...