T

table range, 11

naming cells used as, 13

tables.

See also PivotTables

banded rows, displaying, 197

conditional formatting in, 203

converting into ranges, 196

creating, 194

duplicate rows, removing, 197

filtering, 199–200

header row, displaying, 197

referencing, 201–202

renaming, 196

resizing, 196

styles, applying, 197–208

target cells in Excel Solver, 224

tax rates, computing, 12–13

team point spreads. See point spreads, calculating

text files

delimited, 259

fixed-width, 259

importing from, 259–263

text functions. See specific functions

Text Import Wizard, 259–263

text matching. See MATCH function

text strings

dividing into multiple columns, 32–35

first /i1k/i0 characters in, returning, 30

joining together, 31

last /i1k/i0 characters in, returning, 30

lowercase, changing to, 32

next m characters in, returning, 30

number of characters in, returning, 31

numerical values, converting to, 32

repeating, 31

replacing characters in, 31

spaces, removing, 31

uppercase, changing to, 32

text, filtering, 348

tie-ins, 555

tiling workbooks, 356

TIME function, 93

time series

base of, 431

defined, 427

graphing, 427

predicting, with Winter's method. See Winter's method

seasonality of, 431

trend of, 431

times.

See also date formats;

dates

# result, 75

computations with, 74–75

current, displaying, 93

and dates, in same cell, 74

entering, 74

extracting units from, 94

formats for, 74

intervals, creating, 95

in serial format, 91

text string conversion into, 93

total worked, calculating, 94

total worked, never more than 24 hours, 94

TIMEVALUE function, 93

TODAY() function, 40–41, 93

toggle switches. See check boxes

Top 10 Items conditional formatting rule, 165–166

tracing dependents, 104–105

tracing precedents, 105–106

in multiple worksheets, 106–107

tracking data. See PivotTables

transportation problems

defined, 235

target cell, setting, 236

TRANSPOSE function, 574

transposing data

between columns and rows, 98

between ranges, 99

trend curves, 373

TREND function, 403–404

trendlines

for calculating demand curves, 559

creating, 366, 368

decimal points, formatting, 369

exponential, 374

for maximizing profit, 559–561

moving averages, 428

TRIM function, 31–32

TRIMMEAN function, 292–293

two-part tariffs, 564, 566–569

two-way data tables

defined, 110

row and column input cells, separating, 113

setting up, 112