Skip to content

Excel 2007

Spend $50 to get a free DVD!

ISBN-10: 0596527594

ISBN-13: 9780596527594

Edition: 2nd 2006

Authors: Matthew MacDonald

List price: $39.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed very little since the early '90s is its user interface. The once-simple toolbar has been packed with so many features over the years that few users know where to find them all. Microsoft has addressed this problem in Excel 2007 by radically redesigning the user interface with a tabbed toolbar that makes every feature easy to locate and use. Unfortunately, Microsoft's documentation is as scant as ever, so even if users can find advanced features, they probably won't know what to do with them. "Excel 2007: The Missing Manual," written specifically for this version of the software,…    
Customers also bought

Book details

List price: $39.99
Edition: 2nd
Copyright year: 2006
Publisher: O'Reilly Media, Incorporated
Publication date: 1/6/2007
Binding: Paperback
Pages: 860
Size: 7.00" wide x 9.00" long x 1.25" tall
Weight: 2.684
Language: English

Matthew MacDonald is an author,educator, and MCSD developer who has a passion for emerging technologies. He isthe author of more than a dozen books about .NET programming. In a dimly-remembered past life, he studied English literature and theoretical physics.

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