Microsoft Office Excel 2003 all-in-one desk reference for dummies

Greg Harvey - Collection For Dummies

936 pages, parution le 22/10/2003

Ajouter à une liste

Indisponible

Résumé

Covers everything a reader needs to know to perform the task at hand, then goes a step beyond by outlining the most practical and useful applications for Excel in the workplace
Organized in convenient minibooks to help the reader find necessary information about particular topics quickly and easily
Includes basic coverage of importing data, building and editing worksheets, creating formulas, generating PivotTables, and performing financial functions, what-if scenarios, database functions, and Web que-ries
Advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with VBA and the Web

Introduction
Book I: Excel Basics
- Getting Acquainted with Excel
- Getting Help
- Customizing Excel
Book II: Worksheet Design
- Building Worksheets
- Formatting Worksheets
- Editing Worksheets
- Managing Worksheets
- Printing Worksheets
Book III: Formulas and Functions
- Building Basic Formulas
- Logical Functions and Error Trapping
- Date and Time Formulas
- Financial Formulas
- Math and Statistical Formulas
- Lookup, Information, and Text Formulas
Book IV: Worksheet Collaboration
- Sharing and Reviewing Workbooks
- Protecting Worksheets
- Sharing Data with Other Programs
- Sharing Data via a SharePoint Team Services Web Site
Book V: Charts and Graphics
- Charting Worksheet Data
- Adding Graphic Objects
Book VI: Data Management
- Building and Maintaining Data Lists
- Filtering and Querying a Data List
Book VII: Data Analysis
- Performing What-If Scenarios
- Generating Pivot Tables
Book VIII: Excel and the Web
- Worksheets As Web Pages
- Adding Hyperlinks to Worksheets
Book IX: Excel and Visual Basic for Applications
- Building and Running Macros
- VBA Programming
Index

L'auteur - Greg Harvey

Greg Harvey est président directeur général de la société of Mind Over Media, Inc. Il est l'auteur de tous les livres sur Excel dans la collection pour les Nuls depuis la version 4.

Autres livres de Greg Harvey

Word et Excel 2021 pour les nuls

Word, Excel, Powerpoint, Access, Outlook 2021

Excel 2021 pour les nuls

Découvrir tous les livres de Greg Harvey

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Greg Harvey
Collection	For Dummies
Parution	22/10/2003
Nb. de pages	936
Format	18,5 x 23,3
Couverture	Broché
Poids	1205g
Intérieur	Noir et Blanc
EAN13	9780764537585
ISBN13	978-0-7645-3758-5