Cart
Free Shipping in the UK
Proud to be B-Corp

Successful ICT Projects In Excel (2nd Edition) P.M. Heathcote

Successful ICT Projects In Excel (2nd Edition) By P.M. Heathcote

Successful ICT Projects In Excel (2nd Edition) by P.M. Heathcote


£3.49
Condition - Very Good
Only 2 left

Summary

A guide to writing 'A' Level/BTEC/GNVQ projects using Microsoft Excel (v. 5 to 2000) covering analysis, design and implementation using advanced features of Excel.

Successful ICT Projects In Excel (2nd Edition) Summary

Successful ICT Projects In Excel (2nd Edition) by P.M. Heathcote

It is organised as follows: Part 1 Basic skills in Excel covers entering data, copying and moving cell contents and worksheets, naming cell ranges and worksheets, simple formulae, relative and absolute addressing, functions including VLOOKUP, IF, TRUNC, RAND etc., auditing, Lookup tables, Goal Seek, 'What-if' scenarios and Solver. Part 2 Data analysis and presentation covers linking workbooks, filtering, sorting and subtotalling lists, PivotTables, charts and graphs, and printing. Part 3 Customising an application provides coverage of on-line forms, templates, transferring data to a database, protecting worksheets, macros and the Visual Basic interface, creating custom buttons, menus and toolbars. Part 4 Tackling the project handles ideas, the systems life-cycle and writing up the project. A Sample Project demonstrates how to lay out a complete project report, and the AQA project mark scheme is also included. The template for the sample project as well as a sample chapter entitled 'Project Ideas' are available on the web site www.payne-gallway.co.uk

Successful ICT Projects In Excel (2nd Edition) Reviews

"I have to say thank you for the spreadsheet and database books: they are a godsend." Sara Hampton, Mill Hill County High School, London

About P.M. Heathcote

Pat Heathcote has worked as a programmer and systems analyst, and has many years of experience in teaching Computing and Information Technology. She has served as an Assistant Examiner with AQA, is on the Subject Committee for Computing and is Chair of Examiners for Edexcel AVCE and GNVQ. She is now a full-time author and publisher.

Table of Contents

Part 1 Excel Basics 1 Part 2 Data Analysis and Presentation 55 Part 3 Customising an Application 91 Part 4 Tackling the Project 135 Appendix A Sample Project Appendix B AQA Project Mark Scheme

Additional information

GOR001250978
9781903112267
1903112265
Successful ICT Projects In Excel (2nd Edition) by P.M. Heathcote
Used - Very Good
Paperback
Pearson Education Limited
2000-06-30
224
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Successful ICT Projects In Excel (2nd Edition)