Course curriculum

  • 1

    Introduction to Google Sheets

    • Introduction to this Unit

    • Navigating to Sheets

    • Creating a New Sheet

    • Navigating a Google Sheet & Cell Naming

    • Changing Column/Row Sizes & Moving Columns/Rows

    • Adding a Column or Row

    • Deleting a Column or Row

    • Adding Fill/Highlight Colors to Cells, Rows or Columns

    • Adding Alternating Colors

    • Freezing a Row

    • Creating an In-cell Dropdown Menu

    • Keyboard Shortcut Review

    • Comfort Check
  • 2

    Basic Formulas & Functions

    • Creating a New Sheet

    • The SUM Function

    • The COUNT Function

    • The AVERAGE Function

    • The MIN and MAX Functions

    • Subtraction, Multiplication and Division

    • Comfort Check
  • 3

    Using Formulas & Functions

    • Relative Reference Formulas

    • Absolute Reference Formulas

    • Combining Arithmetic Formulas

    • VLOOKUP

    • Adding Another Sheet Within the Workbook

    • Using Functions Across Sheets

    • Comfort Check
  • 4

    Data Management & Analysis

    • Sorting Cells in Ascending or Descending Order

    • Sorting Multiple Columns, Multiple Criteria

    • Introduction to Filters

    • Comfort Check
  • 5

    Formatting in Google Sheets

    • Hiding Columns

    • Merging Cells

    • Cell Borders

    • Conditional Formatting

    • Comfort Check
  • 6

    Wrap Up & Review

    • Congratulations on Completing this Course!

    • Optional: Let us know your thoughts!