Successful Projects In Excel

Successful Projects In Excel Is Designed To Help Students On An Advanced LevelOr Abce Computing Or Information And Communications Technology Course To Complete A Project Using Excel 2002Or 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. 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 Contents Workbooks And Worksheets Editing And Formatting Writing Formulae Using Functions What If Scenarios Linking Workbooks Filtering, Sorting & Subtotalling Lists Creating Charts Printing Forms & 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 .