Résumé
- Creating worksheets
- Creating simple and complex formulas
- Using Excel's logic to handle decisions and worksheet errors
- Rearranging and manipulating data with text and date functions
- Constructing, editing, and formatting charts
- Sorting, filtering, and subtotaling databases
- Applying conditional formatting and data validation
- Summarizing data with pivot tables and pivot charts
- Importing data from the Web, SQL Server, Access, and OLAP servers
- Integrating Excel with Access, Word, PowerPoint, Outlook, and MapPoint 2002
- Collaborating with other users: workbook routing, file sharing, and SharePoint Team Services
- Modeling business data with the what-if tools: data tables, Goal Seek, Solver, and scenarios
- Using templates and reports to create workbooks for other users
- Recording and editing macros
- Building applications using Excel 2002 and VBA
- Creating simple smart tags
Table of Contents
Introduction
PART I: PUTTING EXCEL 2002 TO WORK FOR YOU
Chapter 2: Creating Excel Worksheets
Chapter 3: Formatting Text and Worksheets
Chapter 4: Using Names and External References
Chapter 6: Manipulating Text and Dates
Chapter 7: Using Decision Making Functions
Chapter 8: Using Financial Functions
Chapter 10: Advanced Charting in Excel 2002
Chapter 11: Using Drawing and Graphics Tools
Chapter 13: Using Excel 2002 to Present Information
Chapter 14: Creating Workbooks for Other Users
Chapter 15: Creating Forms in Excel 2002
Chapter 17: Importing and Exporting with Excel 2002>
Chapter 18: Using Excel 2002 with the Web>
Chapter 20: Using Excel's Workgroup Tools
Chapter 22: Using Visual Basic with Excel
Chapter 23: Do-It-Yourself Functions
Chapter 24: Creating an Excel Application
Appendix B: VBA Quick Reference
Appendix C: Using MapPoint 2002 with Excel 2002
Appendix D: Creating Simple Smart Tags for Excel 2002
L'auteur - Gini Courter
Gini Courter, MBA, has designed and implemented computer training programs and databases for a multitude of schools, colleges, businesses, and other organizations over the past 15 years. She brings a wealth of knowledge about how to effectively design, implement, and enhance technology in any size organization.
L'auteur - Annette Marquis
Annette Marquis, MSW, has over 15 years' executive management experience in health care and nonprofit organizations and over 10 years' experience providing software training and writing user documentation. She combines her experience of office systems with her knowledge of technology to provide practical, applicable technology training and information.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Sybex |
| Auteur(s) | Gini Courter, Annette Marquis |
| Parution | 01/09/2001 |
| Nb. de pages | 900 |
| Format | 19 x 22,7 |
| Couverture | Broché |
| Poids | 1404g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780782140026 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
