Amazon no longer offers textbook rentals. We do!

Microsoft Office Excel 2003 : Complete Tutorial

by: Pasewark and Pasewark

Microsoft Office Excel 2003 : Complete Tutorial

by: Pasewark and Pasewark

ISBN 13:
9780619183547
ISBN 10:
0619183543
Format: Hardcover
Copyright: 09/06/2004
Publisher: Cengage Learning
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

Microsoft Office Excel 2003 Complete is designed for beginning to intermediate users of Microsoft Office 2003. This self-paced, self-instructional guide provides you with all the instruction necessary to become a Microsoft Office Specialist at the Expert level for Excel.

Overview of This Book

vii

Preface

Teaching and Learning Resources for this Book

Message from the Authors

xiii

Getting Started

Guide for Using This Book

Introductory Microsoft Excel Unit

Excel Basics

(18)

What Is Excel?

(1)

Starting Excel

(2)

Opening an Existing Workbook

(1)

Moving the Highlight in a Worksheet

(1)

Selecting a Group of Cells

(1)

Entering Data in a Cell

(1)

Changing Data in a Cell

(2)

Searching for Data

(2)

Using Zoom View

(1)

Saving a Workbook

(1)

Printing a Worksheet

(1)

Summary

(6)

Changing the Appearance of a Worksheet

(22)

Changing the Size of a Cell

(3)

Positioning Text Within a Cell

(3)

Changing Cell Appearance

(5)

Cell Formats

(5)

Summary

(6)

Organizing the Worksheet

(24)

Copying Data

(6)

Moving Data

(1)

Inserting and Deleting Rows and Columns

(2)

Freezing Titles

(1)

Splitting Workbook Screens

(1)

Printing Options

(4)

Checking Spelling on a Worksheet

(1)

Summary

(8)

Worksheet Formulas

(20)

What Are Formulas?

(1)

Structure of a Formula

(2)

Editing Formulas

(1)

Relative, Absolute, and Mixed Cell References

(2)

Creating Formulas Quickly

(3)

Previewing a Calculation

(1)

Formula Helpers

(3)

Summary

(8)

Function Formulas

(22)

Function Formulas

(1)

Parts of Function Formulas

(2)

Types of Functions

(11)

Summary

100

(9)

Making the Worksheet Useful

109

(32)

Sorting Data

109

(2)

AutoFilter

111

(2)

Hiding Columns and Rows

113

(1)

Using the Drawing Tools

114

(5)

Adding a Picture to a Worksheet

119

(5)

Using Templates

124

(4)

Inserting Hyperlinks

128

(2)

Saving Workbooks in a Different Format

130

(2)

Viewing and Editing Comments

132

(1)

Using the Research Tool

133

(2)

Summary

135

(6)

Working with Multiple Worksheets

141

(14)

Worksheets in a Workbook

141

(1)

Identifying Worksheets

142

(1)

Positioning Worksheets in a Workbook

143

(1)

Consolidating Workbook Data

144

(3)

Printing a Workbook

147

(2)

Working with Multiple Workbooks

149

(2)

Summary

151

(4)

Worksheet Charts

155

What Is a Worksheet Chart?

155

(2)

Types of Worksheet Charts

157

(2)

Creating a Chart from Worksheet Data

159

(6)

Creating an Embedded Chart

165

(2)

Creating Other Types of Charts

167

(8)

Summary

175

(8)

Unit Review

183

Advanced Microsoft Excel Unit

Applying Advanced Worksheet and Chart Options

(22)

Introduction

(1)

Creating a Custom Format

(2)

Using AutoFormat and Conditional Formatting

(2)

Using Styles and Data Validation

(3)

Transposing Data

(2)

Copying Values

(1)

Modifying Default Settings

(1)

Enhancing the Appearance of Charts

(5)

Time Saver

(1)

Summary

(6)

Using Lists

(14)

Introducing Lists

(1)

Creating a List

(2)

Adding Records to a Data List

(2)

Editing Records in a List

(1)

Deleting Records in a List

(1)

Sorting a List

(2)

Searching for Records Meeting a Specific Criteria

(1)

Time Saver

(1)

Summary

(5)

Filtering, Extracting, and Using Database Functions

(20)

Introduction

(1)

Searching a List Using AutoFilter

(2)

Displaying Records Using Custom Filters and Search Operators

