Now that we have a solid grounding in how to get around in Google Sheets, as well as how to enter and style data in the program, we will begin learning how to manipulate that data through formulas and other tools.
At its heart, Google Sheets allows us to organize information in helpful ways, and consequently make decisions that affect our lives, organizations and even families. Whether we’re creating a yearly spending budget that tells us how we’re going to get out of debt, or we’re building an profit-focused inventory list that helps us determine where to focus our marketing efforts and get the biggest return on investment (ROI), data manipulation in Google Sheets gives us the power to create forward momentum through informed analysis. Google Sheets Level 2: Intro To Google Sheets Formulas & Data Manipulation will teach you how to begin using these tools.
Learning Objectives
- Explore various ways to work with numbers inside Google Sheets
- Discover how to use basic-to-intermediate formulas in Sheets
- Discover how to use tools like Filter and Sort for greater control over your data
- Identify how to use Conditional Formatting to change the appearance of cells based on their input
- Recognize the power of Data Validation and how it helps shorten time and effort, as well as reduce repetitive inputs
2 Reviews (22 ratings)
Reviews
Prerequisites
Please complete the course entitled "Master Google Sheets Basics in 60 Minutes or Less" before taking this course. And just like in that course, please make sure you have a Google account. This is free (as is the use of Google Sheets). You can open a new Google account at www.Google.com. If you already have a Google or Gmail account, make sure you have the login and password to access it/them.