Free Book Online
Book Advanced Spreadsheet Projects in Excel 2007: Suitable for Users of Office 2010


Advanced Spreadsheet Projects in Excel 2007: Suitable for Users of Office 2010

4.5 (1817)

Log in to rate this item

    Available in PDF - DJVU Format | Advanced Spreadsheet Projects in Excel 2007: Suitable for Users of Office 2010.pdf | Language: ENGLISH
    Julian Mott(Author)

    Book details

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

3.3 (4329)
  • Pdf

*An electronic version of a printed book that can be read on a computer or handheld device designed specifically for this purpose.

Formats for this Ebook

Required Software Any PDF Reader, Apple Preview
Supported Devices Windows PC/PocketPC, Mac OS, Linux OS, Apple iPhone/iPod Touch.
# of Devices Unlimited
Flowing Text / Pages Pages
Printable? Yes

Book details

  • PDF | 297 pages
  • Julian Mott(Author)
  • Trans-Atlantic Publications (December 12, 2010)
  • English
  • 4
  • Computers & Technology

Read online or download a free book: Advanced Spreadsheet Projects in Excel 2007: Suitable for Users of Office 2010


Review Text

  • By captainmidnigt on February 21, 2015

    This is a "textbook". It might be simplistic for advanced users, but I found it immensely helpful in learning/reviewing tasks I don't use much or have never learned. One must be willing to work thru the really easy stuff to build your foundation. It uses real world problems, gives direction, and answers. I wish I could find such a book with VBA problems and solutions! I highly recommend this book. It is written for 2007, but works for 2010 and 2013 if you are familiar for the changes MS keeps making.

  • Name:
    The message text*: