Successful ICT Projects In Excel (3rd Edition) (GCE ICT)

by PatM.Heathcote (Editor)

• Used

  Paperback
  2002

  $4.32

  The 3rd edition of Successful ICT Projects in Excel is designed to help students on an Advanced Level Technology course to complete a project using Microsoft Excel 2002 (also suitable for 2000 and '97 versions). 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. Topics covered: Workbooks and worksheets; Editing and formatting; Writing formulae; Using functions; 'What if' scenarios; Linking; Workbooks; Filtering; Subtotalling lists; Sorting and creating charts; Printing Online forms and templates; Basic macros; Advanced macros; Project ideas; The systems life cycle; Writing the project report.

• Used

  Paperback
  2004

  $3.25

  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