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.

Excel’s auditing tools are found, fittingly enough, on the Formulas tab in the Formula Auditing group, as shown in the screenshot below: Here’s how to use the tools.

Either go to the Formulas tab and select Insert Function in the ribbon or use the Insert Function button to the left of the Formula Bar.

The Draw tab is not on Excel's ribbon by default. Learn how to enable, add and use the Draw tab and the various drawing tools in Excel.

Press F10, and small letters appear over each ribbon tab and quick access toolbar item. Alt+H takes you to the Home tab, Alt+N to Insert, and so on. Once in a tab, additional letters appear for ...

Learn how to define, use & delete names in Excel formulas. It becomes easier to identify & comprehend data when you can add Names to it.

Use Excel in your rate card formulas to calculate discounts, dimensions and unit costs of your advertising rate document. Instead of manually calculating each of these components, use Excel ...