---

MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))

ISBN: 073562304X
EAN: 2147483647

Year: 2004
Pages: 143

Authors: Curtis Frye

BUY ON AMAZON

• Microsoft Office Excel 2007 Step by Step
• Table of Contents
• Copyright
• About the Author
• Acknowledgments
• Features and Conventions
• Using the Book s CD
• Getting Help
• The Microsoft Business Certification Program
• Quick Reference
• Chapter 1. What s New in Excel 2007?
• Becoming Familiar with the New User Interface
• Managing Larger Data Collections
• Using the New Microsoft Office File Format
• Formatting Cells and Worksheets
• Managing Data Tables More Effectively
• Creating Formulas More Easily by Using Formula AutoComplete
• Summarizing Data Using New Functions
• Creating Powerful Conditional Formats
• Creating More Attractive Charts
• Controlling Printouts More Carefully
• Key Points
• Chapter 2. Setting Up a Workbook
• Creating Workbooks
• Modifying Workbooks
• Modifying Worksheets
• Customizing the Excel 2007 Program Window
• Key Points
• Chapter 3. Working with Data and Data Tables
• Entering and Revising Data
• Moving Data Within a Workbook
• Finding and Replacing Data
• Correcting and Expanding Upon Worksheet Data
• Defining a Table
• Key Points
• Chapter 4. Performing Calculations on Data
• Naming Groups of Data
• Creating Formulas to Calculate Values
• Summarizing Data That Meets Specific Conditions
• Finding and Correcting Errors in Calculations
• Key Points
• Chapter 5. Changing Document Appearance
• Formatting Cells
• Defining Styles
• Applying Workbook Themes and Table Styles
• Making Numbers Easier to Read
• Changing the Appearance of Data Based on Its Value
• Adding Images to a Document
• Key Points
• Chapter 6. Focusing on Specific Data Using Filters
• Limiting Data That Appears on Your Screen
• Manipulating List Data
• Defining Valid Sets of Values for Ranges of Cells
• Key Points
• Chapter 7. Reordering and Summarizing Data
• Sorting Data Lists
• Organizing Data into Levels
• Looking Up Information in a Data List
• Key Points
• Chapter 8. Combining Data from Multiple Sources
• Using Data Lists as Templates for Other Lists
• Linking to Data in Other Worksheets and Workbooks
• Consolidating Multiple Sets of Data into a Single Workbook
• Grouping Multiple Sets of Data
• Key Points
• Chapter 9. Analyzing Alternative Data Sets
• Defining and Editing Alternative Data Sets
• Defining Multiple Alternative Data Sets
• Varying Your Data to Get a Desired Result Using Goal Seek
• Finding Optimal Solutions with Solver
• Analyzing Data with Descriptive Statistics
• Key Points
• Chapter 10. Creating Dynamic Lists with PivotTables
• Analyzing Data Dynamically with PivotTables
• Filtering, Showing, and Hiding PivotTable Data
• Editing PivotTables
• Formatting PivotTables
• Creating PivotTables from External Data
• Key Points
• Chapter 11. Creating Charts and Graphics
• Creating Charts
• Customizing the Appearance of Charts
• Finding Trends in Your Data
• Creating Dynamic Charts Using PivotCharts
• Creating Diagrams by Using SmartArt
• Key Points
• Chapter 12. Printing
• Adding Headers and Footers to Printed Pages
• Preparing Worksheets for Printing
• Printing Data Lists
• Printing Parts of Data Lists
• Printing Charts
• Key Points
• Chapter 13. Automating Repetitive Tasks with Macros
• Introducing Macros
• Creating and Modifying Macros
• Running Macros When a Button Is Clicked
• Running Macros When a Workbook Is Opened
• Key Points
• Chapter 14. Working with Other Microsoft Office System Programs
• Including Microsoft Office System Documents in Excel 2007 Worksheets
• Storing Excel 2007 Documents as Parts of Other Microsoft Office System Documents
• Creating Hyperlinks
• Pasting Charts into Other Documents
• Key Points
• Chapter 15. Collaborating with Colleagues
• Sharing Data Lists
• Managing Comments
• Tracking and Managing Colleagues Changes
• Protecting Workbooks and Worksheets
• Authenticating Workbooks
• Saving Workbooks for the Web
• Key Points
• Glossary
• Choose the Right Book for You
• Published and Upcoming Titles
• Index
• SYMBOL
• A
• B
• C
• D
• E
• F
• G
• H
• I
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Z