Skip to content

2. Copy Data and Create a Summary Table

Playback Speed:
Transcript

In this video, you will import data from a banking website into your spreadsheet and freeze a set of rows to create a summary table.

Open the simulated banking statement by clicking the link next to this video.

This is a fake bank account statement, but most banking sites display information in similar ways.

Click and drag to select the entire table of data.

Right click or use keyboard commands to copy the table from the website.

When you paste data into a spreadsheet, you also paste the formatting.

To paste the values with no formatting, right click and select “Paste Values Only.”

Next, add space at the top of your spreadsheet for a summary table.

Highlight ten rows of your spreadsheet.

Right click and insert 10 rows above the data you copied.

Then, freeze these rows so you will always see them as you move around your spreadsheet.

Highlight the tenth row and select “Freeze up to current row.”

Now you have a space at the top of your spreadsheet for your calculations.

In the next video, you will use formulas to calculate your expenditures in this summary table.

Now, it’s your turn: Copy the table from the website and paste it into your spreadsheet.

Create a summary table by adding ten rows to the top of your spreadsheet and freezing those rows.

Then, move on to the next video.

Next
Instructions
  1. Copy and paste the table from the banking website into your spreadsheet.
  2. Create a summary table by adding ten rows to the top of your spreadsheet and freezing these rows.
Attributions
  • "NFL Statistics - 2016" by ESPN (http://www.espn.com/nfl/statistics)
  • "Most common words in English" by Wikipedia (https://en.wikipedia.org/wiki/Most_common_words_in_English)