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

Cloud Software

  • Embed a Live Excel Spreadsheet into a Microsoft Sway Presentation
  • Embed a Google Doc into a Microsoft Sway Presentation
  • Create an Employee Timesheet Using Google Sheets Includes Template
  • Google Sheets – Compare two lists for matches or differences
  • Google Sheets – Show Formulas
  • Google Sheets – Count cells with text only – not numbers
  • Google Sheets – Count cells containing specific text
  • Google Sheets – Count cells that are not blank
  • Google Sheets – Count cells greater or less than an amount
  • Google Sheets – Add or subtract days months or years to a date
  • Google Sheets – Remove leading and trailing spaces
  • Google Docs | APA or MLA Hanging Indent Works Cited with Template
  • Google Sheets – Create drop downs from a range of data
  • Google Sheets – Create drop downs in less than one minute
  • Google Sheets – How to Sort Dates into Chronological Order
  • Google Docs – Create a Table of Contents with Page Numbers or Links
  • Google Sheets – Add a Pop-up Calendar Date Picker
  • Embed a Live Google Spreadsheet into a Google Document
  • Embed a Live Google Spreadsheet into Google Slides
  • Google Sheets | Insert a check box drop down using data validation
  • <<
  • 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