| ISBN: |
978-0-7346-0886-4 |
| Edition: |
First Edition |
| Pages: |
200 pp. |
| Publication date: |
2017 |
| Format: |
Paperback |
| Trim size: |
200 mm x 250 mm |
About the Book:
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 Training Package.
This text would also be of interest to any student undertaking a spreadsheet course in Excel 2016 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 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.