Skip to content

Microsoft Excel 2000

Spend $50 to get a free DVD!

ISBN-10: 0672314576

ISBN-13: 9780672314575

Edition: 1999

Authors: Jennifer Fulton, Margaret Fulton

List price: $12.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

The major features of the new Excel 2000 are covered in this guide for new users. It is organised into a series of ten minute lessons featuring the most frequently used tasks.
Customers also bought

Book details

List price: $12.99
Copyright year: 1999
Publisher: Sams
Publication date: 4/30/1999
Binding: Paperback
Pages: 224
Size: 5.75" wide x 8.50" long x 0.50" tall
Weight: 0.638
Language: English

Jennifer Fulton, iVillage's former "Computer Coach," is an experienced computer consultant and trainer with over 20 years in the business. Jennifer is a best-selling author of over 100 computer books for the beginner, intermediate, and advanced user, ranging from the self-motivated adult business user to the college, technical, high-school, or middle school student. Jennifer is also a computer trainer for corporate personnel, teaching a variety of classes including Windows, Microsoft Office, Paint Shop Pro, Photoshop Elements, and others. Jennifer is a self-taught veteran of computing, which means, of course, that if something can happen to a computer user, it has probably happened to her at one time or another. Thus Jennifer brings what's left of her sense of humor to her many books, including: Adobe Photoshop Elements 4 in a Snap, How to Use Macromedia Dreamweaver 8 and Fireworks 8, Adobe Photoshop Elements 3 in a Snap, Digital Photography with Photoshop Album in a Snap, Paint Shop Pro 8 in a Snap, Learning Office 2003, Learning Excel 2003, and Multimedia Basics.Karen S. Fredricks began her life rather non-technically growing up in Kenya. She attended high school in Beirut, Lebanon, where she developed her sense of humor while dodging bombs. After traveling all over the world, Karen ended up at the University of Florida and has been an ardent Gator fan ever since. In addition to undergraduate studies in English, Theater, and Accounting, Karen has a master's degree in Psycholinguistics. Beginning her career teaching high school English and theater, Karen switched to working with the PC during its inception in the early '80s and has worked as a full-time computer consultant and trainer ever since. Karen is an ACT! Certified Consultant, an ACT! Premier Trainer, a Microsoft Office User Specialist, and a QuickBooks Pro Certified Advisor. She is the author of four For Dummies books on ACT! In addition, she has written Outlook 2007 Business Contact Manager For Dummies and is completing work on Microsoft Office Live For Dummies. A true fan of the For Dummies series, she helped organize The Authors Unconference, the first ever gathering of For Dummies authors.

Introduction
Starting and Exiting Excel
Starting Excel
A Look at the Excel Screen
Exiting Excel
Creating and Opening Workbook Files
Creating a New Workbook
Opening an Existing Workbook
Finding a Workbook File
Saving and Closing Workbook Files
Saving and Naming a Workbook
Saving a Workbook Under a Name
Closing Workbooks
Using Excel's Toolbars
Using the Toolbars
Turning Toolbars On and Off
Moving Toolbars
Customizing the Toolbars
Getting Around Excel
Moving from Worksheet to Worksheet
Moving from Workbook to Workbook
Moving Within a Worksheet
Getting Help
Asking the Office Assistant for Help
Helping Yourself
Beyond Help
Going Online to Get Help
Turning the Office Assistant On or Off
Changing to a Different Office Assistant
Getting Help with Screen Elements
Changing How You View Your Worksheet
Magnifying and Reducing the Worksheet View
Freezing Column and Row Labels
Splitting Worksheets
Hiding Workbooks, Worksheets, Columns, and Rows
Entering Different Types of Data
Entering Text
Entering Numbers
Entering Dates and Times
Copying (Filling) the Same Data to Other Cells
Entering a Series of Numbers, Dates, and Other Data
Entering the Same Data in a Column Over and Over
Correcting Your Entries
Making Changes to Data
Undoing an Action
Finding and Replacing Data
Checking Your Spelling
Working with Ranges
What Is a Range?
Selecting a Range
Naming Ranges
Copying, Moving, and Deleting Ranges
Copying Data
Moving Data
Using the Office Clipboard to Copy or Move Multiple Items
Deleting Data
Inserting and Removing Cells, Rows, and Columns
Inserting Rows and Columns
Removing Rows and Columns
Merging Cells Together to Form One Large Cell
Inserting Cells Between Existing Data
Removing Cells by Shifting Data
Changing Column Width and Row Height
Adjusting Column Width and Row Height with a Mouse
Using the Format Menu for Precise Control
Managing Your Worksheets
Selecting Worksheets
Inserting Worksheets
Deleting Worksheets
Moving and Copying Worksheets
Changing Worksheet Tab Names
Printing Your Workbook
Changing the Page Setup
Previewing a Print Job
Printing Your Workbook
Printing Large Worksheets
Selecting a Print Area
Adjusting Page Breaks
Printing Column and Row Labels on Every Page
Adding Headers and Footers
Scaling a Worksheet to Fit on a Page
Performing Calculations with Formulas
Understanding Excel Formulas
Order of Operations
Entering Formulas
Displaying Formulas
Editing Formulas
Copying Formulas and Recalculating
Copying Formulas
Using Relative and Absolute Cell Addresses
Controlling When Your Worksheet Is Recalculated
Performing Calculations with Functions
What Are Functions?
Using the Function Wizard
Changing How Numbers Look
Using the Style Buttons to Format Numbers
Formatting Values
Copying Formats with Format Painter
Giving Your Text a New Look
How You Can Make Text Look Different
Changing Text Attributes with Toolbar Buttons
Aligning Text in Cells
Changing Text Attributes with the Format Cells Dialog Box
Adding Cell Borders and Shading
Adding Borders to Cells
Adding Shading to Cells
Using AutoFormat
Applying Conditional Formatting
Creating Charts
Charting Terminology
Chart Types
Creating a Chart
Saving Charts
Printing a Chart
Enhancing Your Charts
Selecting a Chart Part
The Chart Toolbar
Changing the Chart Type
Adding a Title and a Legend
Formatting Text and Numbers on a Chart
Enhancing the Chart Area
More Ways to Enhance Charts
Displaying or Hiding Gridlines
Changing the Start and Stop Values of the Value Axis
Changing the Category Axis
Changing the Perspective of 3D Charts
Selecting Data Series Options
Changing Data Series Values
Saving and Publishing Workbooks to the Internet
Saving a Workbook to an FTP Site
Saving a Workbook in HTML Format
Publishing Interactive Data
Adding Hyperlinks to a Worksheet
Working with a Database
Database Basics
Planning a Database
Creating a Database
Using Data Forms to Add, Edit, or Delete Records
Finding and Sorting Data in a Database
Finding Data with a Data Form
Sorting Data in a Database
Narrowing Your List with AutoFilter
Adding Graphics and Other Objects to Worksheets
Working with Graphic Objects
Inserting Clip Art
Adding Your Own Clip Art, Video Clips, or Sound Clips to the Gallery
Drawing Your Own Pictures
Index