Excel topics (tentative)

1. Creating, opening and saving a spreadsheet. Page setup, printing.
2. Find and replace (including all wildcards).
3. Grouping and ungrouping worksheets. Copying a worksheet, inserting a blank worksheet.
4. Absolute, relative and mixed cell references. What they are, how to use them.
5. Editing a worksheet: inserting, moving, deleting cells, rows and columns. Formatting (colors, borders, orientation, row height, column width, etc).
6. Formatting text, numbers, etc. Custom formats. Conditional formatting.
7. Summations, formulas. Naming columns and rows and using those names in formulas. Autofill.
8. Charts. Creating, formatting a chart, adding new data, removing data. Editing a chart.
9. Autofilters. Custom filters.
10. Macros.
11. Sorting. Subtotals. Pivot tables.