Skip to content
Prolific Oaktree
  • Home Page
  • Training
  • Videos
  • Articles
    • Cloud Software
    • Desktop Software
    • Mobile Apps

Cloud Software

  • Google Sheets – Combining Tables With Different Data Using VLOOKUP
  • Google Sheets – Combine Data without Query | Different Worksheets
  • Google Sheets – SUM or COUNT Values If Cells Have Notes
  • Learn Two Methods to Identify Duplicates in Google Sheets
  • Google Sheets – Use Slicers to Filter a Pivot Table on the Fly
  • 4 Ways to Find the Top or Bottom Values Using Google Sheets
  • Collect Data into Google Sheets | Forms, Quizzes, Surveys
  • Google Sheets – Insert Sheet Names into Cells
  • G Suite vs. Free Google Apps | What is the difference?
  • Google Sheets | Conditional Formatting an Entire Row
  • Add an Email from Gmail into Google Keep – No Extensions
  • Google Sheets – Group Rows and Columns with Linked Example File
  • Google Sheets Inventory Tracking Template | Step-by-Step Tutorial
  • Google Sheets Pivot Tables – Basic Tutorial
  • Google Sheets – Group Data Inside a Pivot Table
  • Google Sheets – Pivot Tables | Summarize by Year, Month or Quarter
  • Google Sheets – Create an Interactive Task List
  • Combine Cell Contents from Two Different Columns in Google Sheets
  • How to Find the Plus Code for Any Location
  • Google Sheets – Compare two lists for matches or differences
  • 1
  • 2
  • 3
  • 4
  • >>

Google Sheets – Learn the Basics

Basics Course Thumbnail

Learn all of the foundational skills necessary to create and use spreadsheets.

  • Create and style your sheet
  • Use cell references
  • Create formulas
  • Sort and filter
  • Share and protect
  • Analyze with pivot tables

10 downloadable videos, LINKED GOOGLE SHEETS for you to copy and use, quizzes, and built-in notes. Lifetime access to the course.

Learn More

Prolific Oaktree on YouTube

This site has a companion YouTube channel that has pretty much, well almost exactly, the same content. If you like this, you'll like that.

Recent writings

  • Google Sheets – Combining Tables With Different Data Using VLOOKUP
  • Google Sheets – Combine Data without Query | Different Worksheets
  • Google Sheets – SUM or COUNT Values If Cells Have Notes
  • Learn Two Methods to Identify Duplicates in Google Sheets
  • Google Sheets – Use Slicers to Filter a Pivot Table on the Fly
  • 4 Ways to Find the Top or Bottom Values Using Google Sheets
  • Collect Data into Google Sheets | Forms, Quizzes, Surveys
  • Google Sheets – Insert Sheet Names into Cells
  • G Suite vs. Free Google Apps | What is the difference?
  • Google Sheets | Conditional Formatting an Entire Row
  • Create an Employee Timesheet Using Excel | Includes Overnight Shift
  • Add an Email from Gmail into Google Keep – No Extensions
  • Google Sheets – Group Rows and Columns with Linked Example File
  • Google Sheets Inventory Tracking Template | Step-by-Step Tutorial
  • Google Sheets Pivot Tables – Basic Tutorial
Cropped Logo

Written and Maintained by Adam Steinfurth forĀ ALS Properties, LLC.

© 2021 Prolific Oaktree | Bootstrap WordPress Theme