How to Do Everything with Microsoft Office Excel 2007

Guy Hart-Davis

  • 出版商: McGraw-Hill Education
  • 出版日期: 2007-01-09
  • 售價: $1,290
  • 貴賓價: 9.5$1,226
  • 語言: 英文
  • 頁數: 512
  • 裝訂: Paperback
  • ISBN: 0072263695
  • ISBN-13: 9780072263695
  • 相關分類: Excel
  • 已過版
    無現貨庫存(No stock available)




Master the latest version of Excel

Get more out of Excel than ever before with help from this hands-on guide. Learn how to create powerful and easy-to-use spreadsheets and bring yourself up to speed on all the new and improved features available in Excel 2007. Discover how to enter and format data, use graphics effectively, create formulas, build tables to store and analyze data, and share workbooks securely with other users. You'll also learn how to save files to intranet sites and Internet servers, and publish workbooks to Web pages. Plus, you'll find valuable shortcuts that will make it even easier to use the world's most popular spreadsheet application.

  • Control Excel using the new Ribbon interface instead of menus and toolbars
  • Configure and customize Excel to suit your working needs
  • Add visual impact to your worksheets with pictures and diagrams
  • Develop formulas to perform custom calculations
  • Analyze data using PivotTables and organize your information to show exactly what you need
  • Use what-if analysis to solve complex and time-grabbing business problems
  • Share workbooks and collaborate with colleagues
  • Transfer data easily among other Office applications


Table of Contents

Introduction: An Upgrader’s Guide to Excel 12
Chapter 1. Get Started with Excel
Chapter 2. Configure Excel to Suit You
Chapter 3. Create Spreadsheets
Chapter 4. Format Worksheets
Chapter 5. Add Graphics and Drawings
Chapter 6. Check and Print Worksheets
Chapter 7. Calculate with Functions
Chapter 8. Create Custom Formulas
Chapter 9. Organize Data with Databases
Chapter 10. Outline and Consolidate
Chapter 11. Analyze with PivotTables
Chapter 12. Perform What-If Analysis
Chapter 13. Create Effective Charts
Chapter 14. Share and Collaborate
Chapter 15. Use Web Capabilities
Chapter 16. Integrate with other Office Apps
Chapter 17. Customize Excel
Chapter 18. Use Macros to Automate