Successful ICT Projects In Excel (2nd Edition)
Summary
The feel-good place to buy books
Successful ICT Projects In Excel (2nd Edition) by Heathcote Pm
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
"I have to say thank you for the spreadsheet and database books: they are a godsend" Sara Hampton, Mill Hill County High School, London
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.
| SKU | Unavailable |
| ISBN 13 | 9781903112267 |
| ISBN 10 | 1903112265 |
| Title | Successful ICT Projects In Excel (2nd Edition) |
| Author | P M Heathcote |
| Condition | Unavailable |
| Binding Type | Paperback |
| Publisher | Pearson Education Limited |
| Year published | 2004-12-31 |
| Number of pages | 224 |
| Cover note | Book picture is for illustrative purposes only, actual binding, cover or edition may vary. |
| Note | Unavailable |