How to use Microsoft Excel 2000 : visually in full color

著者

書誌事項

How to use Microsoft Excel 2000 : visually in full color

Dan Gookin, Sandy Gookin

SAMS, 1999

タイトル別名

Microsoft Excel 2000

大学図書館所蔵 件 / 全1件

この図書・雑誌をさがす

注記

Includes index

内容説明・目次

内容説明

How to Use Microsoft Excel 2000 is the ideal product for new users looking for a visual approach. Thanks to the generous coverage of the 300 pages in this book, it's also a product that you can grow with. As you master some of the beginning level topics, there is still coverage introducing you to intermediate uses of Excel. This book covers the essential features and tasks in Excel. The focus of coverage is on the core features that you need to understand on an ongoing basis with enough coverage of some of the new features like web collaboration to give you a feel for the power of this new suite and whet your appetite to learn more.

目次

1. Say Hello to Excel. How to Start Excel. How a Spreadsheet Works. How to Use the Office Assistant. How to Start a New Workbook. How to Open a Workbook. How to Enter Data into a Cell. How to Save a Worksheet. How to Print a Worksheet. How to Close a Worksheet. How to Quit Excel. 2. Working the Worksheet. How to Move About the Worksheet. How to Enter Values and Text. How to Enter a Formula. How to Reference Other Cells in a Formula. How to Change Data. How to Fill Groups of Cells. How to Name a Range of Cells. How to Delete or Clear Cells, Rows, or Columns. How to Hide Rows or Columns. How to Insert or Remove Cells. How to Insert Rows or Columns. 3. Cutting, Copying, and Pasting Information. How to Select Cells. How to Copy and Paste Cells. How to Cut and Paste Cells. How to Collect and Paste Cells. How to Drag Cells Around the Worksheet. 4. Crunching Numbers. Use the SUM Function. How to Paste in a Formula. How to Use the IF Formula. How to Round Numbers. How to Truncate Numbers. How to Use the LOOKUP Function. How to Work with Dates. 5. Making Your Data Presentable. How to Format Numbers. How to Format Dollars and Cents. How to Format Percentages. How to Format Dates and Times. How to Align a Cell. How to Fit Text into a Cell. How to Change Your Text. How to Add Borders. How to Add Patterns and Color. How to Undo Formatting. 6. Sprucing Up the Worksheet. How to Sort Data. How to Change Column Width. How to Change Row Height. How to Check Your Spelling. How to Draw Objects. How to Draw Objects Continued. How to Insert ClipArt. How to Change the Worksheet's Background. How to Create Styles. How to Apply Styles. How to Automatically Format a Worksheet. How to Create and Use Templates. 7. Charts and Graphs. How to Use the Chart Wizard. How to Create a Bar Graph. How to Create a Pie Chart. How to Create an Exploding Pie Chart. How to Create a Pie-of-Pie Chart. How to Put a Table into a Chart. How to Change a Chart. 8. Preparing the Document. How to Zoom In and Out. How to Split the Screen. How to Add Headers and Footers. How to Adjust Your Margins. How to Use Print Preview. How to Change Printing Orientation. How to Print Part of the Worksheet. How to Print Various Worksheet Elements. 9. Excel as a Database. How to Create a List of Data (Database). How to Sort and Sift the List. How to Search the List. How to Use the Data Form. 10. The Rest of Excel. How to Use More Than One Worksheet. How to Reference Data in Other Worksheets. How to Insert Foreign Objects. How to Create and Use a Macro. How to Create an HTML Document in Excel. Glossary. Index.

「Nielsen BookData」 より

詳細情報

ページトップへ