O'Reilly - Safari Books Online: Absolute Beginner’s Guide to Microsoft® Office Excel 2003

Content Tabs

Home
Subscribe
Free Trial

Category Map
My Quick Links
Books
Video
Rough Cuts
Short Cuts
Tools

Search:criteria:

Title=Bold Reference Entry=Italic

Absolute Beginner’s Guide to Microsoft® Office Excel 2003

Absolute Beginner’s Guide to Microsoft® Office Excel 2003
By: Joe Kraynak
Publisher: Que
Pub. Date: September 11, 2003
Print ISBN-10: 0-7897-2941-5
Print ISBN-13: 978-0-7897-2941-5
Pages in Print Edition: 336
Amazon.com® Rating: [0 Ratings]
Safari User Rating: [0 Ratings]

Overview
Table of Contents
Extras
Search This Book
Help

Safari Subscriber Reviews • Browse Similar Topics

Overview

Top Sellers in this Category

Excel® 2007 Bible
by John Walkenbach

Excel 2007: The Missing Manual, 1st Edition
by Matthew MacDonald

Excel® 2007 Power Programming with VBA
by John Walkenbach

Microsoft® Office Excel® 2007 Step by Step
by Curtis D. Frye

Excel 2007 All‐in‐One Desk Reference For Dummies®
by

Let Excel do the math for you! Learn how this application can help calculate and analyze numerical data quickly and easily.

Learn Excel 2003 basics such as building Excel worksheets, performing calculations using formulas and functions, creating charts, PivotTables and more.
Make an easy transition from Excel 2002 to Excel 2003 with the help of this book.

Safari Subscriber Reviews

Average Safari Rating: 0 out of 5 rating Based on 0 Ratings

No Safari Subscribers have provided a review for this book.

Browse Similar Topics

Top Level Categories:
Desktop Applications

Sub-Categories:
Desktop Applications > Excel

Some information on this page was provided using data from Amazon.com®. View at Amazon >

Copyright

Dedication

About the Author

Acknowledgments

We Want to Hear from You!

Introduction

A Book for the True Beginner

How This Book Is Organized

Conventions Used in This Book

Part I: Excel Worksheet Orientation Day

Download Chapter
1 TokenChapter 1. Understanding Excel Worksheets (Spreadsheets)

What Is a Worksheet?

What Is a Workbook?

Examining Columns, Rows, and Cells

Understanding Cell Addresses

Understanding Formulas and Functions

Making Data Graphical with Charts

Part II: Creating Your First Worksheet

Download Chapter
1 TokenChapter 4. Entering and Editing Labels and Values

Understanding Types of Data Entries

Moving from Cell to Cell

Using the Scrollbars

Splitting the Workbook Window

Entering Data

Entering Text Labels

Entering Numbers

Entering Dates and Times

Adjusting Number Formats

Having Excel Read Entries Aloud as You Type

Entering Data Quickly with Auto Fill

Viewing and Using Smart Tags

Editing Data Entries

Selecting Cells

Selecting a Cell Range

Naming Cell Ranges

Copying and Moving Data

Copying a Selection

Moving a Selection

Erasing Data

Undoing Actions and Commands

Download Chapter
1 TokenChapter 5. Controlling Rows, Columns, and Cells

Changing Column Widths

Changing Row Heights

Wrapping Text in Cells

Merging Cells

Locking Headings in Place with Freeze Panes

Inserting Rows and Columns

Inserting One or More Columns

Inserting One or More Rows

Inserting Cells

Deleting Rows and Columns

Deleting Cells

Download Chapter
1 TokenChapter 6. Automating Calculations with Formulas and Functions

Learning the Order of Operations

Entering Formulas

Using Point-and-Click Entry

Typing Formulas Manually

Displaying Formulas

Editing Formulas

Copying and Pasting Formulas

Changing the Recalculation Setting

Using the Auto Calculate Feature

Doing Higher Math with Functions

Using the AutoSum Tool

Entering Functions with the Insert Function Dialog Box

Seeing a Loan Function in Action

Troubleshooting Errors in Formulas

Playing “What If?” with Scenarios

Naming and Saving Different Scenarios

Viewing the Results of Different Scenarios

Creating a Summary Report

Part III: Formatting, Charting, and Printing Your Worksheet

Download Chapter
1 TokenChapter 7. Formatting Your Worksheet

Letting Excel Design Your Worksheet with AutoFormat

Changing the Appearance of Entries

Changing Text Attributes with the Toolbar Buttons

Using the Format Cells Dialog Box

Changing the Alignment of Entries in a Cell

Adding Cell Borders

Adding Shading to Cells

Using Conditional Formatting to Flag Entries

Copying Formatting with the Format Painter

Formatting with Styles

Applying Existing Styles

Creating Your Own Styles

Editing Styles

Saving Styles in a Template

Copying Styles from Another Workbook

Download Chapter
1 TokenChapter 8. Charting (Graphing) the Worksheet Data

Understanding Charting Terminology

Creating a Chart

Making a Chart with the Chart Wizard

Moving and Resizing a Chart

Using the Chart Toolbar

