Read more
Moving to Excel 2007 is not a routine upgrade. Microsoft's radical redesign of the application's user interface has led to confusion among many who people who have relied on Excel for years. Our new edition of the Excel 2007 Pocket Guide has been written from the ground up to help newcomers and longtime users alike find their way around without getting lost.With this book in hand, you'll be able to find your favorite Excel tools quickly. It's packed with information to guide beginners through the basics of creating spreadsheets and entering data, while providing advanced users with information on formulas, pivot tables, and more. Inside, you'll find: A visual guide to the new "Ribbon" interface that helps users find familiar tools A section designed to give beginners enough information to dive right in and start creating rich Excel workbooks immediately Quick answers about how to perform specific tasks in Excel, such as working with files, editing data, formatting, summarizing and displaying data Convenient techniques for connecting data across worksheets and projects Help for moving from the basics of spreadsheet construction to more advanced features: This edition also includes an extensive reference on commonly used formulas, which reveal at a glance the many possibilities Excel 2007 provides for easy calculation.
List of contents
Understanding Excel
What's New in Excel 2007
The Excel 2007 Interface
The Anatomy of an Excel File
Formatting
Shortcut Menus and the Mini Toolbar
How Excel Tries to Help
Excel Tasks
Working with Files
Printing
Moving Around in a Workbook or Worksheet
Manipulating Workbooks and Worksheets
Manipulating Rows, Columns, and Cells
Entering and Editing Data
Formatting
Working with Hyperlinks
Working with Headers and Footers
Summarizing Data
Using Named Ranges
Defining Alternative Data Sets
Controlling How Data Is Displayed
Protecting All or Part of a Workbook
Spelling and Other Tools
Customizing Excel
Collaborating
Working with the Web
Summarizing Data with Charts
Analyzing Data with PivotTables and Pivot
Charts
Formula Reference
New Formulas in Excel 2007
Math Formulas
Date and Time Formulas
Financial Formulas
Lookup and Reference Formulas
Logical Formulas
Text Formulas
About the author
Curt is the author of numerous books on Excel and other Office products, most recently the "Excel 2007 Pocket Guide". He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.
Summary
Covers Excel 2007, helping people find their tools and showing them the new ones. This book includes information on commonly-used formulas, showing readers the possibilities Excel provides for calculation. It also demonstrates techniques for connecting data across worksheets and projects.
