Book description
Beginning Microsoft Excel 2010 is a practical, step-by-step guide to getting started with the world's most widely used spreadsheet application. The book offers a hands-on approach to learning how to create and edit spreadsheets, use various calculation formulas, employ charts/graphs, and get work done efficiently.
Microsoft is rolling out several new features with Excel 2010—perhaps the most notable is the ability to use Excel 2010 online and this collaborate on a project in real time. Beginning Microsoft Office 2010 keeps you up-to-date with all of these new features and more.
Table of contents
- Copyright
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- 1. Introduction to Excel
-
2. Getting Started and Getting Around the Worksheet
- 2.1. More Addresses Than the Phone Book—Cells, and How to Get There
- 2.2. Getting Around
- 2.3. Key Points
- 2.4. Ranges: A Select Tool
- 2.5. Data Entry: Getting Started
- 2.6. Numbers are (a little) Different
- 2.7. Relocating the Data: Copying and Moving
- 2.8. Having Your Fill
- 2.9. There'll Be Some Changes Made—Editing Cells
- 3. From Data Entry to Data Creation: Formula Basics and Beyond
-
4. Keeping Up Appearances—Formatting the Worksheet
- 4.1. You've Got Designs on Your Worksheet
- 4.2. Borderline Command
- 4.3. Getting Oriented
- 4.4. Excel Has Got Your Number(s)
- 4.5. Dates—The Long and the Short of It
- 4.6. Time Is On Your Side—Yes It Is
- 4.7. A New Kind of Copy—and Paste
- 4.8. Style Setter
- 4.9. Formatting—With Conditions
- 4.10. Just a Bit More...
- 4.11. P. S.
- 4.12. IN CONCLUSION...
-
5. The Stuff Of Legend—Charting in Excel
- 5.1. Starting Charting
- 5.2. The Design Tab—A Closer Look
- 5.3. Changing the Chart Default—and the 2-Second Chart
- 5.4. The Layout Tab
- 5.5. Working with Chart Labels
- 5.6. Axes to Grind
- 5.7. The Format Tab—Getting Your Objects in Shape
- 5.8. Sparklines: Mini-Charts with Big Impact
- 5.9. You Win Some, You Lose Some
- 5.10. In Conclusion...
-
6. Setting the Table: Database Features of Excel 2010
- 6.1. Sorting—Sort Of Easy
- 6.2. The AutoFilter: Picking and Choosing Your Data
- 6.3. Playing—or Plying—the Numbers
- 6.4. The Advanced Filter—Setting Your Data Aside
- 6.5. Table Talk
- 6.6. At the Risk of Repeating Yourself: The Remove Duplicates Option
- 6.7. Data Validation: Improving Your Entrée to Data Entry
- 6.8. In Conclusion...
-
7. Working With Multiple Sheets
- 7.1. Adding To Sheets—Inserting Rows, Columns and Cells
- 7.2. Multiple Worksheet Basics
- 7.3. Far-Flung Formulas: Working with Multi-Sheet Cell References
- 7.4. The Watch Window—Spying On Your Own Data
- 7.5. Protect Your Cells From Unwanted Intruders—Even Yourself
- 7.6. Consolidating Your Data—Getting It All Together
- 7.7. In Conclusion...
-
8. PivotTables and Pivot Charts
- 8.1. Starting Out with PivotTables
- 8.2. What's in a Name?
- 8.3. Constructing a PivotTable: Let's Go
- 8.4. Filters Again-PivotTable Style
- 8.5. Your Very Own Top 10 List
- 8.6. The Report Filter—Getting on Top of the PivotTable
- 8.7. The Slicer—Filter Deluxe
- 8.8. Grouping the Data
- 8.9. Formatting the Pivot Report—Values and All
- 8.10. Pivot Charts
- 8.11. In Conclusion...
-
9. Getting It On Paper—Printing in Excel 2010
- 9.1. Hard Copy? Pretty Easy
- 9.2. The Print Area Option
- 9.3. Margin-al Utility
- 9.4. Printing As You See Fit
- 9.5. Headers and Footers—Getting to the Bottom (and the Top) of Your Printout
- 9.6. Title Search
- 9.7. There's More Than One Way to View A Worksheet
- 9.8. Customize Your View, Too
- 9.9. In Conclusion...
- 10. Taking it to the Cloud: Sharing and Collaborating on the Internet
- A. Working With Range Names
- B. Keyboard Shortcuts
- C. Error Messages
Product information
- Title: Beginning Microsoft Excel 2010
- Author(s):
- Release date: June 2010
- Publisher(s): Apress
- ISBN: 9781430229551
You might also like
video
Microsoft Excel 2010
In this Microsoft Excel 2010 tutorial video, veteran Infinite Skills trainer Guy Vaccaro introduces you to …
book
Microsoft Excel 2010 In Depth
Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their …
book
Beginning Pivot Tables in Excel 2007
Beginning PivotTables in Excel 2007 explains what PivotTables are, how you can benefit from using them, …
book
Excel 2013 For Dummies
The bestselling Excel book - completely updated for Excel 2013! As the world's leading spreadsheet application, …