
Excel 2007 Pocket Guide
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- Intro
- Contents
- Understanding Excel
- What's New in Excel 2007
- The Excel 2007 Interface
- The Ribbon
- 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 Workbook
- A Worksheet
- Sheet Tabs
- Formatting
- Worksheets
- Columns and Rows
- Cells
- Characters
- Styles
- Shortcut Menus and the Mini Toolbar
- How Excel Tries to Help
- AutoCorrect
- AutoComplete
- Smart Tags
- 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
- Entering Data Efficiently
- 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 Cell Contents
- Formatting Numbers and Dates
- Formatting Cell Borders and Areas
- Formatting a Workbook
- Working with Hyperlinks
- Working with Headers and Footers
- Summarizing Data
- Getting a Running Total
- Adding Formulas to Cells
- Auditing Formulas
- Using Named Ranges
- Defining Alternative Data Sets
- Controlling How Data Is Displayed
- Sorting Worksheet Data
- Filtering Worksheet Data
- Using Subtotals to Summarize Data
- Creating Custom Views
- Protecting All or Part of a Workbook
- Spelling and Other Tools
- Customizing Excel
- Setting General Customization Options
- Customizing the Quick Access Toolbar
- Collaborating
- Comments
- Tracking Changes
- Sharing Workbooks
- 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
- Excel Reference
- Command Reference
- Native Formats
- Startup Switches
- Wildcards in Filters and Searches
- Default File Locations
- Keyboard Shortcuts
- Excel Resources
- Internet Sites
- Books
- Excel Utilities
- Index
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.