How To Create An Excel Table In Excel For Mac


show more Creating an Excel table provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Creating an Excel table

If you spend a lot of time working in Excel, you'll end up summarizing and maintaining data lists. A list is a set of columns - with each column containing a different category of information - and rows - where each row represents a full set of values. For example, if you track your company's sales by month, you can have columns representing the year, the quarter - in other words, January, February, March is quarter number one; April, May, June is quarter number two; and so on - then the individual month, and the sales for that month. A row would indicate a particular set of values.

So, for example, for the year 2009, quarter number 1, the month of January, you can have sales of just over $406,000. I'm going to take a moment to describe the characteristics of this data list. Then I'll show you why creating an Excel table makes managing your data lists easier. This table has four columns and, including the headers, 25 rows. It represents two years worth of data. You'll no...

Creating an Excel table
Video duration: 4m 43s 6h 32m Beginner

Viewers:

Creating an Excel table provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...