Essentials of Excel 98 for the Macintosh Author:Kevin A. Siegel, Shelly Siegel Essentials of Excel 98 for the Macintosh Course Objectives: Who says spreadsheet programs have to be hard to learn? You'll be shocked how easy it is to learn Excel 98 for the Macintosh using our "skills & drills" approach to learning. If you open this book on Monday morning, you'll be proficient with Excel by Tuesday afternoon. And whe... more »n you have finished with this book, you'll be able to comfortably create simple-to-complex spreadsheets that include absolute and relative formulas. You'll know how to format cells and cell ranges, control pages, work with multiple sheets and even create slick-looking charts. You'll also be able to create your own templates, record and edit macros, and test your data. All this... in two days (or less)! This is the same course that would cost you nearly $600 if you went on-site to a professional training facility. Now you can bring the class to you... and save a bundle. Here's exactly what you'll learn... The Basics Review the Excel 98 Window | Move From Cell to Cell | Type and Edit Data in a Cell | Save an Excel Worksheet | Cell Ranges | Select a Range of Cells | Resize One Column Using AutoFit | Resize Multiple Columns Using AutoFit | Resize Multiple Columns Manually | Move Between Worksheets in a Workbook | Group Worksheets | Enter Data on Multiple Worksheets | AutoFill | Use AutoFill to Enter Data | Insert and Delete Worksheet | Naming Worksheets | Rename and Move Worksheets Formulas and Functions Create a Simple Formula | Use AutoFill to Duplicate a Formula | AutoSum | Use AutoSum | Relative Cell References | Create a Relative Cell Reference | Absolute Cell References | Create an Absolute Cell Reference | Functions | Use Functions to Create Formulas Formatting Cells Move cell contents | Delete and Insert Rows and Columns | Manually Format Selected Cells | Format Cells Automatically Charts Chart Wizard | Create a Chart using Chart Wizard | Moving and Resizing Charts | Resize and Move a Chart | Formatting Charts | Format a Chart’s Plot Area | Change the Font Size of the Chart | Change the Placement of the Legend | Change the Color of a Data Series | Change the Appearance of a Chart’s Title | Change the Chart Type | Add a Graphic to the Chart | Use Color Blends in the Chart | Change the Effect of Chart Data Worksheet Setup Adjust a Worksheet’s Margins and Orientation | Page Breaks, Headers, Footers and Printing | Insert a Manual Page Break | Insert Headers and Footers | Print a Workbook Importing, Filtering & Sorting Data Importing Data | Use the Text Import Wizard | Filtering and Sorting | Filter a List | Custom Filters | Create a Custom Filter | Advanced Filtering Techniques | Filter Data with the Advanced Filter | Copy Filtered Data to Another Location | Sort a List Using Single Criteria | Sort a List Using Multiple Criteria Pivot Tables Create a Pivot Table with the PivotTable Wizard | Update and Change the Layout of a Pivot Table Testing Data & Styles Testing Data | The IF Function | Use the IF Function | The AND Function | Use an AND function | Create Styles Naming & Linking Naming Cells and Ranges | Create a Name | Linking Worksheets | Link Individual Cells | Link Cell Ranges | Linking Worksheets with Names | Define a Name for a Cell Range | Link Cells using Names Consolidating Worksheets Consolidate Data From Multiple Worksheets | Freezing & Splitting Worksheets | Freeze Panes | Split the Worksheet | Hide a Column | Create and Use Comments | Custom Views | Create and Use Custom Views | Protect a Worksheet Templates & Macros Create an IF Function | Delete Cell Contents | Add Comments | Create and Use a Custom Template | Practice Recording a Macro | Record a Macro | Macro Editing | Edit a Macro Note: Excel 98 does not come w« less