* Combining nine books in one, this thorough desk reference delivers the know-how readers need to take full advantage of Excel
* Outlines the most practical and useful applications of Excel for the workplace
* Explains how to import data, build and edit worksheets, create formulas, generate pivot tables, and work with financial functions, what-if scenarios, database functions, and Web queries
* Explores more advanced topics such as worksheet sharing and auditing, error trapping, building and running macros, charting data, and using Excel in conjunction with Visual Basic and the Web
* Author is one of the bestselling technology authors of all time
Rezensionen / Stimmen
"...a book that should live beyond arms reach of the keyboard...4/5..." (Computer Active, 20 February 2003)
Auflage
Sprache
Verlagsort
Verlagsgruppe
Illustrationen
Maße
Höhe: 23.5 cm
Breite: 19 cm
Dicke: 46 mm
Gewicht
ISBN-13
978-0-7645-1794-5 (9780764517945)
Schweitzer Klassifikation
Greg Harvey has authored tons of computer books, the most recent being Excel 2002 For Dummies and Adobe Acrobat 5 PDF 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.
Introduction.
Book I: Excel Basics.
Chapter 1: Getting Acquainted with Excel.
Chapter 2: Getting Help.
Chapter 3: Customizing Excel.
Book II: Worksheet Design.
Chapter 1: Building Worksheets.
Chapter 2: Formatting Worksheets.
Chapter 3: Editing Worksheets.
Chapter 4: Managing Worksheets.
Chapter 5: Printing Worksheets.
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.
Chapter 1: Sharing and Reviewing Workbooks.
Chapter 2: Protecting Worksheets.
Chapter 3: Sharing Data with Other Programs.
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 the Web.
Chapter 1: Worksheets as Web Pages.
Chapter 2: Adding Hyperlinks to Worksheets.
Book IX: Excel and Visual Basic for Applications.
Chapter 1: Building and Running Macros.
Chapter 2: VBA Programming.
Index.
