EXERCISE: 1. Download this file. 2. Open it in Excel. 3. Go through the steps outlined below and perform each one using the downloaded material. Getting to Know Your Workspace in Excel Excel is a spreadsheet program that allows you to store, organize, and analyze information. While you may think that Excel is only used […]
Microsoft Excel – Basics Read More »
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 »