(JavaScript element disabled)

ciatraining.co.uk Visit us on Facebook Visit us on Twitter  

This web site uses cookies to enhance your visit. By browsing this site you agree to our use of cookies. Find out more. Close Notification
 
Browse Products by Title: Products & Store buttonNews Feed buttonData Files buttonContact Us buttonProduct Search button
 
Functional Skills
OCR Cambridge Nationals
I.LEARN
ECDL
ECDL Essentials
ECDL Extra
ECDL Advanced
ECDL for Schools 
Flexible ECDL
ECDL/ICDL (7 Units)
Revision Series
ITQ (IT User Skills)
OCR ITQ
BCS ITQ
BTEC ITQ
City & Guilds ITQ
EDI ITQ
CLAIT
New CLAIT
CLAIT Plus
CLAIT Advanced
Open Learning Guides
Trainer Packs
Start IT
CourseNotes
Additional Services:  
Partner Solutions:  

Bank Safe
Apprentice Range: Staff Roster
 
Custom Services:

Bespoke Products
Product Customisation
e-Mailing List:  
Sign up for CiA resource updates...
Twitter News Feed:  
Quick Links:  
Legal Statements:
Privacy Statement
Terms of Use
Conditions of Sale
Other Links:
Data Files
Purchasing Options
Order Form
Site Map
50% discount with code WINTER
Sharing buttons are not available on this page.

Your shopping cart is empty

Shopping Cart Button


Product Information

Thumbnail of cover - click to enlarge

ECDL Advanced Spreadsheet Software (BCS ITQ L3)

20.50 (Print A4) | 350.00 (Site Licence)

Buy Now Button



Description

Approved by BCS and ICS Skills. This training guide has been written specifically for the ECDL unit Advanced Spreadsheet Software (BCS ITQ level 3, syllabus 2.0). Each exercise has been designed to build upon and extend your knowledge of Microsoft Excel using a simple, step-by-step approach. You will learn how to use a range of advanced spreadsheet software tools and techniques to produce complex spreadsheets. Data files to accompany this title allow you to practise the many different software features covered.




Versions

This product is available in 6 different versions. Click the Buy Now button at the top or bottom of the page to select the version you would like to add to your shopping cart.
 

1.
2.
3.
4.
5.
6.

Excel XP (ISBN: 9781860056512)
Excel 2003 (ISBN: 9781860056529)
Excel 2007 (ISBN: 9781860056536)
Excel 2010 (ISBN: 9781860058509)
Excel 2013 (ISBN: 9780857410436)
Excel 2016 (ISBN: 9780857411990)




Contents

This product contains approximately 180 pages and covers the following topics:

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.

Conditional Formatting
AutoFormat
Paste Special
Worksheet and Workbook Protection
Cell Comments
Using Names
Creating and Using Templates
Display Formulas
Mixed Referencing
Custom Number Formats
Creating and Using Outlines
Using Scenarios
Linking Cell, Sheets and Books
Importing Delimited Data
Sorting
Filtering Lists
PivotTables
Using Functions
Formating and Modifying Charts
Data Tables
Creating and Running Macros
Auditing
Data Validation
Sharing Workbooks
Tracking Changes




Purchasing Options

All CiA Training resources are available in individual printed book format or as digital site licences in Microsoft Word or PDF format. Site licences are only suitable for organisations and allow unlimited editing, customisation, printing and VLE uploads.

Please refer to our Purchasing Options page if you have any queries regarding our ordering process.



Sample Section

To view a sample from this title click the download link below. Documents are in PDF format and require Adobe's Acrobat Viewer.
Download Sample Icon   Sample Section: ECDL Advanced Spreadsheet Software (BCS ITQ L3)



Buy Now

Click the Buy Now button at the top or bottom of the page to purchase this title. For help, please Contact Us.
Buy Now Button

Tel: 0191 549 5002   |   Fax: 0191 549 9005   |   Email:  info@ciatraining.co.uk

Accepted Payment Methods: Visa, Visa Delta, Visa Electron, MasterCard, Switch/Solo/Maestro, American Express