+612 9045 4394
Microsoft Office Excel 2007 Quicksteps : Quicksteps - John Cronan

Microsoft Office Excel 2007 Quicksteps


Paperback Published: 19th December 2006
ISBN: 9780072263725
Number Of Pages: 224

Share This Book:


RRP $32.95
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.

Step-by-Step, Full-Color Graphics!

Get started using Microsoft Office Excel 2007 right away--the QuickSteps way. Color screenshots and clear instructions show you how to use all the new and improved features available in this premier spreadsheet program. Follow along and learn to work with the new Office interface and ribbon, create workbooks, use Excel's XML file formats, enter and edit data, use formulas and functions, create charts and tables, analyze data, and more. Plus, it's easy to flip straight to the information you need using the color-coded tabs. Get the book that gets you started using Excel 2007 in no time.

In each chapter:

  • Shortcuts for accomplishing common tasks
  • Need-to-know facts in concise narrative
  • Helpful reminders or alternate ways of doing things
  • Bonus information related to the topic being covered
  • Errors and pitfalls to avoid

Acknowledgmentsp. iv
Introductionp. xii
Stepping into Excelp. 1
Opening Excelp. 3
Get Started with Excelp. 3
Explore the Excel Windowp. 3
Create a Workbookp. 3
Understanding the Ribbonp. 7
Open an Existing Workbookp. 7
Change the Appearance of New Workbooksp. 8
Customize the Quick Access Toolbarp. 10
Get Helpp. 14
Open Helpp. 15
Use the Excel Help Windowp. 16
Understanding Excel's XML File Formatsp. 18
Close Your Excel Workbookp. 18
Save a Workbook Automaticallyp. 18
Save a Workbook Manuallyp. 21
Save a Copy of Your Workbookp. 22
Add Identifying Informationp. 22
Understanding Excel File Compatibilityp. 24
Exit an Excel Sessionp. 24
Entering and Editing Datap. 25
Understanding Data Typesp. 26
Enter Datap. 26
Enter Textp. 26
Enter Numeric Datap. 29
Completing an Entryp. 30
Enter Datesp. 30
Use Timesp. 31
Formatting Numbersp. 32
Understanding Excel Dates and Timesp. 34
Edit Datap. 35
Edit Cell Datap. 35
Adding Data Quicklyp. 36
Remove Cell Contentsp. 36
Copy and Paste Datap. 38
Selecting Cells and Rangesp. 39
Use Paste Specialp. 39
Find and Replace Datap. 39
Verify Spellingp. 42
Modify Automatic Correctionsp. 44
Formatting a Worksheetp. 45
Adding and Removing Rows, Colunms, and Cellsp. 46
Work with Cells, Rows, and Columnsp. 46
Adjust Row Heightp. 46
Adjust Column Widthp. 47
Hide and Unhide Rows and Columnsp. 48
Change Cell Bordersp. 49
Add a Commentp. 51
Formatting Commentsp. 53
Apply Formattingp. 53
Understanding Excel Formattingp. 54
Apply Themesp. 54
Create Custom Themesp. 59
Searching for Themesp. 60
Use Cell Stylesp. 60
Change Fontsp. 64
Change Alignment and Orientationp. 65
Add a Backgroundp. 66
Transfer Formattingp. 68
Arrange and Organize Worksheetsp. 69
Lock Rows and Columnsp. 69
Split a Worksheetp. 71
Working with Worksheetsp. 72
View Worksheets from Multiple Workbooksp. 72
Compare Workbooksp. 72
Using Formulas and Functionsp. 75
Understanding Cell Referencing Typesp. 76
Reference Cellsp. 76
Change Cell Referencesp. 76
Change to R1C1 Referencesp. 76
Name Cellsp. 77
Using Cell Reference Operatorsp. 79
Go to a Named Cellp. 79
Build Formulasp. 79
Create a Formulap. 79
Working with Cell Namesp. 80
Edit a Formulap. 82
Move Formulasp. 83
Using Formulasp. 84
Copy Formulasp. 84
Recalculate Formulasp. 85
Use External References in Formulasp. 85
Understanding the Trust Centerp. 87
Format Conditionallyp. 91
Using Functions Quicklyp. 95
Use Functionsp. 95
Enter a Functionp. 95
Enter a Sum in Columns or Rows Quicklyp. 98
Find and Correct Errorsp. 98
Check for Errorsp. 98
Trace Precedent and Dependent Cellsp. 100
Watch a Cellp. 100
Evaluate a Formula in Piecesp. 101
Viewing and Printing Datap. 103
Understanding Excel Viewsp. 104
Lay Out a Worksheetp. 104
Add Headers and Footersp. 104
Adding Content to Headers and Footersp. 109
Add Pictures to Headers and Footersp. 109
Change Marginsp. 110
Select Page Orientationp. 112
Use Headers as Page Titlesp. 112
Working with Zoomp. 114
Print the Datap. 115
Change the Order in Which Pages Printp. 115
Choosing Worksheet Print Optionsp. 116
Print Commentsp. 116
Use Print Areasp. 116
Choosing What to Printp. 118
Preview the Print Jobp. 119
Scale Your Data Before Printingp. 125
Output the Print Jobp. 125
Charting Datap. 129
Building a Chartp. 131
Create and Design a Chartp. 131
Choose a Chart Typep. 131
Selecting Data for Chartingp. 134
Choose a Chart Locationp. 134
Modify How the Data Is Plottedp. 137
Apply a Chart Layoutp. 139
Change a Chart's Stylep. 140
Selecting Chart Elementsp. 141
Modify Chart Elementsp. 141
Add Titlesp. 141
Show or Hide Axesp. 142
Add or Remove Gridlinesp. 142
Identifying Chart Elementsp. 143
Show or Hide a Legendp. 143
Add Data Labelsp. 143
Display the Data Tablep. 145
Create Your Own Chart Typep. 145
Add a Second Value Axisp. 146
Format Chart Elementsp. 147
Working with Chartsp. 148
Use Chartsp. 149
Add Charts Elsewherep. 149
Analyze Chartsp. 150
Print a Chartp. 153
Working with Shapes and Picturesp. 155
Understanding Shapesp. 156
Add Shapes, Pictures, and Textp. 156
Add Shapesp. 156
Working with Curvesp. 157
Insert Picturesp. 158
Using Picturesp. 163
Organize Picturesp. 163
Add Textp. 167
Use SmartArtp. 169
Changing SmartArtp. 171
Working with Shapesp. 171
Select, View, and Delete Shapesp. 171
Using Handles and Borders to Change Shapesp. 173
Crop Picturesp. 174
Position Shapesp. 175
Combining Shapes by Groupingp. 177
Formatting Shapes and Textp. 177
Use Stylesp. 177
Apply Styling Elements to Picturesp. 178
Changing a Picture's Attributesp. 180
Change a Shape's Fillp. 180
Add WordArt Styling to Textp. 181
Make Detailed Formatting Changesp. 184
Managing Datap. 185
Understanding Excel Tablesp. 186
Build Tablesp. 186
Create a Tablep. 186
Adding Rows and Columns to a Tablep. 189
Delete Rows and Columns Within a Tablep. 189
Add a Total Rowp. 189
Apply Styles to a Tablep. 190
Working with Tablesp. 192
Validate Datap. 195
Locating Validation Datap. 197
Organize Datap. 198
Sort Data by Columnsp. 199
Sort Data by Rowsp. 202
Removing Filtersp. 203
Create an AutoFilterp. 203
Setting Up Criteria and Extract Rangesp. 206
Use Advanced Filteringp. 206
Outline Data Automaticallyp. 207
Using Outlinesp. 208
Outline Data by Manually Groupingp. 210
Add Subtotalsp. 210
Add Styles to an Outlinep. 211
Analyzing and Sharing Datap. 213
Get the Results You Wantp. 213
Use Goal Seekp. 214
Compare Alternatives Using Scenariosp. 216
Use Multiple Variables to Provide a Resultp. 219
Save Solver Results and Settingsp. 222
Changing Solver Settingsp. 224
Work with PivotTablesp. 224
Create a PivotTablep. 224
Understanding PivotTable Termsp. 225
Create the PivotTable Layoutp. 225
Style a PivotTablep. 229
Using PivotTablesp. 231
Create a PivotTable Chartp. 231
Work with Other Usersp. 234
Protect Workbooks with Passwordsp. 234
Share a Workbookp. 235
Working with Changes in a Shared Workbookp. 237
Protect a Shared Workbookp. 237
Discontinue Sharing a Workbookp. 238
Work with Viewsp. 240
Protect Worksheet and Workbook Elementsp. 241
Extending Excelp. 243
Acquire Datap. 244
Convert Text to Datap. 244
Add a Table from an Access Databasep. 246
Get Data from the Webp. 247
Add External Data from Existing Connectionsp. 248
Setting External Data Range Propertiesp. 249
Manage Connectionsp. 249
Use Excel with Web Technologyp. 252
Understanding the Difference Between Save and Publishp. 253
Save a Workbook as a Web Pagep. 253
Publish Workbook Items as a Web Pagep. 255
Understanding Excel Servicesp. 256
Use Hyperlinksp. 256
Automate Excelp. 260
Use Recorded Macrosp. 260
Edit a Macrop. 262
Indexp. 265
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780072263725
ISBN-10: 0072263725
Series: Quicksteps
Audience: General
Format: Paperback
Language: English
Number Of Pages: 224
Published: 19th December 2006
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 25.4 x 20.3  x 1.4
Weight (kg): 0.68
Edition Number: 1