Analyzing Your Excel 2013 Data
- 2/15/2013
- Using conditional formatting to showcase data trends
- Adding sparklines
- Understanding Excel formulas and functions
- Performing common calculations
- Subtotaling data values
- Entering formulas
- Troubleshooting formulas
- Working with functions
- Creating and modifying data tables
- Sorting data
- Filtering worksheet data
- Creating PivotTables
- Viewing data instantly with Quick Analysis
Creating and modifying data tables
Instead of creating and formatting an entire worksheet, you might prefer to use a data table to store your Excel data. Excel 2013 includes a gallery of predesigned table formats that you can use to create the table. You can then work with table information and name and resize the table as needed.
Create an Excel table
Type your table headers in a single row.
Click any cell in the range from which you want to create a table.
On the Home tab, click Format As Table.
Click the desired table style.
Verify that Excel identified the data range correctly.
If your table has headers, select the My Table Has Headers check box.
Click OK.
Excel applies the data table format to your data.
Name an Excel table
Click any cell in the Excel table.
Click the Table Tools Design tab.
In the Properties group, type a new name for your Excel table and press Enter.
)
Resize an Excel table
Click a table cell.
Click the Table Tools Design tab.
In the Properties group, click Resize Table.
The Resize Table dialog box opens.
Specify a new cell range for the table.
Click OK.
)