Spreadsheets: arithmetic and logic functions, sorting and filtering lists, automatic calculation of subtotals, the VLOOKUP function, the goal seek tool, charts, and pivot tables.
Syllabus:
1. Relative and absolute references, select a cell, range of cells adjacent or non-adjacent
2. Entering numbers, dates, or text in a cell, use the autofill tool to copy or build data sets or formulas
3. Using some logical-mathematical functions: IF, SUM, COUNTIF, SUMIF, VLOOKUP, subtotals; functions MID and CONCATENATE
4. Using lists: sorting on one or more fields, automatic and standard filters, subtotals
5. Using goal seek feature
6. Charts: types and their use, common mistakes
7. Pivot tables: building a pivot table from a list, filters and charts