Microsoft Press, 2009. – 119 p.
Contents:
About the Author.
What’s New in Excel 2007?
Becoming Familiar with the New User Interface.
Managing Larger Data Collections.
Understanding the New Office File Formats.
Formatting Cells and Worksheets.
Managing Data Tables More Effectively.
Creating Formulas More Easily.
Summarizing Data.
Creating Powerful Conditional Formats.
Creating More Attractive Charts.
Controlling Printouts More Carefully.
Let’s Get Started!
Features and Conventions of This Course.
Getting Help.
Getting Help with This Course.
Getting Help with Excel 2007.
More Calculations and Formatting.
Summarizing Data That Meets Specific Conditions.
Finding and Correcting Errors in Calculations.
Changing the Appearance of Data Based on Its Value.
Key Points.
More Charts and Graphics
Customizing the Appearance of Charts.
Finding Trends in Your Data.
Printing Charts.
Adding Images to Worksheets.
Creating Diagrams by Using SmartArt.
Key Points.
Data Lists.
Defining Valid Sets of Values for Ranges of Cells.
Limiting Data That Appears on Your Screen.
Manipulating List Data.
Sorting Data Lists.
Key Points.
More Data Lists
Organizing Data into Levels.
Looking Up Information in a Data List.
Using Data Lists as Templates for Other Lists.
Printing Data Lists.
Printing Parts of Data Lists.
Key Points.
Data from Multiple Sources
Linking to Data in Other Worksheets and Workbooks.
Consolidating Multiple Sets of Data into a Single Workbook.
Grouping Multiple Sets of Data.
Key Points.
Glossary.