Excel: Pocket Guide

by Frye, Curtis

• ISBN13: 9780596005344
• ISBN10: 0596005342
• Format: Paperback
• Copyright: 2003-09-01
• Publisher: Oreilly & Associates Inc

Summary

From simple calculations and lists to critical business management systems, Excel is not just the dominant spreadsheet application, it's one of the most widely used software applications in the world. Chances are good that you use Excel. And no matter what your level of expertise, you'll want a copy of the Excel Pocket Guide close by. Packed with information, the Excel Pocket Guide is a compact reference that covers such basics as creating workbooks, entering data, printing, cell formatting, and spell checking. For more advanced users, the book provides handy information on formulas, pivot tables, collaboration, and customization. This helpful guide is easy to use anywhere -- it's the perfect quick reference for all users who want to complete tasks faster without having to wade through a five hundred-page tutorial. If you're new to Excel, this book will get you up to speed quickly. If you consider yourself an advanced user, you'll be surprised and pleased with some of the new Excel tricks this book will teach you. The Excel Pocket Guide will help users at all levels of expertise become Excel experts.

Author Biography

Curt Frye is a freelance writer from Portland, Oregon. Before embarking on his writing career in June 1995, Curt spent four years with The MITRE Corporation as a defense trade analyst and one year as director of Sales and Marketing for Digital Gateway Systems, a Vienna, Virgina, Internet Service Provicer. He has an honors degree in political science from Syracuse University and is working on a masters in individualized itudies from George Mason University.

Table of Contents

Introduction	p. 1
Conventions Used in This Book	p. 2
Understanding Excel
The Excel Interface	p. 4
Task Panes	p. 8
Workbook, Workspace, and Template Files	p. 11
The Anatomy of an Excel File	p. 14
Formatting	p. 17
Shortcut Menus	p. 25
How Excel Tries to Help	p. 26
Excel Tasks
Working with Files	p. 30
Printing	p. 33
Moving Around in a Workbook or Worksheet	p. 37
Manipulating Workbooks and Worksheets	p. 40
Manipulating Rows, Columns, and Cells	p. 42
Entering and Editing Data	p. 45
Formatting Cells	p. 54
Working with Hyperlinks	p. 59
Working with Headers and Footers	p. 60
Summarizing Data	p. 62
Using Named Ranges	p. 65
Defining Alternative Data Sets	p. 66
Controlling How Data is Displayed	p. 68
Protecting All or Part of a Workbook	p. 72
Spelling and Other Tools	p. 72
Customizing Excel	p. 75
Collaborating	p. 78
Working with the Web	p. 81
Summarizing Data with Charts	p. 82
Summarizing Data with PivotTables and PivotCharts	p. 83
Excel Reference
Command Reference	p. 88
Native Formats	p. 89
Startup Switches	p. 90
Wildcards in Filters and Searches	p. 91
Default File Locations	p. 92
Keyboard Shortcuts	p. 93
Excel Resources
Internet Sites	p. 101
Books	p. 102
Excel Utilities	p. 103
Index	p. 105
Table of Contents provided by Blackwell. All Rights Reserved.