Belajar basic Google Sheets dan Microsoft Excel untuk Data Entry Virtual Assistant Part 2

Main ideas / lessons conveyed

• Google Sheets vs. Microsoft Excel (core similarities): Google Sheets is very similar to Microsoft Excel in basic structure and features (e.g., formulas and cell references).

• Creating and naming a spreadsheet: When you open Google Sheets in Chrome, you can start with a blank spreadsheet and then name it (example given related to data entry work).

• Sharing and collaborating (key advantage of Google Sheets):

  • You can share Google Sheets via email or a shareable link.
  • You can control permissions for invited people, including:
    • Viewer: can only see
    • Commenter: can add comments but not edit
    • Editor: can edit collaboratively

• Working simultaneously (real-time collaboration):

  • Microsoft Excel is described as generally not online live in the same way; sharing typically happens via email or file transfer.
  • Google Sheets is preferred for real-time collaboration and faster updates when sending results.

• Basic formula usage (mathematical functions and cell references):

  • Common formulas and concepts demonstrated:
    • SUM (addition) across cells
    • Example cell references such as F17, F18, etc.
    • AVERAGE (average value)
    • MAX (largest value) and MIN (smallest value)
  • Key terminology:
    • Column = letter code (e.g., B)
    • Cell = column + row coordinate (e.g., B74 to B78)

• Avoiding manual work with drag features: You can apply formulas efficiently by dragging them to other cells instead of recalculating manually.

• Using comments for review/feedback: People with comment-only access can leave feedback on specific cells without changing the spreadsheet.

• Version/format flexibility:

  • You can copy/duplicate files.
  • You can import existing files.
  • Download options include multiple formats: .xlsx, .ods, .pdf, .html, .csv, .tsv.

• Image insertion (for spreadsheets used in data entry / virtual assistant tasks):

  • Ways to add images:
    • Insert an image directly into the sheet.
    • Paste/copy-paste an image into the sheet.
    • Insert via placement options (e.g., “three dots”).
  • Overlay vs. inserting into a cell: “Over” means the image sits on top of the sheet surface rather than being strictly contained within a specific cell.

---

Methodology / step-by-step instructions included

Share and set permissions in Google Sheets

1. Open your spreadsheet in Google Sheets.
2. Use Share to share with others via:
   • Email address(es), or
   • A link
3. When sharing via link/email, set the permission level:
   • Editor: can edit and collaborate
   • Commenter: can add comments but cannot edit
   • Viewer: can only view
4. For feedback workflows:
   • Invite Commenters to review specific cells and add evaluation notes.
   • Editors can continue working without being disrupted by comment-only users.

Enter and understand formulas (basic Excel/Sheets logic)

1. Use function names (e.g., SUM, AVERAGE, MAX, MIN).
2. Use cell references to calculate results from specific cells.
3. Apply formulas across ranges:
   • Use a function to sum across multiple cells (including proper use of ranges such as parentheses/brackets).
4. Replicate calculations quickly:
   • Drag the formula across cells to apply the same logic to other rows/columns.

Insert images into the spreadsheet

1. Choose an image insertion method:
   • Insert image using Sheets Insert option.
   • Use copy-paste (e.g., screenshot → copy → paste into Sheets).
   • Use placement options such as:
     • Overlay / “over several cells” (image floats above the sheet)
     • Insert into a selected cell (image may need resizing if small)
2. If the image appears too small:
   • Enlarge it so it’s readable.

---

Speaker(s) / sources featured

• Speaker name: No specific speaker name is provided in the subtitles (referred to generally as “friends” / “Sis”).
• Source platform mentioned: YouTube, Google Chrome, Google Sheets, Microsoft Excel.