Microsoft® Office Excel® 2003 step by step
This practical, hands-on tutorial expertly builds your skills with Microsoft Office Excel 2003-one step at a time! With STEP BY STEP, you work at your own pace through easy-to-follow lessons and practice exercises to learn exactly the tools and techniques you need. Master the tools for organizing, p...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Colección: | Step by step Microsoft Office Excel 2003 step by step
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627888106719 |
Tabla de Contenidos:
- Microsoft® Office Excel 2003: Step by Step; Getting Help; Getting Help with Microsoft Excel 2003; Using the Book's CD-ROM; Installing the Practice Files; Using the Practice Files; Uninstalling the Practice Files; Conventions and Features; Microsoft Office Specialist Skills Standards; Microsoft Office Specialist Expert Skill Standards; Taking a Microsoft Office Specialist Certification Exam; Selecting a Microsoft Office Specialist Certification Level; Microsoft Office Specialist Skills Standards; The Exam Experience; Test-Taking Tips; College Credit Recommendation; For More Information
- Quick ReferenceChapter 2 Setting Up a Workbook; Chapter 3 Performing Calculations on Data; Chapter 4 Changing Document Appearance; Chapter 5 Focusing on Specific Data Using Filters; Chapter 6 Combining Data from Multiple Sources; Chapter 7 Reordering and Summarizing Data; Chapter 8 Analyzing Alternative Data Sets; Chapter 9 Creating Dynamic Lists with PivotTables; Chapter 10 Creating Charts; Chapter 11 Printing; Chapter 12 Automating Repetitive Tasks with Macros; Chapter 13 Working with Other Microsoft Office Programs; Chapter 14 Working with Database Data
- Chapter 15 Publishing Information on the WebChapter 16 Collaborating with Colleagues; 1. Getting to Know Excel; Working with an Existing Data List; Zeroing In on Data in a List; Creating a Workbook; Checking and Correcting Data; 2. Setting Up a Workbook; Making Data Easier to Read; Adding a Graphic to a Document; 3. Performing Calculations on Data; Creating Formulas to Calculate Values; Finding and Correcting Errors in Calculations; 4. Changing Document Appearance; Applying an Existing Format to Data; Making Numbers Easier to Read; Changing Data's Appearance Based on Its Value
- Making Printouts Easier to FollowPositioning Data on a Printout; 5. Focusing on Specific Data Using Filters; Performing Calculations on Filtered Data; Defining a Valid Set of Values for a Range of Cells; 6. Combining Data from Multiple Sources; Working with More Than One Set of Data; Linking to Data in Other Workbooks; Summarizing Multiple Sets of Data; Grouping Multiple Data Lists; 7. Reordering and Summarizing Data; Organizing Data into Levels; 8. Analyzing Alternative Data Sets; Defining Multiple Alternative Data Sets; Varying Your Data to Get a Desired Result
- Finding Optimal Solutions with SolverAnalyzing Data with Descriptive Statistics; 9. Creating Dynamic Lists with PivotTables; Editing PivotTables; Creating PivotTables from External Data; 10. Creating Charts; Customizing Chart Labels and Numbers; Finding Trends in Your Data; Creating a Dynamic Chart Using PivotCharts; Creating Diagrams; 11. Printing; Change Your Printer Setup; Zoom in on Part of a Page; Change the Page Breaks in a Worksheet; Change the Page Printing Order for a Worksheet; Suppress Errors in a Worksheet; Print Nonadjacent Sheets from a Workbook; Printing Part of a Data List
- Printing a Chart
