Instructor for this course
more

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 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

 

 

Last updated/reviewed: November 14, 2019

Prerequisites

Course Complexity: Intermediate

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.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
  4:13Introduction to Google Sheets Level 2: Intro To Formulas & Data Manipulation
  4:00Working With Numbers
  5:58Creating Dropdown List
  4:14Fill Handle:“Magic Blue Dot”
  5:11Filtering Info
  3:37Sorting Info
  9:37Ranking Info
  7:56Intro To Conditional Formatting
  3:57Intro To Data Validation
  1:34Autosum & Average “Bonus” Tool
  10:00Budget Exercise
  15:00Budget Exercise Continued & Conclusion
Continuous Play
  1:15:17Google Sheets Level 2: Intro To Formulas & Data Manipulation Full Video
Supporting Materials
  PDFGoogle Sheets Level 2: Intro To Formulas & Data Manipulation Glossary/Index
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM