Microsoft Office Excel 2003 Step by Step,9780735615182

Microsoft Office Excel 2003 Step by Step

by
Edition: 1st
ISBN13: 9780735615182
ISBN10: 0735615187
Format: Paperback
Pub. Date: 2003-08-27
Publisher(s): Microsoft Press
List Price: $24.99

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $3.61

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

With Microsoft Office Excel 2003 Step by Step, you'll work at your own pace through easy-to-follow lessons and practice exercises to learn exactly the tools and techniques you need. Master the tools for organizing, processing and presenting data; make data come alive with Microsoft PivotTabler and PivotChartr dynamic views; use data analysis tools for better decision making; tap external data sources; add hyperlinks; create macros; and help keep data secure as you share-and collaborate on-Excel documents over the Web. The book also helps you prepare for the Microsoft Office Specialist exam and makes a great on-the-job desk reference.

Author Biography

Curtis Frye is the author of numerous books on Excel and other Office products, most recently the Excel 2007 Pocket Guide. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

Table of Contents

What's New in Microsoft Excel 2003 vii
Getting Help ix
Getting Help with This Book and Its CD-ROM ix
Getting Help with Microsoft Excel 2003 ix
Using the Book's CD-ROM xi
System Requirements xi
Installing the Practice Files xii
Using the Practice Files xii
Uninstalling the Practice Files xiv
Conventions and Features xv
Microsoft Office Specialist Skills Standards xvii
Microsoft Office Specialist Skill Standards xvii
Microsoft Office Specialist Expert Skill Standards xviii
Taking a Microsoft Office Specialist Certification Exam xxi
About the Microsoft Office Specialist Program xxi
Selecting a Microsoft Office Specialist Certification Level xxi
Microsoft Office Specialist Skills Standards xxii
The Exam Experience xxii
Test-Taking Tips xxiv
For More Information xxv
Quick Reference xxvii
Getting to Know Excel xxvii
Setting Up a Workbook xxix
Performing Calculations on Data xxxiii
Changing Document Appearance xxxv
Focusing on Specific Data Using Filters xxxviii
Combining Data from Multiple Sources xl
Reordering and Summarizing Data xlii
Analyzing Alternative Data Sets xliii
Creating Dynamic Lists with PivotTables xlvi
Creating Charts xlviii
Printing li
Automating Repetitive Tasks with Macros liv
Working with Other Microsoft Office Programs lvii
Working with Database Data lviii
Publishing Information on the Web lx
Collaborating with Colleagues lxiv
Getting to Know Excel
1(23)
Introducing Excel
1(2)
Working with an Existing Data List
3(2)
Zeroing In on Data in a List
5(6)
Creating a Workbook
11(6)
Checking and Correcting Data
17(7)
Setting Up a Workbook
24(16)
Making Workbooks Easier to Work With
25(6)
Making Data Easier to Read
31(3)
Adding a Graphic to a Document
34(6)
Performing Calculations on Data
40(16)
Naming Groups of Data
42(2)
Creating Formulas to Calculate Values
44(6)
Finding and Correcting Errors in Calculations
50(6)
Changing Document Appearance
56(26)
Changing the Appearance of Data
58(4)
Applying an Existing Format to Data
62(2)
Making Numbers Easier to Read
64(5)
Changing Data's Appearance Based on Its Value
69(4)
Making Printouts Easier to Follow
73(3)
Positioning Data on a Printout
76(6)
Focusing on Specific Data Using Filters
82(14)
Limiting the Data That Appears on the Screen
84(5)
Performing Calculations on Filtered Data
89(2)
Defining a Valid Set of Values for a Range of Cells
91(5)
Combining Data from Multiple Sources
96(22)
Using a Data List as a Template for Other Lists
98(3)
Working with More Than One Set of Data
101(6)
Linking to Data in Other Workbooks
107(3)
Summarizing Multiple Sets of Data
110(4)
Grouping Multiple Data Lists
114(4)
Reordering and Summarizing Data
118(12)
Sorting a Data List
120(4)
Organizing Data into Levels
124(6)
Analyzing Alternative Data Sets
130(20)
Defining and Editing Alternative Data Sets
132(3)
Defining Multiple Alternative Data Sets
135(3)
Varying Your Data to Get a Desired Result
138(3)
Finding Optimal Solutions with Solver
141(5)
Analyzing Data with Descriptive Statistics
146(4)
Creating Dynamic Lists with PivotTables
150(22)
Creating Dynamic Lists with PivotTables
152(7)
Editing PivotTables
159(7)
Creating PivotTables from External Data
166(6)
Creating Charts
172(24)
Creating a Chart
174(6)
Customizing Chart Labels and Numbers
180(3)
Finding Trends in Your Data
183(2)
Creating a Dynamic Chart Using PivotCharts
185(5)
Creating Diagrams
190(6)
Printing
196(18)
Printing Data Lists
197(8)
Printing Part of a Data List
205(4)
Printing a Chart
209(5)
Automating Repetitive Tasks with Macros
214(18)
Introducing Macros
216(4)
Creating and Modifying Macros
220(3)
Creating a Toolbar to Hold Macros
223(3)
Creating a Menu to Hold Macros
226(4)
Running a Macro When a Workbook Is Opened
230(2)
Working with Other Microsoft Office Programs
232(14)
Including an Office Document in an Excel Worksheet
234(3)
Storing an Excel Document as Part of Another Office Document
237(2)
Creating a Hyperlink
239(4)
Pasting a Chart into Another Document
243(3)
Working with Database Data
246(16)
Looking Up Information in a Data List
248(3)
Retrieving Data from a Database
251(6)
Summarizing List Data
257(5)
Publishing Information on the Web
262(24)
Saving a Workbook for the Web
264(2)
Publishing Worksheets on the Web
266(4)
Publishing a PivotTable on the Web
270(2)
Retrieving Data from the Web
272(3)
Acquiring Web Data with Smart Tags
275(2)
Working with Structured Data
277(2)
Use Professional XML Data Capabilities
279(7)
Collaborating with Colleagues
286(23)
Sharing a Data List
288(3)
Managing Comments
291(2)
Tracking and Managing Colleagues' Changes
293(3)
Identifying Which Revisions to Keep
296(2)
Protecting Workbooks and Worksheets
298(5)
Authenticate Workbooks
303(6)
Glossary 309(4)
Index 313

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.