How to Do Everything with Microsoft Office Excel 2007 - Softcover

Hart-Davis, Guy

Softcover

ISBN 10: 0072263695 ISBN 13: 9780072263695

Publisher: McGraw Hill, 2007

Synopsis

How to Do Everything with Excel 2007 teaches the reader how to master the latest version of Microsoft’s market-dominating spreadsheet application

Excel 2007 builds on previous versions of Excel by introducing a new interface featuring the Ribbon, a visual feature that replaces the current menus and toolbars and gives instant, context-sensitive access to whichever features the user currently needs. Excel 2007 also features an XML-based file format for greater compatibility with other applications, deeper integration with the other Office applications, and enhanced stability.

Features

Uses the proven hands-on approach of the How to Do Everything series to take the reader from being an Excel beginner to producing full-quality, professional work with Excel

Coverage includes spreadsheet layout; basic and advanced formatting; adding impact with graphics and diagrams; using functions and formulae (built-in and custom); building databases; creating PivotTables and PivotCharts; and using Solver, Goal Seek, and what-if analysis to solve complex business problems

How To sidebars introduce practical, timesaving techniques for everyday operations―from the mundane to the sophisticated. Did You Know sidebars point up key information on why Excel works in unexpected ways and tell the reader how to get the most out of Excel

About this title

Product Description:

How to Do Everything with Microsoft Office Excel 2007 Teaches you how to master the Microsoft's 2007 market-dominating spreadsheet application. This guide covers various features and explains how to enter and format data and graphics, build databases to store and analyze data, and share workbooks securely with other users. Full description

From the Back Cover:

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

About this edition

• Publisher: McGraw Hill
• Publication date: 2007
• ISBN 10: 0072263695
• ISBN 13: 9780072263695
• Binding: Paperback
• Number of pages: 512