did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780596008536

Excel 2003 Personal Trainer

by ;
  • ISBN13:

    9780596008536

  • ISBN10:

    0596008538

  • Edition: CD
  • Format: Paperback
  • Copyright: 2004-12-01
  • Publisher: Oreilly & Associates Inc
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $29.95

Summary

If you're baffled by Excel's multitude of features and functionality, then it's time to experience Excel: Personal Trainer. Part of the O'Reilly Personal Trainer Series, Excel lets you learn exactly what you need to know-at your own pace. You can start with the basics, or if you're already familiar with Excel, you can easily build on your existing knowledge. You'll learn through dozens of task-oriented lessons, each designed to maximize your capabilities and save you precious time. Includes everything you need to know to be a Excel pro. Like all Personal Trainer books, Excel is fully illustrated and includes detailed diagrams to aid learning. Also includes a valuable CD tutorial.

Table of Contents

Introduction xi
The Fundamentals
1(56)
Starting Excel
2(3)
What's New in Excel 2003?
5(2)
Understanding the Excel Program Screen
7(2)
Using Menus
9(4)
Using Toolbars and Creating a New Workbook
13(3)
Filling Out Dialog Boxes
16(3)
Keystroke and Right Mouse Button Shortcuts
19(3)
Opening a Workbook
22(3)
Saving a Workbook
25(2)
Moving the Cell Pointer
27(2)
Navigating a Worksheet
29(2)
Entering Labels in a Worksheet
31(2)
Entering Values in a Worksheet and Selecting a Cell Range
33(2)
Calculating Value Totals with AutoSum
35(2)
Entering Formulas
37(3)
Using AutoFill
40(3)
Previewing and Printing a Worksheet
43(2)
Getting Help
45(3)
Changing the Office Assistant and Using the ``What's This'' Button
48(2)
Closing a Workbook and Exiting Excel
50(7)
Chapter One Review
52(5)
Editing a Worksheet
57(50)
Entering Date Values and Using AutoComplete
58(3)
Editing, Clearing, and Replacing Cell Contents
61(3)
Cutting, Copying, and Pasting Cells
64(3)
Moving and Copying Cells with Drag and Drop
67(3)
Collecting and Pasting Multiple Items
70(2)
Working with Absolute and Relative Cell References
72(3)
Using the Paste Special Command
75(3)
Inserting and Deleting Cells, Rows, and Columns
78(3)
Using Undo, Redo, and Repeat
81(3)
Checking Your Spelling
84(2)
Finding and Replacing Information
86(2)
Advanced Printing Options
88(2)
File Management
90(3)
Inserting Cell Comments
93(2)
Understanding Smart Tags
95(3)
Recovering Your Workbooks
98(9)
Chapter Two Review
101(6)
Formatting a Worksheet
107(46)
Formatting Fonts with the Formatting Toolbar
108(3)
Formatting Values
111(4)
Adjusting Row Height and Column Width
115(3)
Changing Cell Alignment
118(4)
Adding Borders
122(4)
Applying Colors and Patterns
126(3)
Using the Format Painter
129(3)
Using AutoFormat
132(2)
Creating a Custom Number Format
134(3)
Creating, Applying, and Modifying a Style
137(3)
Formatting Cells with Conditional Formatting
140(3)
Merging Cells, Rotating Text, and Using AutoFit
143(2)
Finding and Replacing Formatting
145(8)
Chapter Three Review
148(5)
Creating and Working with Charts
153(40)
Creating a Chart
154(3)
Moving and Resizing a Chart
157(2)
Formatting and Editing Objects in a Chart
159(4)
Changing a Chart's Source Data
163(3)
Changing a Chart Type and Working with Pie Charts
166(4)
Adding Titles, Gridlines, and a Data Table
170(3)
Formatting a Data Series and Chart Axis
173(3)
Annotating a Chart
176(2)
Working with 3-D Charts
178(3)
Selecting and Saving a Custom Chart
181(4)
Using Fill Effects
185(8)
Chapter Four Review
189(4)
Managing Your Workbooks
193(52)
Switching Between Sheets in a Workbook
194(2)
Inserting and Deleting Worksheets
196(3)
Renaming and Moving Worksheets
199(2)
Working with Several Workbooks and Windows
201(4)
Splitting and Freezing a Window
205(3)
Referencing External Data
208(3)
Creating Headers, Footers, and Page Numbers
211(3)
Specifying a Print Area and Controlling Page Breaks
214(3)
Adjusting Page Margins and Orientation
217(2)
Adding Print Titles and Gridlines
219(2)
Changing the Paper Size and Print Scale
221(2)
Protecting a Worksheet
223(3)
Hiding Columns, Rows, and Sheets
226(2)
Viewing a Worksheet and Comparing Workbooks Side by Side
228(2)
Saving a Custom View
230(2)
Working with Templates
232(3)
Consolidating Worksheets
235(10)
Chapter Five Review
238(7)
More Functions and Formulas
245(34)
Formulas with Several Operators and Cell Ranges
246(3)
Using the Insert Function Feature
249(3)
Creating and Using Range Names
252(3)
Selecting Nonadjacent Ranges and Using AutoCalculate
255(2)
Using the IF Function to Create Conditional Formulas
257(2)
Using the PMT Function
259(3)
Displaying and Printing Formulas
262(2)
Fixing Formula Errors
264(15)
Mathematical Functions
267(2)
Financial Functions
269(2)
Date and Time Functions
271(2)
Statistical Functions
273(1)
Database Functions
274(1)
Chapter Six Review
275(4)
Working with Lists
279(30)
Creating a List
280(2)
Working with Lists and Using the Total Row
282(2)
Adding Records Using the Data Form Dialog Box and Insert Row
284(2)
Finding Records
286(2)
Deleting Records
288(2)
Sorting a List
290(2)
Filtering a List with the AutoFilter
292(3)
Creating a Custom AutoFilter
295(2)
Filtering a List with an Advanced Filter
297(3)
Copying Filtered Records
300(2)
Using Data Validation
302(7)
Chapter Seven Review
305(4)
Automating Tasks with Macros
309(22)
Recording a Macro
310(2)
Playing a Macro and Assigning a Macro a Shortcut Key
312(2)
Adding a Macro to a Toolbar
314(2)
Editing a Macro's Visual Basic Code
316(2)
Inserting Code in an Existing Macro
318(3)
Declaring Variables and Adding Remarks to VBA Code
321(3)
Prompting for User Input
324(2)
Using the If...Then...Else Statement
326(5)
Chapter Eight Review
328(3)
Working with Other Programs
331(18)
Inserting an Excel Worksheet into a Word Document
332(3)
Modifying an Inserted Excel Worksheet
335(3)
Inserting a Linked Excel Chart in a Word Document
338(2)
Inserting a Graphic into a Worksheet
340(3)
Opening and Saving Files in Different Formats
343(6)
Chapter Nine Review
346(3)
Using Excel with the Internet
349(24)
Adding and Working with Hyperlinks
350(2)
Browsing Hyperlinks and Using the Web Toolbar
352(3)
Saving a Workbook as a Non-Interactive Web Page
355(4)
Saving a Workbook as an Interactive Web Page
359(3)
Import an External Data Source
362(3)
Refresh a Data Source and Set Data Source Properties
365(3)
Create a New Web Query
368(5)
Chapter Ten Review
371(2)
Data Analysis and PivotTables
373(34)
Creating a PivotTable
374(4)
Specifying the Data a PivotTable Analyzes
378(2)
Changing a PivotTable's Calculation
380(2)
Selecting What Appears in a PivotTable
382(3)
Grouping Dates in a PivotTable
385(2)
Updating a PivotTable
387(2)
Formatting and Charting a PivotTable
389(3)
Creating Subtotals
392(3)
Using Database Functions
395(3)
Using Lookup Functions
398(3)
Grouping and Outlining a Worksheet
401(6)
Chapter Eleven Review
404(3)
What-If Analysis
407(16)
Defining a Scenario
408(2)
Creating a Scenario Summary Report
410(2)
Using a One and Two-Input Data Table
412(3)
Understanding Goal Seek
415(2)
Using Solver
417(6)
Chapter Twelve Review
420(3)
Advanced Topics
423(30)
Hiding, Displaying, and Moving Toolbars
424(2)
Customizing Excel's Toolbars
426(3)
Sending Faxes
429(2)
Creating a Custom AutoFill List
431(2)
Changing Excel's Options
433(3)
Password Protecting a Workbook
436(2)
File Properties and Finding a File
438(3)
Sharing a Workbook and Tracking Changes
441(3)
Merging and Revising a Shared Workbook
444(3)
Using Detect and Repair
447(6)
Chapter Thirteen Review
449(4)
Index 453

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program