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

Tilde skills Develop & Use Complex Spreadsheets: Plus Challenges and Assessment Tasks, Excel 2010, 2nd Edition

by: Tilde Publishing and Distribution

Notify me when in stock

On-line Price: $28.95 (includes GST)

Paperback package 210

5%Off Retail Price

You save: $2.00

Usually Ships within 1 week.

Retail Price: $30.95

Publisher: ,01.01.12

Category: TAFE I.T/Computing Level: B/I/A

ISBN: 0734607954
ISBN13: 9780734607959

Add to Shopping Cart


Tilde skills Develop and Use Complex Spreadsheets with applications in Excel 2010 contributes to achieving the unit of competency BSBITU402A 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 2010 which takes their skills to a complex level.

In response to customer feedback, this text now will include more on:

- linking
-subtotals and outlining
- conditional formatting
- consolidating data
- new function exercises
- expanded Workplace Scenarios

Learning Outcomes:

- BSBITU402A Develop and use complex spreadsheets
- Prepare to develop spreadsheet
- Develop a linked spreadsheet solution
- Automate and standardise spreadsheet operation
- Use spreadsheets
- Represent numerical data in graphic form

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