Target Audience: 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. This course is designed for experienced Excel users who have a vested interest in analyzing Excel data more effectively.

Pre-requisites: Before attending this course, students must have the following pre-requisites:

• Experience with analyzing business data to make decisions about products, projects, and strategic direction.
• The ability to create formulas, including advanced formulas using the Insert Function dialog box.
• The ability to create line graphs and column charts from Excel data.

Purpose: After completing the course, students will be able to 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.