| Introduction |
|
xli | |
| Part I: Getting Started with Excel |
|
1 | (204) |
|
Chapter 1 Introducing Excel |
|
|
3 | (26) |
|
Understanding What Excel Is Used For |
|
|
3 | (1) |
|
Looking at What's New in Excel 2019 |
|
|
4 | (1) |
|
Understanding Workbooks and Worksheets |
|
|
4 | (3) |
|
Moving around a Worksheet |
|
|
7 | (3) |
|
Navigating with your keyboard |
|
|
8 | (1) |
|
Navigating with your mouse |
|
|
9 | (1) |
|
|
|
10 | (6) |
|
|
|
10 | (2) |
|
|
|
12 | (1) |
|
Types of commands on the Ribbon |
|
|
12 | (2) |
|
Accessing the Ribbon by using your keyboard |
|
|
14 | (2) |
|
|
|
16 | (1) |
|
Customizing Your Quick Access Toolbar |
|
|
17 | (1) |
|
Working with Dialog Boxes |
|
|
18 | (2) |
|
|
|
19 | (1) |
|
Using tabbed dialog boxes |
|
|
20 | (1) |
|
|
|
20 | (2) |
|
Creating Your First Excel Workbook |
|
|
22 | (7) |
|
Getting started on your worksheet |
|
|
22 | (1) |
|
Filling in the month names |
|
|
23 | (1) |
|
|
|
23 | (1) |
|
|
|
24 | (1) |
|
Making your worksheet look a bit fancier |
|
|
25 | (1) |
|
|
|
26 | (1) |
|
|
|
26 | (1) |
|
|
|
26 | (1) |
|
|
|
27 | (2) |
|
Chapter 2 Entering and Editing Worksheet Data |
|
|
29 | (22) |
|
|
|
29 | (2) |
|
|
|
29 | (1) |
|
|
|
30 | (1) |
|
|
|
31 | (1) |
|
Entering Text and Values into Your Worksheets |
|
|
31 | (2) |
|
|
|
31 | (1) |
|
|
|
32 | (1) |
|
|
|
33 | (1) |
|
Entering Dates and Times into Your Worksheets |
|
|
33 | (1) |
|
|
|
33 | (1) |
|
|
|
34 | (1) |
|
|
|
34 | (10) |
|
Deleting the contents of a cell |
|
|
34 | (1) |
|
Replacing the contents of a cell |
|
|
35 | (1) |
|
Editing the contents of a cell |
|
|
35 | (2) |
|
Learning some handy data-entry techniques |
|
|
37 | (7) |
|
Automatically moving the selection after entering data |
|
|
37 | (1) |
|
Selecting a range of input cells before entering data |
|
|
37 | (1) |
|
Using Ctrl+Enter to place information into multiple cells simultaneously |
|
|
37 | (1) |
|
|
|
38 | (1) |
|
Entering decimal points automatically |
|
|
38 | (1) |
|
Using AutoFill to enter a series of values |
|
|
39 | (1) |
|
Using AutoComplete to automate data entry |
|
|
40 | (1) |
|
Forcing text to appear on a new line within a cell |
|
|
41 | (1) |
|
Using AutoCorrect for shorthand data entry |
|
|
41 | (1) |
|
Entering numbers with fractions |
|
|
42 | (1) |
|
Using a form for data entry |
|
|
42 | (2) |
|
Entering the current date or time into a cell |
|
|
44 | (1) |
|
Applying Number Formatting |
|
|
44 | (7) |
|
Using automatic number formatting |
|
|
46 | (1) |
|
Formatting numbers by using the Ribbon |
|
|
46 | (1) |
|
Using shortcut keys to format numbers |
|
|
46 | (2) |
|
Formatting numbers by using the Format Cells dialog box |
|
|
48 | (2) |
|
Adding your own custom number formats |
|
|
50 | (1) |
|
Chapter 3 Performing Basic Worksheet Operations |
|
|
51 | (20) |
|
Learning the Fundamentals of Excel Worksheets |
|
|
51 | (8) |
|
Working with Excel windows |
|
|
51 | (3) |
|
Moving and resizing windows |
|
|
52 | (1) |
|
|
|
53 | (1) |
|
|
|
54 | (1) |
|
|
|
54 | (1) |
|
Adding a new worksheet to your workbook |
|
|
55 | (1) |
|
Deleting a worksheet you no longer need |
|
|
55 | (1) |
|
Changing the name of a worksheet |
|
|
56 | (1) |
|
Changing a sheet tab color |
|
|
57 | (1) |
|
Rearranging your worksheets |
|
|
57 | (1) |
|
Hiding and unhiding a worksheet |
|
|
58 | (1) |
|
Controlling the Worksheet View |
|
|
59 | (6) |
|
Zooming in or out for a better view |
|
|
59 | (1) |
|
Viewing a worksheet in multiple windows |
|
|
60 | (1) |
|
Comparing sheets side by side |
|
|
61 | (1) |
|
Splitting the worksheet window into panes |
|
|
62 | (1) |
|
Keeping the titles in view by freezing panes |
|
|
62 | (3) |
|
Monitoring cells with a Watch Window |
|
|
65 | (1) |
|
Working with Rows and Columns |
|
|
65 | (6) |
|
Inserting rows and columns |
|
|
66 | (1) |
|
Deleting rows and columns |
|
|
67 | (1) |
|
Changing column widths and row heights |
|
|
67 | (2) |
|
|
|
68 | (1) |
|
|
|
68 | (1) |
|
|
|
69 | (2) |
|
Chapter 4 Working with Excel Ranges and Tables |
|
|
71 | (46) |
|
Understanding Cells and Ranges |
|
|
71 | (10) |
|
|
|
72 | (1) |
|
Selecting complete rows and columns |
|
|
73 | (1) |
|
Selecting noncontiguous ranges |
|
|
73 | (1) |
|
Selecting multisheet ranges |
|
|
74 | (3) |
|
Selecting special types of cells |
|
|
77 | (2) |
|
Selecting cells by searching |
|
|
79 | (2) |
|
|
|
81 | (12) |
|
Copying by using Ribbon commands |
|
|
82 | (1) |
|
Copying by using shortcut menu commands |
|
|
83 | (1) |
|
Copying by using shortcut keys |
|
|
83 | (2) |
|
Copying or moving by using drag-and-drop |
|
|
85 | (1) |
|
Copying to adjacent cells |
|
|
86 | (1) |
|
Copying a range to other sheets |
|
|
87 | (1) |
|
Using the Office Clipboard to paste |
|
|
87 | (2) |
|
|
|
89 | (1) |
|
Using the Paste Special dialog box |
|
|
90 | (3) |
|
Performing mathematical operations without formulas |
|
|
92 | (1) |
|
Skipping blanks when pasting |
|
|
92 | (1) |
|
|
|
92 | (1) |
|
Using Names to Work with Ranges |
|
|
93 | (5) |
|
Creating range names in your workbooks |
|
|
94 | (3) |
|
|
|
94 | (1) |
|
Using the New Name dialog box |
|
|
94 | (1) |
|
Using the Create Names from Selection dialog box |
|
|
95 | (2) |
|
|
|
97 | (1) |
|
|
|
98 | (4) |
|
|
|
99 | (1) |
|
Changing a comment's shape |
|
|
100 | (1) |
|
|
|
101 | (1) |
|
Hiding and showing comments |
|
|
101 | (1) |
|
|
|
101 | (1) |
|
|
|
102 | (1) |
|
|
|
102 | (15) |
|
Understanding a table's structure |
|
|
102 | (2) |
|
|
|
103 | (1) |
|
|
|
103 | (1) |
|
|
|
103 | (1) |
|
|
|
104 | (1) |
|
|
|
104 | (1) |
|
|
|
105 | (1) |
|
Sorting and filtering table data |
|
|
105 | (7) |
|
|
|
106 | (2) |
|
|
|
108 | (2) |
|
Filtering a table with slicers |
|
|
110 | (2) |
|
Changing the table's appearance |
|
|
112 | (5) |
|
Chapter 5 Formatting Worksheets |
|
|
117 | (36) |
|
Getting to Know the Formatting Tools |
|
|
117 | (3) |
|
Using the formatting tools on the Home tab |
|
|
118 | (1) |
|
|
|
118 | (1) |
|
Using the Format Cells dialog box |
|
|
119 | (1) |
|
Formatting Your Worksheet |
|
|
120 | (11) |
|
Using fonts to format your worksheet |
|
|
120 | (2) |
|
|
|
122 | (5) |
|
Choosing horizontal alignment options |
|
|
123 | (2) |
|
Choosing vertical alignment options |
|
|
125 | (1) |
|
Wrapping or shrinking text to fit the cell |
|
|
125 | (1) |
|
Merging worksheet cells to create additional text space |
|
|
125 | (2) |
|
Displaying text at an angle |
|
|
127 | (1) |
|
|
|
127 | (1) |
|
|
|
128 | (3) |
|
Using Conditional Formatting |
|
|
131 | (12) |
|
Specifying conditional formatting |
|
|
131 | (1) |
|
Using graphical conditional formats |
|
|
131 | (6) |
|
|
|
131 | (2) |
|
|
|
133 | (1) |
|
|
|
134 | (3) |
|
Creating formula-based rules |
|
|
137 | (1) |
|
Understanding relative and absolute references |
|
|
137 | (1) |
|
Conditional formatting formula examples |
|
|
138 | (3) |
|
|
|
139 | (1) |
|
Highlighting a row based on a value |
|
|
139 | (1) |
|
Displaying alternate-row shading |
|
|
140 | (1) |
|
Creating checkerboard shading |
|
|
140 | (1) |
|
|
|
141 | (1) |
|
Working with conditional formats |
|
|
141 | (2) |
|
|
|
142 | (1) |
|
Copying cells that contain conditional formatting |
|
|
142 | (1) |
|
Deleting conditional formatting |
|
|
142 | (1) |
|
Locating cells that contain conditional formatting |
|
|
142 | (1) |
|
Using Named Styles for Easier Formatting |
|
|
143 | (4) |
|
|
|
143 | (1) |
|
Modifying an existing style |
|
|
144 | (1) |
|
|
|
145 | (1) |
|
Merging styles from other workbooks |
|
|
146 | (1) |
|
Controlling styles with templates |
|
|
146 | (1) |
|
Understanding Document Themes |
|
|
147 | (6) |
|
|
|
148 | (1) |
|
|
|
149 | (4) |
|
Chapter 6 Understanding Excel Files and Templates |
|
|
153 | (20) |
|
|
|
153 | (1) |
|
Opening an Existing Workbook |
|
|
154 | (3) |
|
|
|
156 | (1) |
|
Choosing your file display preferences |
|
|
157 | (1) |
|
|
|
157 | (2) |
|
|
|
159 | (2) |
|
Recovering versions of the current workbook |
|
|
159 | (1) |
|
|
|
160 | (1) |
|
|
|
160 | (1) |
|
Password-Protecting a Workbook |
|
|
161 | (1) |
|
|
|
162 | (1) |
|
Other Workbook Info Options |
|
|
162 | (2) |
|
|
|
162 | (1) |
|
|
|
163 | (1) |
|
|
|
163 | (1) |
|
|
|
163 | (1) |
|
Compatibility Mode section |
|
|
164 | (1) |
|
|
|
164 | (1) |
|
|
|
164 | (1) |
|
|
|
165 | (8) |
|
Exploring Excel templates |
|
|
165 | (3) |
|
|
|
165 | (1) |
|
Creating a workbook from a template |
|
|
166 | (2) |
|
|
|
168 | (1) |
|
|
|
168 | (2) |
|
Using the workbook template to change workbook defaults |
|
|
169 | (1) |
|
Creating a worksheet template |
|
|
170 | (1) |
|
|
|
170 | (1) |
|
Resetting the default workbook |
|
|
170 | (1) |
|
Using custom workbook templates |
|
|
170 | (4) |
|
Creating custom templates |
|
|
170 | (1) |
|
Saving your custom templates |
|
|
171 | (1) |
|
|
|
172 | (1) |
|
Chapter 7 Printing Your Work |
|
|
173 | (22) |
|
|
|
173 | (1) |
|
|
|
174 | (4) |
|
|
|
175 | (1) |
|
|
|
175 | (1) |
|
|
|
176 | (2) |
|
Adjusting Common Page Setup Settings |
|
|
178 | (9) |
|
|
|
180 | (1) |
|
Specifying what you want to print |
|
|
180 | (1) |
|
Changing page orientation |
|
|
181 | (1) |
|
|
|
181 | (1) |
|
Printing multiple copies of a report |
|
|
181 | (1) |
|
Adjusting the page margins |
|
|
181 | (2) |
|
Understanding page breaks |
|
|
183 | (1) |
|
|
|
183 | (1) |
|
Removing manual page breaks |
|
|
183 | (1) |
|
Printing row and column titles |
|
|
183 | (2) |
|
|
|
185 | (1) |
|
|
|
185 | (1) |
|
Printing row and column headers |
|
|
185 | (1) |
|
|
|
185 | (2) |
|
Adding a Header or a Footer to Your Reports |
|
|
187 | (3) |
|
Selecting a predefined header or footer |
|
|
188 | (1) |
|
Understanding header and footer element codes |
|
|
189 | (1) |
|
Exploring other header and footer options |
|
|
190 | (1) |
|
Exploring Other Print-Related Topics |
|
|
190 | (5) |
|
Copying Page Setup settings across sheets |
|
|
190 | (1) |
|
Preventing certain cells from being printed |
|
|
191 | (1) |
|
Preventing objects from being printed |
|
|
191 | (1) |
|
Creating custom views of your worksheet |
|
|
192 | (2) |
|
|
|
194 | (1) |
|
Chapter 8 Customizing the Excel User Interface |
|
|
195 | (10) |
|
Customizing the Quick Access Toolbar |
|
|
195 | (6) |
|
About the Quick Access toolbar |
|
|
196 | (1) |
|
Adding new commands to the Quick Access toolbar |
|
|
197 | (2) |
|
Other Quick Access toolbar actions |
|
|
199 | (2) |
|
|
|
201 | (6) |
|
Why you may want to customize the Ribbon |
|
|
201 | (1) |
|
|
|
201 | (1) |
|
How to customize the Ribbon |
|
|
202 | (2) |
|
|
|
202 | (1) |
|
|
|
203 | (1) |
|
Adding commands to a new group |
|
|
203 | (1) |
|
|
|
204 | (1) |
| Part II: Working with Formulas and Functions |
|
205 | (238) |
|
Chapter 9 Introducing Formulas and Functions |
|
|
207 | (32) |
|
Understanding Formula Basics |
|
|
207 | (7) |
|
Using operators in formulas |
|
|
208 | (1) |
|
Understanding operator precedence in formulas |
|
|
209 | (2) |
|
Using functions in your formulas |
|
|
211 | (3) |
|
Examples of formulas that use functions |
|
|
212 | (1) |
|
|
|
213 | (1) |
|
|
|
214 | (1) |
|
Entering Formulas into Your Worksheets |
|
|
214 | (5) |
|
Entering formulas manually |
|
|
216 | (1) |
|
Entering formulas by pointing |
|
|
216 | (1) |
|
Pasting range names into formulas |
|
|
216 | (1) |
|
Inserting functions into formulas |
|
|
217 | (2) |
|
|
|
219 | (1) |
|
|
|
219 | (1) |
|
Using Cell References in Formulas |
|
|
220 | (5) |
|
Using relative, absolute, and mixed references |
|
|
221 | (2) |
|
Changing the types of your references |
|
|
223 | (1) |
|
Referencing cells outside the worksheet |
|
|
223 | (2) |
|
Referencing cells in other worksheets |
|
|
223 | (1) |
|
Referencing cells in other workbooks |
|
|
224 | (1) |
|
|
|
225 | (4) |
|
Summarizing data in a table |
|
|
225 | (2) |
|
Using formulas within a table |
|
|
227 | (1) |
|
Referencing data in a table |
|
|
228 | (1) |
|
Correcting Common Formula Errors |
|
|
229 | (3) |
|
Handling circular references |
|
|
230 | (1) |
|
Specifying when formulas are calculated |
|
|
231 | (1) |
|
Using Advanced Naming Techniques |
|
|
232 | (4) |
|
Using names for constants |
|
|
233 | (1) |
|
|
|
233 | (1) |
|
Using range intersections |
|
|
234 | (2) |
|
Applying names to existing references |
|
|
236 | (1) |
|
|
|
236 | (3) |
|
|
|
236 | (1) |
|
Using the Formula bar as a calculator |
|
|
237 | (1) |
|
Making an exact copy of a formula |
|
|
237 | (1) |
|
Converting formulas to values |
|
|
238 | (1) |
|
Chapter 10 Using Formulas for Common Mathematical Operations |
|
|
239 | (14) |
|
|
|
239 | (8) |
|
Calculating percent of goal |
|
|
239 | (2) |
|
Calculating percent variance |
|
|
241 | (1) |
|
Calculating percent variance with negative values |
|
|
242 | (1) |
|
Calculating a percent distribution |
|
|
243 | (1) |
|
Calculating a running total |
|
|
244 | (1) |
|
Applying a percent increase or decrease to values |
|
|
244 | (1) |
|
Dealing with divide-by-zero errors |
|
|
245 | (2) |
|
|
|
247 | (3) |
|
Rounding numbers using formulas |
|
|
247 | (1) |
|
Rounding to the nearest penny |
|
|
247 | (1) |
|
Rounding to significant digits |
|
|
248 | (2) |
|
Counting Values in a Range |
|
|
250 | (1) |
|
Using Excel's Conversion Functions |
|
|
251 | (2) |
|
Chapter 11 Using Formulas to Manipulate Text |
|
|
253 | (16) |
|
|
|
253 | (1) |
|
|
|
254 | (15) |
|
|
|
254 | (2) |
|
Setting text to sentence case |
|
|
256 | (1) |
|
Removing spaces from a text string |
|
|
257 | (1) |
|
Extracting parts of a text string |
|
|
258 | (1) |
|
Finding a particular character in a text string |
|
|
259 | (2) |
|
Finding the second instance of a character |
|
|
261 | (1) |
|
Substituting text strings |
|
|
262 | (1) |
|
Counting specific characters in a cell |
|
|
263 | (1) |
|
Adding a line break within a formula |
|
|
264 | (1) |
|
Cleaning strange characters from text fields |
|
|
265 | (1) |
|
Padding numbers with zeros |
|
|
266 | (1) |
|
Formatting the numbers in a text string |
|
|
266 | (2) |
|
Using the DOLLAR function |
|
|
268 | (1) |
|
Chapter 12 Using Formulas with Dates and Times |
|
|
269 | (26) |
|
Understanding How Excel Handles Dates and Times |
|
|
269 | (6) |
|
Understanding date serial numbers |
|
|
269 | (3) |
|
|
|
270 | (1) |
|
Understanding time serial numbers |
|
|
271 | (1) |
|
|
|
272 | (1) |
|
Formatting dates and times |
|
|
273 | (1) |
|
|
|
273 | (2) |
|
|
|
274 | (1) |
|
|
|
274 | (1) |
|
Inconsistent date entries |
|
|
275 | (1) |
|
Using Excel's Date and Time Functions |
|
|
275 | (20) |
|
Getting the current date and time |
|
|
275 | (1) |
|
|
|
276 | (1) |
|
Calculating the number of days between two dates |
|
|
277 | (1) |
|
Calculating the number of workdays between two dates |
|
|
277 | (1) |
|
|
|
278 | (1) |
|
Generating a list of business days excluding holidays |
|
|
278 | (2) |
|
Extracting parts of a date |
|
|
280 | (2) |
|
Calculating number of years and months between dates |
|
|
282 | (1) |
|
Converting dates to Julian date formats |
|
|
282 | (2) |
|
Calculating the percent of year completed and remaining |
|
|
284 | (1) |
|
Returning the last date of a given month |
|
|
285 | (1) |
|
Using the EOMONTH function |
|
|
286 | (1) |
|
Calculating the calendar quarter for a date |
|
|
286 | (1) |
|
Calculating the fiscal quarter for a date |
|
|
287 | (1) |
|
Returning a fiscal month from a date |
|
|
288 | (1) |
|
Calculating the date of the Nth weekday of the month |
|
|
289 | (1) |
|
Calculating the date of the last weekday of the month |
|
|
290 | (1) |
|
Extracting parts of a time |
|
|
290 | (1) |
|
|
|
291 | (1) |
|
|
|
292 | (1) |
|
Converting decimal hours, minutes, or seconds to a time |
|
|
293 | (1) |
|
Adding hours, minutes, or seconds to a time |
|
|
294 | (1) |
|
Chapter 13 Using Formulas for Conditional Analysis |
|
|
295 | (20) |
|
Understanding Conditional Analysis |
|
|
295 | (8) |
|
Checking if a simple condition is met |
|
|
295 | (1) |
|
Checking for multiple conditions |
|
|
296 | (2) |
|
Validating conditional data |
|
|
298 | (1) |
|
|
|
298 | (1) |
|
Checking if Condition1 AND Condition2 are met |
|
|
299 | (3) |
|
Referring to logical conditions in cells |
|
|
301 | (1) |
|
Checking if Condition) OR Condition2 are met |
|
|
302 | (1) |
|
Performing Conditional Calculations |
|
|
303 | (12) |
|
Summing all values that meet a certain condition |
|
|
303 | (3) |
|
Summing greater than zero |
|
|
305 | (1) |
|
Summing all values that meet two or more conditions |
|
|
306 | (1) |
|
Summing if values fall between a given date range |
|
|
307 | (2) |
|
|
|
308 | (1) |
|
Getting a count of values that meet a certain condition |
|
|
309 | (1) |
|
Getting a count of values that meet two or more conditions |
|
|
310 | (1) |
|
Finding nonstandard characters |
|
|
311 | (1) |
|
Getting the average of all numbers that meet a certain condition |
|
|
311 | (1) |
|
Getting the average of all numbers that meet two or more conditions |
|
|
312 | (3) |
|
Chapter 14 Using Formulas for Matching and Lookups |
|
|
315 | (18) |
|
Introducing Lookup Formulas |
|
|
315 | (1) |
|
Leveraging Excel's Lookup Functions |
|
|
316 | (17) |
|
Looking up an exact value based on a left lookup column |
|
|
316 | (2) |
|
Looking up an exact value based on any lookup column |
|
|
318 | (2) |
|
Looking up values horizontally |
|
|
320 | (1) |
|
Hiding errors returned by lookup functions |
|
|
321 | (2) |
|
Finding the closest match from a list of banded values |
|
|
323 | (2) |
|
Finding the closest match with the INDEX and MATCH functions |
|
|
324 | (1) |
|
Looking up values from multiple tables |
|
|
325 | (3) |
|
Looking up a value based on a two-way matrix |
|
|
328 | (2) |
|
Using default values for match |
|
|
329 | (1) |
|
Finding a value based on multiple criteria |
|
|
330 | (1) |
|
Returning text with SUMPRODUCT |
|
|
331 | (1) |
|
Finding the last value in a column |
|
|
331 | (2) |
|
Finding the last number using LOOKUP |
|
|
332 | (1) |
|
Chapter 15 Using Formulas for Financial Analysis |
|
|
333 | (32) |
|
Performing Common Business Calculations |
|
|
333 | (10) |
|
Calculating gross profit margin and gross profit margin percent |
|
|
333 | (2) |
|
|
|
334 | (1) |
|
Calculating EBIT and EBITDA |
|
|
335 | (1) |
|
Calculating cost of goods sold |
|
|
336 | (1) |
|
Calculating return on assets |
|
|
337 | (1) |
|
Calculating return on equity |
|
|
337 | (1) |
|
|
|
338 | (2) |
|
Calculating customer churn |
|
|
340 | (1) |
|
Calculating annual churn rate |
|
|
341 | (1) |
|
Calculating average customer lifetime value |
|
|
341 | (1) |
|
Calculating employee turnover |
|
|
342 | (1) |
|
Leveraging Excel's Financial Functions |
|
|
343 | (22) |
|
Converting interest rates |
|
|
343 | (2) |
|
Computing effective rate with FV |
|
|
345 | (1) |
|
Creating a loan payment calculator |
|
|
345 | (3) |
|
Creating an amortization schedule |
|
|
346 | (2) |
|
Creating a variable-rate mortgage amortization schedule |
|
|
348 | (3) |
|
Using dates instead of payment numbers |
|
|
350 | (1) |
|
|
|
351 | (3) |
|
Calculating accelerated depreciation |
|
|
352 | (2) |
|
Calculating present value |
|
|
354 | (2) |
|
Calculating the present value of future payments |
|
|
355 | (1) |
|
Calculating net present value |
|
|
356 | (2) |
|
Calculating positive and negative cash flows |
|
|
357 | (1) |
|
Calculating an internal rate of return |
|
|
358 | (2) |
|
Calculating nonperiodic future cash flows |
|
|
359 | (1) |
|
Performing financial forecasting |
|
|
360 | (5) |
|
Chapter 16 Using Formulas for Statistical Analysis |
|
|
365 | (20) |
|
Working with Weighted Averages |
|
|
365 | (2) |
|
Smoothing Data with Moving Averages |
|
|
367 | (4) |
|
Applying exponential smoothing to volatile data |
|
|
369 | (2) |
|
Using Functions to Create Descriptive Statistics |
|
|
371 | (6) |
|
Getting the largest or smallest value |
|
|
372 | (1) |
|
Getting the Nth largest or smallest value |
|
|
373 | (2) |
|
Calculating mean, median, and mode |
|
|
375 | (2) |
|
Bucketing Data into Percentiles |
|
|
377 | (2) |
|
Identifying Statistical Outliers with an Interquartile Range |
|
|
379 | (4) |
|
Creating a Frequency Distribution |
|
|
383 | (2) |
|
An alternative to the FREQUENCY function |
|
|
384 | (1) |
|
Chapter 17 Using Formulas with Tables and Conditional Formatting |
|
|
385 | (14) |
|
Highlighting Cells That Meet Certain Criteria |
|
|
385 | (4) |
|
Highlighting cells based on the value of another cell |
|
|
387 | (2) |
|
Highlighting Values That Exist in List1 but Not List2 |
|
|
389 | (2) |
|
Highlighting Values That Exist in List1 and List2 |
|
|
391 | (2) |
|
Highlighting Based on Dates |
|
|
393 | (6) |
|
Highlighting days between two dates |
|
|
395 | (2) |
|
Highlighting dates based on a due date |
|
|
397 | (2) |
|
Chapter 18 Understanding and Using Array Formulas |
|
|
399 | (24) |
|
Understanding Array Formulas |
|
|
399 | (4) |
|
A multicell array formula |
|
|
400 | (1) |
|
A single-cell array formula |
|
|
401 | (2) |
|
Creating an Array Constant |
|
|
403 | (1) |
|
Understanding the Dimensions of an Array |
|
|
404 | (3) |
|
One-dimensional horizontal arrays |
|
|
404 | (1) |
|
One-dimensional vertical arrays |
|
|
405 | (1) |
|
|
|
405 | (2) |
|
|
|
407 | (1) |
|
Working with Array Formulas |
|
|
408 | (3) |
|
Entering an array formula |
|
|
408 | (1) |
|
Selecting an array formula range |
|
|
408 | (1) |
|
|
|
409 | (1) |
|
Expanding or contracting a multicell array formula |
|
|
410 | (1) |
|
Using Multicell Array Formulas |
|
|
411 | (5) |
|
Creating an array from values in a range |
|
|
411 | (1) |
|
Creating an array constant from values in a range |
|
|
411 | (1) |
|
Performing operations on an array |
|
|
412 | (1) |
|
Using functions with an array |
|
|
413 | (1) |
|
|
|
414 | (1) |
|
Generating an array of consecutive integers |
|
|
415 | (1) |
|
Using Single-Cell Array Formulas |
|
|
416 | (7) |
|
Counting characters in a range |
|
|
416 | (1) |
|
Summing the three smallest values in a range |
|
|
417 | (1) |
|
Counting text cells in a range |
|
|
418 | (1) |
|
Eliminating intermediate formulas |
|
|
419 | (2) |
|
Using an array instead of a range reference |
|
|
421 | (2) |
|
Chapter 19 Making Your Formulas Error-Free |
|
|
423 | (20) |
|
Finding and Correcting Formula Errors |
|
|
423 | (9) |
|
|
|
424 | (1) |
|
Cells are filled with hash marks |
|
|
425 | (1) |
|
Blank cells are not blank |
|
|
425 | (1) |
|
|
|
426 | (1) |
|
Formulas returning an error |
|
|
426 | (4) |
|
|
|
427 | (1) |
|
|
|
428 | (1) |
|
|
|
428 | (1) |
|
|
|
428 | (1) |
|
|
|
429 | (1) |
|
|
|
429 | (1) |
|
|
|
430 | (1) |
|
Operator precedence problems |
|
|
430 | (1) |
|
Formulas are not calculated |
|
|
431 | (1) |
|
Problems with decimal precision |
|
|
431 | (1) |
|
|
|
432 | (1) |
|
Using Excel Auditing Tools |
|
|
432 | (6) |
|
Identifying cells of a particular type |
|
|
432 | (1) |
|
|
|
433 | (1) |
|
Tracing cell relationships |
|
|
433 | (2) |
|
|
|
434 | (1) |
|
|
|
434 | (1) |
|
|
|
435 | (1) |
|
Fixing circular reference errors |
|
|
435 | (1) |
|
Using the background error-checking feature |
|
|
435 | (1) |
|
|
|
436 | (2) |
|
|
|
438 | (3) |
|
Searching for information |
|
|
438 | (1) |
|
|
|
439 | (1) |
|
|
|
439 | (1) |
|
Spell-checking your worksheets |
|
|
440 | (1) |
|
|
|
441 | (2) |
| Part III: Creating Charts and Other Visualizations |
|
443 | (134) |
|
Chapter 20 Getting Started with Excel Charts |
|
|
445 | (44) |
|
|
|
445 | (8) |
|
|
|
446 | (1) |
|
|
|
447 | (2) |
|
|
|
449 | (1) |
|
|
|
450 | (2) |
|
|
|
452 | (1) |
|
Basic Steps for Creating a Chart |
|
|
453 | (6) |
|
|
|
453 | (1) |
|
Switching the row and column orientation |
|
|
454 | (2) |
|
|
|
456 | (1) |
|
|
|
456 | (1) |
|
|
|
456 | (1) |
|
Adding and deleting chart elements |
|
|
457 | (1) |
|
Formatting chart elements |
|
|
458 | (1) |
|
Modifying and Customizing Charts |
|
|
459 | (5) |
|
Moving and resizing a chart |
|
|
460 | (1) |
|
Converting an embedded chart to a chart sheet |
|
|
460 | (1) |
|
|
|
461 | (1) |
|
|
|
461 | (1) |
|
|
|
461 | (1) |
|
Moving and deleting chart elements |
|
|
462 | (1) |
|
Formatting chart elements |
|
|
462 | (1) |
|
Copying a chart's formatting |
|
|
463 | (1) |
|
|
|
463 | (1) |
|
|
|
464 | (1) |
|
Understanding Chart Types |
|
|
464 | (15) |
|
|
|
465 | (2) |
|
|
|
467 | (2) |
|
|
|
469 | (1) |
|
|
|
469 | (2) |
|
|
|
471 | (3) |
|
|
|
474 | (1) |
|
|
|
474 | (2) |
|
|
|
476 | (1) |
|
|
|
477 | (1) |
|
|
|
477 | (1) |
|
|
|
477 | (2) |
|
New Chart Types for Excel |
|
|
479 | (10) |
|
|
|
479 | (2) |
|
|
|
481 | (1) |
|
|
|
481 | (1) |
|
|
|
482 | (1) |
|
|
|
483 | (1) |
|
|
|
484 | (1) |
|
|
|
484 | (2) |
|
|
|
486 | (3) |
|
Chapter 21 Using Advanced Charting Techniques |
|
|
489 | (34) |
|
|
|
489 | (3) |
|
|
|
490 | (1) |
|
Selecting with the keyboard |
|
|
491 | (1) |
|
Selecting with the Chart Elements control |
|
|
491 | (1) |
|
Exploring the User Interface Choices for Modifying Chart Elements |
|
|
492 | (3) |
|
Using the Format task pane |
|
|
493 | (1) |
|
Using the chart customization buttons |
|
|
494 | (1) |
|
|
|
494 | (1) |
|
|
|
495 | (1) |
|
|
|
495 | (1) |
|
|
|
496 | (1) |
|
Working with Titles in a Chart |
|
|
497 | (1) |
|
|
|
498 | (2) |
|
|
|
500 | (1) |
|
|
|
501 | (8) |
|
|
|
501 | (5) |
|
Modifying the category axis |
|
|
506 | (3) |
|
|
|
509 | (13) |
|
Deleting or hiding a data series |
|
|
510 | (1) |
|
Adding a new data series to a chart |
|
|
510 | (1) |
|
Changing data used by a series |
|
|
511 | (2) |
|
Changing the data range by dragging the range outline |
|
|
511 | (1) |
|
Using the Edit Series dialog box |
|
|
512 | (1) |
|
Editing the Series formula |
|
|
512 | (1) |
|
Displaying data labels in a chart |
|
|
513 | (2) |
|
|
|
515 | (1) |
|
|
|
516 | (1) |
|
|
|
517 | (1) |
|
Creating combination charts |
|
|
518 | (3) |
|
|
|
521 | (1) |
|
|
|
522 | (1) |
|
Chapter 22 Creating Sparkline Graphics |
|
|
523 | (14) |
|
|
|
523 | (2) |
|
|
|
525 | (2) |
|
|
|
527 | (6) |
|
|
|
528 | (1) |
|
Handling hidden or missing data |
|
|
528 | (1) |
|
Changing the Sparkline type |
|
|
529 | (1) |
|
Changing Sparkline colors and line width |
|
|
529 | (1) |
|
Highlighting certain data points |
|
|
529 | (1) |
|
Adjusting Sparkline axis scaling |
|
|
530 | (1) |
|
|
|
531 | (2) |
|
|
|
533 | (2) |
|
|
|
535 | (1) |
|
Displaying a Sparkline for a Dynamic Range |
|
|
535 | (2) |
|
Chapter 23 Visualizing with Custom Number Formats and Shapes |
|
|
537 | (30) |
|
Visualizing with Number Formatting |
|
|
537 | (13) |
|
Doing basic number formatting |
|
|
537 | (3) |
|
Using shortcut keys to format numbers |
|
|
538 | (1) |
|
Using the Format Cells dialog box to format numbers |
|
|
539 | (1) |
|
Getting fancy with custom number formatting |
|
|
540 | (6) |
|
Formatting numbers in thousands and millions |
|
|
542 | (1) |
|
Hiding and suppressing zeros |
|
|
543 | (1) |
|
Applying custom format colors |
|
|
544 | (1) |
|
Formatting dates and times |
|
|
545 | (1) |
|
Using symbols to enhance reporting |
|
|
546 | (4) |
|
Using Shapes and Icons as Visual Elements |
|
|
550 | (11) |
|
|
|
550 | (1) |
|
Inserting SVG icon graphics |
|
|
551 | (1) |
|
Formatting shapes and icons |
|
|
552 | (2) |
|
Enhancing Excel reports with shapes |
|
|
554 | (3) |
|
Creating visually appealing containers with shapes |
|
|
554 | (2) |
|
Layering shapes to save space |
|
|
556 | (1) |
|
Constructing your own infographic widgets with shapes |
|
|
556 | (1) |
|
|
|
557 | (1) |
|
|
|
558 | (3) |
|
Using SmartArt and WordArt |
|
|
561 | (2) |
|
|
|
561 | (1) |
|
|
|
562 | (1) |
|
Working with Other Graphics Types |
|
|
563 | (2) |
|
|
|
563 | (1) |
|
|
|
564 | (1) |
|
Displaying a worksheet background image |
|
|
564 | (1) |
|
Using the Equation Editor |
|
|
565 | (2) |
|
Chapter 24 Implementing Excel Dashboarding Best Practices |
|
|
567 | (10) |
|
Preparing for a Dashboard Project |
|
|
567 | (3) |
|
Establishing the audience and purpose for the dashboard |
|
|
568 | (1) |
|
Delineating the measures for the dashboard |
|
|
568 | (1) |
|
Cataloging the required data sources |
|
|
569 | (1) |
|
Defining the dimensions and filters for the dashboard |
|
|
569 | (1) |
|
Determining the need for drill-down features |
|
|
569 | (1) |
|
Establishing the refresh schedule |
|
|
570 | (1) |
|
Implementing Dashboard Modeling Best Practices |
|
|
570 | (4) |
|
Separating data, analysis, and presentation |
|
|
570 | (1) |
|
Starting with appropriately structured data |
|
|
571 | (1) |
|
Spreadsheet reports make for ineffective data models |
|
|
571 | (1) |
|
Flat data files lend themselves nicely to data models |
|
|
572 | (1) |
|
Avoiding turning your data model into a database |
|
|
572 | (1) |
|
Documenting and organizing your data model |
|
|
573 | (1) |
|
Implementing Dashboard Design Best Practices |
|
|
574 | (5) |
|
|
|
574 | (1) |
|
Don't turn your dashboard into a data repository |
|
|
574 | (1) |
|
Avoid the fancy formatting |
|
|
575 | (1) |
|
Limit each dashboard to one printable page |
|
|
575 | (1) |
|
Format numbers effectively |
|
|
576 | (1) |
|
Use titles and labels effectively |
|
|
576 | (1) |
| Part IV: Managing and Analyzing Data |
|
577 | (204) |
|
Chapter 25 Importing and Cleaning Data |
|
|
579 | (34) |
|
|
|
579 | (8) |
|
|
|
580 | (2) |
|
|
|
580 | (1) |
|
|
|
580 | (1) |
|
|
|
581 | (1) |
|
|
|
582 | (1) |
|
|
|
582 | (1) |
|
|
|
582 | (1) |
|
|
|
583 | (4) |
|
|
|
587 | (1) |
|
|
|
587 | (23) |
|
|
|
587 | (2) |
|
Identifying duplicate rows |
|
|
589 | (1) |
|
|
|
589 | (6) |
|
|
|
591 | (1) |
|
|
|
592 | (3) |
|
Changing the case of text |
|
|
595 | (1) |
|
|
|
596 | (1) |
|
Removing strange characters |
|
|
597 | (1) |
|
|
|
597 | (1) |
|
|
|
598 | (1) |
|
|
|
599 | (1) |
|
|
|
600 | (1) |
|
|
|
601 | (1) |
|
Extracting a filename from a URL |
|
|
601 | (1) |
|
|
|
601 | (2) |
|
Changing vertical data to horizontal data |
|
|
603 | (3) |
|
Filling gaps in an imported report |
|
|
606 | (1) |
|
|
|
607 | (1) |
|
Replacing or removing text in cells |
|
|
607 | (1) |
|
|
|
608 | (1) |
|
Fixing trailing minus signs |
|
|
609 | (1) |
|
Following a data cleaning checklist |
|
|
609 | (1) |
|
|
|
610 | (3) |
|
|
|
610 | (1) |
|
|
|
610 | (1) |
|
|
|
610 | (1) |
|
|
|
611 | (1) |
|
Exporting to other file formats |
|
|
611 | (2) |
|
Chapter 26 Using Data Validation |
|
|
613 | (14) |
|
|
|
613 | (1) |
|
Specifying Validation Criteria |
|
|
614 | (1) |
|
Types of Validation Criteria You Can Apply |
|
|
615 | (2) |
|
Creating a Drop-Down List |
|
|
617 | (2) |
|
Using Formulas for Data Validation Rules |
|
|
619 | (1) |
|
Understanding Cell References |
|
|
619 | (2) |
|
Data Validation Formula Examples |
|
|
621 | (4) |
|
|
|
621 | (1) |
|
Accepting a larger value than the previous cell |
|
|
621 | (1) |
|
Accepting nonduplicate entries only |
|
|
622 | (1) |
|
Accepting text that begins with a specific character |
|
|
623 | (1) |
|
Accepting dates by the day of the week |
|
|
623 | (1) |
|
Accepting only values that don't exceed a total |
|
|
623 | (1) |
|
Creating a dependent list |
|
|
623 | (2) |
|
Using Data Validation without Restricting Entry |
|
|
625 | (2) |
|
|
|
625 | (1) |
|
|
|
626 | (1) |
|
Chapter 27 Creating and Using Worksheet Outlines |
|
|
627 | (10) |
|
Introducing Worksheet Outlines |
|
|
627 | (4) |
|
|
|
631 | (3) |
|
|
|
631 | (1) |
|
Creating an outline automatically |
|
|
632 | (1) |
|
Creating an outline manually |
|
|
632 | (2) |
|
|
|
634 | (3) |
|
|
|
634 | (1) |
|
Adding data to an outline |
|
|
635 | (1) |
|
|
|
635 | (1) |
|
Adjusting the outline symbols |
|
|
635 | (1) |
|
Hiding the outline symbols |
|
|
636 | (1) |
|
Chapter 28 Linking and Consolidating Worksheets |
|
|
637 | (18) |
|
|
|
637 | (1) |
|
Creating External Reference Formulas |
|
|
638 | (2) |
|
Understanding link formula syntax |
|
|
638 | (1) |
|
Creating a link formula by pointing |
|
|
639 | (1) |
|
|
|
640 | (1) |
|
Working with External Reference Formulas |
|
|
640 | (4) |
|
Creating links to unsaved workbooks |
|
|
640 | (1) |
|
Opening a workbook with external reference formulas |
|
|
641 | (1) |
|
Changing the startup prompt |
|
|
642 | (1) |
|
|
|
643 | (1) |
|
|
|
643 | (1) |
|
|
|
643 | (1) |
|
Avoiding Potential Problems with External Reference Formulas |
|
|
644 | (2) |
|
Renaming or moving a source workbook |
|
|
644 | (1) |
|
Using the Save As command |
|
|
644 | (1) |
|
Modifying a source workbook |
|
|
644 | (2) |
|
|
|
646 | (1) |
|
|
|
646 | (9) |
|
Consolidating worksheets by using formulas |
|
|
647 | (1) |
|
Consolidating worksheets by using Paste Special |
|
|
648 | (1) |
|
Consolidating worksheets by using the Consolidate dialog box |
|
|
649 | (1) |
|
Viewing a workbook consolidation example |
|
|
650 | (3) |
|
Refreshing a consolidation |
|
|
653 | (1) |
|
Learning more about consolidation |
|
|
654 | (1) |
|
Chapter 29 Introducing PivotTables |
|
|
655 | (24) |
|
|
|
655 | (7) |
|
|
|
656 | (3) |
|
Data appropriate for a PivotTable |
|
|
659 | (3) |
|
Creating a PivotTable Automatically |
|
|
662 | (1) |
|
Creating a PivotTable Manually |
|
|
663 | (9) |
|
|
|
663 | (1) |
|
Specifying the location for the PivotTable |
|
|
664 | (1) |
|
Laying out the PivotTable |
|
|
664 | (4) |
|
Formatting the PivotTable |
|
|
668 | (2) |
|
|
|
670 | (2) |
|
Seeing More PivotTable Examples |
|
|
672 | (5) |
|
What is the daily total new deposit amount for each branch? |
|
|
672 | (1) |
|
Which day of the week accounts for the most deposits? |
|
|
672 | (2) |
|
How many accounts were opened at each branch, broken down by account type? |
|
|
674 | (1) |
|
How much money was used to open the accounts? |
|
|
674 | (1) |
|
What types of accounts do tellers open most often? |
|
|
675 | (1) |
|
In which branch do tellers open the most checking accounts for new customers? |
|
|
676 | (1) |
|
|
|
677 | (2) |
|
Chapter 30 Analyzing Data with PivotTables |
|
|
679 | (36) |
|
Working with Non-numeric Data |
|
|
679 | (2) |
|
Grouping PivotTable Items |
|
|
681 | (8) |
|
A manual grouping example |
|
|
681 | (2) |
|
Automatic grouping examples |
|
|
683 | (8) |
|
|
|
683 | (5) |
|
|
|
688 | (1) |
|
Using a PivotTable to Create a Frequency Distribution |
|
|
689 | (2) |
|
Creating a Calculated Field or Calculated Item |
|
|
691 | (7) |
|
Creating a calculated field |
|
|
693 | (2) |
|
Inserting a calculated item |
|
|
695 | (3) |
|
Filtering PivotTables with Slicers |
|
|
698 | (2) |
|
Filtering PivotTables with a Timeline |
|
|
700 | (1) |
|
Referencing Cells within a PivotTable |
|
|
701 | (2) |
|
|
|
703 | (4) |
|
|
|
703 | (3) |
|
|
|
706 | (1) |
|
|
|
707 | (8) |
|
Chapter 31 Performing Spreadsheet What-If Analysis |
|
|
715 | (18) |
|
Looking at a What-If Example |
|
|
715 | (2) |
|
Exploring Types of What-If Analyses |
|
|
717 | (16) |
|
Performing manual what-if analysis |
|
|
717 | (1) |
|
|
|
717 | (8) |
|
Creating a one-input data table |
|
|
718 | (3) |
|
Creating a two-input data table |
|
|
721 | (4) |
|
|
|
725 | (9) |
|
|
|
725 | (3) |
|
|
|
728 | (1) |
|
|
|
729 | (1) |
|
|
|
729 | (1) |
|
Generating a scenario report |
|
|
730 | (3) |
|
Chapter 32 Analyzing Data Using Goal Seeking and Solver |
|
|
733 | (22) |
|
Exploring What-If Analysis, in Reverse |
|
|
733 | (1) |
|
Using Single-Cell Goal Seeking |
|
|
734 | (3) |
|
Looking at a goal-seeking example |
|
|
734 | (2) |
|
Learning more about goal seeking |
|
|
736 | (1) |
|
|
|
737 | (7) |
|
Looking at appropriate problems for Solver |
|
|
737 | (1) |
|
Seeing a simple Solver example |
|
|
738 | (5) |
|
|
|
743 | (1) |
|
Seeing Some Solver Examples |
|
|
744 | (11) |
|
Solving simultaneous linear equations |
|
|
745 | (2) |
|
Minimizing shipping costs |
|
|
747 | (3) |
|
|
|
750 | (1) |
|
Optimizing an investment portfolio |
|
|
751 | (4) |
|
Chapter 33 Analyzing Data with the Analysis ToolPak |
|
|
755 | (14) |
|
The Analysis ToolPak: An Overview |
|
|
755 | (1) |
|
Installing the Analysis ToolPak Add-In |
|
|
756 | (1) |
|
|
|
756 | (1) |
|
Introducing the Analysis ToolPak Tools |
|
|
757 | (12) |
|
|
|
757 | (1) |
|
|
|
758 | (1) |
|
|
|
759 | (1) |
|
|
|
759 | (1) |
|
|
|
759 | (1) |
|
F-test (two-sample test for variance) |
|
|
760 | (1) |
|
|
|
760 | (1) |
|
|
|
761 | (1) |
|
|
|
761 | (2) |
|
|
|
763 | (2) |
|
|
|
765 | (1) |
|
|
|
765 | (1) |
|
|
|
766 | (1) |
|
|
|
766 | (1) |
|
Z-test (two-sample test for means) |
|
|
767 | (2) |
|
Chapter 34 Protecting Your Work |
|
|
769 | (12) |
|
|
|
769 | (1) |
|
|
|
770 | (4) |
|
|
|
770 | (2) |
|
|
|
772 | (1) |
|
Assigning user permissions |
|
|
773 | (1) |
|
|
|
774 | (3) |
|
Requiring a password to open a workbook |
|
|
774 | (2) |
|
Protecting a workbook's structure |
|
|
776 | (1) |
|
|
|
777 | (1) |
|
|
|
778 | (5) |
|
Saving a worksheet as a PDF file |
|
|
778 | (1) |
|
Marking a workbook as final |
|
|
778 | (1) |
|
|
|
779 | (1) |
|
Using a digital signature |
|
|
780 | (3) |
|
|
|
780 | (1) |
|
|
|
780 | (1) |
| Part V: Understanding Power Pivot and Power Query |
|
781 | (134) |
|
Chapter 35 Introducing Power Pivot |
|
|
783 | (24) |
|
Understanding the Power Pivot Internal Data Model |
|
|
783 | (10) |
|
Activating the Power Pivot Ribbon |
|
|
783 | (2) |
|
Linking Excel tables to Power Pivot |
|
|
785 | (8) |
|
Preparing your Excel tables |
|
|
786 | (1) |
|
Adding your Excel tables to the data model |
|
|
787 | (1) |
|
Creating relationships between your Power Pivot tables |
|
|
788 | (2) |
|
Managing existing relationships |
|
|
790 | (2) |
|
Using Power Pivot data in reporting |
|
|
792 | (1) |
|
Loading Data from Other Data Sources |
|
|
793 | (14) |
|
Loading data from relational databases |
|
|
793 | (5) |
|
Loading data from SQL Server |
|
|
793 | (4) |
|
Loading data from other relational database systems |
|
|
797 | (1) |
|
Loading data from flat files |
|
|
798 | (5) |
|
Loading data from external Excel files |
|
|
798 | (2) |
|
Loading data from text files |
|
|
800 | (1) |
|
Loading data from the clipboard |
|
|
801 | (2) |
|
Refreshing and managing external data connections |
|
|
803 | (14) |
|
Manually refreshing your Power Pivot data |
|
|
803 | (1) |
|
Setting up automatic refreshing |
|
|
803 | (2) |
|
Editing your data connection |
|
|
805 | (2) |
|
Chapter 36 Working Directly with the Internal Data Model |
|
|
807 | (10) |
|
Directly Feeding the Internal Data Model |
|
|
807 | (6) |
|
Managing Relationships in the Internal Data Model |
|
|
813 | (1) |
|
Removing a Table from the Internal Data Model |
|
|
814 | (3) |
|
Chapter 37 Adding Formulas to Power Pivot |
|
|
817 | (18) |
|
Enhancing Power Pivot Data with Calculated Columns |
|
|
817 | (18) |
|
Creating your first calculated column |
|
|
818 | (1) |
|
Formatting your calculated columns |
|
|
819 | (1) |
|
Referencing calculated columns in other calculations |
|
|
820 | (1) |
|
Hiding calculated columns from end users |
|
|
821 | (1) |
|
Utilizing DAX to Create Calculated Columns |
|
|
822 | (7) |
|
Identifying DAX functions safe for calculated columns |
|
|
822 | (2) |
|
Building DAX-driven calculated columns |
|
|
824 | (2) |
|
Month sorting in Power Pivot-driven PivotTables |
|
|
826 | (1) |
|
Referencing fields from other tables |
|
|
827 | (2) |
|
|
|
829 | (1) |
|
Understanding Calculated Measures |
|
|
829 | (4) |
|
Editing and deleting calculated measures |
|
|
832 | (1) |
|
Using Cube Functions to Free Your Data |
|
|
833 | (2) |
|
Chapter 38 Introducing Power Query |
|
|
835 | (24) |
|
Understanding Power Query Basics |
|
|
835 | (16) |
|
Understanding query steps |
|
|
842 | (2) |
|
Viewing the Advanced Query Editor |
|
|
844 | (1) |
|
Refreshing Power Query data |
|
|
844 | (1) |
|
Managing existing queries |
|
|
845 | (1) |
|
Understanding column-level actions |
|
|
846 | (3) |
|
Understanding table actions |
|
|
849 | (2) |
|
Getting Data from External Sources |
|
|
851 | (4) |
|
Importing data from files |
|
|
852 | (3) |
|
Getting data from Excel workbooks |
|
|
852 | (1) |
|
Getting data from CSV and text files |
|
|
853 | (2) |
|
Importing data from database systems |
|
|
855 | (1) |
|
Importing data from relational and OLAP databases |
|
|
855 | (1) |
|
Importing data from Azure databases |
|
|
855 | (1) |
|
Importing data using ODBC connections to nonstandard databases |
|
|
855 | (1) |
|
Getting Data from Other Data Systems |
|
|
855 | (1) |
|
Managing Data Source Settings |
|
|
856 | (3) |
|
Editing data source settings |
|
|
857 | (2) |
|
Chapter 39 Transforming Data with Power Query |
|
|
859 | (28) |
|
Performing Common Transformation Tasks |
|
|
859 | (18) |
|
Removing duplicate records |
|
|
859 | (3) |
|
|
|
862 | (1) |
|
|
|
862 | (1) |
|
|
|
863 | (2) |
|
|
|
865 | (1) |
|
Finding and replacing specific text |
|
|
865 | (1) |
|
Trimming and cleaning text |
|
|
866 | (2) |
|
Extracting the left, right, and middle values |
|
|
868 | (1) |
|
Extracting first and last characters |
|
|
869 | (1) |
|
Extracting middle characters |
|
|
870 | (1) |
|
Splitting columns using character markers |
|
|
870 | (3) |
|
|
|
873 | (1) |
|
|
|
874 | (1) |
|
|
|
875 | (2) |
|
|
|
877 | (7) |
|
Concatenating with a custom column |
|
|
878 | (1) |
|
Understanding data type conversions |
|
|
879 | (2) |
|
Spicing up custom columns with functions |
|
|
881 | (2) |
|
Adding conditional logic to custom columns |
|
|
883 | (1) |
|
Grouping and Aggregating Data |
|
|
884 | (3) |
|
Chapter 40 Making Queries Work Together |
|
|
887 | (16) |
|
|
|
887 | (4) |
|
Understanding the Append Feature |
|
|
891 | (5) |
|
Creating the needed base queries |
|
|
892 | (1) |
|
|
|
893 | (3) |
|
Understanding the Merge Feature |
|
|
896 | (7) |
|
Understanding Power Query joins |
|
|
896 | (1) |
|
|
|
897 | (6) |
|
Chapter 41 Enhancing Power Query Productivity |
|
|
903 | (12) |
|
Implementing Some Power Query Productivity Tips |
|
|
903 | (7) |
|
Getting quick information about your queries |
|
|
903 | (1) |
|
Organizing queries in groups |
|
|
904 | (2) |
|
Selecting columns in your queries faster |
|
|
906 | (1) |
|
|
|
906 | (1) |
|
Quickly creating reference tables |
|
|
907 | (1) |
|
Copying queries to save time |
|
|
908 | (1) |
|
Setting a default load behavior |
|
|
908 | (1) |
|
Preventing automatic data type changes |
|
|
909 | (1) |
|
Avoiding Power Query Performance Issues |
|
|
910 | (7) |
|
Using views instead of tables |
|
|
910 | (1) |
|
Letting your back-end database servers do some crunching |
|
|
911 | (1) |
|
Upgrading to 64-bit Excel |
|
|
911 | (1) |
|
Disabling privacy settings to improve performance |
|
|
912 | (1) |
|
Disabling relationship detection |
|
|
912 | (3) |
| Part VI: Automating Excel |
|
915 | (122) |
|
Chapter 42 Introducing Visual Basic for Applications |
|
|
917 | (30) |
|
|
|
917 | (1) |
|
Displaying the Developer Tab |
|
|
918 | (1) |
|
Learning about Macro Security |
|
|
919 | (1) |
|
Saving Workbooks That Contain Macros |
|
|
920 | (1) |
|
Looking at the Two Types of VBA Macros |
|
|
921 | (3) |
|
|
|
921 | (1) |
|
|
|
922 | (2) |
|
|
|
924 | (1) |
|
|
|
924 | (9) |
|
Recording your actions to create VBA code: the basics |
|
|
925 | (1) |
|
Recording a macro: a simple example |
|
|
926 | (1) |
|
|
|
926 | (2) |
|
|
|
928 | (1) |
|
|
|
928 | (1) |
|
Absolute versus relative recording |
|
|
929 | (1) |
|
|
|
929 | (1) |
|
|
|
930 | (1) |
|
|
|
930 | (1) |
|
|
|
931 | (1) |
|
|
|
932 | (1) |
|
More about recording VBA macros |
|
|
933 | (2) |
|
Storing macros in your Personal Macro Workbook |
|
|
933 | (1) |
|
Assigning a macro to a shortcut key |
|
|
933 | (1) |
|
Assigning a macro to a button |
|
|
934 | (1) |
|
Adding a macro to your Quick Access toolbar |
|
|
935 | (1) |
|
|
|
935 | (10) |
|
The basics: entering and editing code |
|
|
936 | (1) |
|
|
|
937 | (1) |
|
|
|
937 | (1) |
|
|
|
938 | (1) |
|
|
|
939 | (1) |
|
|
|
940 | (1) |
|
|
|
941 | (1) |
|
|
|
941 | (3) |
|
A macro that can't be recorded |
|
|
944 | (1) |
|
|
|
945 | (2) |
|
Chapter 43 Creating Custom Worksheet Functions |
|
|
947 | (14) |
|
Introducing VBA Functions |
|
|
947 | (1) |
|
|
|
948 | (2) |
|
Creating a custom function |
|
|
948 | (1) |
|
Using the function in a worksheet |
|
|
949 | (1) |
|
Analyzing the custom function |
|
|
949 | (1) |
|
Learning about Function Procedures |
|
|
950 | (2) |
|
Executing Function Procedures |
|
|
952 | (1) |
|
Calling custom functions from a procedure |
|
|
952 | (1) |
|
Using custom functions in a worksheet formula |
|
|
952 | (1) |
|
Using Function Procedure Arguments |
|
|
953 | (5) |
|
Creating a function with no arguments |
|
|
953 | (1) |
|
Creating a function with one argument |
|
|
954 | (1) |
|
Creating another function with one argument |
|
|
954 | (2) |
|
Creating a function with two arguments |
|
|
956 | (1) |
|
Creating a function with a range argument |
|
|
956 | (1) |
|
Creating a simple but useful function |
|
|
957 | (1) |
|
Debugging Custom Functions |
|
|
958 | (1) |
|
Inserting Custom Functions |
|
|
958 | (2) |
|
|
|
960 | (1) |
|
Chapter 44 Creating UserForms |
|
|
961 | (22) |
|
Understanding Why to Create UserForms |
|
|
961 | (1) |
|
Exploring UserForm Alternatives |
|
|
962 | (4) |
|
Using the InputBox function |
|
|
962 | (1) |
|
Using the MsgBox function |
|
|
963 | (3) |
|
Creating UserForms: An Overview |
|
|
966 | (5) |
|
|
|
967 | (1) |
|
|
|
968 | (1) |
|
Changing the properties of a control |
|
|
969 | (1) |
|
|
|
970 | (1) |
|
|
|
970 | (1) |
|
Looking at a UserForm Example |
|
|
971 | (3) |
|
|
|
971 | (1) |
|
|
|
972 | (1) |
|
Creating an event handler procedure |
|
|
973 | (1) |
|
Looking at Another UserForm Example |
|
|
974 | (6) |
|
|
|
974 | (2) |
|
Creating event handler procedures |
|
|
976 | (2) |
|
|
|
978 | (1) |
|
|
|
978 | (1) |
|
Making the macro available from a worksheet button |
|
|
979 | (1) |
|
Making the macro available on your Quick Access toolbar |
|
|
979 | (1) |
|
|
|
980 | (1) |
|
|
|
980 | (1) |
|
|
|
980 | (1) |
|
|
|
981 | (2) |
|
Chapter 45 Using UserForm Controls in a Worksheet |
|
|
983 | (14) |
|
Understanding Why to Use Controls on a Worksheet |
|
|
983 | (3) |
|
|
|
986 | (5) |
|
|
|
986 | (1) |
|
Learning about Design mode |
|
|
986 | (1) |
|
|
|
987 | (1) |
|
|
|
988 | (1) |
|
Linking controls to cells |
|
|
989 | (1) |
|
Creating macros for controls |
|
|
989 | (2) |
|
Reviewing the Available ActiveX Controls |
|
|
991 | (6) |
|
|
|
991 | (1) |
|
|
|
991 | (1) |
|
|
|
992 | (1) |
|
|
|
992 | (1) |
|
|
|
992 | (1) |
|
|
|
993 | (1) |
|
|
|
993 | (1) |
|
|
|
994 | (1) |
|
|
|
995 | (1) |
|
|
|
995 | (1) |
|
|
|
996 | (1) |
|
Chapter 46 Working with Excel Events |
|
|
997 | (14) |
|
|
|
997 | (1) |
|
Entering Event-Handler VBA Code |
|
|
998 | (1) |
|
Using Workbook-Level Events |
|
|
999 | (4) |
|
|
|
1000 | (1) |
|
Using the SheetActivate event |
|
|
1001 | (1) |
|
|
|
1002 | (1) |
|
Using the BeforeSave event |
|
|
1002 | (1) |
|
Using the BeforeClose event |
|
|
1002 | (1) |
|
Working with Worksheet Events |
|
|
1003 | (3) |
|
|
|
1003 | (1) |
|
Monitoring a specific range for changes |
|
|
1004 | (1) |
|
Using the SelectionChange event |
|
|
1005 | (1) |
|
Using the BeforeRightClick event |
|
|
1006 | (1) |
|
Using Special Application Events |
|
|
1006 | (5) |
|
|
|
1007 | (1) |
|
|
|
1008 | (3) |
|
Chapter 47 Seeing Some VBA Examples |
|
|
1011 | (16) |
|
|
|
1011 | (9) |
|
|
|
1012 | (1) |
|
Copying a variable-size range |
|
|
1013 | (1) |
|
Selecting to the end of a row or column |
|
|
1014 | (1) |
|
Selecting a row or column |
|
|
1014 | (1) |
|
|
|
1015 | (1) |
|
Looping through a range efficiently |
|
|
1015 | (1) |
|
Prompting for a cell value |
|
|
1016 | (2) |
|
Determining the type of selection |
|
|
1018 | (1) |
|
Identifying a multiple selection |
|
|
1018 | (1) |
|
|
|
1019 | (1) |
|
|
|
1020 | (1) |
|
|
|
1020 | (1) |
|
Saving and closing all workbooks |
|
|
1020 | (1) |
|
|
|
1021 | (2) |
|
|
|
1021 | (1) |
|
Modifying chart properties |
|
|
1022 | (1) |
|
Applying chart formatting |
|
|
1022 | (1) |
|
|
|
1023 | (4) |
|
Turning off screen updating |
|
|
1023 | (1) |
|
Preventing alert messages |
|
|
1023 | (1) |
|
Simplifying object references |
|
|
1024 | (1) |
|
|
|
1024 | (3) |
|
Chapter 48 Creating Custom Excel Add-Ins |
|
|
1027 | |
|
|
|
1027 | (1) |
|
|
|
1028 | (1) |
|
Understanding Why to Create Add-Ins |
|
|
1029 | (1) |
|
|
|
1030 | (1) |
|
Looking at an Add-In Example |
|
|
1031 | (6) |
|
|
|
1032 | (1) |
|
Learning about the UserForm |
|
|
1032 | (1) |
|
|
|
1032 | (1) |
|
Adding descriptive information |
|
|
1033 | (1) |
|
Creating the user interface for your add-in macro |
|
|
1034 | (1) |
|
|
|
1034 | (1) |
|
|
|
1035 | (1) |
|
|
|
1035 | (2) |
| Index |
|
1037 | |
| 9781138281981 |
|
| Preface |
|
xii | |
| Acknowledgments |
|
xii | |
| 1 Sports in Early America |
|
1 | (16) |
|
The North American Ball Game |
|
|
4 | (1) |
|
The Mesoamerican Ball Game |
|
|
4 | (1) |
|
European Sporting Traditions |
|
|
5 | (2) |
|
European Sport in the Americas |
|
|
7 | (1) |
|
Sport in the Southern British Colonies |
|
|
7 | (2) |
|
|
|
9 | (1) |
|
|
|
9 | (1) |
|
"Lawful Sport" in New England and the Middle Colonies |
|
|
10 | (2) |
|
|
|
12 | (1) |
|
The Great Awakening and Republican Ideology |
|
|
13 | (1) |
|
|
|
14 | (1) |
|
Critical Thinking Questions |
|
|
15 | (1) |
|
|
|
15 | (2) |
| 2 The Setting for Nineteenth-Century Sports |
|
17 | (14) |
|
Conquering Space and Time |
|
|
19 | (1) |
|
Sidebar: Rules and Their Meanings |
|
|
20 | (1) |
|
The Rise of Middle-Class Victorian Culture |
|
|
21 | (1) |
|
|
|
22 | (1) |
|
Alternatives and Opposition |
|
|
23 | (2) |
|
|
|
25 | (1) |
|
|
|
25 | (1) |
|
|
|
26 | (1) |
|
Sports Moves to the Center |
|
|
26 | (1) |
|
|
|
27 | (1) |
|
|
|
28 | (1) |
|
Critical Thinking Questions |
|
|
28 | (1) |
|
|
|
28 | (3) |
| 3 The Sporting Fraternity and Its Spectacles |
|
31 | (13) |
|
|
|
33 | (1) |
|
John Cox Stevens: Wealthy Sporting Patron |
|
|
34 | (1) |
|
|
|
35 | (1) |
|
The Early History of American Prizefighting |
|
|
36 | (1) |
|
Meanings of Prizefighting |
|
|
37 | (1) |
|
Prizefighting in the Postbellum Era |
|
|
38 | (2) |
|
Sidebar: Prizefighting Moves West |
|
|
40 | (1) |
|
|
|
41 | (1) |
|
|
|
42 | (1) |
|
Critical Thinking Questions |
|
|
42 | (1) |
|
|
|
43 | (1) |
| 4 The Rise of America's National Game |
|
44 | (14) |
|
The Club-Based Fraternal Game |
|
|
45 | (3) |
|
|
|
48 | (1) |
|
Baseball as a Commercial Enterprise |
|
|
48 | (3) |
|
|
|
51 | (1) |
|
|
|
52 | (1) |
|
Between the Foul Lines and in the Stands |
|
|
53 | (2) |
|
|
|
55 | (1) |
|
|
|
56 | (1) |
|
Critical Thinking Questions |
|
|
56 | (1) |
|
|
|
56 | (2) |
| 5 Elite Sports |
|
58 | (13) |
|
Sports and the Forging of an American Upper Class |
|
|
60 | (1) |
|
The Wealthy New York Sporting Community |
|
|
60 | (2) |
|
Thoroughbred Horse Racing |
|
|
62 | (1) |
|
|
|
63 | (2) |
|
Sidebar: Caledonian Clubs |
|
|
65 | (1) |
|
|
|
65 | (2) |
|
Cricket Clubs and Country Clubs |
|
|
67 | (2) |
|
|
|
69 | (1) |
|
Critical Thinking Questions |
|
|
69 | (1) |
|
|
|
69 | (2) |
| 6 The Rise of Intercollegiate Sports |
|
71 | (14) |
|
Rowing:The First Intercollegiate Sport |
|
|
73 | (1) |
|
|
|
73 | (1) |
|
Walter Camp: Father of American Football |
|
|
74 | (2) |
|
Football and the Strenuous Life |
|
|
76 | (2) |
|
Sidebar:The Perfect Body of Eugen Sandow |
|
|
78 | (1) |
|
Football and the Making of College Communities |
|
|
79 | (2) |
|
Football as a Sporting Spectacle |
|
|
81 | (2) |
|
|
|
83 | (1) |
|
Critical Thinking Questions |
|
|
83 | (1) |
|
|
|
83 | (2) |
| 7 Broader Horizons |
|
85 | (15) |
|
|
|
87 | (1) |
|
Sidebar:The Misuse of "Science" |
|
|
88 | (1) |
|
Doors Close on African American Athletes |
|
|
89 | (3) |
|
|
|
92 | (3) |
|
|
|
95 | (2) |
|
|
|
97 | (1) |
|
Critical Thinking Questions |
|
|
98 | (1) |
|
|
|
98 | (2) |
| 8 Sports, Culture, and Nation: 1900-1945 |
|
100 | (13) |
|
|
|
102 | (1) |
|
|
|
103 | (1) |
|
|
|
104 | (1) |
|
Consumer Culture and a New Middle Class |
|
|
105 | (2) |
|
Flappers and Female Athletes |
|
|
107 | (1) |
|
Race and International Competition |
|
|
108 | (1) |
|
|
|
109 | (1) |
|
The Challenge of Amateurism |
|
|
109 | (1) |
|
|
|
110 | (1) |
|
Critical Thinking Questions |
|
|
110 | (1) |
|
|
|
111 | (2) |
| 9 The Rise of Organized Youth Sports |
|
113 | (13) |
|
|
|
116 | (2) |
|
Sidebar: Industrial Teams |
|
|
118 | (1) |
|
The Evolutionary Theory of Play |
|
|
119 | (1) |
|
The Public Schools Athletic League |
|
|
120 | (1) |
|
|
|
121 | (1) |
|
Public High School Sports |
|
|
122 | (1) |
|
|
|
123 | (1) |
|
Critical Thinking Questions |
|
|
124 | (1) |
|
|
|
124 | (2) |
| 10 The Age of Sports Heroes |
|
126 | (16) |
|
Jack Johnson: Smashing Race Stereotypes |
|
|
128 | (3) |
|
Sidebar: Jack Johnson's Worldwide Reach |
|
|
131 | (1) |
|
Babe Ruth: Extraordinary Success |
|
|
131 | (2) |
|
Jack Dempsey and Tex Rickard: Charisma and Ballyhoo |
|
|
133 | (4) |
|
Helen Wills: "The American Girl" |
|
|
137 | (2) |
|
|
|
139 | (1) |
|
Critical Thinking Questions |
|
|
139 | (1) |
|
|
|
140 | (2) |
| 11 Baseball's Golden Age |
|
142 | (14) |
|
|
|
143 | (2) |
|
|
|
145 | (1) |
|
|
|
146 | (1) |
|
|
|
147 | (1) |
|
The Black Sox Scandal and the Reign of Kenesaw Mountain Landis |
|
|
148 | (2) |
|
Sidebar:The Enduring Appeal of the Black Sox |
|
|
150 | (1) |
|
|
|
151 | (1) |
|
|
|
152 | (1) |
|
U.S.-Caribbean Connections |
|
|
152 | (1) |
|
|
|
153 | (1) |
|
|
|
154 | (1) |
|
Critical Thinking Questions |
|
|
154 | (1) |
|
|
|
154 | (2) |
| 12 The Intercollegiate Football Spectacle |
|
156 | (13) |
|
|
|
158 | (1) |
|
The Formation of Conferences |
|
|
159 | (1) |
|
|
|
160 | (3) |
|
The Football Coach as Hero |
|
|
163 | (1) |
|
Incomplete Democratization |
|
|
164 | (1) |
|
Sidebar: Football and Segregation |
|
|
165 | (1) |
|
|
|
165 | (1) |
|
|
|
166 | (1) |
|
Critical Thinking Questions |
|
|
167 | (1) |
|
|
|
167 | (2) |
| 13 The Rise and Decline of Organized Women's Sports |
|
169 | (13) |
|
Babe Didrikson:Triumph and Struggle |
|
|
171 | (1) |
|
Hazel Walker: Creating Professional Opportunities |
|
|
172 | (1) |
|
Historically Black Colleges Nurture Female Athletes |
|
|
173 | (2) |
|
|
|
175 | (1) |
|
A War Over Turf and Principles |
|
|
176 | (2) |
|
Sidebar: Lesbian Softball |
|
|
178 | (1) |
|
|
|
178 | (1) |
|
|
|
179 | (1) |
|
Critical Thinking Questions |
|
|
180 | (1) |
|
|
|
180 | (2) |
| 14 Globalizing Sports, Redefining Race |
|
182 | (11) |
|
|
|
184 | (1) |
|
Jim Thorpe: American Olympic Legend |
|
|
184 | (2) |
|
The Olympics as Civic Showcase |
|
|
186 | (1) |
|
|
|
186 | (2) |
|
Sidebar: Jewish Athletes Challenge Nazi Propaganda |
|
|
188 | (1) |
|
|
|
188 | (2) |
|
Significance of Racial Accomplishment |
|
|
190 | (1) |
|
|
|
191 | (1) |
|
Critical Thinking Questions |
|
|
191 | (1) |
|
|
|
192 | (1) |
| 15 The Setting of Organized Sports Since World War II |
|
193 | (12) |
|
Sidebar: Black Athletes and the Cold War |
|
|
195 | (1) |
|
Affluence and Suburbanization |
|
|
196 | (1) |
|
Television Transforms American Life |
|
|
197 | (1) |
|
Television Transforms Sports |
|
|
198 | (1) |
|
Roone Arledge, ABC, and the Rise of Televised Sport |
|
|
199 | (1) |
|
|
|
199 | (2) |
|
|
|
201 | (1) |
|
|
|
202 | (1) |
|
|
|
202 | (1) |
|
|
|
203 | (1) |
|
Critical Thinking Questions |
|
|
203 | (1) |
|
|
|
204 | (1) |
| 16 Professional Team Sports in the Age of Television |
|
205 | (14) |
|
|
|
207 | (2) |
|
Pro Football's Golden Age |
|
|
209 | (1) |
|
Marketing Professional Team Sports |
|
|
210 | (2) |
|
Sidebar: The Ascent of Golf |
|
|
212 | (1) |
|
|
|
213 | (1) |
|
|
|
214 | (1) |
|
Professional Basketball on the Rise |
|
|
215 | (1) |
|
|
|
216 | (1) |
|
|
|
217 | (1) |
|
Critical Thinking Questions |
|
|
217 | (1) |
|
|
|
217 | (2) |
| 17 College Sports in the Age of Television |
|
219 | (13) |
|
The Economics of College Athletics |
|
|
220 | (1) |
|
|
|
221 | (2) |
|
College Football Goes Big-Time |
|
|
223 | (1) |
|
Recruiting Big-Time Teams |
|
|
224 | (2) |
|
College Basketball Enters the National Spotlight |
|
|
226 | (1) |
|
Sidebar: Sports Gambling Expands |
|
|
227 | (1) |
|
|
|
228 | (1) |
|
|
|
229 | (1) |
|
Critical Thinking Questions |
|
|
230 | (1) |
|
|
|
230 | (2) |
| 18 Racial Revolution |
|
232 | (15) |
|
Jackie Robinson and the Politics of Restraint |
|
|
234 | (2) |
|
|
|
236 | (1) |
|
|
|
237 | (1) |
|
The Olympic Project for Human Rights |
|
|
238 | (2) |
|
Sidebar: Olympic Politics |
|
|
240 | (1) |
|
|
|
241 | (2) |
|
Native Americans Protest "Indian" Mascots |
|
|
243 | (1) |
|
Activism for Athletes: The End of the Reserve Clause |
|
|
244 | (1) |
|
|
|
244 | (1) |
|
Critical Thinking Questions |
|
|
244 | (1) |
|
|
|
245 | (2) |
| 19 Women's Liberation |
|
247 | (14) |
|
|
|
249 | (1) |
|
Women's Liberation and Title IX |
|
|
250 | (2) |
|
Losing the Fight for Independence |
|
|
252 | (1) |
|
Women's Professional Tennis |
|
|
253 | (2) |
|
Sidebar: Renee Richards and the Transgender Challenge |
|
|
255 | (1) |
|
|
|
256 | (1) |
|
Conservative Retrenchment |
|
|
257 | (2) |
|
|
|
259 | (1) |
|
Critical Thinking Questions |
|
|
259 | (1) |
|
|
|
260 | (1) |
| 20 All Sports All the Time |
|
261 | (13) |
|
|
|
263 | (1) |
|
|
|
264 | (1) |
|
Baseball Reaches Out to Latinos |
|
|
265 | (2) |
|
|
|
267 | (2) |
|
Sidebar:The Olympics and the End of Amateurism |
|
|
269 | (1) |
|
|
|
270 | (2) |
|
|
|
272 | (1) |
|
Critical Thinking Questions |
|
|
272 | (1) |
|
|
|
272 | (2) |
| 21 Sports in the Twenty-First Century |
|
274 | (16) |
|
|
|
276 | (1) |
|
|
|
277 | (1) |
|
Sidebar: Should College Athletes Be Paid? |
|
|
278 | (1) |
|
Professionals and Performance-Enhancing Drugs |
|
|
279 | (1) |
|
|
|
280 | (1) |
|
Sports and American Identity |
|
|
281 | (1) |
|
|
|
282 | (1) |
|
|
|
283 | (1) |
|
|
|
283 | (1) |
|
|
|
284 | (1) |
|
|
|
285 | (1) |
|
|
|
286 | (1) |
|
Critical Thinking Questions |
|
|
287 | (1) |
|
|
|
287 | (3) |
| Index |
|
290 | |
More info about Wiley Online