Learn how to use basic Formulas for mathematical operations & insert Functions like sum, average, count, max, min, date, time, etc. in Excel.

How to Do the Sum of an Indefinite Series in Excel. The Microsoft Excel program includes a variety of mathematical formulas that you can apply to any cell in a spreadsheet.

How to Enter Formulas in Excel If you're relatively new to Excel, entering a formula is quite easy, even if you have a lot of data.

Every Excel expert knows how to navigate without a mouse and how to format data using keyboard shortcuts. But do you know how to insert a sum without typing the formula?

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

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.

Reviewed by Charlene Rhinehart Fact checked by Vikki Velasquez Businesses depreciate long-term assets for both tax and accounting purposes. For tax purposes, businesses can deduct the cost of the ...