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

Index 755
Ribbon, 21–25
Status bar, 33–34 Worksheet area, 28–33
Excel Start screen, 14–15 Excel Template file
format, 120
Excel web app, editing
in, 492, 496–499 Excel Workbook file
format, 119
existing files, linking to, 458 Expand Field option, 676 Expense Report template, 78 Export option, 20, 642 Export screen, 509 exporting
external data to other programs, 642
workbooks in other file formats, 507–512 extending selections,
129–130
extensions, default settings
for files, 48
External Data Properties
dialog box, 642 external data queries. See
also Microsoft Query to Access tables, 624–626 general discussion,
622–624
to other data sources,
632–633
to text files, 628–632 to web pages, 626–628
external data tables, creating pivot tables from, 673
F
F4 key, 318–319
Facebook, posting SkyDrive
workbook links on, 493
FALSE function, 341 faxing workbooks, 494 feasible solutions setting,
in Solver add-in, 664 field names, 577
Field Settings option, 676 file extensions, default
settings for, 48
file formats. See also specific
formats by name
displaying all files in folders, 186
Excel add-ins, 70 exporting workbooks to
other, 507–512 saving worksheets in
other, 119–120
file icons, Open dialog
box, 186
File menu button, 16, 17–18 File menu options, 19–20 File Name button, 288
File Path button, 288
file sharing, 472–473, 482 files
adding authors to, 19 AutoRecover feature, 190 browsing for, 184
copies of, opening, 190 CSV, 628
default file location, 54, 120–121
delimited, 628
existing, linking to, 458 hyperlinks for, 456, 458 metadata, adding to, 465 read-only, 190
repairing corrupted, 190
Fill & Line options, 537 Fill alignment option, 158 Fill button on Ribbon, 104 fill color, 167–168, 529,
596–597, 609
Fill Color button, 145
Fill Effects dialog box, 167, 168
Fill handle, 101, 102, 103 Fill tab, Format Cells dialog
box, 167, 168 filtering. See also filtering
data lists
enabling in protected
sheets, 443
with Microsoft Query,
637–638
pivot charts, 694–695 pivot tables, 681–686 range names, 330
filtering data lists. See also advanced filtering
by conditional formatting, 609
customizing, 609–612 database functions,
620–622
by date, 605–607 general discussion,
602–603
by numbers, 607–608 overview, 601
by selecting specific field
entries, 603–605
by text, 605
Top Ten option, 607–608
financial functions
Analysis ToolPak, 385–388 arguments, 375–376 depreciation functions,
383–385 FV, 378–379 NPV, 377–378 overview, 375 PMT, 379–382 PV, 376–377
Find and Replace dialog box, 216–221
Find feature, 216–219