Excel Pocket Guide
Curtis D. Frye
已絕版
買這商品的人也買了...
-
$680$578 -
$600$600 -
$980$833 -
$380$300 -
$969$918 -
$320$272 -
$590$466 -
$420$357 -
$680$578 -
$680$578 -
$750$638 -
$560$476 -
$390$304 -
$490$417 -
$420$328 -
$720$612 -
$490$417 -
$860$731 -
$280$218 -
$480$379 -
$750$638 -
$720$569 -
$780$616 -
$490$382 -
$590$460
相關主題
商品描述
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.
Table of Contents
Introduction
Conventions Used in This
Book
Part I: Understanding Excel
The Excel Interface
Task
Panes
Workbook, Workspace, and Template
Files
Tips on Using Templates
The Anatomy of an
Excel File
A Workbook
A Worksheet
Sheet Tabs
Formatting
Worksheets
Columns and Rows
Cells
Characters
Styles
Shortcut Menus
How Excel
Tries to Help
AutoCorrect
AutoComplete
Smart Tags
Part II: 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
Entering Data Efficiently
Entering Data with a Data Entry Form
Using AutoCorrect
and AutoComplete
Inserting Text and Other Elements
Selecting Text and
Data
Cutting, Copying, and Pasting Data
Clearing Cell Contents and Formulas
Formatting Cells
Formatting Cell Contents
Formatting
Numbers and Dates
Formatting Cell Borders and Areas
Formatting a
Worksheet
Working with Hyperlinks
Working with Headers and Footers
Summarizing Data
Getting a Running Total
Adding Formulas to
Cells
Auditing Formulas
Using Named Ranges
Defining Alternative Data Sets
Controlling How Data is Displayed
Sorting Worksheet
Data
Filtering Worksheet Data
Using Subtotals to Summarize Data
Creating Custom Views
Protecting All or Part of a Workbook
Spelling and Other Tools
Customizing Excel
Setting General Customization Options
Customizing Toolbars and Menus
Collaborating
Comments
Tracking Changes
Working with the Web
Summarizing
Data with Charts
Summarizing Data with
PivotTables and PivotCharts
Part III: Excel
Reference
Command Reference
Native Formats
Startup
Switches
Wildcards in Filters and
Searches
Default File Locations
Keyboard Shortcuts
Part IV: Excel Resources
Internet Sites
Books
Excel
Utilities
Index