Download Excel 2003 Just the Steps for Dummies (ISBN - 0764574884) PDF

TitleExcel 2003 Just the Steps for Dummies (ISBN - 0764574884)
TagsFor Dummies
File Size9.8 MB
Total Pages218
Table of Contents
                            About the Author
Contents at a Glance
	About This Book
	Why You Need This Book
	How This Book Is Organized
Part I: Putting Excel to Work
	Chapter 1: Working with Excel Files
		Open and Close Excel
		Create a New Excel File
		Save a Workbook
		Open an Existing Excel File
		Delete an Existing Excel File
		Use the Office Assistant
		Separate the Excel Toolbars
		Display Different Toolbars
		Specify Workbook Properties
		Search for a File by Properties
		Save or Open Files in Different Formats
	Chapter 2: Entering Spreadsheet Data
		Change the Active Cell
		Enter Data
		Undo Data Entry
		Edit or Delete Cell Data
		Select Multiple Cells
		Copy and Paste Data
		Name a Range of Cells
		Extend a Series with AutoFill
		Locate Cells with Data Validation
		Validate Data Entry
	Chapter 3: Building Formulas
		Create Simple Formulas with Operators
		Create Compound Formulas
		Add Numbers with AutoSum
		Find an Average Value
		Copy Formulas with AutoFill
		Edit a Formula
		Define an Absolute Formula
		Copy Values Using Paste Special
		Build a Formula with the Function Wizard
		Generate an IF Statement Formula
		Troubleshoot Formula Errors
		Audit Formulas
Part II: Sprucing Up Your Spreadsheet
	Chapter 4: Formatting Cells and Data
		Align Data
		Format Values
		Indent Data in Cells
		Create a Title by Merging Cells
		Select Font Attributes
		Wrap Text in a Cell
		Rotate Text
		Work with Date Formats
		Adjust Column Width
		Change Row Height
		Copy Formatting
		Use AutoFormats
		Manage Formatting Styles
	Chapter 5: Adding Color and Graphics
		Use Font Color
		Apply Shading to Cells
		Place Borders Around Cells
		Specify Conditional Formatting
		Illustrate with Arrows
		Annotate with Text Boxes
		Draw AutoShapes
		Shade Your Drawings
		Make Objects 3-Dimensional
		Insert Saved Images
		Add Clip Art
		Manipulate Graphics
	Chapter 6: Working with Workbooks
		Insert Additional Worksheets
		Delete Worksheets
		Copy Worksheets
		Rename Worksheets
		Change Worksheet Tab Colors
		Hide and Unhide Worksheets
		Hide Rows or Columns
		Redisplay Rows or Columns
		Unlock Cells
		Relock Cells
		Protect Worksheets
		Create File Passwords
		Generate a Reference to Another Worksheet
		Include a Reference in a Formula
		Cross-Reference Other Workbooks
		Insert a Hyperlink
Part III: Viewing Data in Different Ways
	Chapter 7: Changing Worksheet Views
		Zoom In or Out
		Split the Excel Screen
		Freeze Worksheet Titles
		Hide an Open Workbook
		Arrange Windows
		Compare Spreadsheets
		View Excel in Full Screen View
		Add Cell Comments
		Work with Cell Comments
		Save as a Template
		Open a Template
		Customize Excel Viewing Options
	Chapter 8: Sorting Data
		Use the Toolbar to Sort
		Work with the Sort Command
		Sort by Multiple Criteria
		Create a Customized List
		Sort by Day, Month, or Custom List
		Search for Data
		Find All Data Occurrences
		Locate Cells Based on Format
		Use the Replace Command
	Chapter 9: Creating Charts with Excel
		Create a Basic Chart
		Work with the Chart Wizard
		Change the Chart Type
		Include Titles and Labels
		Customize the Chart Legend
		Modify Chart Attributes
		Add Graphic Images to a Series
		Change a Chart Location
		Add a Data Table
		Enhance a 3-D Chart
		Add or Delete Data
		Format the Value Axis
		Create an Organization Chart
	Chapter 10: Printing Workbooks
		Spell Check
		Preview Before Printing
		Add a Manual Page Break
		Set a Specific Area to Print
		Adjust the Paper Size and Orientation
		Make Worksheets Fit Better on a Page
		Set Page Margins
		Add a Standard Header or Footer
		Create a Custom Header or Footer
		Specify Repeating Rows and Columns
		Print Gridlines and Column Headings
		Print Worksheets and Charts
		E-Mail a Workbook
Part IV: Analyzing Data with Excel
	Chapter 11: Working with Outlines
		Generate a Subtotal
		Collapse Subtotal Headings
		Control Individual Subtotals
		Create Multiple Subtotals
		Copy Subtotals
		Remove Subtotals
		Use AutoOutline
		Form an Outline Group
		Remove Items from a Group
	Chapter 12: Filtering Data
		Create a Data Entry Screen
		Filter Data with AutoFilter
		Perform a Secondary Filter Selection
		Select Only the Top 10
		Customize an AutoFilter
		Find Multiple Criteria
		Use Advanced Filtering
	Chapter 13: Creating Pivot Tables
		Create a PivotTable
		Select and Manage Pivot Data
		Change the Calculation Type
		AutoFormat PivotTables
		Apply Page Fields
		Generate Separate PivotTables
		Rename a Field
		Format PivotTable Values
		Generate Multilevel Totals
		Group Data Together
		Calculate a Percent of Totals
		Add Your Own Calculations
		Create a PivotChart
	Chapter 14: Building Simple Macros
		Record a Macro
		Check Macro Security Level
		Run a Macro
		Assign a Macro KeyStroke
		Create a Macro Toolbar Button
		Stop a Macro
		Delete a Macro
		Delete a Personal Macro
	Chapter 15: Saving Time with Excel Tools
		Add Special Characters
		Create a Custom Toolbar
		Split Data into Multiple Columns
		Merge Columns
		Manage AutoCorrect
		Check for Formula Errors
		Work with SmartTags
