Index
SVG (Scalable Vector Graphics) icons, inserting, 551–552
SYLK (Symbolic Link) files, 581, 611
symbols, in worksheet outlines, 635–636
syntax errors, 423, 424
AutoCorrect and, 425
mismatched parentheses, 424
T
T-test tool, Analysis ToolPak, 766–767
Tab key, cycling through dialog boxes, 20
tab list, 5, 7
tabbed dialog boxes, 20
Table Import Wizard
loading data
from external Excel files, 798–800
from relational databases, 798
from SQL Server, 793–797
from text files, 798–800
Table Styles command, 113–114
Table Tools Design
Table Style Options, 114
Table Styles, 113–114
Tools
Insert Slicer, 110–111
tables
adding data, 105
components, 102–104
creating, 104–105
filtering data, 105–106, 108–112
formulas within, 225–229
linking to Power Pivot, 785–792
overview, 102
referencing data, 228–229
resizing, 104
sorting data, 105–108
style, changing, 112–115
summarizing data, 225–226
tabs
color, changing, 57
contextual, 12
creating, 202
in dialog boxes, 20, 21
rearranging, 203
task panes, 20–22
closing, 21
re-docking, 21
using the keyboard within, 21
templates
chart templates, creating, 522
custom, 170–172
default, 168–170
modifying, 168
viewing, 165–166
text
adding to cells, 608–609
alignment, changing, 122–127
case, changing, 256–256, 595–596, 865
cleaning, 265, 866–868
converting formulas to, 238
counting specific characters, 263–264
displaying at angle, 127
as data type, 30
editing in comments, 101
extracting characters, 258–259, 868–870
finding second instance of a character, 261
finding specific characters, 259–261, 865–866
formatting numbers in, 266–268
free-floating, adding to charts, 498
joining strings, 254–256
line breaks, adding, 264–265
matching in a list, 601–602
numbers identified as, 254
padding with zeros, 266
removing from cells, 607–608
removing spaces, 257–258, 598–599
replacing, 439
in cells, 607–608
shrinking, 125
splitting, 589–595
substituting, 262–263
trimming, 866–868
Unicode characters, 546–550
wrapping, 125
text boxes, creating, 253
text files
exporting data to Power Query, 853–854
expor ting to, 610–611
formats, 581
loading data into Power Pivot data model, 800–801
TEXT function
formatting numbers in text strings, 266–268
returning fiscal months, 288
Text Import Wizard, 581, 582, 583–587
Text number format, 50
Text to Columns command, 591–592
TextAlign property, TextBox control, 996
TextBox ActiveX control, 995–996