fields
defined, 136
naming, 137
filtering data, 144-145, 148
importing data, 138-141
records
defined, 136
sorting, 138
sorting data, 142-144
summarizing data, 148-150
dates, 20. See also times
calculations with, 71-74
formatting, 24-25
Day() function, 73
Days() function, 74
deleting
cell contents, 39
columns, 39
hidden cell ranges, 145
protection from worksheets, 118
row formatting, 86
rows, 39
styles, 99
descending order, 142
details, collapsing, 150
Diagram Gallery dialog box, 117
dollar sign ($), 32
.dot file extension, 105
E
editing, 114. See also customizing
cells, 39-40
comments in cells, 91
formulas, 24
worksheets, 20-25
entering. See typing
153
equal sign (=), 27
erasing. See deleting
error messages, printing, 130
error-checking formulas, 14
Excel Options dialog box, 11, 14-15
exporting
defined, 126
tables
in Access, 139
worksheet data, 126-128
F
fields
defined, 136
naming, 137
file extensions
.dot, 105
.xlsx, 9
fill handles, 59
filling cells, 57-60
filtering database data, 144-145, 148
Find and Replace dialog box, 50-51
finding worksheet data, 48-51
fonts
formatting, 81-83
selecting in themes, 101
footers, 87
Format Cells dialog box, 99
Format Chart Area dialog box, 112
formatting, 102. See also styles; templates;
themes
cells, 81-84
dates, 24-25
hidden cell ranges, 145
numbers as text, 23
formatting

Get Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.