Excel 2007 Pocket Guide, 2/e (Paperback)

Curtis D. Frye

  • 出版商: O'Reilly
  • 出版日期: 2007-12-04
  • 售價: $770
  • 貴賓價: 9.5$732
  • 語言: 英文
  • 頁數: 174
  • 裝訂: Paperback
  • ISBN: 0596514522
  • ISBN-13: 9780596514525
  • 相關分類: Excel
  • 已過版
    無現貨庫存(No stock available)




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. Tasks in the book are presented as answers to "How do I..." questions -- such as "How do I change the formatting of part of a cell's contents?" -- followed by concise instructions for performing the task. You'll learn ways to customize Excel to fit your needs, and how to share workbooks and collaborate with others. And much more.

Don't let Excel 2007 baffle you. Pick up this convenient pocket guide and learn to navigate this redesigned application with ease.

Table of Contents

Understanding Excel  

     What's New in Excel 2007 

     The Excel 2007 Interface 

     The Anatomy of an Excel File 


     Shortcut Menus and the Mini Toolbar 

     How Excel Tries to Help 

Excel Tasks  

     Working with Files 


     Moving Around in a Workbook or Worksheet 

     Manipulating Workbooks and Worksheets 

     Manipulating Rows, Columns, and Cells 

     Entering and Editing Data 


     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 


     Working with the Web 

     Summarizing Data with Charts 

     Analyzing Data with PivotTables and PivotCharts 

Formula Reference  

     New Formulas in Excel 2007 

     Math Formulas 

     Date and Time Formulas 

     Financial Formulas 

     Lookup and Reference Formulas 

     Logical Formulas 

     Text Formulas 

     Statistical Formulas 

Chapter 4:. Excel Reference

     Command Reference 

     Native Formats 

     Startup Switches 

     Wildcards in Filters and Searches 

     Default File Locations 

     Keyboard Shortcuts 

Chapter 5:. Excel Resources

     Internet Sites 


     Excel Utilities