Excel 2007 for Starters

Fast-paced and easy to use, our new guide teaches readers the basics of Excel 2007 so they can start using the program right away. They'll quickly learn how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. The new Excel user interface is radically different from previous versions, but with this book, readers can breeze through the basic features in no time. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of friendly advice, this For Starters Manual is the 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 software developer. He is the author of Excel 2007: The Missing Manual and several books about .NET, including The Book of VB .NET (No Starch), ASP.NET: The Complete Reference (McGraw-Hill), Microsoft .NET Distributed Applications (Microsoft Press), and several more. He is a regular columnist for Inside Visual Basic, and has been involved in non-programming writing projects like the classical All-Music Guide.

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"
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Excel 2007 for Starters

Summary

Author Biography

Table of Contents

Supplemental Materials