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.

Computer with Microsoft Excel.

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.

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

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

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

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

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

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.