Microsoft® Office Excel® 2007 Step by Step
Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2007. With Step By Step, you set the pace-building and practicing the skills you need, just when you need them! Create formulas, calculate values, and analyze dataPresent information vis...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Colección: | Step by step
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627088306719 |
Tabla de Contenidos:
- Microsoft® Office Excel® 2007 Step by Step; Acknowledgments; Features and Conventions; Using the Book's CD; Minimum System Requirements; Installing the Practice Files; Using the Practice Files; Uninstalling the Practice Files; Getting Help; Getting Help with Office Excel 2007; The Microsoft Business Certification Program; Becoming a Microsoft Certified Application Specialist-Microsoft 2007 Office System; Becoming a Microsoft Certified Application Professional; Taking a Microsoft Business Certification Exam; Certification; For More Information; Quick Reference
- 3. Working with Data and Data Tables4. Performing Calculations on Data; 5. Changing Document Appearance; 6. Focusing on Specific Data Using Filters; 7. Reordering and Summarizing Data; 8. Combining Data from Multiple Sources; 9. Analyzing Alternative Data Sets; 10. Creating Dynamic Lists with PivotTables; 11. Creating Charts and Graphics; 12. Printing; 13. Automating Repetitive Tasks with Macros; 14. Working with Other Microsoft Office System Programs; 15. Collaborating with Colleagues; 1. What's New in Excel 2007?; Managing Larger Data Collections; Using the New Microsoft Office File Format
- Formatting Cells and WorksheetsManaging Data Tables More Effectively; Creating Formulas More Easily by Using Formula AutoComplete; Summarizing Data Using New Functions; Creating Powerful Conditional Formats; Creating More Attractive Charts; Controlling Printouts More Carefully; Key Points; 2. Setting Up a Workbook; Modifying Workbooks; Modifying Worksheets; Customizing the Excel 2007 Program Window; Arranging Multiple Workbook Windows; Adding Buttons to the Quick Access Toolbar; Key Points; 3. Working with Data and Data Tables; Moving Data Within a Workbook; Finding and Replacing Data
- Correcting and Expanding Upon Worksheet DataDefining a Table; Key Points; 4. Performing Calculations on Data; Creating Formulas to Calculate Values; Summarizing Data That Meets Specific Conditions; Finding and Correcting Errors in Calculations; Key Points; 5. Changing Document Appearance; Defining Styles; Applying Workbook Themes and Table Styles; Making Numbers Easier to Read; Changing the Appearance of Data Based on Its Value; Adding Images to a Document; Key Points; 6. Focusing on Specific Data Using Filters; Manipulating List Data; Defining Valid Sets of Values for Ranges of Cells
- Key Points7. Reordering and Summarizing Data; Organizing Data into Levels; Looking Up Information in a Data List; Key Points; 8. Combining Data from Multiple Sources; Linking to Data in Other Worksheets and Workbooks; Consolidating Multiple Sets of Data into a Single Workbook; Grouping Multiple Sets of Data; Key Points; 9. Analyzing Alternative Data Sets; Defining Multiple Alternative Data Sets; Varying Your Data to Get a Desired Result Using Goal Seek; Finding Optimal Solutions with Solver; Analyzing Data with Descriptive Statistics; Key Points; 10. Creating Dynamic Lists with PivotTables
- Filtering, Showing, and Hiding PivotTable Data
