Excel 2019 Bible

Index

naming, 56–57
navigating cells, 179–182
number formatting, 44–50
automatic, 46
custom formats, 50
Format Cells dialog box, 48–50
Ribbon controls, 46
shortcut keys, 46–47
overview, 5
printing, 26–27
protecting, 59, 769, 770–774
saving
in PDF format, 194, 778
in XPS format, 194, 778
tab color, changing, 57
time-stamping, 44
unhiding, 58–59
views, 59
comparing worksheets, 61–62
creating, 60–61
freezing panes, 62–64
monitoring cells with Watch Window, 65
splitting worksheets into panes, 62
using multiple views, 60–61
\zooming, 59–60
with the mouse, 10
Zoom control, 7
Wrap Text, 125

X

XIRR function, 359–360
XLA files, 580
.xlam file extension, 1027
XLM files, 580

XLS files, 580

.xlsm file extension, 922

.xlsx file extension, 4

XLStart folder, workbooks stored in, 157

XLT files, 580

XML files, 582

XML Paper Specification Document (XPS) files, 611

saving worksheets as, 194, 778

xVelocity analytics engine, 783

XY charts, 476

Y

y time unit code, DATEDIF function, 276

yd time unit code, DATEDIF function, 276

YEAR function, 280–281

year(s)

between dates, calculating, 282

extracting year from given date, 280–281

fiscal quarters, calculating, 287–288

percent completed/remaining, calculating, 284

returning, 280

YEARFRAC function, 284

ym time unit code, DATEDIF function, 276

Z

Z-test tool, Analysis ToolPak, 767

zeros

divide-by-zero errors, 245–246

hiding, 543–544

padding numbers with, 266

suppressing, 543–544

Zoom control, 5, 7

zooming worksheets

with mouse, 10

Zoom control, 7

worksheets (cont inued)