Analyze data with excel for the web

Add tables, charts, etc.

Use the Insert tab to insert functions, forms, tables, pictures, shapes, charts, and hyperlinks.

To insert rows, columns and cells, see the right side of the Home tab.

Quickly calculate with AutoSum

1. Select the cell below the numbers you want to add.

2. Select Home > AutoSum .

3. Press Enter.

Tip: For more calculations, select the down arrow next to AutoSum, and select a calculation. You can also select a range of numbers to see common calculations in the status bar. See View summary data on the status bar.

Filter data with a table

Make your data into a table to create filters:

1. Click inside your data.

2. Select Insert > Table.

Freeze the top row of headings

Freeze the top row of column headings so that only the data scrolls.

1. Press Enter or Esc to make sure you're done editing a cell.

2. Select View > Freeze Panes > Freeze Top Row.

Next: Tips for Excel for the web