Index_E

E

Editor, Visual Basic, 290–91

elements, XML, 37, 262–63

encoded XML, 277

encryption, Access, 340

English queries, 14

Enterprise Manager, 331–32, 336, 337

events, 290

Excel, 41–94

Analysis ToolPak, 73–88, 349. See also Analysis ToolPak, Excel

charting data, 29, 57–61, 346–47

conditional formatting, 54–57, 346

data lists, 70–73, 345–46, 348–49. See also data lists, Excel

exporting Data Analzyer views to, 254–56, 361

features, 12, 41–42, 202

as file-based, 11, 194

files as PivotTable report data sources, 105–8

filtering data, 25, 44–49, 62–63, 345–46

formatting data, 26

importing external data, 61–63, 347

importing external data from, to Access, 133–36

multidimensional data, 35–36

nonrelational data, 129–30

OLAP data analysis. See Excel, OLAP data analysis with

PivotTable and PivotChart reports. See PivotChart reports, Excel; PivotTable reports, Excel

programming, using code. See code, programming Excel using

publishing data from, to Spreadsheet Component, 165–66, 356. See also Spreadsheet Component

querying external data, 63–70, 347–48

querying Web data, 67–70, 348

quick reference, 345–49

Solver Add-In, 89–93, 349

sorting data, 21, 42–44, 49, 345

summarizing data, 22–23, 348–49

trending data, 24

worksheet functions, 49–54, 346

XML data analysis. See Excel, XML data analysis with

Excel, OLAP data analysis with, 207–24, 349–51

connecting to OLAP data, 208–14, 349–51

creating offline cubes, 17, 218–24

data connection file types, 213

features, 204–5

PivotTable reports and, 214–18

quick reference, 349–51

Excel, XML data analysis with, 266–76

opening and saving XML data using code, 311–13

Web queries and, 275–76

XML spreadsheet flattener and, 266–70

XML Spreadsheet Schema and, 270–75

explosion, 28

exporting

Access, 151, 277–80

data analysis and, 3–4, 27

Data Analyzer views, 17, 254–57, 361

Excel, 270–75

expressions, multidimensional, 246

extending features. See code

Extensible Markup Language. See XML data

Extensible Stylesheet Language (XSLT), 264

external data. See also data sources

Access and, 132–37, 353

Chart Components and, 185

Data Analyzer and OLAP data, 232–35. See also Data Analyzer

data connection file types, 213

Excel and, 61–70, 208–11, 347–51

importing, exporting, querying, and, 27–28. See also exporting; importing; querying

Office Web components and OLAP, 211–14

OLAP data, 208–14

PivotTable Components and, 175

PivotTable reports and, 106

Spreadsheet Components and, 167