Excel Personal Trainer

Description:

Every time a new version of Microsoft Excel appears, you're introduced to another batch of powerful features--most of which you'll never understand or use. Even if you're experienced with this spreadsheet program, you'll struggle to keep up with all of the improvements. But if you're a beginner, you probably don't know where to start.

Now, with Excel 2003 Personal Trainer, beginners and experts alike can become black belts, quickly and easily. This fully illustrated book takes a modular approach to learning, allowing you to start with the fundamentals and work your way to advance topics through dozens of task-oriented lessons---at your own pace. The companion CD tutorial guides you through each lesson interactively.

Excel 2003 Personal Trainer includes sections on editing, formatting, functions, formulas, lists, macros, creating and managing workbooks, and creating and editing charts. You'll also learn data analysis, what-if analysis, pivot tables, how get Excel to work with other programs and the Internet, and advanced topics like using detect and repair. Every chapter includes detailed diagrams and a review at the end to help you absorb and retain all you have learned.

If you already use Excel, you can dive right into those topics (and only those topics) that you need or want to learn. Unlike many consumer software tutorials that dumb down the material or present it in a confusing fashion, Excel 2003 Personal Trainer is written in a non-technical and engaging style that you will find fun, easy, and most of all, clear and informative. You don't have to wade through tons of jargon and technical information to become proficient with Excel.

Part of our new Personal Trainer Series, this book is based on content from CustomGuide (www.customguide.com), a leading provider of computer training materials. Founded by instructors who grew dissatisfied with the industry's dry course materials, CustomGuide offers courseware (for instructors and students), quick references, to software bulletins and e-learning courses that are fun, flexible, and easy to use.

Table of Contents:

Introduction
Chapter 1. The Fundamentals
Lesson 1.1
      Starting Excel
Lesson 1.2
      What's New in Excel 2003?
Lesson 1.3
      Understanding the Excel Program Screen
Lesson 1.4
      Using Menus
Lesson 1.5
      Using Toolbars and Creating a New Workbook
Lesson 1.6
      Filling Out Dialog Boxes
Lesson 1.7
      Keystroke and Right Mouse Button Shortcuts
Lesson 1.8
      Opening a Workbook
Lesson 1.9
      Saving a Workbook
Lesson 1.10
      Moving the Cell Pointer
Lesson 1.11
      Navigating a Worksheet
Lesson 1.12
      Entering Labels in a Worksheet
Lesson 1.13
      Entering Values in a Worksheet and Selecting a Cell Range
Lesson 1.14
      Calculating Value Totals with AutoSum
Lesson 1.15
      Entering Formulas
Lesson 1.16
      Using AutoFill
Lesson 1.17
      Previewing and Printing a Worksheet
Lesson 1.18
      Getting Help
Lesson 1.19
      Changing the Office Assistant and Using the "What's This" Button
Lesson 1.20
      Closing a Workbook and Exiting Excel
      Chapter One Review
Chapter 2. Editing a Worksheet
Lesson 2.1
      Entering Date Values and Using AutoComplete
Lesson 2.2
      Editing, Clearing, and Replacing Cell Contents
Lesson 2.3
      Cutting, Copying, and Pasting Cells
Lesson 2.4
      Moving and Copying Cells with Drag and Drop
Lesson 2.5
      Collecting and Pasting Multiple Items
Lesson 2.6
      Working with Absolute and Relative Cell References
Lesson 2.7
      Using the Paste Special Command
Lesson 2.8
      Inserting and Deleting Cells, Rows, and Columns
Lesson 2.9
      Using Undo, Redo, and Repeat
Lesson 2.10
      Checking Your Spelling
Lesson 2.11
      Finding and Replacing Information
Lesson 2.12
      Advanced Printing Options
Lesson 2.13
      File Management
Lesson 2.14
      Inserting Cell Comments
Lesson 2.15
      Understanding Smart Tags
Lesson 2.16
      Recovering Your Workbooks
      Chapter Two Review
Chapter 3. Formatting a Worksheet
Lesson 3.1
      Formatting Fonts with the Formatting Toolbar
Lesson 3.2
      Formatting Values
Lesson 3.3
      Adjusting Row Height and Column Width
Lesson 3.4
      Changing Cell Alignment
Lesson 3.5
      Adding Borders
Lesson 3.6
      Applying Colors and Patterns
Lesson 3.7
      Using the Format Painter
Lesson 3.8
      Using AutoFormat
Lesson 3.9
      Creating a Custom Number Format
Lesson 3.10
      Creating, Applying, and Modifying a Style
Lesson 3.11
      Formatting Cells with Conditional Formatting
Lesson 3.12
      Merging Cells, Rotating Text, and Using AutoFit
Lesson 3.13
      Finding and Replacing Formatting
      Chapter Three Review
Chapter 4. Creating and Working with Charts
Lesson 4.1
      Creating a Chart
Lesson 4.2
      Moving and Resizing a Chart
Lesson 4.3
      Formatting and Editing Objects in a Chart
Lesson 4.4
      Changing a Chart's Source Data
Lesson 4.5
      Changing a Chart Type and Working with Pie Charts
Lesson 4.6
      Adding Titles, Gridlines, and a Data Table
Lesson 4.7
      Formatting a Data Series and Chart Axis
Lesson 4.8
      Annotating a Chart
Lesson 4.9
      Working with 3-D Charts
Lesson 4.10
      Selecting and Saving a Custom Chart
Lesson 4.11
      Using Fill Effects
      Chapter Four Review
Chapter 5. Managing Your Workbooks
Lesson 5.1
      Switching Between Sheets in a Workbook
