Google Sheets for Beginners & Excel Users Who Need Sheets

The importance of being able to find the Google Sheets you create is key. We’ll create our first Google Sheet, then walk through accessing it again from startup.

Learn to enter data into cells and navigate between tabs

Learn to create simple user-friendly formulas using arithmetic operations like addition and multiplication. These skills will come in handy when you complete the monthly budgeting activity later in the course.

Sometimes having all your data on a single sheet becomes an eye sore and makes organization challenging. In this lecture we’ll discuss the differences between a sheet/tab and a workbook. In addition, we’ll introduce some cross tabular calculations related to the ones we covered in the last lecture.

When organizing a project organization is key, what we’ll do first is create the tabs/sheets within our Google Sheet workbook in order to keep things clean and easy to understand.

We’ll walk through some formatting techniques so that your key information is quick to find on each tab/sheet.

We’ll work with some additional cross tabular calculations in order to enhance the information our summary page holds.

When it comes to copying and moving data from one sheet to another, sometimes we can take entire columns and other times we just want specific segments. We’ll work through some popular methods here.

In this section we’ll work more in depth with these three functions and see how they can enable powerful summary statistics.

Sometimes you need to merge datasets from different tabs and copying and pasting each selection could get tedious and time consuming. Let this powerful function do the grunt work for you.

We’ll start with what type of data lends itself to this type of visualization. Then, focus on the steps in creating one, along with the key aspects when analyzing and explaining it to others.

Sometimes our summary pages are a great place to put together phrases and finalized statements, rather than retyping or copying and pasting we can use this function to automate the process.

We’ll start with what type of data lends itself to a given visualization, as well as the purpose of exploratory data analysis through visualization.

Here we work with a combination of categorical and quantitative variables to expand our ability to visualize as well as explain patterns with data.

Here we work with two quantitative variables to expand our understanding, as well as predictive capabilities.

In this lecture we work through the customization features available.