Table of content

   
  Table of Contents
Show Me Microsoft Office Excel 2003
By Steve  Johnson  Perspection, Inc.
 
Publisher : Que
Pub Date : September 15, 2003
ISBN : 0-7897-3005-7
Pages : 448
      Copyright
      Acknowledgements
        Perspection, Inc.
        Acknowledgements
        About The Author
        We Want To Hear From You!
      Introduction
        Find the Best Place to Start
        What's New
        How This Book Works
        Step-by-Step Instructions
        Real World Examples
        Troubleshooting Guide
        Show Me Live Software
        Microsoft Office Specialist
      Chapter 1.   Getting Started with Excel
        Introduction
        Starting Excel
        Viewing the Excel Window and Task Panes
        Starting a New Workbook
        Opening an Existing Workbook
        Moving Around the Workbook
        Working with Menus and Toolbars
        Working with Dialog Boxes
        Using Task Panes
        Arranging Windows
        Getting Help
        Getting Help from the Office Assistant
        Saving a Workbook
        Saving a File with Different Formats
        Getting Excel Updates on the Web
        Recovering a Workbook
        Exiting Excel
      Chapter 2.   Basic Workbook Skills
        Introduction
        Making Label Entries
        Selecting Cells
        Entering Labels on a Worksheet
        Entering Values on a Worksheet
        Entering Values Quickly with AutoFill
        Editing Cell Contents
        Clearing Cell Contents
        Undoing and Redoing an Action
        Understanding How Excel Pastes Data
        Storing Cell Contents
        Copying Cell Contents
        Moving Cell Contents
        Inserting and Deleting Cell Contents
        Finding and Replacing Cell Contents
        Correcting Cell Contents with AutoCorrect
        Using Smart Tags
        Checking Your Spelling
      Chapter 3.   Working with Formulas and Functions
        Introduction
        Creating a Simple Formula
        Editing a Formula
        Understanding Cell Referencing
        Using Absolute Cell References
        Using Labels for Cell References
        Naming Cells and Ranges
        Simplifying a Formula with Ranges
        Displaying Calculations with AutoCalculate
        Calculating Totals with AutoSum
        Correcting Calculation Errors
        Correcting Formulas
        Auditing a Worksheet
        Performing Calculations Using Functions
        Creating Functions
      Chapter 4.   Modifying Worksheets and Workbooks
        Introduction
        Selecting and Naming a Worksheet
        Inserting and Deleting a Worksheet
        Moving and Copying a Worksheet
        Hiding and Unhiding Worksheets and Workbooks
        Selecting a Column or Row
        Hiding and Unhiding a Column or Row
        Inserting a Column or Row
        Deleting a Column or Row
        Adjusting Column Width and Row Height
        Freezing a Column or Row
        Splitting a Worksheet in Panes
        Creating a Template
        Opening a Template
        Changing a Template
      Chapter 5.   Formatting a Worksheet
        Introduction
        Formatting Text and Numbers
        Designing Conditional Formatting
        Copying Cell Formats
        Changing Fonts
        Changing Data Alignment
        Controlling Text Flow
        Changing Data Color
        Adding Color and Patterns to Cells
        Adding Borders to Cells
        Formatting Data with AutoFormat
        Modifying an AutoFormat
        Formatting Tabs and Background
        Creating and Applying Styles
        Modifying a Style
        Finding and Replacing Formatting
      Chapter 6.   Printing Worksheets and Workbooks
        Introduction
        Inserting Page Breaks
        Setting Up the Page
        Adding Headers and Footers
        Customizing Worksheet Printing
        Setting the Print Area
        Previewing a Worksheet
        Printing a Worksheet and Workbook
      Chapter 7.   Inserting Graphics and Related Material
        Introduction
        Working with the Clipboard
        Inserting Research Material
        Inserting and Deleting Pictures
        Inserting Media Clips
        Modifying Pictures
        Cropping Pictures
        Stylizing Text with WordArt
        Editing WordArt Text
        Applying WordArt Text Effects
        Inserting an Organization Chart
        Modifying an Organization Chart
        Creating a Diagram
        Formatting a Diagram
      Chapter 8.   Drawing and Modifying Objects
        Introduction
        Drawing Lines and Arrows
        Drawing AutoShapes
        Inserting AutoShapes from the Clip Gallery
        Moving and Resizing an Object
        Rotating and Flipping an Object
        Choosing Object Colors
        Adding Object Shadows
        Creating a 3-D Object
        Aligning and Distributing Objects
        Arranging and Grouping Objects
        Changing Object View Settings
      Chapter 9.   Creating and Modifying Charts
        Introduction
        Understanding Chart Terminology
        Choosing the Right Type of Chart
        Creating a Chart
        Editing a Chart
        Selecting and Editing a Chart Object
        Changing a Chart Type
        Moving and Resizing a Chart
        Pulling Out a Pie Slice
        Adding and Deleting a Data Series
        Enhancing a Data Series
        Enhancing a Chart
        Drawing on a Chart
        Formatting Chart Elements
        Adding Chart Gridlines
      Chapter 10.   Analyzing Worksheet Data
        Introduction
        Understanding Lists
        Creating a List
        Understanding a Data Form
        Adding Records Using a Data Form
        Managing Records Using a Data Form
        Sorting Data in a List
        Displaying Parts of a List with AutoFilter
        Creating Custom Searches
        Entering Data in a List
        Working with Lists
        Analyzing Data Using a PivotTable
        Updating a PivotTable and PivotChart
        Modifying a PivotTable and PivotChart
        Charting a PivotTable
        Creating Groups and Outlines
        Using Database Functions in a List
        Adding Data Validation to a Worksheet
      Chapter 11.   Building More Powerful Worksheets
        Introduction
        Loading and Unloading Add-Ins
        Using Data Analysis Tools
        Looking at Alternatives with Data Tables
        Asking "What If" with Goal Seek
        Creating Scenarios
        Using Solver
        Using Lookup and Reference Functions
        Understanding How Macros Automate Your Work
        Recording a Macro
        Running a Macro
        Understanding Macro Code
        Debugging a Macro Using Step Mode
        Editing a Macro
        Restricting Workbook Access
        Protecting Your Data
        Using Digital Signatures
        Applying Security Settings
      Chapter 12.   Sharing Workbook Data
        Introduction
        Sharing Workbooks
        Creating and Reading a Cell Comment
        Editing and Deleting a Cell Comment
        Tracking Changes
        Comparing and Merging Workbooks
        Sending a Workbook for Review
        Sharing Information Between Programs
        Exporting and Importing Data
        Working with XML
        Exporting and Saving Data in XML
        Linking and Embedding Files
        Linking Data
        Consolidating Data
        Getting Data from a Database
        Getting Data from Another Program
      Chapter 13.   Publishing Data on the Web
        Introduction
        Opening a Workbook as a Web Page
        Previewing a Web Page
        Creating a Hyperlink
        Saving a Worksheet as a Web Page
        Publishing a Web Page
        Getting Data from the Web
        Copying a Web Table to a Worksheet
        Creating Refreshable Web Queries
        Getting Data from Web Queries
        Saving Web Queries
        Holding an Online Meeting
        Sending Workbooks Using E-Mail
        Getting Documents from the Web
      Chapter 14.   Tools for Working More Efficiently
        Introduction
        Modifying Workbook Properties
        Finding a File or Contents in a File
        Changing Options
        Changing Your Worksheet View
        Creating a Custom View
        Creating a Toolbar
        Customizing a Toolbar
        Adding Menus and Menu Items
        Playing Back Worksheet Data
        Controlling Excel with Your Voice
        Executing Voice Commands
        Dictating Text
        Recognizing Handwriting
        Repairing and Recovering Office Programs
        Using Multiple Languages
      Chapter 15.   Working Together on Office Documents
        Introduction
        Viewing SharePoint Team Services
        Administering SharePoint Team Services
        Storing Documents in the Library
        Viewing Team Members
        Setting Up Alerts
        Assigning Project Tasks
        Creating an Event
        Creating Contacts
        Holding Web Discussions
        Working with Shared Workspace
        Publishing a List
        Installing Windows 2003 and SharePoint Server 2003
      Microsoft Office Specialist
        About the Microsoft Office Specialist Program
        What Does This Logo Mean?
        Preparing for a Microsoft Office Specialist Exam
        Taking a Microsoft Office Specialist Exam
        Getting More Information
      New! Features
        Microsoft Office Excel 2003
      Troubleshooting
        Cells
        Charts
        Clip art and objects
        Clipboard
        Data
        Database and lists
        Entering and selecting data
        Formatting data
        Formulas and functions
        Help
        Importing and exporting
        Languages and voice options
        Menus, toolbars, and task panes
        Microsoft Office Specialist
        Navigation
        Printing
        Reviewing changes
        Saving
        Security
        SharePoint
        Spelling
        Templates and styles
        Web
        Worksheets and workbooks


Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net