Microsoft Office Excel 2003 Inside Out

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 ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (82) from $1.99   
  • New (7) from $1.99   
  • Used (75) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$1.99
Seller since 2007

Feedback rating:

(1320)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
073561511X Fast Reliable Shipping From a trusted online seller!

Ships from: Cypress, TX

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$8.72
Seller since 2010

Feedback rating:

(858)

Condition: New
PAPERBACK New 073561511X Friendly Return Policy. A+++ Customer Service!

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$8.72
Seller since 2013

Feedback rating:

(345)

Condition: New
PAPERBACK New 073561511X! ! KNOWLEDGE IS POWER! ! ENJOY OUR BEST PRICES! ! ! Ships Fast. All standard orders delivered within 5 to 12 business days.

Ships from: Southampton, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$8.72
Seller since 2011

Feedback rating:

(665)

Condition: New
PAPERBACK New 073561511X SERVING OUR CUSTOMERS WITH BEST PRICES. FROM A COMPANY YOU TRUST, HUGE SELECTION. RELIABLE CUSTOMER SERVICE! ! HASSLE FREE RETURN POLICY, SATISFACTION ... GURANTEED**** Read more Show Less

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$8.72
Seller since 2014

Feedback rating:

(239)

Condition: New
PAPERBACK New 073561511X XCITING PRICES JUST FOR YOU. Ships within 24 hours. Best customer service. 100% money back return policy.

Ships from: Bensalem, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$8.72
Seller since 2010

Feedback rating:

(640)

Condition: New
PAPERBACK New 073561511X! ! ! ! BEST PRICES WITH A SERVICE YOU CAN RELY! ! !

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$45.00
Seller since 2014

Feedback rating:

(114)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

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.

Read More Show Less

Product Details

  • ISBN-13: 9780735615113
  • Publisher: Microsoft Press
  • Publication date: 8/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)

Meet 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.

Read More Show Less

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 Calculate Formulas;
Enter Data;
Enter Special Characters;
Extend a Selection;
Filter Lists;
Format, Cells Dialog Box—Border Tab;
Format Data;
Help;
Help Window;
Insert, Delete, and Copy Cells;
Languages;
Macros;
Menus and Toolbars;
Move and Scroll—In End Mode;
Move and Scroll—Worksheets;
Move Within a Selected Range;
Open, Save As, and Insert Picture Dialog Boxes;
PivotTable and PivotChart Wizard Layout Dialog Box;
PivotTable—Display and Hide Items;
PivotTable—Change the Layout;
Print;
Print Preview;
Select Cells, Rows, Columns, and Objects;
Select Cells with Special Characteristics;
Send E-Mail Messages;
Show, Hide, and Outline Data;
Smart Tags;
Speech Recognition and Text-To-Speech;
Task Panes;
Windows and Office Interface;
Worksheets;
Appendix D: Function Reference;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)