Harvey Excel 2007 All-In-One Desk Reference For Dummies

1. Auflage 2007
ISBN: 978-0-470-11680-7
Verlag: John Wiley & Sons
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 816 Seiten, E-Book

Master the Ribbon, powerful graphics capabilities, and more!
Your one-stop guide to great-looking spreadsheets thatactually mean something
Create colorful spreadsheets and charts, use Live Preview, andmaximize everything Excel 2007 has to offer! Find just what youneed to know about using the new Ribbon, designing spreadsheetsthat communicate, editing and printing them, working with formulas,protecting your data when you collaborate, turning out cool charts,and much more. The included four-color insert highlights theRibbon, new graphics features, and more!
Discover how to
* Create dynamic spreadsheets with style galleries
* Work with more than 40 new cell styles
* Automate formatting with Live Preview
* Share Excel data with other programs
* Use VBA to write custom Excel functions

Autoren/Hrsg.

Harvey, Greg

Inhaltsverzeichnis

Introduction.
Book I: Excel Basics.
Chapter 1: The Excel 2007 User Experience.
Chapter 2: Getting Help, Tips, and Updates.
Chapter 3: Customizing Excel.
Book II: Worksheet Design.
Chapter 1: Building Worksheets.
Chapter 2: Formatting Worksheets.
Chapter 3: Editing and Proofing 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 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.

Über Autor(innen)

Greg Harvey has authored tons of computer books, the mostrecent being Excel 2007 For Dummies, Windows Vista For DummiesQuick Reference, and Excel Workbook For Dummies. Hestarted out training business users on how to use IBM personalcomputers and their attendant computer software in therough-and-tumble days of DOS, WordStar, and Lotus 1-2-3 in themid-80s of the last century. After working for a number ofindependent training firms, he went on to teaching semester-longcourses in spreadsheet and database management software at GoldenGate 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 towrite because they enable him to write to his favorite audience,the beginner. They also enable him to use humor (a key element tosuccess in the training room) and, most delightful of all, toexpress an opinion or two about the subject matter at hand.