Excel 2007

ISBN-10: 0596527594
ISBN-13: 9780596527594
Edition: 2nd 2006
List price: $39.99 Buy it from $3.00
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

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  More...

Used Starting from $19.63
New Starting from $30.04
eBooks Starting from $31.99
Rent
Buy
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Medical Terminology Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

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.19" long x 1.89" tall
Weight: 2.684
Language: English

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, 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.

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

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×