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

Index 771
Summarize with PivotTable option, 641
summary functions for pivot tables, 688–689
summary reports for scenarios, 656–657
sum-of-years-digits depreciation,
calculating, 383–385 surface charts, inserting, 519 Switch Row/Column option,
524, 525
Switch Windows button, 256 switching documents, 189 SYD function, 383 Synchronous Scrolling
button, 256
T
Tab delimited files, 628 Tab key, 450–451
tab scrolling buttons,
247–248
TABLE function, 649 Table Import Wizard, 698 Table Name option, 641 Table Style Options
group, 142
Table Styles gallery, 139,
140, 141
tables. See also data lists;
Outline feature; pivot
tables
from Access, importing,
624
formatting from Ribbon,
139–142
formatting with Quick
Analysis tool, 143 PowerPivot add-in,
importing with, 698 using names in
formulas, 50
tabs, Ribbon, 21, 23–24, 62–66
Take a Tour thumbnail, Start Screen, 15
TBILLEQ function, 387 TBILLPRICE function, 387 TBILLYIELD function, 387 Technical Stuff icon, 9 template thumbnails, Start
Screen, 14–15 templates
creating, 77, 81–82 customized, saving
changes to, 79–81 default location for,
setting, 54 downloading, 77–79 saving charts as, 541–542 selecting, 76–77
text. See also hyperlinks chart, 517
chart titles, formatting,
537–538
in charts, color options
for, 530
direction, 159
filtering data lists by, 605 functions, 425–429 SmartArt graphics, 570–571
Text Box option, 564 text boxes
adding, 562
arrows, adding to, 565–566 deleting, 565
editing text in, 565 formatting, 563–565
text cell entries, 85, 86–87, 96–98, 109–111, 176–179 Text Effects option, 530, 564
text files, importing data from, 624, 628–632
Text Fill option, 530, 564 Text Import Wizard,
628–631
Text Length option, Data Validation dialog box, 112
text operator, 306, 307
Text Outline option, 530, 564 Text That Contains dialog
box, 177
Text to Speech feature,
228–230
text wrapping, 159–160 themes, 573 Thesaurus, 225 third-party add-ins,
purchasing, 71 thumbnail previews of
workbooks, 118 tick mark, 516
Tick Marks options for chart axes, 540
Tiled window arrangements, 257
time
formulas for elapsed,
363–364
general discussion, 361
in headers and footers, 288 inputting, 89–91
number formats, 154 overview, 361
Time functions
HOUR, 374
MINUTE, 374
NOW, 372–373 overview, 372 SECOND, 374
TIME, 373–374 TIMEVALUE, 373–374
Time option, Data Validation dialog box, 112
timeline filters, 685–686 TIMEVALUE function,
373–374 Tip icon, 9