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

750 Excel 2013 All-In-One For Dummies
COM (Component Object Model) add-ins, 68, 71
combo charts, inserting, 520 Comma Separated Values
(CSV) files, 628 Comma Style, 147, 170 commas (,), 89 comment boxes, 114 comments
clearing, 194
default settings for, 58 instructions on template
use, 82 searching in, 218 using, 483–486
Comments option, Paste Special dialog box, 213
Compare and Merge Workbooks command, 479–480
Compare Side by Side dialog box, 257, 258
comparison criteria, specifying, 614–615
comparison operators, 306–307, 615
compatibility with other Excel versions,
checking for, 18, 464 Component Object Model (COM) add-ins, 68, 71
Compress Pictures option, 559
computer, saving workbooks to, 54
Computer button, Open dialog box, 188
concatenation, 307, 428–429 Conditional Formatting
feature
creating rules for, 180–181 filtering data lists by, 609 graphical conditional
formatting, 174–175
highlighting duplicate values in cell ranges, 179–180
identifying values or text entries in cell ranges, 176–179
managing rules for, 181–182 overview, 174
Quick Analysis tool, 176 whiting-out errors with,
346–347 Conditional Formatting
Rules Manager dialog
box, 180, 181–182 Confirm Password dialog box, 435, 436, 437
conflicting changes, 475, 480 Consolidate dialog box,
264–265, 266, 267 consolidating worksheets
by category, 266–267 general discussion,
262–263
linking consolidated data,
267–268
by position, 263–266
constants, 300, 326–327 constraint cells, 660 constraints, in Solver
add-in, 662, 664 contextual tabs, Ribbon, 63 Convert to Range option,
594, 598, 641
copies of files, opening, 190 copying
cut-and-paste technique, 208–211
data between workbook windows, 259
drag-and-drop technique, 206–207
formulas, 312–315, 317 hyperlinks, 460–461
inserting rather than replacing copied cells, 212
overview, 206
Paste Special dialog
box, 212–216 worksheets, between
windows, 259 worksheets, to another
position in workbook,
252
Corrections option, 559 COUNT function, 402 COUNTA function, 402,
404–405
COUNTBLANK function, 403 counting formulas
building, 401–404 conditional counting,
405–407
for occupied cells, 404–405 overview, 401
COUPDAYBS function, 385 COUPDAYS function, 386 COUPDAYSNC function, 386 COUPNCD function, 386 COUPNUM function, 386 COUPPCD function, 386 Create from Selection
button, 328 Create Names from
Selection dialog
box, 328–329 Create New Data Source
dialog box, 633–635 Create PivotTable dialog
box, 672–673
Create Sparklines dialog
box, 542
Criteria button in data
form, 584–586
Criteria Range, 612
.crtx filename extension,
541