Develop and Use Complex Spreadsheets: Getting Results – Excel 2016 contributes directly to achieving the unit of
competency BSBITU402 Develop and use complex spreadsheets in the Business Services
would also be of interest to any student undertaking a spreadsheet course in
Excel 2016 which takes their skills to a complex level.
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 PivotTables, subtotals, grouping and outlines,
conditional formatting, consolidated data, macros and templates;
70 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; and
additional appendix material including keyboard shortcuts, saving to
PDF & Help.
Excel 2016 exercises.rar
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.