This is a complete guide to using and customizing Excel 2010.
Summary Of the Book
Excel is probably the most widely used spreadsheet in the world, and it offers a rich set of features for varied uses. Whether a person just uses the most obvious features, or goes deep into the application and makes optimal use of its advanced features depends on their knowledge.
This is where this book, Microsoft Excel 2010 Bible, comes in. It teaches everything, from the basic to the advanced features. From just creating a table of data to using advanced analytical features, to customizing the application using VBA, this book covers it all.
The book is divided into six parts, with a set of appendices at the end. The six parts are Getting Started With Excel, Working With Formulas and Functions, Creating Charts and Graphics, Using Advanced Excel Features, Analyzing Data With Excel, and Programming Excel With VBA.
The appendix has four sections. Appendix A is Worksheet Function Reference, Appendix B contains What’s On The CD-ROM, Appendix C is Additional Excel Resources, and Appendix D consists of Excel Shortcut Keys.
This is a Bible series book. The books in this series are designed for all types of users, from the beginners to the advanced users and programmers. It covers all features of Excel from the ground up, including providing an introduction to the applications, explaining what it can be used for.
The book begins with a basic introduction that starts with how to enter and edit data into worksheet cells to working with cells and ranges, the concept of tables, and creating files and templates in Excel. The next part explains in detail how to use formulas and functions in Excel to manipulate the data entered in the worksheets.
The third part goes into the visual presentation of data. This includes creating charts and graphs, to enhancing the presentation of formatted data with pictures and drawings. The next part introduces some advanced Excel features that involve processing data, sharing data with other applications, validating the data, and protecting the stored information.
The fifth section looks at various analytical tools included in Excel to analyze the data. It explains how to use Pivot Tables and What-If analysis, analyzing data using Goal Seeking, and Solver and Analysis Toolpak.
The sixth and final section looks at extending and customizing Excel using VBA programming. VBA or Visual Basic for Applications is a form of the Visual Basic programming language that is built into MS Office to create functions and macros that can automate tasks and extend the functionality of the application.
The CD contains the whole book in e-book form, and also all the Excel files that were mentioned in the book in the examples and exercises in each chapter.
About John Walkenbach
John Walkenbach is a leading authority on spreadsheet applications.
Other books by this author include Microsoft Excel 2010 Power Programming With VBA (With CD), Microsoft Office Excel 2007 Bible, Microsoft Excel 2010 Formulas, and Excel 2007 VBA Programming For Dummies.
All his books are about spreadsheet applications.
John Walkenbach is a Microsoft Most Valued Professional (MVP). He also runs a small consultancy business called J-Walk and Associates in Tucson, Arizona. He is also the creator of the award winning Power Utility Pak. He has written more than 50 books and a number of articles and reviews for many magazines like PC World, Windows, and Infoworld.
Table of Contents
Acknowledgments
Introduction
Part I: Getting Started with Excel 1
• Introducing Excel
• Entering and Editing Worksheet Data
• Essential Worksheet Operations
• Working with Cells and Ranges
• Introducing Tables
• Worksheet Formatting
• Understanding Excel Files
• Using and Creating Templates
• Printing Your Work
Part II: Working with Formulas and Functions
• Introducing Formulas and Functions
• Creating Formulas That Manipulate Text
• Working with Dates and Times
• Creating Formulas That Count and Sum
• Creating Formulas That Look Up Values
• Creating Formulas for Financial Applications
• Introducing Array Formulas
• Performing Magic with Array Formulas
Part III: Creating Charts and Graphics
• Getting Started Making Charts
• Learning Advanced Charting
• Visualizing Data Using Conditional Formatting
• Creating Sparkline Graphics
• Enhancing Your Work with Pictures and Drawings
Part IV: Using Advanced Excel Features
• Customizing the Excel User Interface
• Using Custom Number Formats
• Using Data Validation
• Creating and Using Worksheet Outlines
• Linking and Consolidating Worksheets
• Excel and the Internet
• Sharing Data with Other Office Applications
• Using Excel in a Workgroup
• Protecting Your Work
• Making Your Worksheets Error-Free
Part V: Analyzing Data with Excel
• Getting Data from External Database Files
• Introducing Pivot Tables
• Analyzing Data with Pivot Tables
• Performing Spreadsheet What-If Analysis
• Analyzing Data Using Goal Seeking and Solver
• Analyzing Data with the Analysis ToolPak
Part VI: Programming Excel with VBA
• Introducing Visual Basic for Applications
• Creating Custom Worksheet Functions
• Creating UserForms
• Using UserForm Controls in a Worksheet
• Working with Excel Events
• VBA Examples
• Creating Custom Excel Add-Ins
Part VII: Appendixes
• Appendix A: Worksheet Function Reference
• Appendix B: What's on the CD-ROM
• Appendix C: Additional Excel Resources
• Appendix D: Excel Shortcut Keys
Index
End-User License Agreement
| Publisher | WILEY-DREAMTECH INDIA PVT.LTD |
| Publication Year | 2010 |
| ISBN-13 | 9788126526642 |
| ISBN-10 | 8126526645 |
| Language | English |
| Binding | Paperback |
| Number of Pages | 1056 Pages |
CLICK HERE to Buy online MICROSOFT EXCEL 2010 BIBLE (Paperback) by John Walkenbach with special discounts and Options with Cash On Delivery, 30 Day Replacement Guarantee.
0 comments:
Post a Comment