Excel Pocket Guide

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