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: August 24, 2023
2 Reviews (20 ratings)

Reviews

4
Anonymous Author
A little basic for a level 2 course. A lot of repetition, especially in the budget exercise which was too long. Would rather have learned other new things.

5
Anonymous Author
Detailed instruction by author. Refresher course still if you know Excel.

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 .
Instructor for this course
Course Syllabus
INTRODUCTION AND OVERVIEW
  Introduction to Google Sheets Level 2: Intro To Formulas & Data Manipulation4:13
  Working With Numbers4:00
  Creating Dropdown List5:58
  Fill Handle:“Magic Blue Dot”4:14
  Filtering Info5:11
  Sorting Info3:37
  Ranking Info9:37
  Intro To Conditional Formatting7:56
  Intro To Data Validation3:57
  Autosum & Average “Bonus” Tool1:34
  Budget Exercise10:00
  Budget Exercise Continued & Conclusion15:00
Continuous Play
  Google Sheets Level 2: Intro To Formulas & Data Manipulation Full Video1:15:17
Supporting Materials
  Google Sheets Level 2: Intro To Formulas & Data Manipulation Glossary/IndexPDF
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam