|
Excel 2007 Pocket Guide
Moving to Excel 2007 is not a routine upgrade. Microsoft's
radical redesign of the application's user interface has led
to confusion among many who people who have relied on Excel
for years. Our new edition of the Excel 2007 Pocket Guide
has been written from the ground up to help newcomers and
longtime users alike find their
way around without getting
lost.
With this book in hand, you'll be able to find your favorite
Excel tools quickly. It's packed with information to guide
beginners through the basics of creating spreadsheets and
entering data, while providing advanced users with
information on formulas, pivot tables, and more. Inside,
you'll find:
A visual guide to the new "Ribbon" interface that helps
users find familiar tools
A section designed to give beginners enough information to
dive right in and start creating rich Excel workbooks
immediately
Quick answers about how to perform specific tasks in Excel,
such as working with files, editing data, formatting,
summarizing and displaying data
Convenient techniques for connecting data across worksheets
and projects
Help for moving from the basics of spreadsheet construction
to more advanced features
This edition also includes an extensive reference on
commonly used formulas, which reveal at a glance the many
possibilities Excel 2007 provides for easy calculation.
Tasks in the book are presented as answers to "How do I..."
questions -- such as "How do I change the formatting of part
of a cell's contents?" -- followed by concise instructions
for performing the task. You'll learn ways to customize
Excel to fit your needs, and how to share workbooks and
collaborate with others. And much more.
Don't let Excel 2007 baffle you. Pick up this convenient
pocket guide and learn to navigate this redesigned
application with ease.
CONTENTS:
Understanding Excel
What's New in Excel 2007
The Excel 2007 Interface
The Anatomy of an Excel File
Formatting
Shortcut Menus and the Mini Toolbar
How Excel Tries to Help
Excel Tasks
Working with Files
Printing
Moving Around in a Workbook or Worksheet
Manipulating Workbooks and Worksheets
Manipulating Rows, Columns, and Cells
Entering and Editing Data
Formatting
Working with Hyperlinks
Working with Headers and Footers
Summarizing Data
Using Named Ranges
Defining Alternative Data Sets
Controlling How Data Is Displayed
Protecting All or Part of a Workbook
Spelling and Other Tools
Customizing Excel
Collaborating
Working with the Web
Summarizing Data with Charts
Analyzing Data with PivotTables and PivotCharts
Formula Reference
New Formulas in Excel 2007
Math Formulas
Date and Time Formulas
Financial Formulas
Lookup and Reference Formulas
Logical Formulas
Text Formulas
Statistical Formulas
Chapter 4:. Excel Reference
Command Reference
Native Formats
Startup Switches
Wildcards in Filters and Searches
Default File Locations
Keyboard Shortcuts
Chapter 5:. Excel Resources
Internet Sites
Books
Excel Utilities
Index
|
