
Successful Projects in Excel
P.M.Heathcote
SKU: 9788176567015
Rs. 360
FREE PREVIEW
ISBN: 9788176567015
Authors: P.M.Heathcote
Rights: Worldwide
Publishing Date: January 2003
Pages: 147
Weight:
Dimension: 27 X 21.5 X 1 cm
Authors: P.M.Heathcote
Rights: Worldwide
Publishing Date: January 2003
Pages: 147
Weight:
Dimension: 27 X 21.5 X 1 cm
Book Type: Paperback
Looking for an eBook ? Click here
Looking for an eBook ? Click here
Successful Projects in Excel is designed to help students on an Advanced Level or ABCE Computing or Information and Communications Technology course to complete a project using Microsoft Excel 2002 or an earlier version. 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.
- Workbooks and worksheets
- Editing and formatting
- Writing formulae
- Using functions
- 'What if' scenarios
- Linking Workbooks
- Filtering, subtotalling lists sorting
- Creating charts
- Printing
- Forms and templates
- Basic macros
- Advanced macros
- The User Interface
- Project ideas
- The systems life cycle
- The project report
Appendix A Sample Project
Appendix B AQA Specification
Index
P.M.Heathcote