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

Desktop Software

  • Create an Employee Timesheet Using Excel | Includes Overnight Shift
  • Excel – Calculate age with the DATEDIF function
  • Text boxes in Excel – How and when to use them with Examples
  • Using text boxes in spreadsheets – Better than typing into a cell
  • Seven ways Excel is better than Google Sheets with examples
  • Excel formulas showing as text and the trick for fixing it
  • ProSystem fX Engagement – “Partially Failed” Sync
  • Acrobat – How to use letterhead on different pages

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