Tilde skills Developing & Using Complex Spreadsheets plus Challenges and Assessment Tasks - Microsoft Excel 2010 contributes directly to achieving the unit of competency BSBITU402A Develop and use complex spreadsheets in the Business Services Training Package (BSB07). This text would also be of interest to any student undertaking a spreadsheet course in Excel 2010 which takes their skills to a complex level.
The Tilde Group
About the book
Table of Contents
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.
BSBITU402A – Develop and use complex spreadsheets
About the authors
The Tilde Group is the authoring entity for Tilde Publishing and Distribution's TILDE skills imprint.