In my first two Illumeo Google Sheets courses, we learned the foundations of Google Sheets, including how to create, format and share data within your spreadsheets. We also learned basic data manipulation through the use of formulas.

In this course, we continue along that path, focusing on intermediate-level formulas. This will give you more control over your data as well as the ability to extract more useful and powerful conclusions from your data.

Learning Objectives
  • Explore data manipulation through the use of formulas
  • Discover more complex formulas, including how to incorporate data across multiple tabs/sheets
  • Discover how to copy/paste/transform data across multiple cells, as well as consolidating multi-celled bits of data into single cells
  • Recognize how to extrapolate more detailed and complex information from your data inputs
Last updated/reviewed: March 28, 2024
1 Review (17 ratings)

Reviews

4
Anonymous Author
Pivot Tables would have been better if additional rows were added, showing how things get grouped. Concatenate alternatives was helpful.

Prerequisites
Course Complexity: Intermediate
  • Please complete Google Sheets Level 1 and 2
  • And just like in Level 1, 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
  Using Formulas Between Tabs3:43
  Count A Functions1:50
  Round Functions3:03
  Paste Special2:39
  Sumif Countif Functions5:52
  Split Text to Columns2:22
  Concatenate Function Intro2:10
  Concatenate Alternatives6:08
  Inserting Images3:21
  VLookup9:25
  Visualizing Data Using Graphs and Charts12:13
  Pivot Tables8:50
CONTINUOUS PLAY
  Google Sheets Level 3: Intermediate Data Analysis 1:01:35
SUPPORTING MATERIALS
  Google Sheets Level 3: Intermediate Data Analysis Glossary/IndexPDF
REVIEW AND TEST
  REVIEW QUESTIONS quiz
 FINAL EXAMexam