Skip to main content

    Google Sheets

    Free Excel. Track + organize.

    Why Google Sheets?

    • FREE forever.
    • Auto-saves to cloud.
    • Share with family.
    • Works on any device.
    • Phone, tablet, computer.
    • Same as Excel mostly.

    Open + create

    • Go to sheets.google.com.
    • Sign in with Google account.
    • Click "Blank" for new sheet.
    • Or pick template.
    • Type name top-left.
    • Auto-saved.

    Senior uses

    • Track expenses.
    • Medication schedule.
    • Family contacts list.
    • Christmas card list.
    • Bill due dates.
    • Doctor appointments.
    • Tax preparation worksheet.

    Basics

    • Click cell, type, press Enter.
    • Bold = Ctrl+B (Cmd+B Mac).
    • Make formulas: =SUM(A1:A10).
    • =AVERAGE(B1:B10) for averages.
    • Resize column — drag right edge.
    • Add row — right-click row number.

    Templates save time

    • File > New from template.
    • Budget templates built-in.
    • To-do list template.
    • Calendar template.
    • Travel planner.
    • Inventory list.

    Share with family

    • Click blue "Share" button.
    • Type email address.
    • Choose viewer or editor.
    • They get email link.
    • Edit together in real-time.
    • See who's viewing now.

    Help available

    YouTube — "Google Sheets for beginners". Help menu in Sheets — top right. Google Help Center. Library has Sheets books. Senior centers offer classes. Cousin or grandkid can show in 30 minutes. Once basics learned — opens countless uses. Free + valuable senior skill.

    Google Sheets Basics for Seniors | TekSure