Microsoft Office Excel 2003 Inside Out

Microsoft Office Excel 2003 Inside Out

by Craig Stinson, Mark Dodge

Paperback(Book & CD-ROM)

$37.87 $44.99 Save 16% Current price is $37.87, Original price is $44.99. You Save 16%.

Overview

Hey, you know your way around a spreadsheet—so now dig into Excel 2003 and really put your data to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format. It’s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Excel mastery!

  • Build on what you already know about Excel and quickly dive into what’s new
  • Learn how the experts design more powerful spreadsheets
  • Sharpen your core to advanced document editing and formatting skills
  • Perform calculations, analyze data, and build PivotTable reports
  • Drill into new Excel functions for statistical analysis
  • Create high-impact charts, including bubble, radar, and Gantt charts
  • Link and embed Excel data in other Microsoft Office programs
  • Capture, reuse, and share data by exploiting XML features
  • Use macros and Microsoft Visual Basic for Applications to automate Excel

CD features:

  • Complete eBook
  • Insider Extras—including 30-day trial edition of Spreadsheet Assistant add-in.
  • Catalog of select Excel resources with links to third-party tools and demos
  • Microsoft add-ins, demos, and trials, including Insider’s Guide to Microsoft Office OneNote eBook
  • Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entries

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Product Details

ISBN-13: 9780735615113
Publisher: Microsoft Press
Publication date: 08/27/2003
Series: Microsoft Inside Out Series
Edition description: Book & CD-ROM
Pages: 1056
Product dimensions: 7.40(w) x 9.32(h) x 1.85(d)

About the Author

Craig Stinson is a journalist and author. He has written or coauthored more than 20 books including Windows Vista® Inside Out, Deluxe Edition and Microsoft® Office Excel® 2007 Inside Out.

Mark Dodge has coauthored several popular books on Excel®, including Microsoft® Office Excel® 2003 Inside Out. He is a former senior technical writer for the Microsoft® Office User Assistance group.

Table of Contents

Acknowledgments

We'd Like to Hear from You!

About the CD

Conventions and Features Used in this Book

About the Authors

Part 1: Examining the Excel Environment

Chapter 1: What's New in Microsoft Office Excel 2003

Chapter 2: Excel Fundamentals

Chapter 3: Custom-Tailoring the Excel Workspace

Part 2: Building Worksheets

Chapter 4: Worksheet Design Tips

Chapter 5: How to Work a Worksheet

Chapter 6: How to Work a Workbook

Part 3: Formatting and Editing Worksheets

Chapter 7: Worksheet Editing Techniques

Chapter 8: Worksheet Formatting Techniques

Chapter 9: Advanced Formatting and Editing Techniques

Part 4: Adding Graphics and Printing

Chapter 10: Creating Spiffy Graphics

Chapter 11: Printing and Presenting

Part 5: Creating Formulas and Performing Data Analysis

Chapter 12: Building Formulas

Chapter 13: Using Functions

Chapter 14: Everyday Functions

Chapter 15: Formatting and Calculating Date and Time

Chapter 16: Functions for Financial Analysis

Chapter 17: Functions for Analyzing Statistics

Chapter 18: Performing What-If Analysis

Part 6: Collaboration and the Internet

Chapter 19: Collaborating with Excel

Chapter 20: Transferring Files to and from Internet Sites

Part 7: Integrating Excel with Other Applications

Chapter 21: Linking and Embedding

Chapter 22: Using Hyperlinks

Chapter 23: Using Excel Data in Word and PowerPoint Documents

Part 8: Creating Charts

Chapter 24: Basic Charting Techniques

Chapter 25: Enhancing the Appearance of Your Charts

Chapter 26: Working with Chart Data

Chapter 27: Advanced Charting Techniques

Part 9: Managing Databases and Lists

Chapter 28: Managing Information in Lists

Chapter 29: Working with External Data

Chapter 30: Analyzing Data with PivotTable Reports

Part 10: Automating Excel

Chapter 31: Recording Macros

Chapter 32: Creating Custom Functions

Chapter 33: Debugging Macros and Custom Functions

Part 11: Appendixes

Appendix A: Installing Microsoft Excel

Appendix B: Using Speech and Handwriting Recognition

Appendix C: Keyboard Shortcuts

Appendix D: Function Reference

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews