Excel 2001 for Macintosh: Visual QuickStart Guide

About

Features

• Task-based—Information is broken down into concise, one- and two-page tasks.

  • Allows students to learn the most important tasks of a program or operating system and get right to work on any project. Ex.___

• Step-by-Step—Numbered, easy-to-follow instructions.

  • Succinct numbered instructions provide a logical approach to learning tasks. Ex.___

• Visual Reference—Plenty of screen shots illustrate the step-by-step instructions.

  • Visually demonstrates and reinforces the instructions for a particular task as the students work at their computers. Ex.___

• Quick Reference Tabs—Tabs on each page identify the task.

  • Easy for the instructors and students to find a particular task and makes these texts useful after the course ends. Ex.___

• Shaded sidebars.

  • Sections that call attention to important features and additional helpful information. Ex.___

• Tips.

  • Highlighted through the book offer author advice, time-saving shortcuts, and pointers for students who want a further understanding of the program. Ex.___

• Industry-leading Authors.

  • Many of the authors are industry-leading teachers, writers, and designers, providing students with expert, professional training. Ex.___

• Value-priced.

  • All Visual QuickStart Guides are reasonably priced, making them an affordable option for learning multiple software programs. Ex.___

Description

Microsoft Excel is the spreadsheet program of choice for both home users and serious business workers. With it, you can create anything from a simple chart to an advanced worksheet with graphics and links. New features of Excel 2001 include the List Manager, which anticipates the intent to create a list and automatically offers to convert the cells into a manageable, sortable list. In addition, an updated Calculator function makes it easier for new users to create formulas. The fast-paced and easy-to-read Excel 2001 for Macintosh: Visual QuickStart Guide helps new users get up-to-speed quickly on all of Excel's new and improved features, while additional tips throughout the book make this an excellent reference to the versatility and power of this program.

Extras

Web Resources

Click below for Web Resources related to this title:
Author's Web Site

Sample Content

Table of Contents

Introduction.

Introduction. New & Improved Features in Excel 2001.

Meet Microsoft Excel. The Mouse. Menus. Shortcut Keys. Toolbars & Palettes. Dialog Boxes. Scrolling Windows Contents. The Office Assistant. Excel Help.

How Worksheets Work. Launching Excel. Quitting Excel. Excel Workbooks, Templates, & Wizards. The Project Gallery. Crating Workbooks. Activating & Selecting Cells. Entering Values & Formulas. Values. Formula Basics. The Calculator. Natural Language Formulas.

Editing Worksheets. Editing Cell Content. Inserting & Deleting Cells. Copying Cells. Copying with Copy & Paste. The Fill Handle. The Fill Command. Series & AutoFill. Copying Formulas. Relative vs. Absolute Cell References. Mixed References. Moving Cells. The Office Clipboard. Undoing, Redoing, & Repeating Actions.

Excel Files. Workbook Sheets Workbook Windows. Saving Files. Opening Existing Files.

Functions. Anatomy of a Function. Arguments. Entering Functions. Math & Trig Functions. Statistical Functions. Financial Functions. Logical. Functions. Lookup and Reference Functions. Information Functions. Date and Time Functions. Text Functions.

Formatting Basics. Number Formatting. Alignment. Font Formatting. Boarders. Cell Shading. Styles. Conditional Formatting. The Format Painter. Column Width & Row Height. AutoFit. AutoFormat. Removing Formatting from Cells.

Graphic Objects. The Drawing Toolbar. Drawing Objects. Inserting Pictures. Working with Graphic Objects. Stacking Order.

Charts. The Chart Wizard. Worksheets & Chart Links. Data Series & Points. Chart Elements. Chart Types. Chart Options. Titles. Axes. Gridlines. Legend. Data Labels. Data Table. Formatting Chart Elements. Other Formatting Options.

Printing. Printer Drives. The Page Setup Dialog Box. Print Preview. The Print Dialog Box. Printing to a File.

List Basics. Using the Data Form. The List Manager. AutoFilter. Advanced Filters. Sorting. Subtotals. Database Functions.

Collaboration Features. Document Properties. Comments. Revision Tracking. Document Protection. Save Options & Password Protection. Workbook Sharing.

Using Excel with Other Applications. OLE Objects. Using Word with Excel. Using Entourage with Excel. Using FileMaker Pro with Excel.

Advanced Techniques. Names. 3-D References. Opening Worksheets with Links. Consolidations. Custom Views. Macros.

Web pages. Hyperlinks.

The Preferences Dialog Box. View Preferences. Calculation Preferences. Edit Preferences. General Preferences. Transition Preferences. Custom Lists Preferences. Chart Preferences. Color Preferences.

Menus & Shortcut Keys.

Functions. Financial Functions. Date & Time Functions. Math & Trig Functions. Statistical Functions. Lookup & Reference Functions. Database Functions. Text Functions. Logical Functions. Information Functions.

Updates

Submit Errata