You are previewing Excel 2010 Made Simple.
O'Reilly logo
Excel 2010 Made Simple

Book Description

Get the most out of Excel 2010 with Excel 2010 Made Simple—learn the key features, understand what's new, and utilize dozens of time-saving tips and tricks to get your job done. Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a worksheet and understanding Visual Basic for Applications (VBA) and macros.

Excel 2010 Made Simple takes a practical and highly effective approach to using Excel 2010, showing you the best way to complete your most common spreadsheet tasks. You'll learn how to input, format, sort, and filter your data to find out what you want to know. You'll see how to place your data in tables and named ranges for easy access, all of which will get you working efficiently and productively.

Excel 2010 Made Simple also covers the new features introduced in Excel 2010. For instance, it shows you how to use Sparklines for data comparison and the Backstage view for printing and sharing your spreadsheets, so you can carry out your tasks with the minimum of fuss. The hands-on focus on tasks means you'll see how to actually use Excel 2010 to suit your needs.

What you'll learn

  • How to do efficient and complex data entry

  • How to format your data

  • How to write basic—and not so basic—formulas

  • How to use Excel's database capabilities, including PivotTables

  • How to create colorful, meaningful charts

  • How to create basic macros and how to use them

  • How to use new Excel 2010 features, such as Sparklines and the Backstage view

Who this book is for

Excel 2010 Made Simple is for newcomers to Excel.

Table of Contents

  1. Title Page
  2. Contents at a Glance
  3. Contents
  4. About the Author
  5. About the Technical Reviewer
  6. Acknowledgments
  7. Quick Start Guide
    1. The Excel Worksheet: What You're Looking At
    2. Key Tips: Accessing Buttons with the Keyboard
    3. Contextual Tabs
    4. A Visit Backstage
    5. Customizing the Quick Access Toolbar
    6. Where to Learn More
    7. Excel Keyboard Equivalents
  8. Chapter 1: Introducing Excel 2010
    1. The Advantages of Learning More
    2. Spreadsheets Defined
    3. Excel Can Be Fun
    4. Summary
  9. Chapter 2: Getting Around the Worksheet and Data Entry
    1. The Journey Starts Here
    2. Looking Around
    3. Getting Around a Worksheet
    4. Selecting Multiple Cells
    5. Entering Text and Data
    6. Aligning Your Data—Where It Appears in the Cell
    7. Widening and Narrowing Columns
    8. Entering Numerical Data—How it's Different
    9. Entering Data into a Selected Range
    10. Using Auto Fill to Speed Up Data Entry
    11. Data Validation: Bringing Quality Control to the Worksheet
    12. Adding Data Entry Instructions with Input Messages
    13. Summary
  10. Chapter 3: EditingData
    1. Changing Your Data
    2. Copying and Moving: Duplicating and Relocating Your Data
    3. The Clipboard: The Storage Area for Copied and Cut Data
    4. Summary
  11. Chapter 4: Number Crunching 101: Functions, Formulas, and Ranges
    1. Automatic Calculations with Functions
    2. Customizing the Worksheet with Formulas
    3. Clarifying Cell References by Naming a Range
    4. Summary
  12. Chapter 5: For Appearance's Sake: Formatting Your Data
    1. What Formatting Does (and Doesn't Do)
    2. Basic Formatting
    3. Aligning (and Realigning) Your Data
    4. Inserting, Deleting, and Hiding Columns and Rows
    5. Formatting Values: Making the Numbers Look Good
    6. Customizing Number Formats
    7. Copying Formats (Not Data) with the Format Painter
    8. Applying Ready-Made Formats with Styles
    9. Applying Styles Quickly: Another Way to Access Formatting Options
    10. Conditional Formatting
    11. Summary
  13. Chapter 6: Charting Your Data
    1. Defining Chart Elements
    2. Choosing a Chart Type
    3. Creating a Column Chart
    4. Creating a Chart in 2 Seconds
    5. Changing a Chart
    6. Switching Rows with Columns: A Different Kind of Change
    7. Formatting Charts
    8. Introducing Sparklines: Mini-Charts Placed in Cells
    9. Summary
  14. Chapter 7: Sorting and Filtering Your Data: Excel's Database Features
    1. Sorting Data: Instilling Order in Your Data
    2. Finding What You Want with Filters
    3. Tables: Adding User-Friendliness to Your Database
    4. Summary
  15. Chapter 8: PivotTables: Data Aggregation Without the Aggravation
    1. Looking at Some PivotTables
    2. Creating a PivotTable
    3. Grouping Related Items Using Two Fields
    4. Viewing Which Records Are Filtered: Using the Slicer
    5. Formatting the PivotTable
    6. Styling Your Report
    7. Creating Charts from PivotTables Using PivotCharts
    8. Summary
  16. Chapter 9: Managing Your Workbook
    1. Adding Worksheets to Your Workbook
    2. Grouping Sheets: Changing Multiple Sheets at the Same Time
    3. Using the View Context Tab to Show and Hide Basic Screen Elements
    4. Protecting the Worksheet and the Workbook
    5. Summary
  17. Chapter 10: Printing Your Worksheets: Hard Copies Made Easy
    1. Deciding What You Want to Print
    2. Surveying Printing Options: The Print Backstage
    3. Setting the Print Area
    4. Customizing Your Printing
    5. Adding Headers and Footers
    6. Printing the Gridlines and Headings
    7. Summary
  18. Chapter 11: Automating Your Work with Macros
    1. The Two Kinds of Macros
    2. Composing a Macro
    3. About Saving a Workbook with a Macro
    4. Saving a Macro to the Personal Macro Workbook
    5. Deleting a Macro
    6. Editing a Macro by Tweaking It in VBA
    7. Activating a Macro with a Keyboard Shortcut
    8. A Note on Macro Security
    9. Summary
  19. Index