Instructor for this course
more

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: November 6, 2019

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 .
Course Syllabus
INTRODUCTION AND OVERVIEW
  3:43Using Formulas Between Tabs
  1:50Count A Functions
  3:03Round Functions
  2:39Paste Special
  5:52Sumif Countif Functions
  2:22Split Text to Columns
  2:10Concatenate Function Intro
  6:08Concatenate Alternatives
  3:21Inserting Images
  9:25VLookup
  12:13Visualizing Data Using Graphs and Charts
  8:50Pivot Tables
CONTINUOUS PLAY
  1:01:35Google Sheets Level 3: Intermediate Data Analysis
SUPPORTING MATERIALS
  PDFGoogle Sheets Level 3: Intermediate Data Analysis Glossary/Index
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM