|
|
MICROSOFT EXCEL 2000 STEP BY STEP is the easiest and fastest way to teach yourself to use the latest version of Microsoft s popular spreadsheet program. Work through every lesson to complete the full course, or do individual lessons to learn just the skills you need. Either way, you learn at your optimum pace from the teacher who knows you best you. With this book and Microsoft Excel 2000, you ll learn to: Create worksheets, charts, and graphs to effectively analyze data Quickly organize data using filter and sort Simplify calculations using formulas, AutoCalculate, Subtotal, and other functions Use PivotTables and PivotCharts to summarize and present data in a visual format Liven up presentations by inserting pictures, customizing formats, and adding charts Publish data to the Internet or intranets and work simultaneously with others by sharing a workbook via your company intranet Import data from other sources, merge multiple spreadsheets, and share your work Integrate Microsoft Excel with other Microsoft Office programs Forecast trends and relationships with Goal Seek and Scenario Manager Validate data and protect work with a password Create and use macros to automate work Format dates for the twenty-first century
| ISBN | 1572319747 | | Pages | 414 | | ISBN13 | 9781572319745
(What's this?) | | Volumes | 1 | | Publisher | Microsoft Press,U.S. | | Weight (grammes) | 943 | | Imprint | Microsoft Press,U.S. | | Published in | Redmond | | Format | Multimedia Item | | Series title | Step by Step (Microsoft) | | Publication date | 01 May 1999 | | Height (mm) | 240 | | Library of Congress | 98-48193 | | Width (mm) | 187 | | DEWEY | 005.369 | | Spine width (mm) | 33 | | DEWEY edition | DC21 | | Academic level | General |
|
| |
| | | QuickLook Guide | | | | | | Finding Your Best Starting Point | | | | | | Using the Microsoft Excel 2000 Step by Step CD-ROM | | | | | | Conventions and Features in This Book | | | | Pt. 1 | | Getting Acquainted with Excel 2000 | | 1 | | Lesson 1 | | Working in the Excel Environment | | 3 | | Lesson 2 | | Setting Up a Worksheet | | 29 | | Lesson 3 | | Adding Formulas | | 49 | | Lesson 4 | | Dressing Up a Worksheet | | 65 | | Pt. 2 | | Organizing and Summarizing Your Data | | 87 | | Lesson 5 | | Consolidating Multiple Lists | | 89 | | Lesson 6 | | Filtering to Find Information | | 101 | | Lesson 7 | | Organizing Data by Sorting and Subtotaling | | 115 | | Pt. 3 | | Presenting Data to Others | | 139 | | Lesson 8 | | Creating PivotTable Reports | | 141 | | Lesson 9 | | Using PivotChart Reports | | 163 | | Lesson 10 | | Printing Worksheets and Charts | | 181 | | Lesson 11 | | Distributing Information Online | | 201 | | Pt. 4 | | Analyzing Data and Sharing Your Work | | 221 | | Lesson 12 | | Comparing Alternative Scenarios | | 223 | | Lesson 13 | | Sharing a Workbook | | 235 | | Lesson 14 | | Integrating Microsoft Office Programs | | 257 | | Pt. 5 | | Using Advanced Features of Excel 2000 | | 277 | | Lesson 15 | | Enhancing Worksheets | | 279 | | Lesson 16 | | Using Data from Other Sources | | 295 | | Lesson 17 | | Working With Macros | | 313 | | | More... | | |
|
|
|
|
|
Enlarge
