Description
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 is 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.
Full Description
Table of Contents
-
Chapter 1 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
-
-
Chapter 2 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
-
-
Chapter 3 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
-
Product Details
- Title:
- Excel 2007 Pocket Guide, Second Edition
- By:
- Curt Frye
- Publisher:
- O'Reilly Media
- Formats:
-
- Ebook
- Safari Books Online
- Print Release:
- October 2007
- Ebook Release:
- February 2009
- Pages:
- 172
- Print ISBN:
- 978-0-596-51452-5
- | ISBN 10:
- 0-596-51452-2
- Ebook ISBN:
- 978-0-596-10294-4
- | ISBN 10:
- 0-596-10294-1
Customer Reviews
