You are previewing Microsoft® Excel® 2010: Step by Step.
O'Reilly logo
Microsoft® Excel® 2010: Step by Step

Book Description

Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.

Table of Contents

  1. Microsoft® Excel® 2010: Step by Step
  2. A Note Regarding Supplemental Files
  3. Acknowledgments
  4. Introducing Microsoft Excel 2010
    1. Managing Excel Files and Settings in the Backstage View
    2. Previewing Data by Using Paste Preview
    3. Customizing the Excel 2010 User Interface
    4. Summarizing Data by Using More Accurate Functions
    5. Summarizing Data by Using Sparklines
    6. Filtering PivotTable Data by Using Slicers
    7. Filtering PivotTable Data by Using Search Filters
    8. Visualizing Data by Using Improved Conditional Formats
    9. Creating and Displaying Math Equations
    10. Editing Pictures within Excel 2010
    11. Managing Large Worksheets by Using the 64-bit Version of Excel 2010
    12. Summarizing Large Data Sets by Using the PowerPivot (Project Gemini) Add-In
    13. Accessing Your Data from Almost Anywhere by Using the Excel Web App and Excel Mobile 2010
  5. Modifying the Display of the Ribbon
    1. Dynamic Ribbon Elements
    2. Changing the Width of the Ribbon
    3. Adapting Exercise Steps
  6. Features and Conventions of This Book
  7. Using the Practice Files
  8. Your Companion eBook
  9. Getting Help
    1. Getting Help with This Book
    2. Getting Help with Excel 2010
    3. More Information
  10. 1. Setting Up a Workbook
    1. Creating Workbooks
    2. Modifying Workbooks
    3. Modifying Worksheets
    4. Customizing the Excel 2010 Program Window
      1. Zooming In on a Worksheet
      2. Arranging Multiple Workbook Windows
      3. Adding Buttons to the Quick Access Toolbar
      4. Customizing the Ribbon
      5. Maximizing Usable Space in the Program Window
    5. Key Points
  11. 2. Working with Data and Excel Tables
    1. Entering and Revising Data
    2. Moving Data Within a Workbook
    3. Finding and Replacing Data
    4. Correcting and Expanding Upon Worksheet Data
    5. Defining Excel Tables
    6. Key Points
  12. 3. Performing Calculations on Data
    1. Naming Groups of Data
    2. Creating Formulas to Calculate Values
    3. Summarizing Data That Meets Specific Conditions
    4. Finding and Correcting Errors in Calculations
    5. Key Points
  13. 4. Changing Workbook Appearance
    1. Formatting Cells
    2. Defining Styles
    3. Applying Workbook Themes and Excel Table Styles
    4. Making Numbers Easier to Read
    5. Changing the Appearance of Data Based on Its Value
    6. Adding Images to Worksheets
    7. Key Points
  14. 5. Focusing on Specific Data by Using Filters
    1. Limiting Data That Appears on Your Screen
    2. Manipulating Worksheet Data
      1. Selecting List Rows at Random
      2. Summarizing Worksheets with Hidden and Filtered Rows
      3. Finding Unique Values Within a Data Set
    3. Defining Valid Sets of Values for Ranges of Cells
    4. Key Points
  15. 6. Reordering and Summarizing Data
    1. Sorting Worksheet Data
    2. Organizing Data into Levels
    3. Looking Up Information in a Worksheet
    4. Key Points
  16. 7. Combining Data from Multiple Sources
    1. Using Workbooks as Templates for Other Workbooks
    2. Linking to Data in Other Worksheets and Workbooks
    3. Consolidating Multiple Sets of Data into a Single Workbook
    4. Grouping Multiple Sets of Data
    5. Key Points
  17. 8. Analyzing Alternative Data Sets
    1. Defining an Alternative Data Set
    2. Defining Multiple Alternative Data Sets
    3. Varying Your Data to Get a Desired Result by Using Goal Seek
    4. Finding Optimal Solutions by Using Solver
    5. Analyzing Data by Using Descriptive Statistics
    6. Key Points
  18. 9. Creating Dynamic Worksheets by Using PivotTables
    1. Analyzing Data Dynamically by Using PivotTables
    2. Filtering, Showing, and Hiding PivotTable Data
    3. Editing PivotTables
    4. Formatting PivotTables
    5. Creating PivotTables from External Data
    6. Key Points
  19. 10. Creating Charts and Graphics
    1. Creating Charts
    2. Customizing the Appearance of Charts
    3. Finding Trends in Your Data
    4. Summarizing Your Data by Using Sparklines
    5. Creating Dynamic Charts by Using PivotCharts
    6. Creating Diagrams by Using SmartArt
    7. Creating Shapes and Mathematical Equations
    8. Key Points
  20. 11. Printing
    1. Adding Headers and Footers to Printed Pages
    2. Preparing Worksheets for Printing
      1. Previewing Worksheets Before Printing
      2. Changing Page Breaks in a Worksheet
      3. Changing the Page Printing Order for Worksheets
    3. Printing Worksheets
    4. Printing Parts of Worksheets
    5. Printing Charts
    6. Key Points
  21. 12. Automating Repetitive Tasks by Using Macros
    1. Enabling and Examining Macros
      1. Macro Security in Excel 2010
      2. Examining Macros
    2. Creating and Modifying Macros
    3. Running Macros When a Button Is Clicked
    4. Running Macros When a Workbook Is Opened
    5. Key Points
  22. 13. Working with Other Microsoft Office Programs
    1. Including Office Documents in Workbooks
    2. Storing Workbooks as Parts of Other Office Documents
    3. Creating Hyperlinks
    4. Pasting Charts into Other Documents
    5. Key Points
  23. 14. Collaborating with Colleagues
    1. Sharing Workbooks
    2. Managing Comments
    3. Tracking and Managing Colleagues’ Changes
    4. Protecting Workbooks and Worksheets
    5. Authenticating Workbooks
    6. Saving Workbooks for the Web
    7. Key Points
  24. Glossary
  25. A. Keyboard Shortcuts
    1. Ctrl Combination Shortcut Keys
    2. Function Keys
    3. Other Useful Shortcut Keys
  26. B. About the Author
  27. Index
  28. About the Author
  29. Copyright