Register your product to gain access to bonus material or receive a coupon.
Sams Teach Yourself Microsoft Excel 2000 in 10 Minutes
- By Jennifer Fulton
- Published Apr 30, 1999 by Sams. Part of the Sams Teach Yourself series.
Book
- This product currently is not for sale.
Description
- Copyright 1999
- Dimensions: 5.5 X 8.5
- Pages: 224
- Edition: 1st
- Book
- ISBN-10: 0-672-31457-6
- ISBN-13: 978-0-672-31457-5
Sams Teach Yourself Microsoft Excel 2000 covers the most common tasks and features used in Excel. You will save time by completing the 10-minute lessons on the most used features rather than weeding through pages and pages of reference material. The perfect down and dirty little tutorial to get up and running with Excel QUICKLY.
Sample Content
Table of Contents
Introduction.
1. Starting and Exiting Excel.
Starting Excel. A Look at the Excel Screen. Exiting Excel.
2. Creating and Opening Workbook Files.
Creating a New Workbook. Opening an Existing Workbook. Finding a Workbook File.
3. Saving and Closing Workbook Files.
Saving and Naming a Workbook. Saving a Workbook Under a New Name. Closing Workbooks.
4. Using Excel's Toolbars.
Using the Toolbars. Turning Toolbars On and Off. Moving Toolbars. Customizing the Toolbars.
5. Getting Around Excel.
Moving from Worksheet to Worksheet. Moving from Workbook to Workbook. Moving Within a Worksheet.
6. Getting Help.
Asking the Office Assistant for Help. Helping Yourself.
7. Beyond Help.
Going Online to Get Help. Turning the Office Assistant On or Off. Changing to a Different Office Assistant. Getting Help with Screen Elements.
8. Changing How You View Your Worksheet.
Magnifying and Reducing the Worksheet View. Freezing Column and Row Labels. Splitting Worksheets. Hiding Workbooks, Worksheets, Columns, and Rows.
9. Entering Different Types of Data.
Entering Text. Entering Numbers. Entering Dates and Times. Copying (Filling) the Same Data to Other Cells. Entering a Series of Numbers, Dates, and Other Data. Entering the Same Data in a Column Over and Over.
10. Correcting Your Entries.
Making Changes to Data. Undoing an Action. Finding and Replacing Data. Checking Your Spelling.
11. Working with Ranges.
What Is a Range? Selecting a Range. Naming Ranges.
12. Copying, Moving, and Deleting Ranges.
Copying Data. Moving Data. Using the Office Clipboard to Copy or Move Multiple Items. Deleting Data.
13. Inserting and Removing Cells, Rows, and Columns.
Inserting Rows and Columns. Removing Rows and Columns. Merging Cells Together to Form One Large Cell. Inserting Cells Between Existing Data. Removing Cells by Shifting Data.
14. Changing Column Width and Row Height.
Adjusting Column Width and Row Height with a Mouse. Using the Format Menu for Precise Control.
15. Managing Your Worksheets.
Selecting Worksheets. Inserting Worksheets. Deleting Worksheets. Moving and Copying Worksheets. Changing Worksheet Tab Names.
16. Printing Your Workbook.
Changing the Page Setup. Previewing a Print Job. Printing Your Workbook.
17. Printing Large Worksheets.
Selecting a Print Area. Adjusting Page Breaks. Printing Column and Row Labels on Every Page. Adding Headers and Footers. Scaling a Worksheet to Fit on a Page.
18. Performing Calculations with Formulas.
Understanding Excel Formulas. Order of Operations. Entering Formulas. Displaying Formulas. Editing Formulas.
19. Copying Formulas and Recalculating.
Copying Formulas. Using Relative and Absolute Cell Addresses. Controlling When Your Worksheet Is Recalculated.
20. Performing Calculations with Functions.
What Are Functions? Using the Function Wizard.
21. Changing How Numbers Look.
Using the Style Buttons to Format Numbers. Formatting Values. Copying Formats with Format Painter.
22. Giving Your Text a New Look.
How You Can Make Text Look Different. Changing Text Attributes with Toolbar Buttons. Aligning Text in Cells. Changing Text Attributes with the Format Cells Dialog Box.
23. Adding Cell Borders and Shading.
Adding Borders to Cells. Adding Shading to Cells. Using AutoFormat. Applying Conditional Formatting.
24. Creating Charts.
Charting Terminology. Chart Types. Creating a Chart. Saving Charts. Printing a Chart.
25. Enhancing Your Charts.
Selecting a Chart Part. The Chart Toolbar. Changing the Chart Type. Adding a Title and a Legend. Formatting Text and Numbers on a Chart. Enhancing the Chart Area.
26. More Ways to Enhance Charts.
Displaying or Hiding Gridlines. Changing the Start and Stop Values of the Value Axis. Changing the Category Axis. Changing the Perspective of 3D Charts. Selecting Data Series Options. Changing Data Series Values.
27. Saving and Publishing Workbooks to the Internet.
Saving a Workbook to an FTP Site. Saving a Workbook in HTML Format. Publishing Interactive Data. Adding Hyperlinks to a Worksheet.
28. Working with a Database.
Database Basics. Planning a Database. Creating a Database. Using Data Forms to Add, Edit, or Delete Records.
29. Finding and Sorting Data in a Database.
Finding Data with a Data Form. Sorting Data in a Database. Narrowing Your List with AutoFilter.
30. Adding Graphics and Other Objects to Worksheets.
Working with Graphic Objects. Inserting Clip Art. Adding Your Own Clip Art, Video Clips, or Sound Clips to the Gallery. Drawing Your Own Pictures.
Index.
More Information
Other Things You Might Like
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot
- eBook $35.19