Dr Seuss Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | September 30, 2014

    Brian Doyle: IMG The Rude Burl of Our Masks



    One day when I was 12 years old and setting off on my newspaper route after school my mom said will you stop at the doctor's and pick up something... Continue »

    spacer
Qualifying orders ship free.
$18.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Excel 2003 for Dummies Quick Reference (For Dummies)

by

Excel 2003 for Dummies Quick Reference (For Dummies) Cover

 

Synopses & Reviews

Publisher Comments:

If you’re using Excel 2003 and you’d rather be working on your projects instead of plodding through everything you could ever need to know (and may never need to know) about Excel, this is the reference for you. In a compact, info-packed, spiral-bound book that puts the facts you need at your fingertips, it covers the basics most Excel users need to know, including:
  • Opening, saving protecting, and recovering workbook files and using workbook templates
  • Adding, copying, and deleting worksheets, e-mailing worksheet data, and publishing worksheet data to the Web
  • Entering and editing data and text and working with cells and ranges
  • Creating formulas and functions
  • Creating and using names
  • Auditing, formatting, and printing your work
  • Charting your data
  • Analyzing data with pivot tables

Complete with concise, step-by-step explanations (most of which take less than one page) and lots of screen shots and tables, this no nonsense guide gets you working instead of searching or reading, A detailed index makes it easy to find what you need to know fast. Excel 2003 For Dummies is a practical, at-a-glance reference for any Excel user.

Synopsis:

Excel is a spreadsheet/data analysis tool attached to the Microsoft Office suite and included in all Office offerings. This book provides the reader with all the information necessary to get a job done with Excel quickly and easily.

Synopsis:

Fast answers to frequently asked questions

Excel 2003 essentials at your fingertips!

If you like your answers quick and your information up-to-date, look no further. With this concise, superbly organized reference, you’ll quickly find just what you need to know about opening, saving, protecting, and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing, formatting, printing, and a whole lot more.

The Dummies Way

  • Concise, "get it done" information
  • Helpful alphabetical organization
  • Convenient lay-flat binding
  • Icons and other navigational aids
  • A dash of humor and fun

Synopsis:

If you're using Excel 2003 and you'd rather be working on your projects instead of plodding through everything you could ever need to know (and may never need to know) about Excel, this is the reference for you. In a compact, info-packed, spiral-bound book that puts the facts you need at your fingertips, it covers the basics most Excel users need to know, including: Opening, saving protecting, and recovering workbook files and using workbook templates Adding, copying, and deleting worksheets, e-mailing worksheet data, and publishing worksheet data to the Web Entering and editing data and text and working with cells and ranges Creating formulas and functions Creating and using names Auditing, formatting, and printing your work Charting your data Analyzing data with pivot tables

Complete with concise, step-by-step explanations (most of which take less than one page) and lots of screen shots and tables, this no nonsense guide gets you working instead of searching or reading, A detailed index makes it easy to find what you need to know fast. Excel 2003 For Dummies is a practical, at-a-glance reference for any Excel user.

Table of Contents

The Big Picture: Microsoft Office Excel 2003.

What You See: The Excel Window.

What You See: Dialog Boxes.

Toolbar Table.

The Basics: Starting Excel.

The Basics: Getting Acquainted with Excel.

Navigating with the keyboard.

Navigating with the mouse.

Understanding the Excel menu bar.

The Basics: Getting Help.

The Basics: Creating an Empty Workbook File.

The Basics: Saving a Workbook File.

The Basics: Opening a Workbook File.

The Basics: Closing a Workbook File and Exiting Excel.

What You Can Do: Create and Analyze Data.

What You Can Do: Show Data Graphically.

What You Can Do: Import Data for Analysis.

Part I: Using Workbook Files.

Changing the Default File Location.

Creating Multiple Windows (Views) for a Workbook.

Deleting a Workbook File.

Opening Nonstandard Files.

Opening a non-Excel or older Excel file.

Opening a workspace file.

Protecting a Workbook File.

Recovering Workbook Files after a System Crash.

Saving Files.

Saving a workbook under a different name.

Saving a workbook in a different or older file format.

Saving a workspace file.

Switching among Open Workbooks.

Working with Workbook Templates.

Creating a workbook template.

Creating a workbook from a template.

Creating a default workbook template.

Part II: Working with Worksheets.

Activating Worksheets.

Adding a New Worksheet.

Arranging Windows Automatically.

Changing a Worksheet’s Name.

Coloring a Worksheet Tab.

Copying a Worksheet.

Deleting a Worksheet.

E-Mailing Worksheet Data.

Freezing Row or Column Titles.

Hiding and Unhiding a Worksheet.

Moving a Worksheet.

Protecting a Worksheet.

Publishing Your Worksheet Data to the Web.

Publishing your worksheet data to a Web page.

Republishing your worksheet data to the Web.

Splitting Panes.

Using Full-Screen View.

Zooming Worksheets.

Part III: Entering and Editing Worksheet Data.

Copying Cells and Ranges.

Copying a cell to another cell or a range.