Using the Chart Menu

Formatting Text on a Chart

Formatting the Chart Axes

Enhancing the Chart Frame

Changing the Appearance of 3-D Charts

Download Chapter
1 TokenChapter 9. Inserting Clip Art and Other Graphics

Working with Graphic Objects

Inserting Clip Art and Other Graphics

Browsing Through the Clip Art Galleries

Inserting Other Pictures

Resizing and Reshaping Your Pictures

Touching Up Images with the Picture Toolbar

Inserting WordArt Objects

Adding Text Outside a Cell

Drawing Your Own Pictures from Scratch

Working with Layers of Objects

Selecting Objects

Moving an Object Up or Down in the Stack

Grouping and Ungrouping Objects

Changing an Object’s Appearance

Creating an Organization Chart

Download Chapter
1 TokenChapter 10. Printing and Protecting Your Workbook, Worksheets, and Charts

Previewing Your Worksheets Before Printing

Changing the Page Setup

Changing the Page Settings

Adjusting the Page Margins

Adding a Header and Footer

Changing the Worksheet Settings

Checking and Adjusting Page Breaks

Hiding Columns and Rows

Printing Your Worksheets

Previewing and Printing Charts

Preventing Unauthorized Changes to a Workbook

Part IV: Going Beyond the Basics

Download Chapter
1 TokenChapter 11. Managing a Database with Excel

What Is a Database?

Database Terminology

Creating Your Database

Entering Column Labels

Formatting Database Fields

Using Data Forms to Enter, Edit, and Delete Data

Finding Records in Your Database

Sorting Your Records

Narrowing Your List with AutoFilter

Summarizing and Comparing Data with Pivot Tables

Creating a Pivot Table Using the PivotTable Wizard

Creating a Pivot Table from a Single Range

Creating a Pivot Table from Multiple Ranges

Rearranging Data in a Pivot Table

Download Chapter
1 TokenChapter 12. Customizing Excel

Customizing Excel’s Toolbars

Changing the Toolbar Buttons

Creating Your Own Toolbars

Reconfiguring Excel’s Menus

Creating Your Own Menus

Setting Toolbar and Menu Options

Changing Excel’s Default Settings

Installing Optional Components

Download Chapter
1 TokenChapter 13. Automating Tasks with Macros

What Is a Macro?

Recording a Macro

Running a Macro

Creating a Toolbar Button for Your Macro

Editing Macros in Visual Basic Editor

Protecting Your System Against Macro Viruses

Download Chapter
1 TokenChapter 14. Using Excel on the Web

Transforming Worksheets into Web Pages

Inserting Links on Your Worksheets

Publishing Your Worksheets on the Web

Finding a Home for Your Page

Setting Up a Network Place or Web Folder

Uploading Files to an FTP Server

Importing Data from the Web into Your Worksheets

E-mailing Your Worksheet

Saving Your Workbook as an XML File

Download Chapter
1 TokenChapter 15. Using Excel’s Speech and Handwriting Recognition Features

Making Sure You Have the Essential Equipment

Checking Your Sound System

Installing Speech Recognition

Training Excel to Recognize Your Voice

Dictating Your Entries

Entering Voice Commands

Handwriting Your Entries

Installing the Handwriting Recognition Feature

Penning Your Entries by Hand

Part V: Appendixes

Download Chapter
1 TokenAppendix A. Excel Shortcut Keys

Download Chapter
1 TokenGlossary

Extras

The publisher has provided additional content related to this title.

Description	Content
These links have been provided by the publisher.	buyprint

About Safari Books Online • Terms of Service • Privacy Policy • Contact Us • Corporate Licenses • Help • Accessibility |

Absolute Beginner’s Guide to Microsoft® Office Excel 2003

Overview

Top Sellers in this Category

Safari Subscriber Reviews

Browse Similar Topics

Table of Contents

Download Chapter1 TokenChapter 1. Understanding Excel Worksheets (Spreadsheets)

Download Chapter1 TokenChapter 2. Starting and Navigating Excel

Download Chapter1 TokenChapter 3. Working with Workbook Files

Download Chapter1 TokenChapter 4. Entering and Editing Labels and Values

Download Chapter1 TokenChapter 5. Controlling Rows, Columns, and Cells

Download Chapter1 TokenChapter 6. Automating Calculations with Formulas and Functions

Download Chapter1 TokenChapter 7. Formatting Your Worksheet

Download Chapter1 TokenChapter 8. Charting (Graphing) the Worksheet Data

Download Chapter1 TokenChapter 9. Inserting Clip Art and Other Graphics

Download Chapter1 TokenChapter 10. Printing and Protecting Your Workbook, Worksheets, and Charts

Download Chapter1 TokenChapter 11. Managing a Database with Excel

Download Chapter1 TokenChapter 12. Customizing Excel

Download Chapter1 TokenChapter 13. Automating Tasks with Macros

Download Chapter1 TokenChapter 14. Using Excel on the Web

Download Chapter1 TokenChapter 15. Using Excel’s Speech and Handwriting Recognition Features

Download Chapter1 TokenGlossary