Spreadsheet Projects in Excel 2007

Advanced Spreadsheet Projects in Excel 2007 is designed to support your learning of the GCE Applied AS and A level ICT spreadsheet units and the project coursework requirements of AS and A levels in ICT and computing. It also covers the spreadsheet units of the IT specialised Diploma ensuring you have everything you need to produce a high-quality project.

This book is aimed at a number of Advanced courses of study within the National Qualifications Framework currently available in schools and colleges, supported by AQA, OCR, Edexcel and WJEC. Advanced Spreadsheet Projects in Excel TM has been comprehensively revised and extended to cover the requirements of all GCE Applied A and AS Level ICT spreadsheet units, in addition to the coursework requirements of A and AS Levels in both ICT and Computing, and the database requirements of the IT Specialised Diploma. The materials and approach used in the book should also be applicable to students on many courses in further and higher education where a study of spreadsheet through Microsoft ® Excel TM is necessary.

Microsoft ® Excel TM is a popular choice of relational spreadsheet software, allowing students to develop and customise systems for a real user. This book covers everything a student needs to know to produce a high quality project, including:

- Key features of the software to include tables, forms, queries and reports;

- The development of a fully customised solution, including features such as subforms, macros, action queries and fully customised reports;

- Starting points and scenarios to aid project development;

- Guidance on how a project should be documented.

The book also includes many valuable tricks and tips, making the use of Excel TM easier and fun.

Table of Contents:
The Development of a system
Excel Tricks and Tips
Starting Points
Project Ideas