Skip to content

Excel 2007 for Starters

Spend $50 to get a free DVD!

ISBN-10: 0596528329

ISBN-13: 9780596528324

Edition: 2007

Authors: Matthew MacDonald

List price: $19.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:

Fast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away. This concise guide shows readers how to work with Excel's most useful features and its completely redesigned interface. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of timesaving advice, Excel 2007 for Starters: The Missing Manual will quickly teach you to:* Build spreadsheets* Add and format information* Print reports* Create charts and graphics* Use basic formulas and functions* and moreThe new Excel is radically different from previous versions. Over the years, Excel has grown in power, sophistication and capability, but…    
Customers also bought

Book details

List price: $19.99
Copyright year: 2007
Publisher: O'Reilly Media, Incorporated
Publication date: 2/2/2007
Binding: Paperback
Pages: 352
Size: 7.00" wide x 9.00" long x 1.00" tall
Weight: 1.210
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
Disaster Recovery
Opening Files
Opening Multiple Spreadsheets at Once
Adding Information to Worksheets
Adding Different Types of Data
Controlling Your Data Types
Quick Ways to Add Data
Auto Complete
Auto Correct
Auto Fill
Auto Fit Undo 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
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
Formatting Cell Appearance
Alignment and Orientation
Fonts and Color
Borders and Fills
Drawing Borders by Hand
Smart Ways to Apply Formatting
The Format Painter
Styles and Themes
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
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
Worksheet power
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 to Quickly Find and Insert Functions
Copying Formulas
Absolute Cell
References
Partially Fixed
References
Tables: List Management Made Easy
The Basics of Tables
Creating a Table
Formatting a Table
Editing a Table
Selecting Parts of a Table
Sorting and Filtering a Table
Applying a Simple Sort Order
Sorting with Multiple Criteria
Filtering with the List of Values
Creating Smarter Filters
Creating Basic Charts
Charting 101 Embedded and Standalone Charts
Creating a Chart with the Ribbon
The Chart Tools Ribbon Tabs
Basic Tasks with Charts
Moving and Resizing a Chart
Creating a Standalone Chart
Editing and Adding to Chart Data
Changing the Chart Type
Printing Charts
Practical Charting
Charts with Multiple Series of Numbers
Controlling the Data Excel Plots on the X-Axis
Non-Contiguous Chart Ranges
Changing the Order of Your Data Series
Changing the Way Excel Plots Blank Values
Chart Types
Column
BarLine
PieArea
Appendix
Customizing the Quick Access Toolbar
Index"