How to Do Everything with Microsoft Office Excel 2007 / Edition 1

How to Do Everything with Microsoft Office Excel 2007 / Edition 1

by Guy Hart-Davis
     
 

ISBN-10: 0072263695

ISBN-13: 9780072263695

Pub. Date: 12/19/2006

Publisher: McGraw-Hill Professional Publishing

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

Overview

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

Product Details

ISBN-13:
9780072263695
Publisher:
McGraw-Hill Professional Publishing
Publication date:
12/19/2006
Series:
How To Do Everything Series
Pages:
512
Product dimensions:
7.30(w) x 9.10(h) x 1.01(d)

Table of Contents

Part I: Get Started with Excel

Chapter 1: Navigate the Excel Screen

Chapter 2: Configure Excel to Suit Your Working Needs

Chapter 3: Create Spreadsheets and Enter Data

Chapter 4: Format Worksheets for Best Effect

Chapter 5: Add Graphics and Drawings to Worksheets

Chapter 6: Check, Lay Out, and Print Worksheets
Part II: Calculate, Manipulate, and Analyze Data

Chapter 7: Perform Calculations with Functions

Chapter 8: Create Formulas to Perform Custom Calculations

Chapter 9: Organize Data with Excel Databases

Chapter 10: Outline and Consolidate Worksheets

Chapter 11: Analyze Data Using PivotTables and PivotCharts

Chapter 12: Solve Problems by Performing What-If Analysis
Part III: Share, Publish, and Present Data

Chapter 13: Create Effective Charts to Present Data Visually

Chapter 14: Share Workbooks and Collaborate with Colleagues

Chapter 15: Using Excel's Web Capabilities

Chapter 16: Use Excel with the Other Office Applications
Part IV: Customize and Program Excel

Chapter 17: Customize Excel's Interface

Chapter 18: Use Macros to Automate Tasks
Appendix: Keyboard Shortcuts
Index

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >