Payne-Gallway - the future in books
search the Payne-Gallway ICT book catalogue
gateway to books and teachers resources on Word, Access, Excel,Windows, CAD, etc


The 3rd edition of Successful ICT Projects in Excel is designed to help students on an Advanced Level Technology course to complete a project using Microsoft Excel 2002 (also suitable for 2000 and '97 versions). It will also be useful to students on a wide range of other courses requiring an in-depth knowledge of spreadsheets. It assumes no previous knowledge of Excel and takes the reader from basics such as entering, editing and formatting text, numbers and formulae through to advanced features such as 'What if' scenarios, pivot tables, macros and customised toolbars. A wide range of examples is used to illustrate the different facilities of Excel, and a sample project shows students how to tackle and document each stage of project work.

Topics covered:

  • Workbooks and worksheets
  • Editing and formatting
  • Writing formulae
  • Using functions
  • 'What if' scenarios
  • Linking Workbooks
  • Filtering, subtotalling lists sorting and creating charts
  • Printing
  • Online forms and templates
  • Basic macros
  • Advanced macros
  • Project ideas
  • The systems life cycle
  • Writing the project report

Publication Date: May 2002
Page Extent:
224pp
ISBN:
Price: 10.95 10% discount minimum



Student
Resources


Teacher's
Resources

Contents
Pages

Sample
Pages

FREE delivery on any two items ordered online

Other books in the Successful ICT Projects series include:
Successful ICT Projects in Access (3rd Edition)

Successful ICT Projects in FrontPage (2nd Edition)

Successful ICT Projects in FrontPage 2000

Successful ICT Projects in Word (2nd Edition)
.

Copyright 2004 Payne-Gallway Publishers Ltd. All Rights Reserved.
Ipswich IP1 3DB UK. Tel: Fax:

Legal Notice and Privacy Statement
.