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.
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.
When downloading reports from a system, sometimes dates are not recognised by Microsoft Excel. However, you can still convert them into the proper date format.
NOW, DATE and WEEKNUM - just some of the useful functions to use in your Date formulas.