Home Page Icon
Home Page
Table of Contents for
Microsoft® Office Excel® 2007 Plain & Simple
Close
Microsoft® Office Excel® 2007 Plain & Simple
by Curtis D. Frye
Microsoft® Office Excel® 2007 Plain & Simple
Microsoft® Office Excel® 2007 Plain & Simple
SPECIAL OFFER: Upgrade this ebook with O’Reilly
Acknowledgments
1. Introduction: About This Book
No Computerese!
Useful Tasks...
...And the Easiest Way to Do Them
A Quick Overview
A Few Assumptions
A Final Word (or Two)
2. What’s New in Excel 2007?
Touring the New User Interface
Arranging Data into Tables
Introducing Galleries
Using the Mini Toolbar
Creating Formulas Using New Functions
Using More Colors
Creating Better Conditional Formats
Creating More Attractive Charts
3. Getting Started with Excel 2007
Surveying the Excel Screen
Working with the User Interface
Working with Galleries
Starting Excel
Start Excel with a Blank Workbook
Open an Existing Workbook
Finding and Opening Existing Workbooks
Open a Workbook
Open a Recently Used Workbook
Search for a Workbook and Open It
Using File Properties
Set File Properties
Define Custom Properties
Creating a New Workbook
Create a New Workbook
Working with Multiple Workbooks
Switch between Open Workbooks
Show More than One Workbook
Sizing and Viewing Windows
Resize a Window
Zooming In or Out on a Worksheet
Zoom In or Out
Zoom In or Out to a Custom Zoom Level
Viewing a Worksheet in Full Screen Mode
Turn Full Screen Mode On
Turn Full Screen Mode Off
Saving and Closing an Excel Workbook
Save a Workbook
Save a Workbook with a New Name
Change the Default File Folder
Close a Workbook
Exit Excel
Using the Excel Help System
Get Microsoft Excel Help
Get Suggested Commands from Shortcut Menus
Get Help on the Web
4. Building a Workbook
Understanding How Excel Interprets Data Entry
Navigating the Worksheet
Navigate Your Workbook Using the Keyboard
Selecting Cells
Select a Contiguous Group of Cells
Select a Noncontiguous Group of Cells
Select Rows or Columns
Select Noncontiguous Rows or Columns
Entering Text in Cells
Enter Text as One Line
Enter Text with Forced Line Breaks
Entering Numbers in Cells
Enter Numbers
Enter Numbers Using Scientific Notation and Exponents
Entering Dates and Times in Cells
Enter a Date
Enter a Time
Enter a Date and Time
Enter the Current Date and Time
Entering Data Using Fills
Fill Data with AutoFill
Use AutoFill to Enter a Series of Values
Entering Data with Other Shortcuts
Enter Data with AutoComplete
Pick Data from a List
Creating a Data Table
Create a Data Table
Add Data to a Data Table
Rename a Data Table
Resize a Table
Select a Table Column
Editing Cell Contents
Edit Cell Contents in the Formula Bar
Edit Cell Contents Directly in the Cell
Inserting a Symbol in a Cell
Add a Symbol to a Cell
Creating Hyperlinks
Add a Hyperlink to a Place in the Same File
Add a Hyperlink to Another File
Add a Hyperlink to a Web Page
Add a Mailto Hyperlink
Cutting, Copying, and Pasting Cell Values
Cut a Cell Value
Copy a Cell Value
Pasting Values with More Control
Paste Values with More Control
Clearing Cell Contents
Clear a Cell
Using the Office Clipboard
Display the Contents of the Office Clipboard
Paste an Item from the Office Clipboard
Clear an Item from the Office Clipboard
Undoing or Redoing an Action
Undo or Redo an Action
Finding and Replacing Text
Find a Word or Value
Replace a Word or Value
Checking the Spelling of Your Worksheet
Check Spelling
5. Managing and Viewing Worksheets
Viewing and Selecting Worksheets
Select Multiple Worksheets
Renaming Worksheets
Change the Name of a Worksheet
Moving Worksheets
Move Worksheets within the Workbook
Move Worksheets to Another Workbook
Copying Worksheets
Copy Worksheets within the Workbook
Copy Worksheets to Another Workbook
Inserting and Deleting Worksheets
Insert a Blank Worksheet
Delete One or More Worksheets
Hiding or Showing a Worksheet
Hide or Unhide a Worksheet
Unhide a Hidden Worksheet
Changing Worksheet Tab Colors
Color a Sheet Tab
Inserting, Moving, and Deleting Cells
Inserting Cells in a Worksheet
Moving Cells in a Worksheet
Deleting Cells in a Worksheet
Inserting, Moving, and Deleting Columns and Rows
Insert a Row in a Worksheet
Insert a Column in a Worksheet
Set Insert Options
Delete a Row or Column
Move One or More Rows
Move One or More Columns
Hiding and Unhiding Columns and Rows
Hide Rows or Columns
Unhide Rows or Columns
Entering Data and Formatting Many Worksheets at the Same Time
Enter and Format Data on Several Worksheets at One Time
Copy Cells from One Worksheet to a Group of Worksheets
Changing How You Look at Excel Workbooks
View Different Parts of One Worksheet at the Same Time
View Multiple Workbooks at the Same Time
View Multiple Parts of a Worksheet by Freezing Panes
Naming and Using Worksheet Views
Name the Current View of the Worksheet
Switch to Another View of the Worksheet
6. Using Formulas and Functions
Understanding Formulas and Cell References in Excel
Creating Simple Cell Formulas
Build a Formula
Edit a Formula
Assigning Names to Groups of Cells
Create a Named Range
Go to a Named Range
Delete a Named Range
Rename a Named Range
Using Names in Formulas
Create a Formula with a Named Range
Creating a Formula that References Values in a Table
Create a Formula with a Table Reference
Creating Formulas that Reference Cells in Other Workbooks
Use Cells from Other Workbooks in a Formula
Break Links to Other Workbooks and Convert to Values
Refresh Links
Changing Links to Different Workbooks
Summing a Group of Cells without Using a Formula
Summarizing Data in a Group of Cells
Find the Total, Average, or Other Values of Cell Data
Creating a Summary Formula
Create an AutoSum Function
Summing with Subtotals and Grand Totals
Create a Subtotal
Remove a Subtotal
Exploring the Excel Function Library
List Functions Available from the Excel Library
Use Function ScreenTips
Using the IF Function
Create an IF Function
Checking Formula References
Find Cell Precedents and Dependents
Remove Tracer Arrows
Debugging Your Formulas
Monitor a Formula for Changes
Delete a Watch
Evaluate Parts of a Formula
7. Formatting the Worksheet
Formatting Cell Contents
Change Font and Font Size
Change Text Appearance
Format Part of a Cell’s Contents
Formatting Cells Containing Numbers
Display Numerical Values as Currency and Percentages
Set the Number of Decimal Places
Formatting Cells Containing Dates
Set a Date Format
Adding Cell Backgrounds and Shading
Add Background Color
Change Background Shading
Formatting Cell Borders
Draw Borders
Format Cell Borders
Defining Cell Styles
Apply a Style
Create a Style
Modify a Style
Delete a Style
Aligning and Orienting Cell Contents
Change Text Alignment
Set Text Orientation and Wrapping
Formatting a Cell Based on Conditions
Change the Format of a Cell Based on Its Value
Change the Format of a Cell Based on the Results of a Formula
Edit a Conditional Formatting Rule
Delete a Conditional Formatting Rule
Changing How Conditional Formatting Rules Are Applied
Stop when a Condition Is Met
Change the Order of Conditions
Displaying Data Bars, Icon Sets, or Color Scales Based on Cell Values
Display Data Bars
Display Icon Sets
Display Color Scales
Copying Formats with the Format Painter
Copy Styles with the Format Painter
Merging or Splitting Cells or Data
Merge Several Cells into One
Split a Merged Cell
8. Formatting the Worksheet
Applying Workbook Themes
Apply a Workbook Theme
Change Colors within a Theme
Change Fonts within a Theme
Change Effects within a Theme
Create a New Workbook Theme
Coloring Sheet Tabs
Color a Sheet Tab
Changing a Worksheet’s Gridlines
Change the Color of Cell Gridlines
Show or Hide Cell Gridlines
Changing Row Heights and Column Widths
Resize a Row
Resize a Column
Resizing Multiple Rows or Columns
Inserting Rows or Columns
Insert a Row in a Worksheet
Insert a Column in a Worksheet
Set Insert Options
Moving Rows and Columns
Move One or More Rows
Move One or More Columns
Deleting Rows and Columns
Delete a Row or Column
Outlining to Hide and Show Rows and Columns
Group Rows and Columns
Ungroup Rows and Columns
Show Grouped Rows and Columns
Hide Grouped Rows and Columns
Hiding Rows and Columns
Hide Rows or Columns
Unhide Rows or Columns
Protecting Worksheets from Changes
Protect a Worksheet
Locking Cells to Prevent Changes
Lock Cells
9. Printing Worksheets
Previewing Worksheets Before Printing
Display a Worksheet in Page Layout View
View and Zoom Worksheets in Print Preview
Change Column Widths and Row Heights in Page Layout View
Printing Worksheets with Current Options
Print Multiple Worksheets from the Same Workbook
Choosing Whether to Print Gridlines and Headings
Choose to Print Gridlines
Choose to Print Headings
Choosing Printers and Paper Options
Choose a Printer
Choose the Paper
Printing Part of a Worksheet
Set a Print Area
Remove a Print Area
Printing Row and Column Headings on Each Page
Identify the Rows and Columns to Repeat
Setting and Changing Print Margins
Set Page Margins
Adjust Page Margins in Print Preview
Setting Page Orientation and Scale
Set Page Orientation
Scale the Printout to a Fixed Number of Pages
Creating Headers and Footers
Add a Premade Header and Footer
Add Pre-Defined Text to the Header or Footer
Adjust Header and Footer Height
Adding Graphics to a Header or a Footer
Include a Graphic in a Header or Footer
Format a Graphic in a Header or Footer
Setting and Viewing Page Breaks
View Current Page Breaks
Set Manual Page Breaks
Change Manual Page Breaks
10. Customizing Excel to the Way You Work
Opening Ready-to-Use Workbook Templates
Create a Workbook from a Template
Modify a Template
Saving a Workbook as a Template
Save a Workbook as a Template
Adding Commands to the Quick Access Toolbar
Add a Command to the Quick Access Toolbar
Remove a Command from the Quick Access Toolbar
Move the Quick Access Toolbar
Controlling which Error Messages Appear
Choose which Error Messages Appear
Reset Ignored Errors
Select the Color in which Excel Displays Errors
Defining AutoCorrect and AutoFormat Entries
Create an AutoCorrect Entry
Delete an AutoCorrect Entry
Control AutoFormat Rules
Controlling Worksheet Gridline Appearance
Display or Hide Worksheet Gridlines
Change Gridline Color
11. Sorting and Filtering Worksheet Data
Sorting Worksheet Data
Sort Data in Ascending or Descending Order
Create a Multi-Column Sort
Creating a Custom Sort List
Define a Custom List of Values
Sort by a Custom List
Filtering Data Quickly with AutoFilter
Create an AutoFilter
Display All Rows in a Filtered List
Create a Custom AutoFilter
Creating an Advanced Filter
Build an Advanced Filter
Remove an Advanced Filter
Validating Data for Correctness during Entry
Validate for Specific Requirements
Validate Data According to a List in a Worksheet Range
Getting More out of Advanced Filters
Copy Filtered Rows to a New Location
Finding Unique Values in a Data List
Find Unique Rows in a Data Table
Finding Duplicate Values in a Data List
Delete Duplicate Values from a Data List
12. Summarizing Data Visually Using Charts
Displaying Data Graphically
Standard Excel Chart Types and Uses
Creating a Chart Quickly
Create a Chart
Change a Chart’s Layout
Change a Chart’s Style
Changing a Chart’s Appearance
Change a Chart’s Type
Change the Formatting of a Chart Element
Formatting Chart Legends and Titles
Show or Hide a Chart Legend
Add Titles
Add and Remove Data Labels
Changing the Body of a Chart
Show or Hide Chart Grid Lines
Change the Scale on the Value Axis
Change the Scale on the Category (X) Axis
Customizing Chart Data
Change the Source Data for Your Chart
Add a New Series
Delete a Series
Working with Common Charts
Pull a Slice Out of a Pie Chart
Create a 3-D Exploded Pie Chart
Change the Way You View 3-D Charts
Working with Uncommon Charts
Create a Stock Chart
Adding a Trendline to a Chart
Add a Trendline to a Data Series
13. Enhancing Your Worksheets with Graphics
Working with Graphics in Your Worksheets
Adding Graphics to Worksheets
Add a Picture
Delete a Picture
Adding Drawing Objects to a Worksheet
Add a Simple Shape
Add Text to Any Shape
Format Text in a Shape
Adding Fills to Drawing Objects
Apply a Shape Style
Apply a Fill
Fill an Object with a Picture
Adding Effects to Drawing Objects
Add or Edit an Object’s Shadow
Rotate an Object in Three Dimensions
Customizing Pictures and Objects
Resize a Picture or Object
Rotate a Picture or Object
Aligning and Grouping Drawing Objects
Align Objects
Group or Ungroup Objects
Change the Order of Objects
Using WordArt to Create Text Effects in Excel
Add WordArt Text
Change WordArt Text Colors
Inserting Clip Art into a Worksheet
Add Clip Art
Browse the Clip Organizer for Clip Art
Inserting and Changing a Diagram
Insert a Diagram
Change the Style of a Diagram
Creating an Organization Chart
Create an Organization Chart
Adding a Shape
Alter the Layout of Your Organization Chart
Change the Design of Your Organization Chart
14. Sharing Excel Data with Other Programs
Introducing Linking and Embedding
Linking and Embedding Other Files
Embed a File in a Worksheet
Link to a File
Exchanging Table Data between Excel and Word
Bring Word Data into Excel
Copy Excel Data to Word
Copying Excel Charts and Data into PowerPoint
Move Excel Data to PowerPoint
Copy an Excel Chart to PowerPoint
Exchanging Data between Access and Excel
Bring Access Table Data into an Excel Worksheet
Send Excel Data to Access
Importing a Text File
Bring Text into Excel
15. Using Excel in a Group Environment
Sharing Workbooks in Excel
Turn on Workbook Sharing
Commenting in Cells
Add a Comment
View a Comment
Edit a Comment
Delete a Comment
Tracking Changes in Workbooks
Turn on Track Changes
Accepting or Rejecting Changes
View a Change
Review Changes
Create a Change History
Saving Worksheets to the Web
Save a Workbook to the Web
Add a Worksheet to an Existing Web Page
Dynamically Update Worksheets Published to the Web
Dynamically Update Worksheets Published to the Web
Retrieving Web Data from Excel
Retrieve Data from Web Pages
Copy Data from the Web to Excel
Modifying Web Queries
Schedule Web Query Data Refreshes
Introducing XML
Interacting over the Web with XML
Save a Workbook as an XML Spreadsheet
Import Spreadsheet XML
About the Author
Choose the Right Book for You
Published and Upcoming Titles
Plain & Simple
Step by Step
Inside Out
Index
About the Author
SPECIAL OFFER: Upgrade this ebook with O’Reilly
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
SPECIAL OFFER: Upgrade this ebook with O’Reilly
Microsoft
®
Office Excel
®
2007 Plain & Simple
Curtis D. Frye
Copyright © 2009
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset