A
Absolute copying 13
Adding cells 6
Arrange All 84
Average function 11
B
Blank cells
filling with zero 57
Blank columns/rows
deleting 57
Bold 4
Brackets 8
Bush, Kate v
C
Chandoo 158
Chart
animations 120
column chart 26
combination chart 29
drawing a line 31
in PowerPoint 120
in Word 120
pie chart 28
Cleaning data 125
Clifford, Bróna v
Collie, Rob 158
Comment 36
Commins, Claire v
Concatenate function 63
Concatenating cells 63
Conditional Formatting
duplicates 75
in pivot table 122
Copy & paste 4
relative vs. absolute 13
CountA function 11
Count function 11
Cruise, Tom 12
CSV/Text format 47
Ctrl+Enter 5
Cummins, Dolores v
Custom lists 2
D
Data dump 46
Data entry 1
multiple cells 5
principles for lists 37
extending 162
Date entries
restricting 161
Dates
extracting parts of 69
gap between 73
Day function 70
Day name from date 69
Delimited data 48
Division 7
Dropdown in cell 37
Duplicates
identifying 75
removing 76
E
Error alert 39
Errors
ignoring 66
#VALUE! 1
F
F4 for $ 13
Files, practice vii
Fill handle 2
Filtering 54
Find and Replace 62
Footers 24
Formula
adding cells 6
Average 11
brackets 8
Concatenate 63
Count 11
CountA 11
Day 70
division 7
entering multiple times 59
If 72
Iferror 77
in tables 44
Left 67
Max 10
Mid 68
Min 11
Month 70
multiplication 7
parentheses 8
Right 67
subtracting cells 7
Sum 9
Text 69
Trim 61
Vlookup 79
Weeknum 70
Year 70
G
Gaskin, Sharon v
Gorey, Karen v
Go To Special 58
Gridlines 31
Groups of cells 3
H
Headers 24
Headings
printing 20
repeating 59
Helper cell 93
Highest value 10
Hoffman, Dustin 12
I
Iferror function 77
If function 72
Input message 39
Italic 4
J
Joining cells 63
K
Keyboard shortcuts 31
L
Landscape 22
Left function 67
Lotus 1-2-3 vi
Lowest value 11
M
Marching ants 9
Max function 10
Mean 11
Mid function 68
Min function 11
Month function 70
Month name from date 69
Motivational quote 25
N
Naming a range 38
New Window 84
Noncontiguous selection 3
Number formatting 4
Numbers as text 50
Numeric series 3
O
Operator precedence 8
Order of operations 8
Outline view, filling 59
P
Page Breaks 23
Parentheses 8
PDF to Excel 52
Peltier, Jon 30
Phil Handle 2
Phone numbers 35
Picture, background 25
Pivot Table
assembling data 96
blank cells 118
conditional formatting 122
creating first 97
difference from 108
drill-down 117
grand totals 115
grouping by amounts 105
grouping dates 99
layout 115
number formatting 102
% of column total 107
pivot chart 118
refreshing 103
Report Filters 111
report layout 116
running totals 110
show values as 105
Slicers 113
subtotals 115
summarize values by 100
troubleshooting 123
Portrait 22
Power Pivot 141
calculated measures 153
linking data sets 146
YTD 156
PowerPivotPro.com 158
Power Query 125
merging data sets 137
unpivoting data 134
Practice files vii
Printing 18
fit to page 19
headings 20
landscape 22
page breaks 23
Print Preview 19
Puls, Ken 125
R
Rain Man 12
Range 9
Red triangle 36
Relative copying 12
Restricting number sizes 159
Restricting text length 162
Right function 67
S
Sample files vii
Sheet
deleting 17
renaming 14
tab color 16
Simple list 34
Sorting 53
Status bar 12
Structural references 44
Subtracting cells 7
Sum function 9
T
Taylor, Deborah v
Text function 69
Text import wizard 48
Text numbers 50
Text series 2
Text to columns 49
Trailing spaces 60
Transposing 163
Treacy, Mynda 158
Trim function 61
U
Underline 4
Unpivoting Data 164
V
Validation list 37
Vlookup function 79
between workbooks 86
between worksheets 83
helper cell 93
identify what's new 92
Missing Data 87
#N/A errors 81
returning many columns 91
W
Weekday name from date 69
Week Number 70
Wilson, Kitty v
Y
Year function 70
Z
Zeros, leading 1