| |
|
| |
Make Sense of Your Sales and Product Data with Pivot Tables using Excel Training Class
Course ID: 5979
|
|
| |
|
|
| |
|
|
| |
Make Sense of Your Sales and Product Data with Pivot Tables using Excel Training Seminar
Overview:
Students will learn how to use PivotTables to summarize large amounts of data and analyze large amounts of data.
Who Should Attend:
Students enrolling in this course should understand how to: - Open, create, and save a worksheet - Navigate in a worksheet and workbook
At Course Completion:
Upon successful completion of this course, students will be able to: - Create a PivotTable based on sales data and make the summary easier to read by grouping data and applying formatting. - Use PivotTables to answer questions about sales by category and region by month and use a chart to view the summary graphically. Students will also be able to use a PivotTable to summarize the performance of sales representatives. - Analyze the buying patterns of customers by using PivotTable and a variety of summary functions. - Use PivotTables to summarize the results of two different kinds of business surveys.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Lab 1: Make it easy to read
Begin with you raw data
Create a PivotTable
Group some data
Apply some formatting
|
|
Lesson 2: Lab 2: See sales trends
What were sales by category by month?
What were the trends?
What products are doing well?
How did each sales rep do?
|
Lesson 3: Lab 3: Spot market patterns
What did customers buy?
Who were our biggest customers?
What products do best in each region?
|
Lesson 4: Lab 4: Analyze product surveys
Are customers satisfied?
What's the most important feature?
|
|
| |
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Make Sense of Your Sales and Product Data with Pivot Tables using Excel Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5979
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|