Excel 2003 Inside Out
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
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 WorkspacePart 2: Building Worksheets
- Chapter 4: Worksheet Design Tips
- Chapter 5: How to Work a Worksheet
- Chapter 6: How to Work a WorkbookPart 3: Formatting and Editing Worksheets
- Chapter 7: Worksheet Editing Techniques
- Chapter 8: Worksheet Formatting Techniques
- Chapter 9: Advanced Formatting and Editing TechniquesPart 4: Adding Graphics and Printing
- Chapter 10: Creating Spiffy Graphics
- Chapter 11: Printing and PresentingPart 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 AnalysisPart 6: Collaboration and the Internet
- Chapter 19: Collaborating with Excel
- Chapter 20: Transferring Files to and from Internet SitesPart 7: Integrating Excel with Other Applications
- Chapter 21: Linking and Embedding
- Chapter 22: Using Hyperlinks
- Chapter 23: Using Excel Data in Word and PowerPoint DocumentsPart 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 TechniquesPart 9: Managing Databases and Lists
- Chapter 28: Managing Information in Lists
- Chapter 29: Working with External Data
- Chapter 30: Analyzing Data with PivotTable ReportsPart 10: Automating Excel
- Chapter 31: Recording Macros
- Chapter 32: Creating Custom Functions
- Chapter 33: Debugging Macros and Custom FunctionsPart 11: Appendixes
- Appendix A: Installing Microsoft Excel
- Appendix B: Using Speech and Handwriting Recognition
- Appendix C: Keyboard Shortcuts
- Appendix D: Function Reference