Limit search to available items
Record 3 of 24
Previous Record Next Record
Book Cover
Author Frye, Curtis, 1968-

Title Excel 2007 pocket guide / by Curtis Frye
Edition Second edition
Published Sebastopol, Calif. : O'Reilly, 2007
Online access available from:
Safari O'Reilly books online    View Resource Record  


Description 1 online resource
Contents Excel 2007 Pocket Guide, 2nd Edition; The Excel 2007 Interface; Contextual Tabs; Dialog Expanders; The Office Button; Quick Access Toolbar; The Excel Program Window; New Excel 2007 File Format; Workbook, Template, and Workspace Files; Tips on Using Templates; The Anatomy of an Excel File; A Worksheet; Sheet Tabs; Formatting; Columns and Rows; Cells; Characters; Styles; Shortcut Menus and the Mini Toolbar; How Excel Tries to Help; AutoComplete; Smart Tags; 2. Excel Tasks; Printing; Moving Around in a Workbook or Worksheet; Manipulating Workbooks and Worksheets
Controlling How Data Is DisplayedFiltering Worksheet Data; Using Subtotals to Summarize Data; Creating Custom Views; Protecting All or Part of a Workbook; Spelling and Other Tools; Customizing Excel; Customizing the Quick Access Toolbar; Collaborating; Tracking Changes; Sharing Workbooks; Working with the Web; Summarizing Data with Charts; Analyzing Data with PivotTables and PivotCharts; 3. Formula Reference; Math Formulas; Date and Time Formulas; Financial Formulas; Lookup and Reference Formulas; Logical Formulas; Text Formulas; Statistical Formulas; 4. Excel Reference; Native Formats
Manipulating Rows, Columns, and CellsEntering and Editing Data; Creating, Managing, and Formatting Excel Tables; Entering Data with a Data Entry Form; Using AutoCorrect and AutoComplete; Inserting Text and Other Elements; Selecting Text and Data; Cutting, Copying, and Pasting Data; Clearing Cell Contents and Formulas; Formatting; Formatting Numbers and Dates; Formatting Cell Borders and Areas; Formatting a Workbook; Working with Hyperlinks; Working with Headers and Footers; Summarizing Data; Adding Formulas to Cells; Auditing Formulas; Using Named Ranges; Defining Alternative Data Sets
Startup SwitchesWildcards in Filters and Searches; Default File Locations; Keyboard Shortcuts; 5. Excel Resources; Books; Excel Utilities
Summary 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
Bibliography Includes bibliographical references and index
Notes Print version record
Subject Microsoft Excel (Computer file)
Business -- Computer programs.
Electronic spreadsheets.
Form Electronic book
ISBN 0596514522