free pdf viewer c# winform : Delete text from pdf preview Library software component asp.net windows azure mvc EXCEL%20readings82-part161

cell ranges continued
properties, Visual Basic for Applications
(VBA), 644–649
random number generation in, 433–434,
689–690
randomizing, 691–692
reference operator, 36, 101
references, absolute, 42, 567–568
references, color, 567
references, combining, 36
references, copy/paste operations, 78
references, full-column, 101
references, full-row, 101
references, in SERIES formulas, 442
references, in Visual Basic for Applications
(VBA), 644–646
references, indirect, 88–89
references, intersection, 36, 70, 72
references, mixed, 42, 88
references, natural language formulas
versus, 71–72
references, operators used for, 36
references, relative, 42, 87, 567–568
references, returning number of areas 
in, 725
references, returning number of 
columns in, 725
references to ranges in other workbooks,
44–45, 68
references to ranges in other worksheets,
44–45
references, using array constants in lieu of,
395–396
references, using in named formulas, 84–85
rows, returning, 649
rows, returning number of, 648
rows, testing for hidden, 649, 654–655
selecting, 14 , 60–61
text strings, returning longest in, 405
validation checks in, 406
values in, counting non-zero, 403
values in, counting unique, 193–195
values in, determining closest, 410
values in, determining largest, 432–433
values in, finding, 403–404
values in, finding nth occurrence of, 405
values in, returning average of 
non-zero, 403
values in, returning location of maximum,
404–405
values in, returning maximum, 404–405
values in, returning maximum using LARGE
function, 100
values in, returning maximum using MAX
function, 98, 433
values in, returning most frequently
occurring, 191
values in, returning positive-only, 414–415
values in, returning unique, 416–417
values in, sorting dynamically, 416
values in, summing based on different
ranges, 206–207
values in, summing every nth, 409–410
values in, summing largest, 204, 402
values in, summing smallest, 204, 392
values in, summing squares of, 643–644
viewing named, 76–77
Visual Basic for Applications (VBA),
working with in, 643–652
worksheets, spanning multiple, 65–66
worksheets containing, returning, 647
cell references. See also circular references
A1 notation, 43–44
absolute, 42
color, 567
column number of, returning, 725
combining, 36
conditional formatting formulas, in, 517,
518, 520–521
database operations, in, 239, 256
entering, 31, 32, 45
formula elements, as, 29
formulas, copied, 45
formulas, using in named, 84–87
indirect, 88–89
intersection, 36, 70, 72
invalid, 50, 566
megaformulas, substituting formula text for
in, 544
mixed, 42, 88
multiple, combining into one, 36
names, using instead of, 58
natural language formulas versus, 71–72
number format correspondence, 31
operators used for, 36
R1C1 notation, 43–44
ranges, cells in multicell named, 73
relative, 42, 85–87
Visual Basic for Applications (VBA)
formulas, in, 645
workbooks, in other, 44–45, 68
worksheets, in other, 44–45
CELLFORMULA function, 654
CELLHASFORMULA function, 654
CELLHASTEXT function, 137, 671–672
CELLISHIDDEN function, 654–655
cells
arrays, changing cell contents in, 384
arrays, selecting cells containing, 383–384
auditing by identifying cells of particular
type, 573
characters in, maximum, 113–114
charts, linking to, 445–448
charts, plotting hidden, 457
charts, single-cell, 448
color, background, 16, 524, 528–529
784
Index
Delete text from pdf preview - extract text content from PDF file in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Feel Free to Extract Text from PDF Page, Page Region or the Whole PDF File
edit pdf replace text; copying text from pdf to word
Delete text from pdf preview - VB.NET PDF Text Extract Library: extract text content from PDF file in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
How to Extract Text from PDF with VB.NET Sample Codes in .NET Application
copy text from pdf reader; copy and paste text from pdf to word
conditional formatting, applying shading
using, 515, 517, 525–526
conditional formatting, applying to cells
containing above-average values, 522
conditional formatting, applying to cells
containing formulas, 530–531
conditional formatting, applying to cells
containing invalid data, 532–533
conditional formatting, applying to cells
containing link formulas, 532
conditional formatting, applying to cells
containing more than one word, 528
conditional formatting, applying to cells
containing specific characters, 528
conditional formatting, applying to cells
containing text, 521
conditional formatting, applying to 
named, 521
conditional formatting, applying to 
specific cells, 518
conditional formatting, copying cells
containing, 519
conditional formatting, hiding contents
using, 524, 528–529
conditional formatting, locating cells
containing, 520
copy operations, 15, 79
counting blank, 180, 183–184
counting cells between two values, 675
counting cells containing dates, 187, 210
counting cells containing specific
formatting, 210
counting cells containing specific numeric
value, 180
counting cells meeting AND criteria,
190–191
counting cells meeting multiple criteria,
189–190
counting cells meeting OR criteria, 190–191
counting cells meeting specified criteria,
180, 186–191, 192–193, 210
counting characters in, 130
counting nonempty, 180, 184, 411, 646
counting nontext, 185
counting numeric, 185
counting text cells, 185, 187, 392–393
counting total in range, 183, 644, 647
counting total in worksheet, 645
counting visible, 210, 675–676
counting words in, 135–136
data stored in, 14
data type, determining, 110, 115–117, 137,
210, 659–660
deleting, 75, 566
dependents, 575, 576–577
editing contents, 34
empty, allowing/disallowing using data
validation, 537
empty, determining if, 110
empty, filling using Paste Special, 245
empty, in database operations, 241
empty, in lookup formulas, 219
empty, in net present value 
calculations, 339
empty, in pivot tables, 501
empty, spaces in, 563
formatting, stylistic, 16–17
formatting information, returning, 648,
657–659
formulas, identifying cells containing,
530–531, 573, 647, 654
formulas in, returning, 646–647
line breaks in, 15, 119–120
locking, 25, 49
number format, counting cells containing
specific, 210
number format, displaying, 756
number format, filling with repeating
characters using, 756–757
number format, padding with dashes using,
756–757
number of, maximum, 9
precedents, 575–576
preformatting to avoid automatic number
formatting, 734, 740
returning nonempty, 415, 680–681
selecting, 14, 16, 60–61
selecting cells containing arrays, 383–384
selecting random, 663–664
shading, 515, 517, 525–526
summing cells containing specific
formatting, 210
summing visible cells, 210, 676–677
text, determining if cell contains, 115–117,
137, 671–672
tracing, 575–577
wrap, 9, 15, 120–121
zero values in, 184, 219
Cells property, 645–646
CELLSINCOMMON function, 650–651
CELLTYPE function, 659–660
celltype function.xls (on the CD-ROM), 773
CHAR function, 118–119, 732
character codes, 117–118
character set.xls (on the CD-ROM), 766
characters, special, 119
Chart➪Chart Type, 443
chart data in active row.xls (on the CD-ROM),
771
chart from combo box.xls (on the CD-ROM),
771
Chart➪Location, 479
Chart Location dialog box, 479
Chart Options dialog box, 445, 447
Chart Wizard, 448–449, 450–451, 454–455
Index
785
How to C#: Preview Document Content Using XDoc.Word
How to C#: Preview Document Content Using XDoc.Word. Get Preview From File. You may get document preview image from an existing Word file in C#.net.
copy and paste text from pdf; extract text from pdf open source
How to C#: Preview Document Content Using XDoc.PowerPoint
How to C#: Preview Document Content Using XDoc.PowerPoint. Get Preview From File. You may get document preview image from an existing PowerPoint file in C#.net.
copy text pdf; delete text from pdf online
charts. See also SERIES formulas
3-D, 466–467
activating, 20, 444
Analysis ToolPak add-in features, 199
animation, 481–482
arrays, converting data range 
references to, 445
AutoFiltering, 455–456
axes labels, 442, 451
axes number formats, custom, 452
axes scale values, adjusting, 451
axes tick marks, removing, 452
bar charts, clustered, 452
bar charts, creating Gantt charts from, 450
bar charts, stacked, 450
borders, 451
box plots, 453–455
category axis titles, 445
cell range names, referencing in, 77
cells, charts in single, 448
cells, linking to, 445–448
cells, plotting hidden, 457
circles, plotting, 485–486
clock charts, 483–485, 486
color settings, 443, 455, 467, 515
column charts, 448–449
columns, plotting data in hidden, 455
combo box, data selection from, 461–462
COS function in, 483–484
COUNTA function, using in, 457, 458
curve fitting, 474
data labels, adding by specifying range, 446
data labels, editing, 446
data labels, linking to cells, 446
data labels, selecting, 446
data points, changing worksheet values by
dragging, 480–481
data points, displaying most recent,
458–459
data points, missing, 444, 454
data points, plotting every nth, 455–457
data points, plotting last n, 458–459
data series, 441
data series, deleting from, 444
data series, selecting points in, 443
data series, updating automatically,
457–458
data tables in, 447
date format, 451
dynamic, 444, 457–458
embedded, 10
embedded, printing, 443
embedded, relocating, 479
embedded, removing from printing, 443
embedded, selecting, 444
embedded, viewing in window, 480
EVALUATE function, using in, 465
extrapolation, 474
fill color, 443
font color, 443, 515
forecasting using trendlines, 469, 473
formulas, working with named, 444,
460–461
free-floating, 20
frequency distributions, charting, 196–197,
198–200
functions, plotting double-variable,
466–467
functions, plotting single-variable, 462–466
Gantt charts, 449–451
gap width, 449, 452
gauge charts, 482
goal seeking, 481
goals, charting progress toward, 448–449
histograms, 123–124, 198–200, 451–452
hypocycloid curves, 468–469
interactive, 460–467
interpolation, 454, 474
legends, 442, 467
line charts, continuing line through points
with no data, 444
line charts with markers, 454
line color, 455
location, 479
names, using in, 77, 442, 444
naming, 80
NOW function, updates using, 466
number formats, custom, 452
OFFSET function, using in, 457, 458–459,
464–465
overlap, 452
percent values, displaying as data series,
448–449
pictures, linking to cells, 447–448
pictures, pasting as, 444
pie charts, 482
PivotChart Report, 495
plot area, 443
plotting order, specifying, 442
population pyramids, 451
positioning, 444
Power Utility Pak tools, 446
printing chart sheets, 10
printing embedded charts, 443
printing without associated worksheet, 443
properties, changing, 444
quartile plots, 453–455
range, unlinking from, 444
range names, referencing, 442
range references, 442, 444
range references, converting to arrays, 445
range references, noncontiguous, 442
row, plotting based on active, 460–461
row, plotting data in hidden, 455
786
Index
VB.NET PDF delete text library: delete, remove text from PDF file
Visual Studio .NET application. Delete text from PDF file in preview without adobe PDF reader component installed. Able to pull text
export highlighted text from pdf to word; extract text from scanned pdf
VB.NET PDF File Compress Library: Compress reduce PDF size in vb.
a preview component enables compressing and decompressing in preview in ASP images size reducing can help to reduce PDF file size Delete unimportant contents:
copy text from scanned pdf; extract text from pdf
scatter, 462, 469
selecting, 20, 444
selecting elements in, 443
SERIES formulas, relation to, 441–442
shading, 467
sheets, 8, 10
SIN function in, 462, 483–484
single-cell charts, 448
sizing/resizing, 443, 449
static, 444
surface charts, formatting, 467
surface charts, plotting double-variable
functions using, 466
surface charts, XYZ, 466
text, linking to cells, 446–447
text boxes in, 446–447
“thermometer” type display, 448–449
tick marks, 452
titles, 442, 445, 449
trendlines, 469
trendlines, coefficient of determination, 471
trendlines, data series versus, 470
trendlines, decimal places setting, 471
trendlines, exponential, 474, 477–478
trendlines, intercept calculations, 470,
471–472
trendlines, linear, 469, 470–471
trendlines, logarithmic, 474, 475–476
trendlines, moving average option, 474
trendlines, nonlinear, 474–479
trendlines, polynomial, 474, 478–479
trendlines, power, 474, 476–477
trendlines, predicted values calculations,
472–473
trendlines, R-squared values, 470, 471, 474
trendlines, slope calculations, 471–472
type, setting default, 443
value axis titles, 445
variables, plotting functions with double,
466–467
variables, plotting functions with single,
462–463
Visual Basic for Applications (VBA) macros,
using in, 461, 484–485
windows, sizing to, 443, 479
windows, viewing embedded charts in
separate, 480
worksheets, 8, 10
worksheets, changing values by dragging
data points, 480–481
worksheets, referring to other, 442
worksheets, storing multiple charts on,
479–480
XY charts, animated, 481
XY charts, circle plotting in, 485
XY charts, clock display in, 483
XY charts, drawing using, 486–487
XY charts, function plotting using, 463
XY charts, hypocycloid curve 
display in, 468
XY charts, scatter, 462, 469
checksum digits, 552
CHIDIST function, 728
CHIINV function, 728
CHITEST function, 728
CHOOSE function, 212, 725
Chr function, 621
circle.xls (on the CD-ROM), 771
Circular Reference toolbar, 51–52, 426–427, 577
circular references
accidental, 51–52, 426–427, 560, 572, 577
described, 51, 425–426
Do-Loop constructs, 428
entering, 51–52
equations, solving recursive using, 435–436
equations, solving simultaneous using,
436–438
error message, 51–52, 426
error message, turning off, 52
IF function in, 122
indirect, 427
intentional, 428–430
iteration settings, 52, 427, 
428–429, 431, 439
locating, 426
NOW function in, 122
random number generation using, 433–434
time stamping cell entries using, 432
value, determining highest using, 432–433
circular reference.xls (on the CD-ROM), 770
CLEAN function, 125–126, 732
clock chart vba.xls (on the CD-ROM), 771
clock chart.xls (on the CD-ROM), 771
clocks, creating in charts, 483–485, 486
closest match.xls (on the CD-ROM), 767
CODE function, 118, 732
color
cell backgrounds, 16, 524, 528–529
cell references, 567
cell shading, 515, 517, 525–526
charts, 443, 455, 467, 515
conditional formatting, applying using, 515,
516, 517, 525–526, 528–529
error values, hiding using, 524
fills, chart, 443
fills, returning color index number for,
658–659
fills, text box, 16
font, 443
modifying available, 516
number formats, custom, 518, 739, 751–752
palette, 516
workbooks, 516
Columbus Day, calculating, 164
Index
787
C# PDF delete text Library: delete, remove text from PDF file in
DotNetNuke), SharePoint. Delete text from PDF file in preview without adobe PDF reader component installed in ASP.NET. C# class source
copy paste text pdf; cut text pdf
C# WinForms Viewer: Load, View, Convert, Annotate and Edit PDF
Add text to PDF document in preview. • Add text box to PDF file in preview. • Draw PDF markups. Search PDF text in preview. • View PDF outlines.
get text from pdf file c#; c# get text from pdf
COLUMN function, 725
columns. See also worksheets
cells, returning last nonempty in, 680–681
database columns, mixing data types
in, 239
database columns as fields, 238
deleting, 75, 77–78
function arguments, as, 101
inserting, cell name behavior during, 77
labels, database column, 239
labels, using in formulas, 71–72
letters, returning for values contained in
cells, 132
naming, 63
number of, maximum, 9
numbers, returning, 725
pivot table column headers, 492
pivot table column orientation, 492
pivot table column titles, 501
returning last value in, 410–411
shading using conditional formatting, 525
splitting, 136
summing values in meeting 
specified criteria, 180
testing for hidden, 649, 654–655
values in, determining largest, 432–433
width, changing, 9
width, insufficient, 50, 562
COLUMNS function, 111, 183, 725
Columns property, 648
COM automation, retrieving real-time data from
programs supporting, 725
COMBIN function, 726
COMMISSION function, 665–667
commission function.xls (on the CD-ROM), 773
comp.apps.spreadsheets FAQ site, 764
comparative histogram.xls (on the CD-ROM),
771
Compare Sheets or Ranges utility (on 
the CD-ROM), 581
comparison operations
case sensitivity, 120, 129, 131
equal to, 34, 36, 119–120, 719
greater than, 36
greater than or equal to, 36
less than, 36, 37
less than or equal to, 36, 37
logical, 36, 110, 202, 208–209
not equal to, 37
summing values based on date 
comparisons, 207
summing values based on text 
comparisons, 207
text comparisons, 119–120, 
130–131, 137, 207
Visual Basic for Applications (VBA), 137,
629
COMPLEX function, 719
CONCATENATE function, 121, 732
conditional formatting. See formatting,
conditional
Conditional Formatting dialog box
accessing, 514
Add button, 518
Cell Value Is button, 514, 516
Delete button, 520
Format button, 514, 515
Formula Is button, 514, 516
formulas, entering in, 517
conditional formatting.xls (on the CD-ROM),
772
Conditional Sum Wizard add-in, 205
conditional summing.xls (on the CD-ROM), 767
CONFIDENCE function, 729
Consolidate_Area internal name, 64
Const statements, 626
constants
array constants, 378–379
array constants, creating from range values,
386–387
array constants, naming, 381–383
array constants, summing operations
involving, 378–379
array constants, using in calendars, 416
arrays constants, using in lieu of range
references, 395–396
equations, in, 283
naming, 81–83
numeric, 81–82
scope, 626
text constants, 82–83
Visual Basic for Applications (VBA),
626–627
Control Toolbox, 19
controls, dialog box, 19–20
conversions, measurement unit. See
measurement unit conversions
CONVERT function, 269, 719
Convert Text to Columns Wizard, 136
Convert utility, 278
copy/cut/paste operations
cell contents, 15
cell ranges, 15, 78
cells, 15, 78–79, 566
conditional formatting considerations, 519
formulas, 45–46, 566
keyboard shortcuts, 14, 15
name considerations, 32, 64, 68, 78–79
pivot tables, 504
text, copying from formulas, 544
Visual Basic for Applications 
(VBA) code, 598
worksheets, 78–79
CORREL function, 729
788
Index
C# WinForms Viewer: Load, View, Convert, Annotate and Edit
PowerPoint Conversion. • Convert Microsoft Office PowerPoint to PDF (.pdf). Delete annotations from PowerPoint. Select PowerPoint text contents for edit.
extract text from pdf online; copy pdf text to word document
C# PDF insert text Library: insert text into PDF content in C#.net
Supports adding text to PDF in preview without adobe reader installed in ASP.NET. Powerful .NET PDF edit control allows modify existing scanned PDF text.
cut and paste text from pdf document; copy highlighted text from pdf
COS function, 483–484, 726
COSH function, 726
COUNT function, 180, 729
Count property, 647
count unique.xls (on the CD-ROM), 767
COUNTA function
array formulas, in, 411
cells, counting non-empty using, 180, 184,
411, 646
charts, in, 457, 458
described, 729
formulas, in dynamic named, 92
COUNTBETWEEN function, 210, 675
COUNTBLANK function, 180, 183–184, 729
counters, 615, 639–640
COUNTIF function, 180, 186–193, 403, 539, 729
counting
AND/OR criteria in, 189–191
array formula involvement in, 183
AutoCalculate, using, 182
case sensitivity in, 187, 193
cell ranges, differences between, 404
cells, blank, 180, 183–184
cells, nonempty, 180, 184, 411, 646
cells, nontext, 185
cells, numeric, 185
cells, text, 185, 187, 392–393
cells, total in range, 183, 644, 647
cells, visible, 210, 675–676
cells, words in, 135–136
cells between two values, 675
cells containing dates, 187, 210
cells containing specific formatting, 210
cells containing specific numeric 
values, 180
cells meeting AND criteria, 190–191
cells meeting multiple criteria, 188–191
cells meeting OR criteria, 190–191
cells meeting specified criteria, 180,
186–191, 192–193, 210
characters in cell ranges, 391–392
characters in cells, 130
characters in text strings, 126, 130,
192–193
database operations involving, 110, 180,
181–182, 242–243
day of week, occurrences of, 161–162
error values in ranges, 185–186, 398–399
frequency distributions, 195–201
functions related to, 180–181, 210, 674–676
invalid items, 406
logical values, 185
most frequently occurring value, 191
pivot tables, in, 181, 195, 494
substring occurrences, 130–131
text string occurrences, 130–131, 192–193
text strings, words in, 135–136
values, non-zero, 403
values, unique, 193–195
Visual Basic for Applications (VBA)
functions, using, 210, 674–676
wildcard characters in, 186
words in cells, 135–136
counting and summing functions.xls (on the
CD-ROM), 773
counting text in a range.xls (on the CD-ROM),
767
COUNTVISIBLE function, 210, 675–676
COUPDAYBS function, 721
COUPDAYS function, 721
COUPDAYSNC function, 721
COUPNCD function, 721
COUPNUM function, 721
coupon period calculations, 721
COUPPCD function, 721
COVAR function, 729
Create Names dialog box, 61–62
creating indices.xls (on the CD-ROM), 769
credit card calculations.xls (on the CD-ROM),
769
credit card validation.xls (on the CD-ROM), 772
credit cards
American Express, 552
checksum digits, 552
Discover, 552
Mastercard, 552
minimum payment considerations, 365
number validity formulas, 552–556
payment calculations, 324, 365–366
Visa, 552
CRITBINOM function, 729
Criteria internal name, 64
cross-checking formulas for accuracy, 300
crosstab tables, dynamic, 413–414
CUMIPMT function, 322–323, 543, 721
CUMPRINC function, 322–323, 721
cumulative sum.xls (on the CD-ROM), 767
currency
dollars, fractional, 285, 288, 721
dollars, rounding, 287
format, 15, 16, 733, 735, 736
fraction/decimal conversions, 285
spelling out, 137, 674
text, displaying as, 122–123
cut/paste operations. See copy/cut/paste
operations
CVErr function, 686
D
Data Analysis dialog box, 198–199
data entry. See also validation, data
array formulas, 30, 376, 377, 383
AutoFill, using, 15, 48
databases, in, 248
continued
Index
789
How to C#: Preview Document Content Using XDoc.excel
How to C#: Preview Document Content Using XDoc.Excel. Get Preview From File. You may get document preview image from an existing Excel file in C#.net.
delete text from pdf with acrobat; c# extract text from pdf
C# PDF replace text Library: replace text in PDF content in C#.net
Description: Delete specified string text that match the search option from specified PDF page. Parameters: Name, Description, Valid Value.
extract text from pdf file using java; pdf text replace tool
data entry continued
formula results, 35
formulas, 30–32, 39–40
functions, 103–107
introduced, 14–15
parentheses, 39
Visual Basic for Applications (VBA) code,
manually, 595–596
Visual Basic for Applications (VBA) code
using macro recorder, 596–598
Data➪Filter➪Advanced Filter, 22
Data➪Filter➪AutoFilter, 22, 240
Data➪Filter➪Show All, 242
Data➪Form, 248
Data Form feature, 248, 497
Data➪JWalk Enhanced Data Form, 248
Data➪PivotTable, 495
data recovery using link formulas, 45
Data➪Sort, 22
Data➪Subtotals, 107
Data➪Table, 261
data table summary.xls (on the CD-ROM), 768
data tables, summary
array formulas in, 264, 359
calculation mode considerations, 361
creating, 263, 358–361
crosstab tables, dynamic, 413–414
dynamic, 261
frequency distributions, 195
loan option summaries, 358–361
one-way, 358–360
pivot tables, using, 261
speed considerations, 361
two-way, 360–361
Data➪Text to Columns, 136
data types
arrays, returned by, 687
Boolean, 624
byte, 624
currency, 624
database columns, mixing data types in,
239
date, 624, 627–628
decimal, 624
determining, 110, 115–117, 
137, 210, 659–660
displaying, 615
double, 624
errors, debugging, 567
integer, 624
long, 624
object, 624
single, 624
string, 624, 627
variant, 624, 687
Visual Basic for Applications (VBA), 624
Visual Basic for Applications (VBA),
automatic assignment, 623
Visual Basic for Applications (VBA),
declaring in, 625
Visual Basic for Applications (VBA),
determining using, 659–660
Visual Basic for Applications (VBA)
functions, specifying type returned by,
603, 620
data validation. See validation, data
Data➪Validation, 15
Data Validation dialog box
accessing, 534
Error Alert tab, 535, 537, 538
Input Message tab, 535
Settings tab, 534, 537, 538
data validation.xls (on the CD-ROM), 772
Database internal name, 64
databases (worksheet lists)
array formula operations, 260, 264
arrays, using in filter criteria formulas,
257–258
arrays, using in place of criteria range, 260,
395
averages, 258, 717
cell references, 239, 256
cells, blank, 241
columns, labeling, 239
columns, mixing data types in, 239
columns as fields, 238
counting operations, 110, 180, 181–182,
242–243
data entry/editing, 248
date format considerations, 254
design, 239
field labels, using in filtering, 247, 256
fields, columns as, 238
fields, maximum, 238
filtering, 22, 240
filtering, comparison operators in, 250–251
filtering, copying data resulting from, 243
filtering, count operations on resulting 
data, 242–243
filtering, data hidden by, 240, 242, 243
filtering, deleting data resulting from, 243
filtering, duplicate record removal 
using, 247
filtering, field labels in, 247, 256
filtering, logical comparisons in, 
253–255, 256
filtering, range name of filtered list, 241
filtering, sum operations on resulting data,
242–243, 266
filtering, wildcards in, 251–252
filtering criteria, AND/OR, 246, 
253–254, 257–258
filtering criteria, computed, 255–258
790
Index
filtering criteria, multiple, 
241, 246, 253–255
filtering criteria, specifying, 
240–241, 246, 248–258
filtering criteria, using arrays in place of
ranges, 260, 395
filtering using Advanced Filter 
dialog box, 247
filtering using AutoFilter, 240–244
functions related to, 110, 258–259, 717–718
headings, 239
import data cleanup, 245
import data, Lotus, 261
multiplication, 717
pivot table background queries, 501
pivot table data sources, as, 496
pivot table summaries, 491
queries, background in pivot tables, 501
records, counting nonempty, 180
records, counting using specified criteria,
110, 180, 717
records, extracting unique, 247, 717
records, maximum number of, 22, 238
records, removing duplicates, 247
records, rows as, 238
rows, empty, 239
rows, freezing first, 239
rows, hiding, 243, 244
rows, labeling, 239
sorting, 22
standard deviation calculations, 717
summing operations, 242–243, 259–260,
264–267, 718
table relationships, 237
table selection, 14
tables, data, 261–264
uses of, 238–239
values, returning maximum/minimum, 717
variance calculations, 718
worksheets, storage in, 239
databases, external, 22, 501
DATATYPE function, 210
DATE function
arguments, invalid, 151
arguments, other functions as, 151
date calculations, in, 157, 160–166
date display using, 151
date formats, ensuring compatibility 
using, 254
described, 149, 718
displaying dates using, 151
string conversions, in, 153
summing operations, in, 207
TIME function, using with, 169
date functions.xls (on the CD-ROM), 773
Date Report utility (on the CD-ROM), 159, 581
DATEDIF function, 149, 158, 718
dates
1582, prior to, 690
1900, prior to, 147–148, 679–680
1900 system, 140
1904 system, 140, 173
add-ins, 112, 148, 149–150, 159
age calculations, 156–157
AutoFill, entering series using, 152–153
calendars, creating in ranges, 166–167,
417–418
cells containing, counting, 187, 210
cells containing, referencing, 146
century, specifying, 148–149
chart date format, 451
Columbus Day, determining, 164
current, displaying, 150–151
current, entering, 15
current, returning, 109, 122, 523
data validation, 536
databases, format considerations in, 254
day of month, determining last, 165
day of week, counting occurrences, 161–162
day of week, determining, 
158–159, 160–161
day of week, determining date of next, 678
day of week, returning as integer, 679
day of week after specified date,
determining first, 160
day of year, determining, 157
days, adding to dates, 679
days, offsetting using work days, 156
days between two dates, calculating, 149,
153–154, 158, 679, 718
days of dates, returning, 679
displaying, 150–152
Easter, determining, 165
entering, 15, 141–142, 148–149, 151
entering with time, 145
fence-post analogy, 154
format, applying, 140, 145–146, 734, 736
format, automatic, 146, 734
format, custom, 146, 741, 752
format, default, 141
format compatibility, 139, 152, 254
formats recognized, 141–142
formatting, conditional, 522–523, 531
functions related to, 109, 112, 148, 149–150,
718–719
holidays, determining, 163–165
holidays, lists of, 156
Julian, 157
Labor Day, determining, 164
leap year bug, 147
Lotus 1-2-3 legacy, 147, 158
Macintosh date system, 140
Martin Luther King Jr. Day, 
determining, 163
continued
Index
791
dates continued
Memorial Day, determining, 164
Monday, determining date of next, 677–678
month, determining last day of, 165
month, identifying dates in, 522
months, determining number between two
dates, 158, 718
months of dates, returning, 679
ordinals, expressing as, 162
Power Utility Pak (on the CD-ROM) tools, 
159, 581
Presidents’ Day, determining, 164
quarter, determining, 166
range supported, 140
regional settings, 141
replacement characters for invalid, 50, 562
reports, 581
searching for, 143
serial numbers, converting text strings to,
151, 718
serial numbers, converting to days, 149,
150, 718, 719
serial numbers, converting to months, 150,
168, 718
serial numbers, converting to years, 150,
719
serial numbers, entering as, 141
serial numbers, returning for current date,
150, 719
serial numbers, returning for current date
and time, 150, 168, 718
serial numbers, returning for 
specified dates, 149, 150, 718
serial numbers, viewing, 140
serial numbers, zero value, 145
series of, generating, 152–153
stamp, 151
summing values based on date 
comparisons, 207
Sunday, determining date of the most
recent, 160
system settings, 141
text, converting to, 151, 153
text, returning, 157, 162
text recognized as, 141, 142, 147–148
Thanksgiving Day, determining, 164
time, day association with, 145
United States format, 139, 152
variables, storing in, 627–628
version differences, 148–149
versions of Excel, differences in, 140,
148–149
Visual Basic for Applications (VBA),
working with in, 627–628, 677–680
week, determining day of, 158–159
week number in year, returning, 150, 719
week of month, returning integer for,
678–679
weekend dates, identifying, 523
workdays calculations, 150, 
154–155, 718, 719
year, determining day of, 157
years, converting to Roman numerals, 166
years, leap, 147, 165–166
years, returning fractional values for date
spans, 150, 719
years, two-digit, 147, 148–149
years between two dates, calculating, 156,
158, 679, 718
years of dates, returning, 679
DATEVALUE function, 149, 151–152, 718
DAVERAGE function, 258, 717
DAY function, 149, 718
day of the week count.xls (on the CD-ROM),
766
DAYS360 function, 149, 718
DB function, 348, 349, 721
DCF. See Discounted Cash Flow (DCF)
DCOUNT function, 110, 180, 181, 258, 717
@DCOUNT Lotus function 707, 714–715
DCOUNTA function, 180, 258
DDB function, 348, 349, 721
Debug➪Compile, 610
Debug➪Toggle Breakpoint, 616
debugging. See also auditing; errors in formulas
actual versus displayed values 
problems, 570
add-ins, missing, 565
array formulas, 567
breakpoints, using, 614, 615, 616
cell dependents, tracing, 576–577
cell precedents, tracing, 576
cell range intersection errors, 565–566
cell references, absolute/relative problems,
567–568
cell references invalid errors, 50, 566
circular references, 560, 572, 577
column width, insufficient, 562
data type errors, 567
Debug.Print statements, monitoring
variables using, 612–613
described, 559
division by zero errors, 50, 564
error checking, background, 578–579
error values, identifying, 398, 399, 564
error values, tracing, 563, 577
floating point number errors, 571
Formula Evaluator, using, 580
formulas not calculated, 569
function arguments, non-numerical when
numerical expected, 566
function arguments, range when single
value expected, 467
functions, custom, 567
iteration errors, 566
link errors, 572
792
Index
loop constructs, monitoring values in,
611–613
missing data errors, 565
MsgBox statements, using, 610–612
name/range undefined errors, 565
operator precedence errors, 568–569
parentheses, mismatched, 561
programs versus formulas, 559
spaces in blank cells, accidental, 563
syntax errors, 561, 562, 596, 610
values too large/small errors, 566
variables, monitoring, 610–613
Visual Basic for Applications (VBA)
statement execution, viewing in
Immediate window, 590
Debug.Print statements, monitoring variables
using, 612–613
DEC2BIN function, 719
DEC2HEX function, 719
DEC2OCT function, 719
decimal numbers, converting to/from, 719, 720
Define Name dialog box
accessing, 58
name creation using, 58–59
name definition, changing using, 60, 76
name deletion using, 75
Names field, 59
names listed in, 64, 80
Refers to field, 59, 65–66, 80–81, 457, 458
Workbook field, 67
DEGREES function, 279, 726
Delete Conditional Formatting dialog box, 520
DELTA function, 719
dependents, cell, 575, 576–577
depreciation, 347
depreciation calculations
accounting period, 721
cost arguments, 348
declining balance, 348, 349, 721
double-declining balance, 348, 349, 721
factor arguments, 348
functions related to, 348
life arguments, 348
month arguments, 348
no-switch arguments, 348
rate arguments, 348
salvage arguments, 348
straight-line, 348, 349
sum of year’s digits, 348, 349
variable-declining balance, 348, 349–350
depreciation.xls (on the CD-ROM), 769
detailed loan amortization schedule.xls (on the
CD-ROM), 769
DEVSQ function, 180, 729
DGET function, 258, 717
Diagram Gallery, 18–19
dialog box controls, placing on worksheets,
19–20
dialog boxes, built-in, 12–13. See also specific
boxes
dialog sheets, 8, 10
Dim keyword, 620, 625, 630–631
DISC function, 721
Discounted Cash Flow (DCF), 363–364
discounted cash flow schedule.xls (on 
the CD-ROM), 769
discounting calculations
accumulation compared, 304
complex, 304
Discounted Cash Flow (DCF), 363
Future Value (FV), 308
payment, 307, 309–313
Present Value (PV), 304–306, 307
rate, 306, 307–308
rate, discount, 306, 329–330, 339, 
341–342, 721
simple, 304
display, customizing, 14
distance measurement unit conversions, 
272, 273
#DIV/O! division by zero errors, 50, 564
DIVIDETWO function, 642–643
division operators, 36, 38, 60, 629
DMAX function, 259, 717
DMIN function, 259
Do Until constructs, 640–641
Do While constructs, 639–640
document shortcuts, 725
DOLLAR function, 122–123, 732
DOLLARDE function, 285, 288, 721
DOLLARFR function, 285, 288, 721
dollars
fractional, 285, 288, 721
rounding, 287
DPRODUCT function, 259, 717
drag-and-drop editing, 13
draw layer, worksheet, 10, 13, 18–20
Drawing toolbar, 18
DRAWONE function, 663–664
DSTDEV function, 259, 717
DSTDEVP function, 259, 717
DSUM function, 180, 181, 259–260, 718
DURATION function, 721
DVAR function, 259, 718
DVARP function, 259, 718
E
Easter, calculating, 165
EDATE function, 149, 718
Edit ➪Clear➪Formats, 520
Edit ➪Copy Picture, 444
Edit ➪Paste Picture, 444
Edit ➪Paste Picture Link, 19
Edit ➪Paste Special, 46, 245
Index
793
Documents you may be interested
Documents you may be interested