Synopses & Reviews
Hey, you know your way around a spreadsheetso 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 Extrasincluding 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, eBook10,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 OReilly Medias Digital Distribution services. To download this content, please visit OReillys 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 [email protected].
Synopsis
Target Audience: Tech-savvy information workers. About the Technology: Office 2003 provides new capabilities, new technologies, and new designs to help information workers and businesses in:
Synopsis
25-Word Description Take your Microsoft Excel experience to the next level! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds for Excel 2003 in concise, fast-answer format. 75-Word Description Hey, you know your way around a spreadsheet--so now dig into Excel 2003 and really put its data analysis capabilities to work! This supremely organized reference packs all the information you need to master every major tool, task, and enhancement in Excel 2003--without the fluff. Work smarter with core functions such as using worksheets and charts, analyzing data, and creating databases--and quickly advance your expertise by creating macros, using custom functions, and automating Microsoft Excel with Microsoft Visual Basic(R) for Applications. You'll gain hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format. You also get the entire book on CD-ROM, along with the Excel Productivity Kit--featuring a complete eBook; author extras; the Microsoft Computer Dictionary, Fifth Edition; advance chapters from a forthcoming business-school-level book on data analysis; and dozens of other resources, including several direct from the Microsoft Office product group. With INSIDE OUT, you'll discover the best and fastest ways to perform everyday tasks--and challenge yourself to new levels of Excel mastery! Positioning Statement: Designed for advanced users, this supremely organized, one-volume reference will help you conquer Excel 2003--from the inside out!
Synopsis
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
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
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.
Table of Contents
AcknowledgmentsWe'd Like to Hear from You!About the CDConventions and Features Used in this BookAbout the AuthorsPart 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