TY - BOOK AU - Hart-Davis, Guy, author. TI - How to do everything with Microsoft Office Excel 2007 / SN - 0072263695 (pbk.) AV - CIR HF 5548.4.M52 D38 2007 U1 - 005.54 20 PY - 2007/// CY - New York : PB - McGraw-Hill, KW - Microsoft Excel (Computer file) KW - Business KW - Computer programs. KW - Electronic spreadsheets. N1 - Includes index; pt. I. Get started with Excel -- 1. Navigate the Excel screen -- 2. Configure Excel to suit your working needs -- 3. Create spreadsheets and enter data -- 4. Format worksheets for best effect -- 5. Add graphics and drawings to worksheets -- 6. Check, lay out, and print worksheets. pt. II. Calculate, manipulate, and analyze data -- 7. Perform calculations with functions -- 8. Create formulas to perform custom calculations -- 9. Organize data with Excel databases -- 10. Outline and consolidate worksheets -- 11. Analyze data using PivotTables and PivotCharts -- 12. Solve problems by performing what-if analysis. pt. III. Share, publish, and present data -- 13. Create effective charts to present data visually -- 14. Share workbooks and collaborate with colleagues -- 15. Using Excel's Web capabilities -- 16. Use Excel with the other Office applications. pt. IV. Customize and program Excel -- 17. Customize Excel's interface -- 18. Use macros to automate tasks -- Appendix. Keyboard shortcuts. Index.c N2 - Provides coverage of the new features of the spreadsheet program, covering such topics as upgrading one's system, configuration and customization, building spreadsheets, adding graphics, creating custom formulas, using PivotTable analysis, and using Web capabilities ER -