Excel 2007: The Missing Manual

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780596527594 | 0596527594
Cover: Paperback
Copyright: 12/1/2006

Buy New

In Stock Usually Ships in 24-48 Hours

$38.40
eBook

Available Instantly

Online: 1825 Days

Downloadable: Lifetime Access

$35.99

Excel 2007: The Missing Manual, written specifically for this version of the software, covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Like its siblings in the Missing Manual series, this book crackles with a fine sense of humor and refreshing objectivity about its subject, guiding readers through the new Excel with clear explanations, step-by-step instructions, lots of illustrations, and friendly, time- saving advice. It's a perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

The Missing Credits
Introduction
Worksheet Basics
Creating and Navigating Worksheets
Creating a Basic Worksheet
Starting a New Workbook
Adding the Column Titles
Adding Data
Editing Data
Navigating in Excel
The Tabs of the Ribbon
The Formula Bar
The Status Bar
Excel Options
Saving Files
The Excel 2007 File Format
Saving Your Spreadsheet in Older Formats
Saving Your Spreadsheet As a PDF
Saving Your Spreadsheet with a Password
Disaster Recovery
Opening Files
Opening Files-with a Twist
Opening Multiple Spreadsheets at Once
Adding Information to Worksheets
Adding Different Types of Data
Controlling Your Data Types
Quick Ways to Add Data
AutoComplete
AutoCorrect
AutoFill
AutoFitUndo and Redo
Moving Data Around a Worksheet
Selecting Cells
Making Continuous Range Selections
Making Non-Contiguous Selections
Automatically Selecting Your Data
Making Selections with the Keyboard
Moving Cells Around
A Simple Cut-and-Paste or Copy-and-Paste
A Fancy Cut-and-Paste or Copy-and-Paste
The Clipboard
Special Pasting
Adding and Moving Columns or Rows
Inserting Columns
Inserting Rows
Inserting Copied or Cut Cells
Deleting Columns and Rows
Managing Worksheets and Workbooks
Worksheets and Workbooks
Adding, Removing, and Hiding Worksheets
Naming and Rearranging Worksheets
Grouping Sheets
Moving Worksheets from One Workbook to Another
Find and Replace
The Basic Find
Find All
More Advanced Searches
Finding Formatted Cells
Finding and Replacing Values
Spell Check
Spell Checking Options
Formatting Cells
Formatting Cell Values
Formatting Numbers
Formatting Dates and Times
Special Formats for Special Numbers
Custom Formats
Formatting Cell Appearance
Alignment and Orientation
Fonts and Color
Borders and Fills
Drawing Borders by Hand
Smart Formatting Tricks
The Format Painter
Styles and Themes
Custom Styles
Modifying Styles
Transferring Styles Between Workbooks
Themes: A Package of Styles
Modifying Themes
Conditional Formatting
The Basics of Conditional Formatting
Highlighting Specific Values
Data Bars
Color ScalesIcon Sets
Fine-Tuning a Formatting Rule
Using Multiple Rules
Viewing and Printing Worksheets
Controlling Your View
Zooming
Viewing Distant Parts of a Spreadsheet at Once
Freezing Columns or Rows
Hiding Data
Saving View Settings
Viewing Multiple Workbooks at Once
Printing
How to Print an Excel File
Quick Printing
Previewing Your Printout
Creating Headers and Footers
Customizing Print Settings
Controlling Pagination
Page Breaks
Scaling
Page Break Preview: A Bird''s-Eye View of Your Worksheet
Formulas and Functions
Building Basic Formulas
Creating a Basic Formula
Excel''s Order of Operations
Cell References
How Excel Formats Cells That Contain Cell References
Functions
Formula Errors
Logical Operators
Formula Shortcuts
Point-and-Click Formula Creation
Point-and-Click Formula Editing
The Formulas Tab
Using the Insert Function Button
Copying Formulas
Absolute Cell References
Partially Fixed References
Referring to Other Worksheets and Workbooks
Math and Statistical Functions
Rounding Numbers
Round( ), Rounddown( ), Roundup( )
Rounding Numbers
Mround( ), Ceiling( ), and Floor( )
More Rounding Functions
INT( ) and TRUNC( )
Chopping Off Non-Whole Numbers
Even( ) and Odd( )
Rounding Up to Even or Odd Values
Groups of Numbers
Sum( )
Summing Up Numbers
Count( ), Counta( ), and Countblank( )
Counting Items in a List
Max( ) and Min( )
Finding Maximum and Minimum Values
Large( ), Small( ), and Rank( )
Ranking Your Numbers
Average( ) and Median( )
Finding Average or Median Values
Mode( )
Finding Numbers That Frequently Occur in a List
Percentile( ) and Percentrank( )
Advanced Ranking Functions
Frequency( )
Identifying to Which Category a Number Belongs
General Math Functions
Product( ), Fact( ), Power( ), and SQRT( )
Products, Factorials, Powers, and Square Roots
Quotient( ) and MOD( )
Higher Division
ABS( ) and SIGN( )
Absolute Value and Determining a Number''s Sign
Rand( ) and Randbetween( )
Generating Random Numbers
GCD( ) and LCM( )
Greatest and Least Common DenominatorC
Table of Contents provided by Publisher. All Rights Reserved.

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Excel 2007: The Missing Manual

Summary

Author Biography

Table of Contents

Supplemental Materials