Large numbers always look much better on a chart axis in Microsoft Excel when abbreviated. For example, 7.9 M instead of 7,899,456. Just use the appropriate custom number format code.
Each row of your source data might have a date. These dates and corresponding values can roll up into a month, a quarter or a year through Pivot Table date grouping, e.g. it can give a single figure for February sales from all your daily sales for February.
You can add, subtract, multiply and divide in Microsoft Excel using basic formulas. Also, the SUM function for adding up a range of cells or "&" to join text from different cells can be very useful too in basic Microsoft Excel formulas.
Two spreadsheets can be linked together by a formula in a cell in the destination spreadsheet which references a cell in the source spreadsheet.
Your spreadsheet column of numbers can be represented by a line on your line chart or graph. I explain the different ways you can add another line.
Use Data Validation to create great dropdown lists in any cell. These dropdown lists can even be interconnected via the INDIRECT function.
Use COUNTIF to match two lists.
“Add a column” might mean either insert a new column or just calculate its total.
I identify three ways to get a sum of multiple sheets in Microsoft Excel.
I outline two of the ways to multiply two columns and sum in Microsoft Excel.