Copying a range to another range.

Copying data to another worksheet or workbook.

Copying multiple cells or ranges to another range.

Deleting Entire Rows and Columns.

Editing a Cell’s Contents.

Entering Data into a Range.

Entering data into a specific range.

Entering the same data into a range of cells.

Entering Dates and Times.

Entering specific dates and times.

Entering the current date or time.

Entering Formulas.

Entering formulas manually.

Entering formulas by pointing.

Entering Text.

Entering text into cells.

Completing text entries by using AutoComplete.

Entering Values.

Entering values into cells.

Entering fractions.

Erasing Data in Cells and Ranges.

Filling a Series.

Entering a series of incremental values or dates.

Entering a series of text.

Inserting Decimal Points Automatically.

Inserting Entire Rows and Columns.

Moving Cells and Ranges.

Moving data to a new location in the same worksheet.

Moving data to a different worksheet or workbook.

Replacing the Contents of a Cell.

Searching and Replacing Data.

Searching for data.

Searching for and replacing data.

Selecting Cells and Ranges.

Selecting a cell.

Selecting a range.

Selecting noncontiguous ranges.

Selecting entire rows and columns.

Selecting a multisheet (3-D) range.

Transposing a Range.

Undoing Changes and Mistakes.

Validating Data Entry.

Part IV: Using Formulas and Functions.

Absolute, Relative, and Mixed References.

Add-In Functions.

Basic Formula Essentials.

Changing When Formulas Are Calculated.

Converting Formulas to Values.

Editing Functions in Formulas.

Entering Functions in Formulas.

Entering functions manually.

Using the Extended AutoSum tool.

Using the Insert Function dialog box.

Modifying a Range Reference Used in a Function.

Referencing Cells in Other Worksheets.

Part V: Creating and Using Names.

Changing Names.

Creating Names.

Creating names by using the Define Name dialog box.

Creating names by using the Name Box.

Creating names automatically.

Creating multisheet names.

Creating a Table of Names.

Deleting Names.

Names in Formulas.

Applying names to existing cell references.

Pasting names into a formula.

Using row and column headers.

Using sheet-level names.

Naming Constants.

Redefining Name References.

Part VI: Auditing Your Work.

Cell Comments.

Adding a cell comment.

Editing a cell comment.

Changing the looks of a cell comment.

Viewing cell comments.

Checking for Specific Worksheet Errors.

Checking for errors in the background.

Checking for errors manually.

Displaying Formulas in a Worksheet.

Evaluating Parts of a Formula.

Formula Error Values.

Handling Circular References.

Locating Errors by Selecting Special Cells.

Proofreading Your Worksheet Data.

Spell Checking.

Tracing Cell Relationships.

Tracing precedents and dependents.

Tracing formula error values.

Using the Watch Window.

Displaying and adding cells to the Watch Window.

Removing cells from the Watch Window.

Hiding the Watch Window.

Part VII: Formatting Your Data.

Adding Borders to a Cell or Range.

Aligning Cell Contents.

Setting horizontal and vertical alignment.

Indenting the contents of a cell.

Justifying (refitting) text across cells.

Wrapping text within a cell.

Applying Background Colors and Patterns.

Applying a Background Graphic.

Changing the Appearance of Text in Cells.

Changing fonts and text sizes.

Applying colors to text.

Changing text attributes.

Changing Text Orientation (Direction).

Copying Formats.

Formatting Based on a Cell’s Contents.

Formatting Numbers.

Using Excel’s built-in number formats.

Creating custom number formats.

Formatting a Table Automatically.

Hiding Cell Contents.

Hiding and Unhiding Columns and Rows.

Hiding columns and rows.

Unhiding columns and rows.

Merging Cells.

Modifying Cell Size.

Changing column width.

Changing row height.

Using Named Styles.

Creating named styles.

Applying named styles.

Part VIII: Printing Your Work.

Adjusting Margins.

Centering Printed Output.

Changing Default Print Settings by Using a Template.

Changing the Header or Footer.

Selecting a predefined header or footer.

Creating a custom header or footer.

Controlling Page Settings.

Changing page orientation.

Selecting paper size.

Scaling your printed output.

Specifying the beginning page number.

Dealing with Page Breaks.

Inserting manual page breaks.

Removing manual page breaks.

Previewing and adjusting page breaks.

Previewing Your Work.

Printing Cell Comments.

Printing Charts.

Printing Colors in Black and White.

Printing in Draft Quality.

Printing or Substituting Error Values.

Printing or Suppressing Gridlines.

Printing Row and Column Headings.

Selecting Global Print Options.

Printing noncontiguous ranges.

Printing selected pages.

Selecting a printer.

Setting the print area.

Specifying the data range to print.

Setting Print Titles.

Specifying Page Order.

Part IX: Charting Your Data.

Adding Elements to a Chart.

Adding a new data series to a chart.

Adding a trendline to a data series.

Adding Fill Effects to a Chart.

Changing a Chart’s Data Series.

Changing a Chart’s Location.

Changing Chart Elements.

Changing a chart’s scale.

