How to do everything with Microsoft Office Excel 2007 /
Guy Hart-Davis.
- New York : McGraw-Hill, 2007.
- xxiv, 488 pages : illustrations ; 24 cm.
- Microsoft Office Excel 2007 How to do everything with; How to do everything with-- .
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
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.
In English text.
0072263695 (pbk.) 9780072263695 (pbk.)
Microsoft Excel (Computer file). Business--Computer programs. Electronic spreadsheets.