- 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…mehr
- 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
Greg Harvey has authored tons of computer books, the most recent being Excel 2007 For Dummies, Windows Vista For Dummies Quick Reference, and Excel Workbook For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough-and-tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, he went on to teaching semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience, the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Inhaltsangabe
- Introduction
Book I: Excel Basics - Chapter 1: The Excel 2007 User Experience - Chapter 2: Getting Help, Tips, and Updates - Chapter 3: Customizing Excel
Book III: Formulas and Functions - Chapter 1: Building Basic Formulas - Chapter 2: Logical Functions and Error Trapping - Chapter 3: Date and Time Formulas - Chapter 4: Financial Formulas - Chapter 5: Math and Statistical Formulas - Chapter 6: Lookup, Information, and Text Formulas
Book IV: Worksheet Collaboration and Review - Chapter 1: Protecting Workbooks and Worksheet Data - Chapter 2: Linking Workbooks with Hyperlinks - Chapter 3: Sending Workbooks Out for Review - Chapter 4: Sharing Worksheets and Worksheet Data
Book V: Charts and Graphics - Chapter 1: Charting Worksheet Data - Chapter 2: Adding Graphic Objects
Book VI: Data Management - Chapter 1: Building and Maintaining Data Lists - Chapter 2: Filtering and Querying a Data List
Book VII: Data Analysis - Chapter 1: Performing What-If Scenarios - Chapter 2: Generating Pivot Tables
Book VIII: Excel and VBA - Chapter 1: Building and Running Macros - Chapter 2: VBA Programming
Book III: Formulas and Functions - Chapter 1: Building Basic Formulas - Chapter 2: Logical Functions and Error Trapping - Chapter 3: Date and Time Formulas - Chapter 4: Financial Formulas - Chapter 5: Math and Statistical Formulas - Chapter 6: Lookup, Information, and Text Formulas
Book IV: Worksheet Collaboration and Review - Chapter 1: Protecting Workbooks and Worksheet Data - Chapter 2: Linking Workbooks with Hyperlinks - Chapter 3: Sending Workbooks Out for Review - Chapter 4: Sharing Worksheets and Worksheet Data
Book V: Charts and Graphics - Chapter 1: Charting Worksheet Data - Chapter 2: Adding Graphic Objects
Book VI: Data Management - Chapter 1: Building and Maintaining Data Lists - Chapter 2: Filtering and Querying a Data List
Book VII: Data Analysis - Chapter 1: Performing What-If Scenarios - Chapter 2: Generating Pivot Tables
Book VIII: Excel and VBA - Chapter 1: Building and Running Macros - Chapter 2: VBA Programming
- Appendix: Using XML File Formats - Index.
Es gelten unsere Allgemeinen Geschäftsbedingungen: www.buecher.de/agb
Impressum
www.buecher.de ist ein Shop der buecher.de GmbH & Co. KG Bürgermeister-Wegele-Str. 12, 86167 Augsburg Amtsgericht Augsburg HRA 13309