| CARVIEW |
Save a Tree - Go Digital What is this?
Microsoft® Office Excel® 2007 Step by Step
- By
- Curtis Frye
- Publisher:
- Microsoft Press
- Released:
- January 2007
- Pages:
- 432
The smart way to learn the latest version of Office Excel 2007—one step at a time! Build exactly the skills you need by working at your own pace through easy-to-follow lessons and hands-on practice files on CD.
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
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
-
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
-
Appendix Choose the Right Book for You
-
Published and Upcoming Titles
-
- Title:
- Microsoft® Office Excel® 2007 Step by Step
- By:
- Curtis Frye
- Publisher:
- Microsoft Press
- Formats:
-
- Ebook
- Safari Books Online
- Print Release:
- January 2007
- Ebook Release:
- November 2009
- Pages:
- 432
- Print ISBN:
- 978-0-7356-2304-0
- | ISBN 10:
- 0-7356-2304-X
- Ebook ISBN:
- 978-0-7356-9044-8
- | ISBN 10:
- 0-7356-9044-8
Curtis D. Frye is a coauthor of Microsoft Office Excel 2003 Programming Inside Out and the author of Microsoft Office Excel 2003 Step by Step, Microsoft Excel Version 2002 Plain & Simple, Faster Smarter Home Networking, several books on Microsoft Access, and numerous online training courses.
©2010, O'Reilly Media, Inc. (707) 827-7000 / (800) 998-9938 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
|