Working with Excel
Getting to Know Excel
4(2)
Start Excel
6(2)
Tour the Excel Window
8(1)
Work with Excel's Ribbon
9(1)
Work with Excel's Galleries
10(2)
Customize the Quick Access Toolbar
12(2)
Customize the Ribbon
14(2)
Work with Smart Tags
16(2)
Change the View
18(2)
Configure Excel Options
20(2)
Add Excel to the Windows 7 Taskbar
22(1)
Quit Excel
23(3)
Entering and Editing Excel Data
Learning the Layout of a Worksheet
26(1)
Understanding the Types of Data You Can Use
27(1)
Enter Text into a Cell
28(2)
Enter a Number into a Cell
30(2)
Enter a Date or Time into a Cell
32(2)
Insert a Symbol
34(2)
Edit Cell Data
36(2)
Delete Data from a Cell
38(4)
Working with Excel Ranges
Select a Range
42(2)
Fill a Range with the Same Data
44(2)
Fill a Range with a Series of Values
46(2)
Move or Copy a Range
48(2)
Insert a Row or Column
50(2)
Insert a Cell or Range
52(2)
Delete Data from a Range
54(2)
Delete a Range
56(2)
Hide a Row or Column
58(2)
Freeze Rows or Columns
60(2)
Merge Two or More Cells
62(2)
Transpose Rows and Columns
64(4)
Working with Range Names
Understanding the Benefits of Using Range Names
68(2)
Define a Range Name
70(2)
Use Worksheet Text to Define a Range Name
72(2)
Navigate a Workbook Using Range Names
74(2)
Change a Range Name
76(2)
Delete a Range Name
78(2)
Paste a List of Range Names
80(4)
Formatting Excel Ranges
Change the Font and Font Size
84(2)
Apply Font Effects
86(2)
Change the Font Color
88(2)
Align Text Within a Cell
90(2)
Center Text Across Multiple Columns
92(2)
Rotate Text Within a Cell
94(2)
Add a Background Color to a Range
96(2)
Apply a Number Format
98(2)
Change the Number of Decimal Places Displayed
100(2)
Apply an AutoFormat to a Range
102(2)
Apply a Conditional Format to a Range
104(2)
Apply a Style to a Range
106(2)
Change the Column Width
108(2)
Change the Row Height
110(2)
Wrap Text Within a Cell
112(2)
Add Borders to a Range
114(2)
Copy Formatting from One Cell to Another
116(4)
Building Formulas and Functions
Understanding Excel Formulas
120(2)
Build a Formula
122(2)
Understanding Excel Functions
124(2)
Add a Function to a Formula
126(2)
Add a Row or Column of Numbers
128(2)
Build an AutoSum Formula
130(2)
Add a Range Name to a Formula
132(2)
Reference Another Worksheet Range in a Formula
134(2)
Move or Copy a Formula
136(2)
Switch to Absolute Cell References
138(2)
Toggle the Formula Bar on and Off
140(2)
Troubleshoot Formula Errors
142(4)
Manipulating Excel Worksheets
Navigate a Worksheet
146(1)
Rename a Worksheet
147(1)
Create a New Worksheet
148(2)
Move a Worksheet
150(2)
Copy a Worksheet
152(2)
Delete a Worksheet
154(2)
Change the Gridline Color
156(2)
Toggle Worksheet Gridlines On and Off
158(1)
Toggle Worksheet Headings On and Off
159(1)
Set the Worksheet Tab Color
160(2)
Set the Worksheet Background
162(2)
Zoom in On or Out of a Worksheet
164(2)
Split a Worksheet into Two Panes
166(2)
Hide and Unhide a Worksheet
168(4)
Dealing with Excel Workbooks
Create a New Blank Workbook
172(2)
Create a New Workbook from a Template
174(2)
Save a Workbook
176(1)
Open a Workbook
177(1)
Arrange Workbook Windows
178(2)
Find Text in a Workbook
180(2)
Replace Text in a Workbook
182(2)
Check Spelling and Grammar
184(2)
Close a Workbook
186(4)
Formatting Excel Workbooks
Modify the Workbook Colors
190(2)
Set the Workbook Fonts
192(2)
Choose Workbook Effects
194(2)
Apply a Workbook Theme
196(2)
Add a Workbook Header
198(2)
Add a Workbook Footer
200(4)
Printing Excel Workbooks
Adjust the Workbook Margins
204(2)
Change the Page Orientation
206(1)
Insert a Page Break
207(1)
Choose a Paper Size
208(2)
Set the Print Area
210(2)
Configure Titles to Print on Each Page
212(2)
Preview the Printout
214(2)
Print a Workbook
216(4)
Analyzing Excel Data
Sort a Range
220(2)
Filter a Range
222(2)
Set Data Validation Rules
224(2)
Convert a Range to a Table
226(2)
Create a Data Table
228(2)
Summarize Data with Subtotals
230(2)
Group Related Data
232(2)
Analyze Data with Goal Seek
234(2)
Analyze Data with Scenarios
236(4)
Create a PivotTable
240(2)
Load Excel's Analysis ToolPak
242(4)
Visualizing Data with Excel Charts
Examining Chart Elements
246(1)
Understanding Chart Types
247(1)
Create a Chart
248(2)
Add Chart Titles
250(1)
Add Data Labels
251(1)
Position the Chart Legend
252(1)
Display Chart Gridlines
253(1)
Display a Data Table
254(1)
Change the Chart Layout and Style
255(1)
Select a Different Chart Type
256(2)
Change the Chart Source Data
258(2)
Move or Resize a Chart
260(2)
Add a Sparkline to a Cell
262(4)
Formatting Excel Charts
Format Chart Elements
266(2)
Customize a Chart Element Background
268(2)
Set a Chart Element's Outline
270(2)
Add Effects to a Chart Element
272(2)
Apply a Style to a Chart Element
274(2)
Apply a WordArt Style to Chart Text
276(4)
Adding and Editing Worksheet Graphics
Draw a Shape
280(2)
Insert a Clip Art Image
282(2)
Insert a Photo
284(2)
Insert a WordArt Image
286(2)
Insert a SmartArt Graphic
288(2)
Move or Resize a Graphic
290(2)
Crop a Picture
292(2)
Format a Picture
294(2)
Add a Shadow or Glow to a Picture
296(2)
Add a Reflection or 3-D Effect to a Picture
298(2)
Add an Artistic Effect to a Photo
300(2)
Recolor an Image
302(4)
Collaborating with other People
Add a Comment to a Cell
306(2)
Protect a Worksheet's Data
308(2)
Protect a Workbook's Structure and Windows
310(2)
Share a Workbook with Other Users
312(2)
Track Workbook Changes
314(2)
Accept or Reject Workbook Changes
316(2)
Send a Workbook as an E-Mail Attachment
318(2)
Save Excel Data as a Web Page
320(2)
Make a Workbook Compatible with Earlier Versions of Excel
322(2)
Collaborate on a Workbook Online
324