TY - BOOK AU - Tilde Skills TI - Develop and use complex spreadsheets : : plus challenges and assessment tasks : Microsoft Excel 2010 SN - 9780734607959 U1 - 005.52 TIL 2012 PY - 2012/// CY - Prahran, Vic. PB - Tilde Publishing and Distribution KW - Business Computer programs KW - Electronic spreadsheets KW - Microsoft Excel (Computer file) KW - Tableaus N1 - "Tilde skills"--Cover N2 - Topic 1 - Spreadsheet skills reviewed, Topic 2 - Formulas in Excel, Topic 3 - Functions in Excel, Topic 4 - Using statistical functions, Topic 5 - Viewing and adjusting worksheets, Topic 6 - Using date & time functions, Topic 7 - Using logical functions, Topic 8 - Creating and editing templates, Topic 9 - Using lookup functions, Topic 10 - Using maths functions, Topic 11 - Charting and pictures in Excel, Topic 12 - Using financial functions, Topic 13 - Useful text functions, Topic 14 - Working with data in tables, Topic 15 - Creating PivotTables and PivotCharts, Topic 16 - Useful database functions, Topic 17 - Importing & exporting data, Topic 18 - Linking Excel data to other programs, Topic 19 - Tools for summarising data, Topic 20 - Conditional formatting, Topic 21 - Creating macros ER -