Activity Overview Pivot tables provide you the ability to to extract significance from a large detailed data set. The following activity illustrates how to drill into data to summarize, analyze, explore, and present your data. New Skill In this activity, you will practice how to: Create a pivot table using a large data set. Drag […]
Microsoft Excel – Lesson 10 Read More »
Activity Overview There are 1’000’s of uses for spreadsheets. The following activity illustrates how they can be used to create a bar graph to analyze the frequency of popular music downloads. New Skill In this activity, you will practice how to: Create a column chart. Change text alignment. Change the major and minor units of frequency
Microsoft Excel – Lesson 9 Read More »
Activity Overview The following activity illustrates how spreadsheets can be used to analyze data and use charts that illustrates the data distribution. New Skill In this activity, you will practice how to: Create a pie chart. Enhance charts by changing colors and font sizes. Lesson Open the AMERICAN IDOL.xls file. Create a Pie Chart as
Microsoft Excel – Lesson 8 Read More »