Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)

In this chapter, you learned the following:

• The Spreadsheet Component, the PivotTable Component, and the Chart Component can be used to sort, filter, group, conditionally format, and perform other data analysis tasks over the Web.

• You can use Microsoft FrontPage to create Office Web Components in Web pages. You can also use the Office Web Components to host data published from Microsoft Excel workbooks on Web pages.

In the next chapter, “Introducing Online Analytical Processing,” you will learn

• What online analytical processing (OLAP) and online transaction processing (OLTP) are, and why they are important in the data analysis field.

• How OLAP can be used to inform business decisions.

• How OLAP features are used in Microsoft Office.