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.
Sprache
Verlagsort
Produkt-Hinweis
Broschur/Paperback
Klebebindung
Maße
Höhe: 177 mm
Breite: 108 mm
Dicke: 12 mm
Gewicht
ISBN-13
978-0-596-51452-5 (9780596514525)
Schweitzer Klassifikation
Curt Frye is the author of numerous books on Excel and other Office products, most recently "Excel Annoyances". He graduated from Syracuse with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He now lives in Portland, Oregon and is a freelance writer.
Inhaltsverzeichnis
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