Successful Projects in Excel By P.M.Heathcote

Successful Projects in Excel By P.M.Heathcote

Rs. 360 Rs. 324 Save 10%

Author: P.M.Heathcote

Book Title Successful Projects in Excel By P.M.Heathcote
Type Book
Date Published Sep 29, 2017

Author: P.M.Heathcote


  • Language: English
  • Binding: Paperback
  • Publisher: BPB Publications
  • ISBN: 9788176567015
  • Edition: 2003
  • Pages: 147
  • Dimension: 27 X 21.5 X 1 cm


Successful  Projects in Excel is designed to help students on an Advanced Level or ABCE Computing or Information and Communications Technology course to complete a project using Microsoft Excel 2002 or an earlier version. 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.

Table Of Contents:

  1. Workbooks and worksheets
  2. Editing and formatting
  3. Writing formulae
  4. Using functions
  5. 'What if' scenarios
  6. Linking Workbooks
  7. Filtering, subtotalling lists sorting
  8. Creating charts
  9. Printing
  10. Forms and templates
  11. Basic macros
  12. Advanced macros
  13. The User Interface
  14. Project ideas
  15. The systems life cycle
  16. The project report

 Appendix A  Sample Project

Appendix B  AQA Specification