Spreadsheet Quick Tips

Video quick reference for how to accomplish different spreadsheet tasks.

Importing a CSV

How to import a CSV file into Google Sheets.

Moving the header line

How to make it known that the first row is a header.

Hide columns

How to clean up a spreadsheet by hiding columns. By not removing them, we can add them back in later if need be.

Create calculated columns

Create a new column and derive it based on a formula applied to existing columns.

Create a filter view

Create a filter view to sort columns and filter the values in columns.

Making a simple chart

Creating a chart on one column of data. Showcases how to create a chart from a column, change the chart type, and dive into chart settings to customize the cart.

Making a simple pivot table

Creating a pivot table in a new sheet. Showcases how to select a row, add a value, changing the value aggregation type, and sort by the value within the rows.