Changing a chart’s gridlines.

Changing data markers.

Changing the Chart Type.

Creating a Chart by Using the Chart Wizard.

Chart Wizard — Dialog box 1 of 4.

Chart Wizard — Dialog box 2 of 4.

Chart Wizard — Dialog box 3 of 4.

Chart Wizard — Dialog box 4 of 4.

Creating a Custom Chart Type.

Creating a Default Chart on a Chart Sheet.

Deleting a Chart Element or Data Series.

Displaying a Data Table in a Chart.

Displaying Data Labels in a Chart.

Formatting a Chart Element.

Handling Missing Data in a Chart.

Inserting and Modifying Chart Legends.

Adding a legend to a chart.

Adding titles to a chart legend.

Formatting a chart legend or legend entry.

Moving a Chart Element.

Rotating 3-D Charts.

Selecting a Chart Element.

Part X: Linking and Consolidating Worksheets.

Consolidating Worksheets.

Consolidating by position or by matching labels.

Consolidating by using formulas.

Linking Workbooks.

Referencing cells in other workbooks.

Changing the source of links.

Severing (breaking) links.

Updating links.

Part XI: Working with Lists and External Data.

Accessing Advanced Filtering.

Setting up a criteria range for advanced filtering.

Performing advanced filtering.

Applying Database Functions with Lists.

Calculating Subtotals.

Filtering a List.

Filtering by using an Excel AutoFilter.

Filtering by using a custom AutoFilter.

Importing Data from a Text File.

Importing Data from the Web.

By using an existing Web query file.

By creating a new Web query.

Refreshing Imported Data.

Sorting a List.

Sorting numerically or alphabetically.

Using a custom sort order.

Part XII: Goal Seeking and What-If Analysis.

Creating Data Input Tables.

Creating a one-input table.

Creating a two-input table.

Goal Seeking.

Using Scenario Manager.

Creating a named scenario.

Creating a scenario summary report.

Displaying a named scenario.

Part XIII: Analyzing Data with PivotTables.

Adding and Removing Fields in a PivotTable Report.

Inserting a new field.

Removing a field.

Creating a PivotTable Report.

Formatting a PivotTable Report.

Grouping PivotTable Items.

Modifying a PivotTable’s Structure.

Refreshing a PivotTable Report.

Glossary: Tech Talk.

Index.

Product Details

ISBN:
9780764539879
Author:
Walkenbach, John
Publisher:
Wiley Publishing
Author:
Banfield, Colin
Location:
Hoboken, NJ
Subject:
Spreadsheets - General
Subject:
Electronic spreadsheets
Subject:
Microsoft Excel
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
Computers
Series:
For Dummies: Quick Reference
Series Volume:
410
Publication Date:
20031017
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Yes
Pages:
240
Dimensions:
8.34x5.92x.62 in. .57 lbs.

Other books you might like

  1. Quicken. 2001 for Dummies. Quick... Used Spiral $5.95
  2. Access 2003 All-In-One Desk... Used Trade Paper $2.95
  3. Access 2003 for Dummies(r) (For Dummies) New Trade Paper $21.99
  4. Word 2002 for Dummies. Quick... Used Trade Paper $5.95
  5. Excel 2003 for Dummies Used Trade Paper $3.95

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Excel 2003 for Dummies Quick Reference (For Dummies) New Trade Paper
0 stars - 0 reviews
$18.99 In Stock
Product details 240 pages Wiley Publishing - English 9780764539879 Reviews:
"Synopsis" by , Excel is a spreadsheet/data analysis tool attached to the Microsoft Office suite and included in all Office offerings. This book provides the reader with all the information necessary to get a job done with Excel quickly and easily.
"Synopsis" by , Fast answers to frequently asked questions

Excel 2003 essentials at your fingertips!

If you like your answers quick and your information up-to-date, look no further. With this concise, superbly organized reference, you’ll quickly find just what you need to know about opening, saving, protecting, and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing, formatting, printing, and a whole lot more.

The Dummies Way

  • Concise, "get it done" information
  • Helpful alphabetical organization
  • Convenient lay-flat binding
  • Icons and other navigational aids
  • A dash of humor and fun
"Synopsis" by , If you're using Excel 2003 and you'd rather be working on your projects instead of plodding through everything you could ever need to know (and may never need to know) about Excel, this is the reference for you. In a compact, info-packed, spiral-bound book that puts the facts you need at your fingertips, it covers the basics most Excel users need to know, including: Opening, saving protecting, and recovering workbook files and using workbook templates Adding, copying, and deleting worksheets, e-mailing worksheet data, and publishing worksheet data to the Web Entering and editing data and text and working with cells and ranges Creating formulas and functions Creating and using names Auditing, formatting, and printing your work Charting your data Analyzing data with pivot tables

Complete with concise, step-by-step explanations (most of which take less than one page) and lots of screen shots and tables, this no nonsense guide gets you working instead of searching or reading, A detailed index makes it easy to find what you need to know fast. Excel 2003 For Dummies is a practical, at-a-glance reference for any Excel user.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.