Excel Pocket Guide

Curtis D. Frye

  • 出版商: O'Reilly
  • 出版日期: 2003-10-03
  • 售價: $560
  • 貴賓價: 9.5$532
  • 語言: 英文
  • 頁數: 128
  • 裝訂: Paperback
  • ISBN: 0596005342
  • ISBN-13: 9780596005344
  • 相關分類: Excel





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


   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 



               Columns and Rows 




     Shortcut Menus 

     How Excel Tries to Help 



               Smart Tags 

   Part II: Excel Tasks

     Working with Files 


     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 



               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 


     Excel Utilities