Buy Used
Used - Very Good See details
Price: £2.79

Have one to sell? Sell yours here
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Microsoft® Office Excel 2003 Inside Out (Inside Out (Microsoft)) [Paperback]

Craig Stinson , Mark Dodge
4.7 out of 5 stars  See all reviews (3 customer reviews)

Available from these sellers.

‹  Return to Product Overview

Table of Contents

Acknowledgments; We'd Like to Hear from You!; About the CD; What's On the CD; Using the CD; System Requirements; Support Information; Conventions and Features Used in this Book; Text Conventions; Design Conventions; About the Authors; Part 1: Examining the Excel Environment; Chapter 1: What's New in Microsoft Office Excel 2003; New and Improved for 2003; If You Missed the Last Upgrade …; Onward …; Chapter 2: Excel Fundamentals; What Happens After You Install Excel?; Recovering from Crashes; Examining the Excel Workspace; File Management Fundamentals; Importing and Exporting Files; Online Help Works—Really!; Chapter 3: Custom-Tailoring the Excel Workspace; Customizing Toolbars and Menus; Managing Toolbars; Creating New Toolbars and Menus; Controlling Other Elements of the Excel Interface; Enhancing Accessibility; Part 2: Building Worksheets; Chapter 4: Worksheet Design Tips; Which Data Should Be in Rows, and Which in Columns?; Will You Need to Print the Worksheet?; Who Is the Audience?; Would Your Worksheet Survive Without You?; Does the Worksheet Rely on Imported Data?; Do You Need More Than One Worksheet?; Have You Allowed Room to Insert New Rows and Columns?; Chapter 5: How to Work a Worksheet; Moving Around; Selecting Stuff; Entering Stuff; Managing Worksheets; Looking at Worksheets; Protecting Worksheets; Chapter 6: How to Work a Workbook; Managing Multiple Workbooks; Opening Multiple Windows for the Same Workbook; Hiding and Protecting Workbooks; Part 3: Formatting and Editing Worksheets; Chapter 7: Worksheet Editing Techniques; Copying, Cutting, and Pasting; Inserting and Deleting; Undoing Previous Actions; Editing Cell Contents; Finding and Replacing Stuff; Editing Multiple Worksheets; Getting the Words Right; Chapter 8: Worksheet Formatting Techniques; Formatting Fundamentals; Formatting in Cells; Creating Custom Formats; Aligning Data in Cells; Aligning Text Vertically; Using Fonts; Customizing Borders; Applying Colors and Patterns; Controlling the Size of Cells; Chapter 9: Advanced Formatting and Editing Techniques; Applying Conditional Formats; Formatting with Styles; Using Template Files to Store Formatting; Auditing and Documenting Worksheets; Outlining Worksheets; Consolidating Worksheets; Part 4: Adding Graphics and Printing; Chapter 10: Creating Spiffy Graphics; Using the Drawing Tools; Creating Graphic Objects; Working with Graphic Objects; Inserting Other Objects; More Tricks with Objects; Gallery of Spiffy Examples; Chapter 11: Printing and Presenting; Controlling the Appearance of Your Pages; Adjusting Page Breaks; Using Print Preview; Specifying What and Where to Print; Setting Printer Driver Options; Part 5: Creating Formulas and Performing Data Analysis; Chapter 12: Building Formulas; Formula Fundamentals; Using Functions: A Preview; Naming Cells and Cell Ranges; Understanding Error Values; Worksheet Calculation; Using Arrays; Linking Workbooks; Creating Conditional Tests; Chapter 13: Using Functions; Using Excel's Built-In Function Reference; Installing the Analysis ToolPak; Exploring the Syntax of Functions; Inserting Functions; Chapter 14: Everyday Functions; Understanding Mathematical Functions; Understanding Text Functions; Understanding Logical Functions; Understanding Information Functions; Understanding Lookup and Reference Functions; Chapter 15: Formatting and Calculating Date and Time; Understanding How Excel Records Dates and Times; Entering Dates and Times; Formatting Dates and Times; Calculating with Date and Time; Working with Date and Time Functions; Chapter 16: Functions for Financial Analysis; Calculating Investments; Calculating Depreciation; Analyzing Securities; Chapter 17: Functions for Analyzing Statistics; Analyzing Distributions of Data; Understanding Linear and Exponential Regression; Using the Analysis Toolpak Data Analysis Tools; Chapter 18: Performing What-If Analysis; Using Data Tables; Using the Scenario Manager; Using the Goal Seek Command; Using the Solver; Part 6: Collaboration and the Internet; Chapter 19: Collaborating with Excel; Saving and Retrieving Files on Remote Computers; Sharing Workbooks on a Network; Combining Changes Made to Multiple Workbooks; Distributing Workbooks and Worksheets by E-Mail; Controlling Document Access with Information Rights Management; Using a SharePoint Team Services Site; Using Web Discussions; Chapter 20: Transferring Files to and from Internet Sites; Working with FTP Sites; Saving and Publishing Excel Files in HTML; Using the Interactive Web Components; Part 7: Integrating Excel with Other Applications; Chapter 21: Linking and Embedding; Embedding vs. Linking; Embedding vs. Static Pasting; Embedding and Linking from the Clipboard; Embedding and Linking with the Object Command; Manipulating Embedded Objects; Managing Links; Linking vs. Hyperlinking; Chapter 22: Using Hyperlinks; Creating a Hyperlink in a Cell; Assigning a Hyperlink to a Graphic, Toolbar Button, or Menu Command; Using the HYPERLINK Function; Chapter 23: Using Excel Data in Word and PowerPoint Documents; Using Excel Tables in Word Documents; Using Excel Charts in Word Documents; Using Excel to Supply Mail-Merge Data to Word; Using Excel Data in PowerPoint; Part 8: Creating Charts; Chapter 24: Basic Charting Techniques; Creating a New Chart; Creating Combination (Overlay) Charts; Changing a Chart's Size and Position; Plotting Hidden Cells; Handling Missing Values; Changing the Default Chart Type; Printing Charts; Saving, Opening, and Protecting Charts; Working with Embedded Chart Objects; Chapter 25: Enhancing the Appearance of Your Charts; Working with the Chart Menu and Chart Toolbar; Selecting Chart Elements; Copying Formats from One Chart to Another; Adding a Customized Chart to the Chart Wizard Gallery; Repositioning Chart Elements with the Mouse; Moving and Resizing the Plot Area; Working with Titles; Adding Text Annotations; Working with Data Labels; Working with Axes; Adding, Removing, and Formatting Gridlines; Formatting Data Series and Markers; Working with Data Tables; Formatting Background Areas; Changing Three-Dimensional Viewing Angles; Chapter 26: Working with Chart Data; Adding Data; Removing Data; Changing or Replacing Data; Plotting or Marking Every nth Point; Changing the Plot Order; Using Multilevel Categories; Adding Trend Lines; Adding Error Bars; What-If Charting: Dragging Markers to Change Data; Chapter 27: Advanced Charting Techniques; Using Named Ranges to Create Dynamic Charts; Using Arrays to Create a Static Chart; Using Bubble Charts; Using Radar Charts; Creating Gannt Charts; Assorted Formatting Issues; Part 9: Managing Databases and Lists; Chapter 28: Managing Information in Lists; Building and Maintaining a List; Working with List Objects; Validating Data Entry; Using Excel's Form Command to Work with Lists; Sorting Lists and Other Ranges; Filtering a List; Using Subtotals to Analyze a List; Using Functions to Extract Details from a List; Chapter 29: Working with External Data; Using File, Open to Import External Data Files; Working with XML Files; Using a Query to Retrieve External Data; Using a Web Query to Return Internet Data; Chapter 30: Analyzing Data with PivotTable Reports; A Simple Example; Creating a PivotTable; Pivoting a PivotTable; Creating a PivotChart; Refreshing a PivotTable; Selecting Elements of a PivotTable; Formatting a PivotTable; Using Multiple Data Fields; Renaming Fields and Items; Sorting Items; Showing the Top or Bottom Items in a Field; Hiding and Showing Inner Field Items; Displaying the Details Behind a Data Value; Grouping and Ungrouping Data; Using Grand Totals and Subtotals; Changing a PivotTable's Calculations; Referencing PivotTable Data from Worksheet Cells; Creating a PivotTable from External Data; Using a PivotTable to Consolidate Ranges; Building a PivotTable from an Existing PivotTable; Printing PivotTables; Using the PivotTable Web Component; Part 10: Automating Excel; Chapter 31: Recording Macros; Using the Macro Recorder; Behind the Scenes: The VBA Environment; Adding Code to an Existing Macro; Using Absolute and Relative References; Macro Subroutines; Using the Personal Macro Workbook; Going On from Here; Chapter 32: Creating Custom Functions; Using Custom Functions; Understanding Custom Function Rules; Using VBA Keywords in Custom Functions; Documenting Macros and Custom Functions; Creating Custom Functions with Optional Arguments; Making Your Custom Functions Available Anywhere; Chapter 33: Debugging Macros and Custom Functions; Using Design-Time Tools; Dealing with Run-Time Errors; Part 11: Appendixes; Appendix A: Installing Microsoft Excel; System Requirements; Installing Office; Uninstalling Office; Installing Additional Components; Repairing Your Office Installation; Appendix B: Using Speech and Handwriting Recognition; Using the Language Bar; Using Speech Recognition; Using Handwriting Recognition; Appendix C: Keyboard Shortcuts; Charts and Select Chart Elements; Data Forms; Dialog Box Edit Boxes; Dialog Boxes; Edit Data; Enter and ...

‹  Return to Product Overview