Lesson 5.2
      Inserting and Deleting Worksheets
Lesson 5.3
      Renaming and Moving Worksheets
Lesson 5.4
      Working with Several Workbooks and Windows
Lesson 5.5
      Splitting and Freezing a Window
Lesson 5.6
      Referencing External Data
Lesson 5.7
      Creating Headers, Footers, and Page Numbers
Lesson 5.8
      Specifying a Print Area and Controlling Page Breaks
Lesson 5.9
      Adjusting Page Margins and Orientation
Lesson 5.10
      Adding Print Titles and Gridlines
Lesson 5.11
      Changing the Paper Size and Print Scale
Lesson 5.12
      Protecting a Worksheet
Lesson 5.13
      Hiding Columns, Rows, and Sheets
Lesson 5.14
      Viewing a Worksheet and Comparing Workbooks Side by Side
Lesson 5.15
      Saving a Custom View
Lesson 5.16
      Working with Templates
Lesson 5.17
      Consolidating Worksheets
      Chapter Five Review
Chapter 6. More Functions and Formulas
Lesson 6.1
      Formulas with Several Operators and Cell Ranges
Lesson 6.2
      Using the Insert Function Feature
Lesson 6.3
      Creating and Using Range Names
Lesson 6.4
      Selecting Nonadjacent Ranges and Using AutoCalculate
Lesson 6.5
      Using the IF Function to Create Conditional Formulas
Lesson 6.6
      Using the PMT Function
Lesson 6.7
      Displaying and Printing Formulas
Lesson 6.8
      Fixing Formula Errors
      Mathematical Functions
      Financial Functions
      Date and Time Functions
      Statistical Functions
      Database Functions
      Chapter Six Review
Chapter 7. Working with Lists
Lesson 7.1
      Creating a List
Lesson 7.2
      Working with Lists and Using the Total Row
Lesson 7.3
      Adding Records Using the Data Form Dialog Box and Insert Row
Lesson 7.4
      Finding Records
Lesson 7.5
      Deleting Records
Lesson 7.6
      Sorting a List
Lesson 7.7
      Filtering a List with the AutoFilter
Lesson 7.8
      Creating a Custom AutoFilter
Lesson 7.9
      Filtering a List with an Advanced Filter
Lesson 7.10
      Copying Filtered Records
Lesson 7.11
      Using Data Validation
      Chapter Seven Review
Chapter 8. Automating Tasks with Macros
Lesson 8.1
      Recording a Macro
Lesson 8.2
      Playing a Macro and Assigning a Macro a Shortcut Key
Lesson 8.3
      Adding a Macro to a Toolbar
Lesson 8.4
      Editing a Macro's Visual Basic Code
Lesson 8.5
      Inserting Code in an Existing Macro
Lesson 8.6
      Declaring Variables and Adding Remarks to VBA Code
Lesson 8.7
      Prompting for User Input
Lesson 8.8
      Using the If-Then-Else Statement
      Chapter Eight Review
Chapter 9. Working with Other Programs
Lesson 9.1
      Inserting an Excel Worksheet into a Word Document
Lesson 9.2
      Modifying an Inserted Excel Worksheet
Lesson 9.3
      Inserting a Linked Excel Chart in a Word Document
Lesson 9.4
      Inserting a Graphic into a Worksheet
Lesson 9.5
      Opening and Saving Files in Different Formats
      Chapter Nine Review
Chapter 10. Using Excel with the Internet
Lesson 10.1
      Adding and Working with Hyperlinks
Lesson 10.2
      Browsing Hyperlinks and Using the Web Toolbar
Lesson 10.3
      Saving a Workbook as a Non-Interactive Web Page
Lesson 10.4
      Saving a Workbook as an Interactive Web Page
Lesson 10.5
      Import an External Data Source
Lesson 10.6
      Refresh a Data Source and Set Data Source Properties
Lesson 10.7
      Create a New Web Query
      Chapter Ten Review
Chapter 11. Data Analysis and PivotTables
Lesson 11.1
      Creating a PivotTable
Lesson 11.2
      Specifying the Data a PivotTable Analyzes
Lesson 11.3
      Changing a PivotTable's Calculation
Lesson 11.4
      Selecting What Appears in a PivotTable
Lesson 11.5
      Grouping Dates in a PivotTable
Lesson 11.6
      Updating a PivotTable
Lesson 11.7
      Formatting and Charting a PivotTable
Lesson 11.8
      Creating Subtotals
Lesson 11.9
      Using Database Functions
Lesson 11.10
      Using Lookup Functions
Lesson 11.11
      Grouping and Outlining a Worksheet
      Chapter Eleven Review
Chapter 12. What-If Analysis
Lesson 12.1
      Defining a Scenario
Lesson 12.2
      Creating a Scenario Summary Report
Lesson 12.3
      Using a One and Two-Input Data Table
Lesson 12.4
      Understanding Goal Seek
Lesson 12.5
      Using Solver
      Chapter Twelve Review
Chapter 13. Advanced Topics
Lesson 13.1
      Hiding, Displaying, and Moving Toolbars
Lesson 13.2
      Customizing Excel's Toolbars
Lesson 13.3
      Sending Faxes
Lesson 13.4
      Creating a Custom AutoFill List
Lesson 13.5
      Changing Excel's Options
Lesson 13.6
      Password Protecting a Workbook
Lesson 13.7
      File Properties and Finding a File
Lesson 13.8
      Sharing a Workbook and Tracking Changes
Lesson 13.9
      Merging and Revising a Shared Workbook
Lesson 13.10
      Using Detect and Repair
      Chapter Thirteen Review
Index