Successful ICT Projects In Excel (2nd Edition) - Couverture souple

P-m-heathcote

Couverture souple

ISBN 10 : 1903112265 ISBN 13 : 9781903112267

Editeur : Pearson Education Limited, 2004

Synopsis

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

A propos du livre

À propos de l'auteur

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.

Détails de l'édition

• Éditeur: Pearson Education Limited
• Date d'édition: 2004
• Langue: anglais
• ISBN 10: 1903112265
• ISBN 13: 9781903112267
• Reliure: Broché
• Nombre de pages: 224
• Coordonnées du fabricant: non disponible
• Personne responsable: Riccardo Bacigalupo; riccardo.bacigalupo@sanoma.it; ; Sanoma Italia Via Arconati, 1 �; Milano; 20135; Italie