Learn how to use Excel 2010 with this fun and fast-paced book. Filled with color screenshots and easy-to-follow steps, Microsoft Office Excel 2010 QuickSteps shows you how to create worksheets, enter and edit data, use formulas and functions, create charts and tables, and more.
These sample chapters are excerpted from Microsoft Office Excel 2010: Quick Steps, written by John Cronan. This material is Copyright ©2010 McGraw Hill and is used with permission. You can buy Microsoft Office Excel 2010: Quick Steps from the McGraw-Hill Online Bookstore.
Chapter 1 Excerpt: Explore the Excel Window
Take a quick tour of the Excel window and the Excel ribbon. This excerpt introduces you to tool groups, panes, and navigation controls that you can use in an Excel worksheet.
Chapter 4 Excerpt: Reference Cells
This excerpt teaches you the power of using cell references in your worksheets and formulas. Learn about the three main types of cell references and also how to name a cell or range, and how to use the Name Manager.
Chapter 6 Excerpt 1: Using Charts
Discover the power of using charts. Read this excerpt to learn how to resize, position, and style charts in a worksheet. Also, see how you can share charts between worksheets and copy charts to Word 2010 and PowerPoint 2010.
Chapter 6 Excerpt 2: Creating Sparklines
What are sparklines and how can you use them to add some dazzle to your worksheets? This excerpt shows you how to create sparklines (a graphic way to show background data in a single cell) and discusses the three sparkline types.
Chapter 8 Excerpt: Create an AutoFilter
You can use an AutoFilter to quickly hide rows of data that you don’t need to work with at the moment. This excerpt explains how to use the auto-filtering options to display data based on different criteria.