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