What You Will Learn In This Course:
Using Google Sheets
CLC 0112

The Basics of Google Sheets

In this video, we’ll fill out a budget. For this, we’ll create a new spreadsheet, enter text and numbers, use the fill handle, adjust column widths, and use mathematical formulas.

Formatting Worksheets

In this video, we’ll merge and center cells, change cell fill color, add cell borders, apply themes, and use text formatting to understand our document’s purpose better.

Enhancing Workbooks

In this video, we’ll be using some tools to enhance your workbook. We’ll learn how to display formulas, create a column chart, and move that column chart to a new sheet.

Charts and Graphs

In this video we’re going to create charts and graphs using our existing data sets and then customize them to fit our style goals.

Formulas

During this course, we are going to create formulas and reference other cells. Google Sheets is essentially a sophisticated calculator, and formulas are how we make those calculations.

Conditional Formatting

In this video, we will use format rules, format styles, and color scales to clarify our spreadsheet.

Sort and Filter

In this video, we will arrange data alphabetically and numerically, apply sorting hierarchy using columns, and use the filter tool to navigate through large amounts of data.

Importing Data

In this video, we’ll be importing a plain text file and a Comma-Separated Value or, CSV, file into Google Sheets.

Relative and Absolute Cell References

In this video, we’ll add and rename sheets to organize our workbook, use relative and absolute cell references to perform more advanced calculations, and then apply conditional formatting to increase the readability of our sheets.

PivotTables, Charts, and Filtering Data

With the PivotTable, you can take raw data and create customized summary reports. Data can then be filtered, or used to make a chart, and customized for maximum visual impact. The PivotTable feature once understood and learned, is indispensable for manipulating and making sense of your data.

Data Table

In this video, we will apply absolute and relative cell references to calculations. We will then use the fill handle to extend our calculations to other cells in a table. If you would like to follow along, make a copy of the start file that is bundled with this module.

Financial Formulas Part 1 - Future and Present Value Functions

In this video, we will apply the future value function to determine the amount of money gained on an investment over a period of time. Then, we will identify the current value of investments using the present value function. Finally, we will use the present value function to calculate how much money we can borrow for a mortgage loan.

Financial Formulas Part 2 - Rate, Payment, and Principal Payment Functions

In this video, we will devise the monthly interest rate on a loan. Next, we will discover the constant payment amount due for a loan after one month. And finally, we will determine the amount of principal paid on a loan after the first pay period.

Macros

We are going to describe what macros are and what they’re used for, and then create and use our own macro.

IF Function

In this video we will use IF Functions to return Conditional Values by using proper syntax and logical operators, create Nested IF functions for more complex scenarios, and use AND and OR functions.

Average IF

In this video, we will use the Average IF formula to discover averages from a data set. The criteria range, criterion, and average range are the three sections of the formula.

Sum IF and Count IF

In this video, we’ll utilize the SumIF and CountIF formulas to analyze data with conditional formulas. We’ll also use an asterisk within a CountIF formula to include more values.

XLOOKUP

This video is about using the XLOOKUP function in Google Sheets in a variety of ways. The viewer finds values in a table, adds a column to a table, and finds close values in a sorted table, all using XLOOKUP.

Histograms

Histograms are a helpful tool for representing data frequency. We will define what a histogram is, then we will create a histogram in Google Sheets.