ITFM+LO3+Spreadsheets

=ITFM LO3= =Spreadsheets=

♦ working with cells and cell data: — cell formatting including conditional cell formatting — comments — add, edit, remove

♦ managing workbooks: — insert common data or formulae and formats simultaneously (linking worksheets) — insert page breaks

♦ working with named cells and ranges of cells: — modify a range

♦ data consolidation: — summary worksheets/files using 3D references; pivot tables; pivot charts

♦ functions: — countif — round mathematical function — V and H lookups

♦ sorting: — filtering on two criteria — grouping and outlining

♦ charts: — customise data series in rows and columns

♦ importing data from external source: — table from word processing document — data from a database table

♦ exporting dynamically linked data: — link spreadsheet data as a table and/or chart in a word processing document

♦ print: — completed worksheet/s and sections from worksheets in value and formulae view — separate and embedded charts