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.
In another window, open the simulated banking statement by clicking the link next to this video.
This is a fictitious bank account statement, but most banking sites display information
in similar ways.
Any time you see a table on the Internet, you can copy and paste it into Google Sheets,
just like this.
Select the entire table of data.
Right click or use keyboard commands to copy the table from the website and paste it into your spreadsheet.
Some tables do not paste smoothly into a spreadsheet.
To fix this, experiment with paste special, which gives you more options for pasting.
For example: Use “Paste values” to paste only the text
contained in the original range of cells.
Use “Paste format” to copy the cell formatting without changing the text or formulas in your spreadsheet.
Next, add space at the top of your spreadsheet for a summary table.
In this area, you will calculate your total expenditures.
Then, you will create categories and total your spending in each category.
You could perform these calculations anywhere in the spreadsheet, but they are easy to see
at the top of the sheet.
Set aside a space to make these calculations.
To do this, you could insert individual rows above the table you copied.
Or, you could right click and add ten rows.
You could even copy ten blank rows and paste them at the top of the sheet.
But the fastest way is to insert multiple rows at once.
Highlight about ten rows of your spreadsheet.
Right click and insert 10 rows above the data you copied.
Then, freeze these rows so you will always be able to 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 dedicated for your calculations.
In the next video, you will use the SUM and SUM-IF formulas to calculate your expenditures.
Now, it’s your turn
Copy and paste the table from the banking website 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.