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
"synopsis" may belong to another edition of this title.
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.
"About this title" may belong to another edition of this title.
Seller: AwesomeBooks, Wallingford, United Kingdom
Paperback. Condition: Very Good. Successful ICT Projects In Excel (2nd Edition) This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 7719-9781903112267
Quantity: 2 available
Seller: Better World Books Ltd, Dunfermline, United Kingdom
Condition: Good. Former library copy. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Seller Inventory # 39119632-20
Quantity: 1 available
Seller: Bahamut Media, Reading, United Kingdom
Paperback. Condition: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 6545-9781903112267
Quantity: 2 available
Seller: Sell Books, Elland, YORKS, United Kingdom
paperback. Condition: Good. Our good condition books are generally good for reading but not for gifting or collecting. They could have imperfections such as creasing, fanning, inscriptions, margin notes, yellowing, staining on edge or cover or pages, bumps, scuffs, etc etc (sometimes multiple of these). It's a wide category that encompasses anything that isn't almost-new down to anything that is slightly better than poor. We would NOT recommend gifting Good books - these should be considered reading copies. Our books are dispatched from a Yorkshire former cotton mill. We list via barcode/ISBN so please note that the images are stock images and may not be the exact copy you receive, furthermore the details about edition and year might not be accurate as many publishers reuse the same ISBN for multiple editions and as we simply scan a barcode or enter an ISBN we do not check the validity of the edition data when listing. If you're looking for an exact edition please don't order (at least not without checking with us first, although we don't always have time to check). We aim to dispatch prompty, the service used will depend on order value and book size. We can ship to most countries, see our shipping policies. Payment is via Abe only. Seller Inventory # L-BKH00810-RAG-20231123-G
Quantity: 1 available
Seller: Brit Books, Milton Keynes, United Kingdom
Paperback. Condition: Used; Good. ***Simply Brit*** Welcome to our online used book store, where affordability meets great quality. Dive into a world of captivating reads without breaking the bank. We take pride in offering a wide selection of used books, from classics to hidden gems, ensuring there is something for every literary palate. All orders are shipped within 24 hours and our lightning fast-delivery within 48 hours coupled with our prompt customer service ensures a smooth journey from ordering to delivery. Discover the joy of reading with us, your trusted source for affordable books that do not compromise on quality. Seller Inventory # mon0000326914
Quantity: 1 available
Seller: Greener Books, London, United Kingdom
Paperback. Condition: Used; Very Good. **SHIPPED FROM UK** We believe you will be completely satisfied with our quick and reliable service. All orders are dispatched as swiftly as possible! Buy with confidence! Greener Books. Seller Inventory # 4581107
Quantity: 1 available