(5)

Displaying Records Using Advanced Filters

(5)

Using DSUM and DAVERAGE

(2)

Time Saver

(1)

Summary

(5)

Working with Analysis Tools

(22)

Introduction

(1)

Using Excel's Auditing Feature

(2)

Performing Data Validation and Circling Invalid Data

(3)

Creating and Merging Scenarios

(5)

Performing What-if Analysis Using Goal Seek

(2)

Using Solver

(1)

Projecting Values Using Correlation and Regression

(3)

Time Saver

(1)

Summary

(4)

Creating PivotTables and PivotCharts

(18)

Introduction

(1)

Creating a PivotList and PivotTable Report

(13)

Time Saver

(1)

Summary

(4)

Creating Macros and Menus

(16)

Introduction

(1)

Understanding Macros

(1)

Creating, Recording, and Running a Macro

100

(2)

Editing a Macro

102

(2)

Changing Macro Settings

104

(1)

Customize a Toolbar by Adding Macro Buttons

105

(2)

Removing a Button from a Toolbar

107

(1)

Assigning a Macro to a Command Button

107

(1)

Creating a Custom Menu

108

(3)

Time Saver

111

(1)

Summary

111

(4)

Importing and Exporting

115

(18)

Introduction

115

(1)

Importing Data

115

(3)

Importing External Data from Other Data Sources

118

(4)

Importing Real Time Data (RTD)

122

(2)

Using Drag-and-Drop to Import Data

124

(1)

Exporting Excel Data

125

(2)

Publishing Excel Worksheets and Workbooks in HTML Format

127

(1)

Time Saver

128

(1)

Summary

129

(4)

Using Templates and Protection

133

(16)

Introduction

133

(1)

Creating and Saving a Template

134

(1)

Opening and Using a Template

135

(1)

Editing a Template

136

(1)

Using Predefined Templates

137

(1)

Adding Protection Options

138

(2)

Protecting Workbooks

140

(1)

Changing Default File Location of Templates

141

(1)

Time Savers

142

(1)

Summary

143

(6)

Working with Multiple Worksheets and Workbooks

149

(16)

Introduction

149

(1)

Naming Ranges and Using in Formulas

150

(1)

Copying Data Between Worksheets

151

(2)

Copying an Entire Worksheet

153

(1)

Printing Multiple Worksheets

154

(1)

Consolidating Data

155

(2)

Moving Between Workbooks

157

(1)

Saving a Workspace

158

(2)

Defining and Modifying Workbook Properties

160

(1)

Time Saver

161

(1)

Summary

162

(3)

Working with Shared Workbooks

165

(16)

Introduction

165

(1)

Creating and Modifying a Shared Workbook

166

(3)

Merging Shared Workbooks

169

(2)

Tracking Changes

171

(2)

Adding Password Protection

173

(2)

Time Saver

175

(1)

Summary

176

(5)

Using Outlines, Subtotals, and Validation

181

(22)

Introduction

181

(1)

Creating Outlines

182

(2)

Creating Subtotals

184

(3)

Grouping Data

187

(2)

Using Data Validation

189

(2)

Circling Invalid Data

191

(2)

Placing a Watch on a Cell

193

(1)

Evaluating a Formula

194

(2)

Time Savers

196

(1)

Summary

197

(6)

Using Advanced Excel Tools

203

Introduction

203

(1)

Creating LOOKUP Functions

204

(2)

Using the FORECAST Function and Adding Trendlines

206

(3)

Using XML to Share Data on the Web

209

(3)

Managing Attributes and Maps in XML Workbooks

212

(2)

Reformatting Graphics

214

(3)

Using Digital Signatures

217

(1)

Time Saver

218

(1)

Summary

219

(4)

Unit Review

223

Appendix A Windows Basics

(1)

Appendix B Computer Concepts

(1)

Appendix C Concepts for Microsoft Office Programs

(1)

Appendix D The Microsoft® Office Specialist Program

(1)

Appendix E Keyboarding Touch System Improvement

(1)

Glossary

(1)

Index

Amazon no longer offers textbook rentals. We do!

Microsoft Office Excel 2003 : Complete Tutorial

Microsoft Office Excel 2003 : Complete Tutorial

9780619183547

0619183543

Summary

Table of Contents

Supplemental Materials

Write a Review