Develop and Use Complex Spreadsheets

This text will be of interest to any student undertaking a spreadsheet course in Excel 2013 which takes their skills to a complex level. Key features include: creating complex worksheets which include a variety of functions, linked worksheets, charts, imported and exported data, filtered data using tables and PivitTables, subtotals, grouping and outlines, conditional formatting, consolidated data.

---

Tilde skills Develop and Use Complex Spreadsheets – Microsoft Excel 2013, contributes 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 2013 which takes their skills to a complex level.

Key features of this course:

creating complex worksheets which include a variety of functions (including nested functions), linked worksheets, charts, imported and exported data, filtered data using tables and PivitTables, subtotals, grouping and outlines, conditional formatting, consolidated data, macros and templates
68 hands-on exercises, 11 consolidation tasks, 3 workplace scenarios, 10 Skills challenges and 5 Assessment tasks that bring skills together and can act as assessment tools
additional appendix material including keyboard shortcuts and Help.