Excel 2007 All-In-One Desk Reference For Dummies (eBook)
816 Seiten
John Wiley & Sons (Verlag)
978-1-118-05060-6 (ISBN)
Your one-stop guide to great-looking spreadsheets that
actually mean something
Create colorful spreadsheets and charts, use Live Preview, and
maximize everything Excel 2007 has to offer! Find just what you
need to know about using the new Ribbon, designing spreadsheets
that 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 the
Ribbon, 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
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.
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.
| Erscheint lt. Verlag | 11.2.2011 |
|---|---|
| Sprache | englisch |
| Themenwelt | Informatik ► Office Programme ► Excel |
| Informatik ► Office Programme ► Outlook | |
| Schlagworte | Computer-Ratgeber • End-User Computing • Excel 2007 • Microsoft Excel |
| ISBN-10 | 1-118-05060-6 / 1118050606 |
| ISBN-13 | 978-1-118-05060-6 / 9781118050606 |
| Haben Sie eine Frage zum Produkt? |
EPUB (Adobe DRM)Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: EPUB (Electronic Publication)
EPUB ist ein offener Standard für eBooks und eignet sich besonders zur Darstellung von Belletristik und Sachbüchern. Der Fließtext wird dynamisch an die Display- und Schriftgröße angepasst. Auch für mobile Lesegeräte ist EPUB daher gut geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
