• Author:
  • Walkenbach, John
  • Banfield, Colin
• Subject:
  Business Applications
• Published by:
  John Wiley & Sons Inc (US)
• Published:
  22/12/2006
• Price:
  $27.99
• <  Buy this book  >

Fast answers to frequently asked questions

Excel 2007 essentials at your fingertips!

If you like your answers quick and your information up-to-date, look no further. With this concise, superbly organized reference, you'll quickly find just what you need to know about navigating the new interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more.

John Walkenbach is a leading authority on spreadsheet software and is principal of JWalk and Associates Inc., a small San Diego–based consulting firm that specializes in spreadsheet application development. He is the author of approximately three dozen spreadsheet books and has written hundreds of articles and reviews for a variety of publications, including PC World, InfoWorld, Windows magazine, and PC/Computing. John graduated from the University of Missouri and earned a master’s and a PhD from the University of Montana. Visit his Web site at www.j-walk.com.

Colin Banfield has been working in the telecommunications field for more than twenty-five years and has been using spreadsheet programs for more than two decades. Colin’s largest Excel project to date is a comprehensive tool that is designed for telephone central office equipment configuration, pricing, and manufacturing and used by sales, engineering, and manufacturing personnel. In between his telecom consulting duties, Colin works with organizations to extract information from corporate databases for business intelligence reporting in Excel. In his spare time, Colin writes and reviews books for Wiley and enjoys photography, astronomy, and expanding his musical repertoire. Colin holds a BSc (Honors) in Electrical Engineering from the University of the West Indies and has received extensive training in many advanced technologies.

Part 1: Getting to Know Excel 2007.

Part 2: Managing Workbooks.

Part 3: Working with Worksheets.

Part 4: Entering and Editing Worksheet Data.

Part 5: Using Formulas and Functions.

Part 6: Creating and Using Names.

Part 7: Auditing Your Work.

Part 8: Formatting Your Data.

Part 9: Printing Your Work.

Part 10: Charting Your Data.

Part 11: Working with Tables.

Part 12: Goal Seeking and What-If Analysis.

Part 13: Analyzing Data with PivotTables.

Glossary: Tech Talk.

Index.