Book description
Experience learning made easy—and quickly teach yourself
how to organize, analyze, and present data with Excel 2007. With
Step By Step, you set the pace—building and practicing the
skills you need, just when you need them!
Create formulas, calculate values, and analyze data
Present information visually with graphics, charts, and diagrams
Build PivotTable dynamic views—even easier with new data tables
Reuse information from databases and other documents
Share spreadsheets for review and manage changes
Create macros to automate repetitive tasks and simplify your work
Your all-in-one learning experience includes:
Files for building skills and practicing the book’s lessons
Fully searchable eBook
Bonus quick reference to the Ribbon, the new Microsoft Office interface
Windows Vista Product Guide eReference—plus other resources on CD
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Table of contents
- About the Author
- Acknowledgments
- Features and Conventions
- Using the Book’s CD
- Getting Help
- The Microsoft Business Certification Program
-
Quick Reference
- 2. Setting Up a Workbook
- 3. Working with Data and Data Tables
- 4. Performing Calculations on Data
- 5. Changing Document Appearance
- 6. Focusing on Specific Data Using Filters
- 7. Reordering and Summarizing Data
- 8. Combining Data from Multiple Sources
- 9. Analyzing Alternative Data Sets
- 10. Creating Dynamic Lists with PivotTables
- 11. Creating Charts and Graphics
- 12. Printing
- 13. Automating Repetitive Tasks with Macros
- 14. Working with Other Microsoft Office System Programs
- 15. Collaborating with Colleagues
-
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
- 2. Setting Up a Workbook
- 3. Working with Data and Data Tables
- 4. Performing Calculations on Data
- 5. Changing Document Appearance
- 6. Focusing on Specific Data Using Filters
- 7. Reordering and Summarizing Data
- 8. Combining Data from Multiple Sources
- 9. Analyzing Alternative Data Sets
- 10. Creating Dynamic Lists with PivotTables
- 11. Creating Charts and Graphics
- 12. Printing
- 13. Automating Repetitive Tasks with Macros
- 14. Working with Other Microsoft Office System Programs
- 15. Collaborating with Colleagues
- Glossary
- Choose the Right Book for You
- Index
- About the Authors
- Copyright
Product information
- Title: Microsoft® Office Excel® 2007 Step by Step
- Author(s):
- Release date: January 2007
- Publisher(s): Microsoft Press
- ISBN: 9780735623040
You might also like
book
2007 Microsoft® Office System Plain & Simple
Get the fast facts that make learning the 2007 Microsoft Office system plain and simple! This …
book
Absolute Beginner’s Guide to Microsoft® Office 2003
Absolute Beginner's Guide to Microsoft Office 2003 covers Office 2003 for new users. The topics are …
book
Microsoft® Office SharePoint® Server 2007 Administrator's Companion
Get the definitive guide for administering Microsoft Office SharePoint Server 2007--with field-tested technical information and solutions …
book
Excel® 2007 Charts
Excel, the top number-crunching tool, now offers a vastly improved charting function to help you give …