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.
Author: Marty
Pivot Table date grouping
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.
Basic Microsoft Excel formulas
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.
Link cells in different Microsoft Excel spreadsheets
Two spreadsheets can be linked together by a formula in a cell in the destination spreadsheet which references a cell in the source spreadsheet.
Add another line to a graph
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.
Great dropdown lists in any cell
Use Data Validation to create great dropdown lists in any cell. These dropdown lists can even be interconnected via the INDIRECT function.
Match two lists
Use COUNTIF to match two lists.
Add a column
“Add a column” might mean either insert a new column or just calculate its total.
sum of multiple sheets
I identify three ways to get a sum of multiple sheets in Microsoft Excel.
Multiply two columns and sum
I outline two of the ways to multiply two columns and sum in Microsoft Excel.