Job Aid: How to Make a Simple Excel Table

I made a basic Excel table to show how easy it is to gather and analyze data using Microsoft Exce.

Supplies

Computer with Microsoft Excel.

Step 1: Request Received

Your boss needs help preparing a sales presentation for his boss, but he does not know how. He sends you this email and needs to it to look good by end-of-day today.

Step 2: Open Excel

First, you will open Excel and select the New Blank Workbook button on the top left of the screen.

Step 3: Enter Header Titles

Enter the required header titles. In our example, we will use Employee, Sales, and Earnings ($).

Step 4: Enter Employee and Sales Data

Add in each employee's name, number of sales, and earnings in the applicable columns.

Step 5: Select Data to Build Table

Next, you will click cell A1 and drag to cell C5 to select your table data.

Step 6: Analyze Data

Select Analyze Data to have Excel suggest the best method to analyze our table data. 

Step 7: Finished

Pick you preferred Analyzation method. For this example, I want to know how many total sales the team made and the average earnings of each sales rep. Select the applicable table to add it to you workbook.