A comprehensive, up-to-date, user-friendly guide to Excel
2010
Excel is the standard for spreadsheet applications and is used
worldwide, but it’s not always user-friendly. That makes it a
perfect For Dummies topic, and this handy all-in-one guide
covers all the essentials, the new features, how to analyze data
with Excel, and much more.
Eight minibooks address Excel basics, worksheet design, formulas
and functions, worksheet collaboration and review, charts and
graphics, data management, data analysis, and Excel and VBA.
* Excel is the leading spreadsheet/data analysis software and is
used throughout the world; the newest revision includes upgraded
tools and a redesigned interface
* For Dummies books are the bestselling guides to Excel, with
more than three million copies sold
* Excel 2010 All-in-One For Dummies covers the changes in the
newest version as well as familiar tasks, such as creating and
editing worksheets, setting up formulas, and performing statistical
functions
* Eight self-contained minibooks cover the basics, worksheet
design, formulas and functions, worksheet collaboration, presenting
data in charts and graphics, data management, data analysis, and
creating macros with VBA.
Newcomers to Excel as well as veterans who just want to learn
the latest version will find Excel 2010 All-in-One For
Dummies has everything they need to know.
Tabla de materias
Introduction.
Book I: Excel Basics.
Chapter 1: The Excel 2010 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 Proofi ng 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.
Sobre el autor
Greg Harvey, Ph D, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He’s also an experienced educator.
Más ebooks del mismo autor / Editor
16.619 Ebooks en esta categoría
