Training
Certifications
Books
Special Offers
Community




 
Microsoft® Office Excel® 2003 Step by Step
Author Curtis Frye
Pages 400
Disk 1 Companion CD(s)
Level Beg/Int
Published 08/27/2003
ISBN 9780735615182
Price $24.99
To see this book's discounted price, select a reseller below.
 

More Information

About the Book
Table of Contents
Sample Chapter
Index
Related Series
Related Books
About the Author

Support: Book & CD

Rate this book
Barnes Noble Amazon Quantum Books

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


Last Updated: May 12, 2004
Top of Page