4003 Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions

One of the great challenges business people face today is not collecting information, but making sense of the information they already have. Within the endless rows of Microsoft® Excel® data is information that can help you make better business decisions, but how can you filter you way through all that information? This course, through hands-on activities, will teach you some of the most effective techniques in data summary and display. It covers the role of business intelligence in today’s workplace and introduces the power of Excel in business intelligence analysis. Students also learn how to hone their skills regarding data lists and PivotTables.

	Describe the role business intelligence plays in organizational planning and explain how to extend business intelligence analysis beyond the spreadsheet.
	Use data lists and SUBTOTAL formulas to summarize their Excel data.
	Create and use PivotTables to visualize worksheet data.
	Limit the data displayed in a PivotTable to only the data needed to make a specific decision.

This course is designed for experienced Excel users who have a vested interest in analyzing Excel data more effectively. This audience is familiar with tracking project budgets and chart trends, and they have no difficulty using Excel to create formulas, charts, and cell formats.