Use calculated columns in an Excel table - Microsoft Support
Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the rest of the column by itself. There’s no need to use the Fill or Copy commands.
Use Excel as your calculator - Microsoft Support
Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature to quickly total a series of values without entering them manually in a formula.
When to use Calculated Columns and Calculated Fields
Use calculated columns. If you want your new data to appear on ROWS, COLUMNS, or in FILTERS in a PivotTable, or on an AXIS, LEGEND, or, TILE BY in a Power View visualization, you must use a calculated column.
Use calculated columns in a table in Excel for the web
A calculated column uses a single formula that adjusts for each row and automatically expands to include additional rows in that column so that the formula is immediately extended to those rows. You only need to enter a formula to have it automatically filled down to create a calculated column—there’s no need to use the Fill or Copy command.
Use AutoSum to sum numbers - Microsoft Support
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you’re done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example.
Create a simple formula in Excel - Microsoft Support
How to create simple formulas in Excel using AutoSum and the SUM function, along with the add, subtract, multiply, or divide values in your worksheet.
Count the number of rows or columns in Excel - Microsoft Support
Count the number of rows, columns, or cells in Excel by using the status bar at the bottom of the Excel screen. You can also customize the status bar.
Sum a column or row of numbers in a table - Microsoft Support
=SUM(ABOVE) adds the numbers in the column above the cell you’re in. =SUM(LEFT) adds the numbers in the row to the left of the cell you’re in. =SUM(BELOW) adds the numbers in the column below the cell you’re in.
Calculate the difference between two dates - Microsoft Support
How to calculate the number of days, months, or years between two dates using the DATEIF function in Excel.
Use Excel as your calculator in Excel for Mac - Microsoft Support
Instead of reaching for your calculator, use Excel to do the math! On a sheet, you can enter simple formulas to add, subtract, multiply, and divide two or more numeric values. Once you have created a formula, you can fill it into adjacent cells — no need to create the same formula over and over again.