+612 9045 4394
 
CHECKOUT
Microsoft(R) Office Excel 2003 Quicksteps : Consumer Application & Hardware - OMG - John Cronan

Microsoft(R) Office Excel 2003 Quicksteps

Consumer Application & Hardware - OMG

Paperback Published: 27th January 2004
ISBN: 9780072232288
Number Of Pages: 224

Share This Book:

Paperback

RRP $32.95
$25.25
23%
OFF
This title is not in stock at the Booktopia Warehouse and needs to be ordered from our supplier.
Click here to read more about delivery expectations.

Brace youself, because here comes QuickSteps: The fast, easy, accessible information on Excel 2003 in a full-color cookbook-style format. Provides answers to all of your How-do-I questions in a concise and meaningful way. Lengthwise page layout allows for easy page viewing. Useful tips and cautions are displayed in the margins so that they don't break the flow of the quick steps themselves.

Acknowledgmentsp. xv
Introductionp. xvii
Stepping into Excelp. 1
Start Excelp. 1
Use the Start Menu to Load Excelp. 1
Starting Excelp. 3
Open a Workbookp. 4
Opening a Workbookp. 5
Add Identifying Informationp. 5
Find a Workbookp. 6
Using Task Panesp. 7
Personalize Excelp. 7
Remove the Getting Started Task Panep. 7
Select a Toolbar to Displayp. 7
Show Toolbars on Two Rowsp. 8
Customize a Toolbarp. 8
Using Toolbarsp. 10
Get Helpp. 10
Open Helpp. 10
Using Helpp. 11
Do Researchp. 11
End Your Excel Workbookp. 12
Save a Workbook Automaticallyp. 12
Save a Workbook Manuallyp. 12
Save a Copy of Your Workbookp. 13
Save a Workbook As a Templatep. 14
Close an Excel Sessionp. 14
Entering and Editing Datap. 15
Enter Datap. 15
Enter Textp. 17
Completing an Entryp. 18
Enter Numeric Datap. 18
Enter Datesp. 19
Formatting Numbersp. 20
Use Timesp. 22
Adding Data Quicklyp. 24
Edit Datap. 24
Edit Cell Datap. 24
Remove Cell Contentsp. 25
Selecting Cells and Rangesp. 26
Copy and Paste Datap. 27
Use Paste Specialp. 27
Find and Replace Datap. 28
Verify Spellingp. 30
Modify Automatic Correctionsp. 31
Formatting a Worksheetp. 33
Work with Cells, Rows, and Columnsp. 33
Adding and Removing Rows, Columns, and Cellsp. 34
Adjust Row Heightp. 34
Adjust Column Widthp. 35
Hide and Unhide Rows and Columnsp. 36
Change Cell Bordersp. 37
Add a Backgroundp. 39
Add a Commentp. 40
Change How Text Looksp. 40
Use Fontsp. 40
Using Commentsp. 41
Change Alignment and Orientationp. 42
Use Stylesp. 44
Transfer Formattingp. 45
Format Automaticallyp. 46
Format Conditionallyp. 47
Arrange and Organize Worksheetsp. 48
Lock Rows and Columnsp. 48
Split a Worksheetp. 49
View Worksheets from Multiple Workbooksp. 49
Working with Worksheetsp. 50
Using Formulas and Functionsp. 51
Reference Cellsp. 51
Change Cell References in Formulasp. 52
Change to R1C1 Referencesp. 53
Using Cell Reference Operatorsp. 54
Name a Cellp. 54
Go to a Named Cellp. 54
Build Formulasp. 54
Create a Formulap. 55
Edit a Formulap. 56
Move Formulasp. 57
Copy Formulasp. 57
Using Formulasp. 58
Recalculate Formulasp. 58
Use External References in Formulasp. 59
Use Functionsp. 60
Enter a Functionp. 61
Using Functionsp. 63
Sum Numbers in Columns or Rows Quicklyp. 63
Find and Correct Errorsp. 63
Check for Errorsp. 64
Trace Precedent and Dependent Cellsp. 64
Watch a Cellp. 65
Evaluate a Formula in Piecesp. 66
Printing Datap. 67
Set Up the Print Jobp. 67
Add Headers and Footersp. 68
Formatting Headers and Footersp. 70
Add Pictures to Headers and Footersp. 70
Adjust Marginsp. 71
Select Page Orientation and Scalingp. 72
Use Headings as Page Titlesp. 73
Choosing Worksheet Print Optionsp. 74
Change the Order Pages Printp. 74
Print Commentsp. 74
Choosing What to Printp. 75
Print the Datap. 75
Use Print Areasp. 75
Preview the Print Jobp. 76
Output the Print Jobp. 80
Charting Datap. 83
Build a Chart with the Chart Wizardp. 85
Start the Chart Wizardp. 85
Choose a Chart Typep. 86
Select Data for Chartingp. 87
Modify Chart Itemsp. 90
Choose a Chart Locationp. 90
Modify Existing Chartsp. 92
Create a Chart from the Chart Toolbarp. 92
Selecting Chart Itemsp. 93
Identify Itemsp. 93
Add Titlesp. 94
Show or Hide Axesp. 95
Add or Remove Gridlinesp. 95
Show or Hide a Legendp. 96
Add Data Labelsp. 97
Display the Data Tablep. 97
Format Chart Itemsp. 98
Add a Second Value Axisp. 99
Create Your Own Chart Typep. 100
Working with Chartsp. 101
Use Chartsp. 101
Add Pictures and Textp. 101
Add a Trendlinep. 103
Print a Chartp. 104
Work with Pie Chartsp. 105
Working with Graphicsp. 107
Add Graphicsp. 107
Add Picturesp. 109
Organize Clip Artp. 112
Use Clip Artp. 113
Add AutoShapesp. 115
Add Objects from Other Programsp. 115
Working with Curvesp. 116
Add Special Effects to Textp. 118
Create a Diagramp. 119
Format and Modify Graphicsp. 121
Use Color Effectsp. 121
Using Handles and Borders to Change Graphicsp. 122
Resize and Rotate a Graphicp. 124
Trim a Picturep. 125
Positioning Graphicsp. 126
Combine Graphics by Groupingp. 126
Create a Mirrored Imagep. 127
Keep Changes Intactp. 127
Managing Datap. 129
Build Listsp. 129
Create a Listp. 130
Adding Rows and Columns to a Listp. 131
Enter and Manage Data Using a Formp. 132
Locating Data Using a Formp. 134
Add a Total Rowp. 134
Remove a Listp. 134
Validate Datap. 136
Organize Datap. 139
Sort Data by Columnsp. 139
Sort Data by Rowsp. 140
Create an AutoFilterp. 141
Removing Filtersp. 142
Outline Data Automaticallyp. 142
Outline Data by Groupingp. 143
Add Styles to an Outlinep. 143
Using Outlinesp. 144
Acquire Datap. 144
Convert Text to Datap. 144
Add All Data from an Access Tablep. 147
Add Selective Data from an Access Tablep. 147
Get Data from the Webp. 150
Change External Datap. 151
Setting External Data Range Propertiesp. 152
Analyzing and Sharing Datap. 153
Get the Results You Wantp. 153
Use Goal Seekp. 154
Compare Alternatives Using Scenariosp. 156
Use Multiple Variables to Provide a Resultp. 160
Save Solver Results and Settingsp. 162
Changing Solver Settingsp. 164
Work with PivotTablesp. 164
Create a PivotTablep. 165
Create the PivotTable Layoutp. 166
Using PivotTablesp. 167
Create a PivotTable Chartp. 168
Work with Othersp. 169
Guard Workbooks with Passwordsp. 169
Using Passwords in a Shared Workbookp. 170
Share a Workbookp. 170
Merge Shared Workbooksp. 172
Working with Changes in a Shared Workbookp. 173
Protect a Shared Workbookp. 173
Work with Viewsp. 174
Protect Non-Shared Workbooks and Worksheetsp. 175
Extending Excelp. 177
Use Excel with Web Technologyp. 177
Save or Publish a Workbook as a Web Pagep. 178
Save Workbook Items as a Web Pagep. 182
Publish Workbook Itemsp. 182
Using Excel Interactive Web Pagesp. 183
Keep Web Pages Updatedp. 183
Package Excel Web Filesp. 183
Use Hyperlinksp. 186
Plan for the Futurep. 190
Automate Excelp. 191
Use Recorded Macrosp. 191
Edit a Macrop. 195
Starting a Macrop. 196
Communicate with Excelp. 196
Listen to Excelp. 196
Tell Excel What to Dop. 196
Indexp. 199
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780072232288
ISBN-10: 0072232285
Series: Consumer Application & Hardware - OMG
Audience: General
Format: Paperback
Language: English
Number Of Pages: 224
Published: 27th January 2004
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 20.4 x 25.5  x 1.2
Weight (kg): 0.54
Edition Number: 1