Table of content
|
MicrosoftR Office ExcelR 2007 Step by Step Authors: Frye C. D. Published year: 2004 Pages: 1/143 |
 |
- 1
- 2
- Microsoft Office Excel 2007 Step by Step
- 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
- 1
- 2
|
MicrosoftR Office ExcelR 2007 Step by Step Authors: Frye C. D. Published year: 2004 Pages: 1/143 |
|