Learning Microsoft Excel 2000
by Fulton, Jennifer; Kaczmarczyk, NancyFormat: Paperback
Pub. Date: 1999-06-01
Publisher(s): Pearson College Div
Other versions by this Author
List Price: $69.00
Buy New
Usually Ships in 2-3 Business Days
$68.93
Rent Textbook
Select for Price
Used Textbook
We're Sorry
Sold Out
eTextbook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
Provides a compendium of ten lessons comprising short exercises designed for using Excel 2000 in real-life business settings. Spiral. CD-ROM included.
Table of Contents
| Introduction | p. vi |
| Directory of Files | p. ix |
| Excel 2000 Basics | p. 1 |
| p. 2 | |
| About Microsoft Excel 2000 | |
| Start Excel | |
| The Excel Window | |
| Exit Excel | |
| Use the Mouse | |
| Use the Keyboard | |
| Mouse and Keystroke Procedures | |
| Menus and Commands | |
| Shortcut Menus | |
| Toolbars | |
| Dialog Box Options | |
| p. 11 | |
| Change the Size of a Window | |
| Set View Preferences | |
| The View Menu | |
| The Zoom Option | |
| p. 16 | |
| The Office Assistant | |
| Other Help Features | |
| Help on the Internet | |
| p. 21 | |
| Change the Active Cell | |
| Explore the Worksheet with the Mouse or the Keyboard | |
| Use Go To | |
| Use the Name Box | |
| The Excel Keyboard Template | |
| p. 25 | |
| Manage Multiple Workbooks | |
| Internet Basics | |
| Web Features in Excel 2000 | |
| Use Web Toolbars | |
| Key Worksheet Procedures | p. 31 |
| p. 32 | |
| Start a Blank Workbook | |
| Enter Labels | |
| Make Corrections | |
| Save a Workbook | |
| Close a Workbook | |
| p. 36 | |
| Enter Numeric Labels and Values | |
| Enter Fractions and Mixed Numbers | |
| Change Data Alignment | |
| Center a Title (Merge and Center) | |
| Change Column Width | |
| Adjust Row Height | |
| Indent Text in Cells | |
| Add Comments to Cells | |
| p. 43 | |
| AutoComplete | |
| Pick From List | |
| AutoCorrect | |
| Undo and Redo | |
| Clear Cell Contents | |
| Check Spelling | |
| p. 47 | |
| Enter Line Breaks in a Cell Entry | |
| Enter Dates | |
| Format Dates | |
| p. 50 | |
| Open a Workbook | |
| Change Workbook Properties | |
| Save a Workbook with a Different Name | |
| Create a New Folder | |
| Create Backup Files | |
| Check for Potential Viruses | |
| Send a File | |
| p. 55 | |
| Critical Thinking | |
| Use Formulas And Formatting | p. 57 |
| p. 58 | |
| Use Formulas | |
| Mathematical Operators | |
| Natural Language Formulas | |
| p. 62 | |
| Format Data with Formatting Toolbar | |
| Fonts and Font Size | |
| Add Bold, Italic, and Underline | |
| Currency, Percent, Comma, and Accounting Formats | |
| Increase or Decrease Decimals | |
| Format Numbers with the Format Cells Dialog Box | |
| Create Custom Number Formats | |
| p. 67 | |
| Use Ranges | |
| Name Ranges | |
| p. 72 | |
| Copy Data | |
| Copy Using AutoFill | |
| Copy Part of a Cell's Contents | |
| Copy a Formula (Absolute, Relative, and Mixed Reference) | |
| p. 76 | |
| Create a Series | |
| AutoSum | |
| p. 80 | |
| Use Functions | |
| Formula Bar and Palette | |
| Paste Function | |
| Noncontiguous Ranges in a Function | |
| AutoCalculate | |
| p. 85 | |
| Critical Thinking | |
| Print A Worksheet | p. 87 |
| p. 88 | |
| Preview a Worksheet | |
| Quickly Print a Worksheet | |
| p. 91 | |
| Set the Print Area | |
| Print Options | |
| Page Setup | |
| p. 95 | |
| Page Breaks | |
| Page Break Preview | |
| Headers and Footers | |
| p. 99 | |
| Print Titles | |
| p. 102 | |
| Critical Thinking | |
| Edit and Manipulate Worksheets and Workbooks | p. 103 |
| p. 104 | |
| Insert and Delete Selected Cells | |
| Insert and Delete Columns and Rows | |
| Move Data (Cut/Paste) | |
| Drag-and-Drop Editing | |
| Copy or Move Data with the Office Clipboard | |
| p. 110 | |
| Copy and Paste Special | |
| Transpose Data | |
| p. 113 | |
| Move Between Worksheets | |
| Rearrange Worksheets | |
| Name a Worksheet | |
| Add and Delete Worksheets | |
| Copy a Worksheet | |
| Group Sheets | |
| p. 118 | |
| Copy and Paste Special (Combine Data) | |
| p. 121 | |
| Freeze Titles | |
| Split Panes | |
| Scroll Tips | |
| Move Between Workbooks | |
| Arrange Workbooks | |
| Save the Workspace | |
| New (or Duplicate) Workbook Window | |
| p. 127 | |
| 3-D Formulas | |
| p. 130 | |
| Drag-and-Drop Editing Between Workbooks | |
| Find and Replace | |
| p. 133 | |
| Use Templates (Spreadsheet Solutions) | |
| p. 139 | |
| Create Original Templates | |
| p. 142 | |
| Critical Thinking | |
| Modify the Appearance of a Worksheet | p. 143 |
| p. 144 | |
| Use the Font Tab | |
| Rotate Text | |
| Wrap Text | |
| Merge Cells | |
| p. 148 | |
| Change Cell Colors and Patterns | |
| Change Cell Borders | |
| Hide Worksheet Gridines | |
| Format Worksheet Background | |
| Copy Formats with Format Painter | |
| Clear Cell Formats | |
| Create Styles | |
| p. 154 | |
| The Drawing Toolbar | |
| Insert AutoShapes | |
| Draw Objects | |
| Format Objects | |
| p. 159 | |
| Insert WordArt | |
| p. 162 | |
| Insert and Size Clip Art | |
| Download Clip Art from the Internet | |
| p. 165 | |
| Use AutoFormat to Format Ranges | |
| p. 168 | |
| Add and Format a Text Box | |
| Add Callouts | |
| Add Shadows | |
| p. 172 | |
| Critical Thinking | |
| Integrate Excel with other Applications and the Internet | p. 173 |
| p. 174 | |
| Object Linking and Embedding (OLE) | |
| Link Workbooks | |
| Link Files | |
| Edit a Linked File | |
| Embed a File | |
| Integrate Office Documents | |
| p. 178 | |
| Integrate an Excel Worksheet and a Word Document | |
| Financial Data on the Internet | |
| p. 184 | |
| Save a Worksheet as a Web Page | |
| Web Page Preview | |
| Create an Interactive Worksheet | |
| View a Web Page | |
| p. 191 | |
| Import Text Files | |
| Import Data from Other Applications | |
| Import a Table from an HTML File | |
| Use the Clipboard to Import Data | |
| Export Data to Other Applications | |
| p. 198 | |
| Critical Thinking | |
| Use Advanced Functions | p. 199 |
| p. 200 | |
| Understand IF Functions | |
| Enter an IF Function | |
| Nested IF Functions | |
| =SUMIF() | |
| =COUNTIF() | |
| Conditional Formatting | |
| p. 207 | |
| PMT Function | |
| What-If Data Tables | |
| p. 213 | |
| Solve a Problem with Goal Seek | |
| Use Solver to Resolve Problems | |
| p. 217 | |
| Conditional Sum Wizard | |
| p. 220 | |
| Audit Formulas | |
| Error Messages | |
| p. 224 | |
| Hide Data | |
| Save Different Views of the Workbook (Custom Views) | |
| p. 228 | |
| Scenarios | |
| Report Manager | |
| p. 233 | |
| VLOOKUP Function | |
| HLOOKUP Function | |
| p. 237 | |
| Lock/Unlock Cells in a Worksheet | |
| Protect a Worksheet | |
| Protect a Workbook | |
| p. 241 | |
| Share Workbooks | |
| Track Changes | |
| Merge Changes | |
| p. 245 | |
| Critical Thinking | |
| Create and Modify Charts | p. 247 |
| p. 248 | |
| Chart Basics | |
| Select Chart Data | |
| Chart Elements | |
| Create a Chart | |
| Select a Chart | |
| Change the Chart Type | |
| Resize, Copy, Move, or Delete a Chart | |
| p. 254 | |
| Use the Chart Toolbar | |
| Select a Chart Object | |
| Resize, Move, or Delete a Chart Object | |
| Add a Chart Object | |
| Change Chart Text | |
| Change the Orientation of Chart Text | |
| p. 259 | |
| Enhance the Chart Background | |
| Format Category and Value Axes | |
| Change Color and Patterns of Data Series | |
| Add or Remove Data in a Chart | |
| p. 266 | |
| Preview a Chart | |
| Print a Chart Sheet | |
| Print an Embedded Chart | |
| Publish a Chart to the Internet/intranet | |
| p. 271 | |
| Change the Location of a Chart | |
| Change the Orientation of a Data Series | |
| p. 274 | |
| Create a Stock Chart | |
| Add a Secondary Value Axis to a Chart | |
| Change Data Marker Format | |
| p. 279 | |
| Create an Exploded Pie Chart | |
| Size the Plot Area or Legend in a Chart | |
| Create a Stacked Area Chart | |
| p. 283 | |
| Create a 3-D Chart | |
| Change the View of a 3-D Chart | |
| Display or Hide Gridlines or Data Labels | |
| p. 288 | |
| Map Excel Data with Microsoft Map | |
| Edit and Format a Map | |
| p. 292 | |
| Link a Chart and a Word Document | |
| Embed a Chart into a Word Document | |
| Edit a Linked or Embedded Chart | |
| p. 296 | |
| Critical Thinking | |
| Analyze Data | p. 299 |
| p. 300 | |
| Create a List/Database | |
| Name a List/Database | |
| Use a Data Form to Add Records | |
| Adding Fields to a List | |
| p. 304 | |
| Modify a Record | |
| Find a Record | |
| Delete a Record | |
| p. 308 | |
| Control Data Entry | |
| Copy and Paste Validation Rules | |
| Circle Invalid Data | |
| p. 314 | |
| Sort Records in a List | |
| Rules for Sorting | |
| Undo a Sort | |
| Restore the Record Order | |
| p. 319 | |
| AutoFilter a Database | |
| p. 323 | |
| Advanced Filters | |
| Guidelines for Entering Criteria | |
| Examples of Advanced Criteria | |
| Remove an In-place Advanced Filter | |
| Edit Extracted Records | |
| p. 330 | |
| Use Database (List) Functions | |
| Excel's Database Functions | |
| p. 334 | |
| Subtotal a List | |
| Create Nested Subtotals | |
| Remove a Subtotal | |
| Copy a Subtotal | |
| Outline a Worksheet | |
| p. 340 | |
| Create PivotTables and PivotCharts | |
| Publish a PivotTable or PivotChart | |
| Use PivotTable Toolbar | |
| p. 347 | |
| Data Consolidation | |
| Create Consolidation Tables | |
| p. 351 | |
| Critical Thinking | |
| Create Macros and Hyperlinks | p. 353 |
| p. 354 | |
| Record a Macro | |
| Stop Recording | |
| Run a Macro | |
| p. 359 | |
| Open a Workbook Containing Macros | |
| Edit a Macro | |
| Delete a Macro | |
| Assign a Macro to a Toolbar Button | |
| Assign a Macro to a Control | |
| p. 365 | |
| Link Documents with Hyperlinks | |
| Add a Hyperlink to a Worksheet | |
| p. 370 | |
| Critical Thinking | |
| Table of Contents provided by Syndetics. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.