Page 769 - Excel 2013 All-in-One For Dummies

Index 751
CSV (Comma Separated Values) files, 628
Ctrl key, Touch keyboard, 95 CUMIPMT function, 386 CUMPRINC function, 386 Currency number format,
151
Currency style, 170 current cells, 28
Current Date button, 288 Current Time button, 288 Custom AutoFilter dialog
box, 605, 606, 607,
609–612
Custom Dictionaries dialog
box, 224–225 Custom Lists dialog box,
106, 107–108, 109 Custom option, Data Validation dialog
box, 112
Custom Views feature,
204–205, 247 customization. See also
Excel Options dialog
box
add-ins, 68–71
of charts, from Format
tab, 529–532
of dictionaries, 52,
224–225
of footers, 288–290
of headers, 288–290 of lists, 60, 106–109 macro buttons, Quick
Access toolbar, 719–720 number formats, 152–155 Office apps, 66–68 overview, 41
Quick Access toolbar, 27, 41–45
Ribbon tabs, 63–66, 718–719
of templates, 79–81
themes, 573
views, 246–247 Customize Ribbon tab,
Excel Options dialog
box, 61–66
Cut, Copy, and Paste
options, 55, 57 cut-and-paste technique,
208–211, 503, 506–507
D
dashes (-), in cell entries, 86 Data Analysis Expression
(DAX), 71, 701–703 Data Bars option, 174, 175 Data Connection Wizard,
importing data
from, 633
Data Entered in a Table Is
Invalid check box, 356 data entry. See also AutoFill
feature AutoComplete feature,
96–97
AutoCorrect feature, 97–98 constraining to cell range,
98–99
Data Validation feature,
111–115
decimal points, 99–100 Flash Fill feature, 109–111 with keyboard, 93–94 mistakes in, 92
numeric cell entries,
88–92
rules of, 92–93
text cell entries, 86–87 with Touch keyboard,
94–95
in unlocked cells in
protected files, 450–451 data forms, 581–586
data labels, adding to charts, 533–534
data lists. See also querying data
adding records to, 581–586 calculated fields, creating,
579–580
cell icons, sorting on,
596–597 database functions,
620–622 designing, 578–579 duplicate records,
deleting, 586–587 fill color, sorting on,
596–597
font, sorting on, 596–597 overview, 577–578, 601 pivot tables, creating
from, 672
sorting columns, 592–596 sorting records on fields,
588–592
structure of, modifying, 580 subtotaling data, 597–599
data marker, 516 data models
default settings for, 60–61 importing Access data
to, 625
PowerPivot add-in, 696–699 relationships between
different tables in, 623 undo feature, 60
Data options, Excel Options dialog box, 60–61
data series
AutoFill feature, using for,
103, 104–106 custom lists, creating,
106–109
emptying from charts,
527–528