Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
Call our store: 9955 5567 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
Browse by Subject
 TAFE Accounting
 TAFE I.T./Computing
 TAFE - Other
 Windows 8
 Adobe CS6
 CCNA 2012
 CCNP 2012
 Web Design
 Project Management
 Mobile Devices
 Windows Server 2012
 SQL Server 2012
Economics and Business
 Business Information Systems
 Human Resources

Develop And Use Complex Spreadsheets: Microsoft Excel 2013


Notify me when in stock

On-line Price: $32.95 (includes GST)

package 204

0%Off Retail Price

You save: $0.00

TBA. This item is currently out of stock, with no due date for more to arrive. Please contact Bookware customer service for more information.

Retail Price: $32.95

Publisher: Tilde Skills,30.06.14

Category: Level: B/I/A

ISBN: 0734608551
ISBN13: 9780734608550

Add to Shopping Cart


Institution: Coffs Harbour Campus - NCIT (North Coast Inst of TAFE) - 2014 Third Term
Course Code: 17808
Subject: Certificate IV Business Administration

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 templates68 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 toolsadditional appendix material including keyboard shortcuts and Help.

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 & 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
Workplace scenarios
Skills challenges
Assessment tasks
Appendix I - Keyboard shortcuts
Apendix II - Additional topics