|
|
|
|
4 | (2) |
|
|
6 | (2) |
|
|
8 | (1) |
|
|
9 | (1) |
|
Work with Excel's Galleries |
|
|
10 | (2) |
|
Customize the Quick Access Toolbar |
|
|
12 | (2) |
|
|
14 | (2) |
|
|
16 | (2) |
|
|
18 | (2) |
|
|
20 | (2) |
|
Add Excel to the Windows 7 Taskbar |
|
|
22 | (1) |
|
|
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) |
|
|
28 | (2) |
|
Enter a Number into a Cell |
|
|
30 | (2) |
|
Enter a Date or Time into a Cell |
|
|
32 | (2) |
|
|
34 | (2) |
|
|
36 | (2) |
|
|
38 | (4) |
|
Working with Excel Ranges |
|
|
|
|
42 | (2) |
|
Fill a Range with the Same Data |
|
|
44 | (2) |
|
Fill a Range with a Series of Values |
|
|
46 | (2) |
|
|
48 | (2) |
|
|
50 | (2) |
|
|
52 | (2) |
|
|
54 | (2) |
|
|
56 | (2) |
|
|
58 | (2) |
|
|
60 | (2) |
|
|
62 | (2) |
|
Transpose Rows and Columns |
|
|
64 | (4) |
|
|
|
Understanding the Benefits of Using Range Names |
|
|
68 | (2) |
|
|
70 | (2) |
|
Use Worksheet Text to Define a Range Name |
|
|
72 | (2) |
|
Navigate a Workbook Using Range Names |
|
|
74 | (2) |
|
|
76 | (2) |
|
|
78 | (2) |
|
Paste a List of Range Names |
|
|
80 | (4) |
|
|
|
Change the Font and Font Size |
|
|
84 | (2) |
|
|
86 | (2) |
|
|
88 | (2) |
|
|
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) |
|
|
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) |
|
|
106 | (2) |
|
|
108 | (2) |
|
|
110 | (2) |
|
|
112 | (2) |
|
|
114 | (2) |
|
Copy Formatting from One Cell to Another |
|
|
116 | (4) |
|
Building Formulas and Functions |
|
|
|
Understanding Excel Formulas |
|
|
120 | (2) |
|
|
122 | (2) |
|
Understanding Excel Functions |
|
|
124 | (2) |
|
Add a Function to a Formula |
|
|
126 | (2) |
|
Add a Row or Column of Numbers |
|
|
128 | (2) |
|
|
130 | (2) |
|
Add a Range Name to a Formula |
|
|
132 | (2) |
|
Reference Another Worksheet Range in a Formula |
|
|
134 | (2) |
|
|
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 |
|
|
|
|
146 | (1) |
|
|
147 | (1) |
|
|
148 | (2) |
|
|
150 | (2) |
|
|
152 | (2) |
|
|
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) |
|
|
176 | (1) |
|
|
177 | (1) |
|
|
178 | (2) |
|
|
180 | (2) |
|
Replace Text in a Workbook |
|
|
182 | (2) |
|
Check Spelling and Grammar |
|
|
184 | (2) |
|
|
186 | (4) |
|
Formatting Excel Workbooks |
|
|
|
Modify the Workbook Colors |
|
|
190 | (2) |
|
|
192 | (2) |
|
|
194 | (2) |
|
|
196 | (2) |
|
|
198 | (2) |
|
|
200 | (4) |
|
|
|
Adjust the Workbook Margins |
|
|
204 | (2) |
|
Change the Page Orientation |
|
|
206 | (1) |
|
|
207 | (1) |
|
|
208 | (2) |
|
|
210 | (2) |
|
Configure Titles to Print on Each Page |
|
|
212 | (2) |
|
|
214 | (2) |
|
|
216 | (4) |
|
|
|
|
220 | (2) |
|
|
222 | (2) |
|
Set Data Validation Rules |
|
|
224 | (2) |
|
Convert a Range to a Table |
|
|
226 | (2) |
|
|
228 | (2) |
|
Summarize Data with Subtotals |
|
|
230 | (2) |
|
|
232 | (2) |
|
Analyze Data with Goal Seek |
|
|
234 | (2) |
|
Analyze Data with Scenarios |
|
|
236 | (4) |
|
|
240 | (2) |
|
Load Excel's Analysis ToolPak |
|
|
242 | (4) |
|
Visualizing Data with Excel Charts |
|
|
|
|
246 | (1) |
|
Understanding Chart Types |
|
|
247 | (1) |
|
|
248 | (2) |
|
|
250 | (1) |
|
|
251 | (1) |
|
Position the Chart Legend |
|
|
252 | (1) |
|
|
253 | (1) |
|
|
254 | (1) |
|
Change the Chart Layout and Style |
|
|
255 | (1) |
|
Select a Different Chart Type |
|
|
256 | (2) |
|
Change the Chart Source Data |
|
|
258 | (2) |
|
|
260 | (2) |
|
Add a Sparkline to a Cell |
|
|
262 | (4) |
|
|
|
|
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 |
|
|
|
|
280 | (2) |
|
|
282 | (2) |
|
|
284 | (2) |
|
|
286 | (2) |
|
Insert a SmartArt Graphic |
|
|
288 | (2) |
|
|
290 | (2) |
|
|
292 | (2) |
|
|
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) |
|
|
302 | (4) |
|
Collaborating with other People |
|
|
|
|
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) |
|
|
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 | |