Product Description

This third edition of the best selling text, Spreadsheet Projects in Excel, features a new colour design and updated project advice.


The 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. The book has been comprehensively revised and extended to cover the requirements of all Applied A and AS Level ICT spreadsheet units, in addition to the coursework requirements of A and AS Levels in ICT. 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 spreadsheets through Microsoft ® Excel TM is necessary.


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


- Spreadsheet examples to introduce the reader to all the skills and techniques in Excel TM required for Applied AS and A2 Level units;

- The development of fully customised solutions for A Level units including features such as LOOKUP, spinners, option boxes, macros and UserForms;

- 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.

Product Details

• Amazon Sales Rank: #81869 in Books
• Published on: 2008-06-27
• Original language: English
• Binding: Paperback
• 238 pages

About the Author
Julian Mott and Ian Rendell have over 20 years of experience in teaching ICT and Computing to post-16 students. They are both practising teachers, being Heads of ICT in two of the largest schools in the country.
Both authors have senior moderating and coursework advisory roles with a major examination board.

Customer Reviews

Suitable for all
I teach adults with good IT skills. Many are 'reluctant to buy this book. However once they buy the book they think it is excellent - lots of stuff is here that they recognise they dont know.

If in doubt, buy the book. Many of my students re so impressed with one that they buy a second. Only weakness is lack of VBA

Excellent Book
I have thorugh work being doing a basic Excel course for staff. People wanted a more advanced course to do more fancy things. As this was new territory for me, I purchased this book, based on the first review.

It is very very good, it expects you to know a good basic level of Excel,
but the way it describes how to do certain Excel functions, espcially VB objects has made the learning of these new skills a joy.

I never really thought I would get to grips with Macros and assigning them to command buttons, but the way it is laid out is very easy to understand yet very powerful.

It readily builds from one section to the next. The last chapter, 50 Excel tips is really great, about 30 of them I had never come across and yet they are very concise but great for adding value to creating a course.

Thank You.