Part V: Practical Applications for Excel
	Chapter 16: Creating a Commission Calculator
		Enter Headings
		Create the Commission Table
		Define the Sales Data Input Area
		Total Sales with the SUMIF Function
		Use the COUNTIF Function to Count Sales
		Calculate Commission with a Nested IF Statement
		Create Totals
		Make It Look Nicer
		Protect Your Work
	Chapter 17: Tracking Medical Expenses
		Enter Text Headings
		Create Totaling Formulas
		Calculate the Amount Due
		Specify Data Validation
		Format the Worksheet
		Determine Print Settings
		Add Protection from Accidental Changes
		Duplicate the Worksheet for Other Family Members
		Create a Totals Worksheet
		Save the Workbook as a Template
	Chapter 18: Planning for Your Financial Future
		Plan for a House
		Prepare to Pay Off a Credit Card Balance
		Save for College or Retirement
	Chapter 19: Integrating Excel into Word
		Copy Excel Cells into Word
		Insert a Saved Excel Worksheet into Word
		Edit the Inserted Worksheet
		Embed an Excel Worksheet into Word
		Copy a Word Table to Excel
		Create a Word Mail Merge Form Letter Using an Excel List
		Make Mailing Labels
	Chapter 20: Blending Excel and PowerPoint
		Copy Excel Cells into a PowerPoint Slide
		Drag an Excel Chart into a PowerPoint Slide
		Insert a Saved Excel Worksheet or Chart into a PowerPoint Slide
		Link an Excel Worksheet into a PowerPoint Slide
	Chapter 21: Using Excel with Access
		Copy Data from Excel to an Access Table
		Import Data from Excel to an Access Table
		Link an Excel Worksheet to an Access Database
		Analyze Access Data with Microsoft Excel
		Export Access Data to Excel
Document Text Contents
Page 1

by Diane Koers

Excel® 2003
Just the Steps™



01_574884 ffirs.qxp 3/7/06 9:56 PM Page i

File Attachment

Page 2

02_574884 ftoc.qxp 3/7/06 9:56 PM Page vi

Page 109

Adjust the Paper Size and Orientation
1. Choose File➪Page Setup. The Page Setup dialog box


2. From the Page tab (see Figure 10-7), select whether
you want a Portrait or Landscape orientation from the
Orientation section. Portrait orientation prints the
top along the short edge of the paper and Landscape
prints along the long edge of the paper.

3. Select a paper size from the Paper Size drop-down list.
The paper size choices you see depend on the printer
you use. The two most common choices are Letter
(which is 8.5 inches by 11 inches) and Legal (which is
8.5 inches by 14 inches).

4. Click OK.

Make Worksheets Fit Better on a Page
1. Choose File➪Page Setup. The Page Setup dialog box


2. Click the Page tab.

3. From the Scaling area, make a selection from the
options shown in Figure 10-8:

• Adjust To: Enlarge or shrink the printed font size by
setting a percentage option between 10 and 400.

• Fit To: Force Excel to a specified number of pages
wide and tall.

Don’t try to shrink the document too much. Because Excel shrinks
the font, trying to fit too much on a page can make the document
too small to read.

4. Click OK.

Figure 10-7: Choose paper options from the
Page tab

Figure 10-8: Squeeze your worksheet onto a
specified number of pages


Make Worksheets Fit Better on a Page

16_574884 ch10.qxp 3/7/06 10:01 PM Page 101

Page 110

Set Page Margins
1. Choose File➪Page Setup. The Page Setup dialog box


2. Click the Margins tab (shown in Figure 10-9) and set
the margins for the top, bottom, left, and right side
of the page.

The default worksheet margins are 1 inch on both the top and bot-
tom and .75 inch on the left and right sides.

Click the Horizontally and/or the Vertically options in the Center on
Page section to center the worksheet on the page, regardless of the

3. Click OK.

Add a Standard Header or Footer
1. Choose File➪Page Setup. The Page Setup dialog box


2. Click the Header/Footer tab. See Figure 10-10.

Headers appear at the top of each printed page and footers
appear at the bottom of each printed page.

3. Select a header from the Header drop-down list.

4. Select a footer from the Footer drop-down list.

5. Click OK.

Figure 10-9: Set worksheet page margins

Figure 10-10: Choose a predefined header or


Chapter 10: Printing Workbooks

16_574884 ch10.qxp 3/7/06 10:01 PM Page 102

Page 217

defined, 53
deleting, 54
embedding into Word, 174
fitting on the page, 101
hiding and unhiding, 56
importing data to Access table, 187–189
inserting, 54
inserting into PowerPoint slides, 182
linking into PowerPoint slides, 183
linking to Access database, 190–191
maximum number per workbook, 53
moving between, 14
printing, 105

protecting, 59
referencing another worksheet, 61
renaming, 55
rules for naming, 55
saving into Word, 173
splitting data into multiple columns, 147
unprotecting, 59

wrapping text in cells, 36

• Z •
zooming in or out, 68



30_574884 bindex.qxp 3/7/06 10:08 PM Page 209

Page 218


30_574884 bindex.qxp 3/7/06 10:08 PM Page 210

Similer Documents