Excel 2007 All-in-One Desk Reference for Dummies

8 books in 1

Greg Harvey - Collection For Dummies

777 pages, parution le 26/01/2007

Ajouter à une liste

Indisponible

Résumé

New and experienced Excel users will get the most bang for their buck with this comprehensive reference on all things Excel, the most popular spreadsheet and data analysis tool available
Completely updated to include coverage of the new release of Microsoft Office, this book discusses how to format worksheets, set up formulas, protect worksheets, import data, chart data, and perform statistical functions
Also covers building and editing worksheets, generating pivot tables, performing financial functions, and executing Web queries
More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Visual Basic and the Web

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

Sommaire

Excel Basics.
- The Excel 2007 User Experience.
- Getting Help, Tips, and Updates.
- Customizing Excel.
Worksheet Design.
- Building Worksheets.
- Formatting Worksheets.
- Editing and Proofing Worksheets.
- Managing Worksheets.
- Printing Worksheets.
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.
Worksheet Collaboration and Review.
- Protecting Workbooks and Worksheet Data.
- Linking Workbooks with Hyperlinks.
- Sending Workbooks Out for Review.
- Sharing Worksheets and Worksheet Data.
Charts and Graphics.
- Charting Worksheet Data.
- Adding Graphic Objects.
Data Management.
- Building and Maintaining Data Lists.
- Filtering and Querying a Data List.
Data Analysis.
- Performing What-If Scenarios.
- Generating Pivot Tables.
Excel and VBA.
- Building and Running Macros.
- VBA Programming.
- Appendix: Using XML File Formats.

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Greg Harvey
Collection	For Dummies
Parution	26/01/2007
Nb. de pages	777
Format	18,7 x 23,3
Couverture	Broché
Poids	1155g
Intérieur	Noir et Blanc
EAN13	9780470037386
ISBN13	978-0-470-03738-6