Excel Tables
Page 18
ListRow Property 104
ListRows 97
Lists 6
Live Preview 76
Looping through columns
with VBA 117
Looping through rows
with VBA 116
M
Mac Excel 141
Filtering 142
Marketplace data 87
M code 61
MDX 54
ME 95
Members 94
Merged cells prevent appending 13, 23
Microsoft Query 87
for Crosstab queries 90
Moving columns 24
Multiple columns 39
N
Name manager 45
Name Property 100
Naming Conventions 15
N function 47
Number filters 68
O
Object model 93
Object variables 95
OData 87
ODBC 87
Office Mobile 143
OFFSET function
for Absolute 41
OLEDB 52, 87
OneDrive 131
Options 32
P
Parent Property 100
PivotDiagram 30
PivotTables 49
Power BI 51
Power Pivot 51
with Excel 2013 53
Power Query 6, 57
Editor window 59
Renaming columns 59
Publish Method 104
Pwer Pivot data model
with VBA 111
Q
Querying data 89
QueryTable Property 100
R
Range property 96
Reapplying filters
with VBA 119
Refreshing
External data 88
PivotTables 50
using VBA 50
Refresh Method 104
Remove duplicates 28
Repair formatting
with VBA 122
Resize Method 104
Resizing handle 22
Resizing table 10
Resources 148
Retrieving Crosstab query
with VBA 124
Row limits 52
Row number
Displaying 46
Running total 46
S
Sharepoint
Exporting to 28
Share Point
with Power Pivot 53
SharePointURL Property 101
ShowAutoFilter 97
ShowAutoFilterDropDown 97
ShowHeaders 97
ShowTableStyleColumnStripes 98
ShowTableStyleFirstColumn 99
ShowTableStyleLastColumn 99
ShowTableStyleRowStripes 99
ShowTotals 97
Sizing handle 9
SkyDrive 131
Slicers
Excel online 71
in Excel 2010 17
items with no data 71
Require header 73
Styles 72
Slicers Property 101
Sorting 65
by Color 65
Custom 66
State 67
Sort Property 102
SourceType Property 103
Special characters 43
SQL server
Connecting to 89
SQL Server 54, 87
SSAS 87
Stacking tables 12
Stripe size 81
Structured references 16, 35
Advantages 36
Operators 43
Syntax 35
Structured referneces
Disabling 42
Styles 63, 77
Copying to new workbook 85
for Cells 84
for Tables 75
Table elements 80
SUBTOTAL function 9
Bug in 2013 37
SUM function
to ignore headers 47
SUMIF function 41
Summary Property 103
Surveys 136
Syntax 35
T
Table
Limitations 10
Table name rules 14
TableObject Property 103
Tables 5
as PivotTable source 49
Convert to range 27
Creating 19
Defined 5
Formatting 75
Formulas 35
History 6
Parts of 7
Resizing 22
Unique name 10
versus List 11
TableStyle 98
Table styles 63
Table tools
in Ribbon 13
Testing
for Calculated column 9
Text files 87, 90
Theme colors 84
This row
versus @ 16, 39
ThisWorkbook 95
Timelines 73
Total row 8
Argument list 38
in Formulas 38
Must be single row 10
Toggling 32
TotalRowRange 96
U
Umlas, Bob 3
Unique headers 7
Unlink Method 105
Unlist Method 105
Unpivot 59
V
Validation 45
in Total row 38
Variables 95
VB
Does a table exist 129
VBA 93
Active property 99
Adding a column 106
Adding a ListObject 105
Adding rows 115
AlternativeText property 99
AutoFilter method 107
AutoFilter property 99
Clearing filters 119
Comment property 99
Converting to table 111
Copy new table style to workbook 123
Creating a table 111
Creating filters 118
DataBodyRange 96
Delete Method 104
Deleting a table 107
Deleting rows 115
DisplayName property 100
Does column exist 114
Does table exist? 113
ExportToVisio Method 104
Filtering 117
Filter state 118
Find a table address 114
HeaderRowRange 96
How many columns 114
How many rows 114
Icon sets 108
InsertRowRange 97
ListColumn property 103
ListColumns 97
ListObject 96
ListObject Object’s Add Method 105
ListRow property 104
ListRows 97
Looping through columns 117
Looping through rows 116
Name property 100
Naming a table 111
Object variables 95
Parent property 100
Power Pivot data model 111
Publish Method 104
QueryTable property 100
Range property 96
Reapplying filters 119
Refreshing PivotTables 50
Refresh Method 104
Repair formatting 122
Resize Method 104
Retrieving new Crosstab query 124
SharePointURL property 101
ShowAutoFilter 97
&
nbsp; ShowAutoFilterDropDown 97
ShowHeaders 97
ShowTableStyleColumnStripes 98
ShowTableStyleFirstColumn 99
ShowTableStyleLastColumn 99
ShowTableStyleRowStripes 99
ShowTotals 97
Slicers property 101
Sort property 102
SourceType property 103
Summary property 103
TableObject property 103
Table parts 110
TableStyle 98
TotalRowRange 96
Unlink Method 105
Unlist Method 105
with External data 112
XmlMap property 103
VertiPaq 52
Visio
Exporting to 30
VSTO 127
W
Web pages 87
Website
Companion 3
Websites 150
What-if tables 2
Wikstr, Max 3
Windows XP 54
X
XLSX file format
prevents VBA 51
XML data
with VBA 113
XML data import files 87
XML formatted files 17
XmlMap Property 103
xVelocity 52