Lesson 7, Google Docs and Sheets for Professionals

1What Is It?

Google Docs and Sheets: Your Daily Professional Tools

Start with what students already know

How many of you have used Microsoft Word? Great. How many have used Excel? Good. Google Docs is Word in the cloud. Google Sheets is Excel in the cloud. But here is the key difference that changes everything: they are live, collaborative, and always saved automatically. There is no "Save" button in Google Workspace because saving happens every time you type a letter.

Today we are going deep into both tools: how to write and format a professional document in Google Docs, how to use real-time collaboration features, and how to build a working spreadsheet in Google Sheets that calculates and tracks things automatically. These two tools are used in virtually every remote job and every digital workflow. Mastering them is not optional.

📄

Google Docs

Word processor for professional documents, reports, letters, proposals, and shared notes. Live collaboration built in.

📊

Google Sheets

Spreadsheet tool for tracking, budgeting, scheduling, client data, and any calculation-heavy work.

🔄

Always in sync

Everyone with access sees the same document, in real time, on any device, from anywhere in the world.

🕐

Version history

Every change ever made is saved. Go back to any version at any time, see who changed what and when.

2Why Do I Need It?

Why These Tools Define Your Professional Value

Make it concrete

Let me tell you what happens in a real remote job. Your client sends you an email: "Please review the attached proposal and add your comments. Also, can you update the content tracker spreadsheet with this week's data?"

If you know Docs and Sheets, you open the shared document, you add precise comments in the right places, you switch the document to Suggesting mode instead of Editing so your changes are tracked, the client accepts or rejects them, and the document is cleaner. You then open the Sheets tracker, enter the new data, the formulas update automatically, the totals recalculate, and the job is done.

If you do not know these tools, you download the file, open it in Word, make changes, save it, re-attach it to an email, and the client now has two versions of the document that do not sync. This is why remote employers specifically ask for Google Workspace experience.

3Show Me

Google Docs: Professional Formatting and Collaboration

Part A: Document structure and formatting

A professional document is not just text on a page. It has hierarchy. Headings tell the reader where they are. Paragraph text gives the detail. Formatting creates visual breathing room and makes the document scannable before it is readable. Let me show you what a well-structured Google Doc looks like.

Client Onboarding Proposal

Prepared by Doris Onyia | October 2026

1. Overview

This proposal outlines the onboarding process for new clients joining the virtual support programme. All services begin with a 30-day discovery period to assess communication preferences and workflow needs.

Please clarify the timeline here. Does this apply to all packages?

2. Deliverables

Weekly email summary, monthly analytics report, and access to shared Google Drive folder with all deliverables archived by date.

Key Docs collaboration features

📝
Suggesting mode: Switch from "Editing" to "Suggesting" using the dropdown top right. Every change you make appears as a coloured suggestion the document owner can accept or reject. Use this whenever you are editing someone else's document.
💬
Comments: Highlight any text, then press Ctrl+Alt+M (or click Insert, then Comment). A comment bubble appears in the margin. The document owner is notified by email. Comments are resolved (not deleted) when addressed. This is the professional way to give feedback.
🕐
Version history: File, then Version history, then See version history. A sidebar shows every version ever saved, who made changes, and the date and time. Click any version to restore it. This has saved countless documents from accidental deletion.
⌨️
Headings for structure: Use Heading 1 for major sections, Heading 2 for subsections, Normal Text for body. This creates a document outline (View, then Show outline) that lets you navigate long documents instantly.

Essential Google Docs shortcuts

CtrlAltM

Add a comment

CtrlAltH

Open version history

CtrlShiftC

Word and character count

CtrlAlt1

Apply Heading 1 style

CtrlAlt2

Apply Heading 2 style

CtrlK

Insert a link

4Let's Do It

Google Sheets: Building a Working Tracker

Now switch to Google Sheets

Now we move into Sheets. The most important thing to understand about spreadsheets is that they are not just tables. They are calculation engines. Every cell can hold a value, a label, or a formula that calculates based on other cells. When you build a sheet correctly, changing one number updates everything else automatically. Let me show you with a real example every VA will use: a job application tracker.

G2 =IF(E2="Offer Received","✓ SUCCESS",IF(E2="Rejected","✗",IF(E2="Applied","Pending","")))

	A	B	C	D	E	F	G
1	Company	Role	Date Applied	Platform	Status	Follow-up Date	Result
2	Acme Ltd	Virtual Assistant	2026-10-01	LinkedIn	Interview	2026-10-15	Pending
3	BrightPath	Admin Assistant	2026-10-03	Indeed	Applied	2026-10-17	Pending
4	TechCo NG	EA to CEO	2026-10-05	MyJobMag	Rejected		✗
5	Global VA Hub	Remote VA	2026-10-10	Upwork	Offer Received		✓ SUCCESS
6	Total Applications:				=COUNTA(A2:A5)

Essential Sheets formulas every VA should know

Formula	What it does	Example
`=SUM(A1:A10)`	Adds up all numbers in a range	Total invoices, total hours, total spend
`=AVERAGE(B2:B20)`	Calculates the average of a range	Average response time, average rating
`=COUNTA(A2:A100)`	Counts all non-empty cells	How many applications, how many entries
`=IF(A2="Yes","Done","Pending")`	Returns one value if true, another if false	Status labels, pass/fail, yes/no
`=TODAY()`	Inserts today's date, updates daily	Tracking current date in a live tracker
`=VLOOKUP(A2,Sheet2!A:B,2,0)`	Looks up a value in another table	Pull a client's rate from a rates table

💡

Freeze your header row In any spreadsheet with more than 10 rows, freeze your header row so it stays visible as you scroll down. Go to View, then Freeze, then 1 row. This is one of those tiny things that makes working with a spreadsheet 10 times more pleasant.

5Now You Try

Build Your Own Docs and Sheets Documents

Set them to work

Here is your hands-on task for this section. You have 20 minutes.

First, create a new Google Doc. Write a short "VA Services Overview" document with at least one Heading 1, two Heading 2 sections, and body text under each. Then switch to Suggesting mode and make one edit. Then add one comment on any sentence.

Second, create a new Google Sheet. Build your own Job Application Tracker using the layout you just saw. Add at least 5 real applications you have made (or plan to make). Add a COUNTA formula at the bottom to count your total applications. Freeze Row 1.

Go now. I will come around and check on you.

🧊

Pro tip: use templates Google Docs and Sheets both have a Template Gallery (visible when you open a new document from drive.google.com). Browse the gallery for meeting notes, project proposals, and budget trackers. Starting from a template saves 30 minutes of formatting time on every document.

6Your Task

Lesson 7 Assignment

📋

This lesson's assignment Produce a professional Google Doc and a working Google Sheets tracker, both demonstrating the skills from this lesson.

1
Google Doc task: Write a "Virtual Assistant Services Overview" document (minimum 300 words). Use Heading 1 for the title, Heading 2 for at least 3 sections (Introduction, Services Offered, How to Get Started), and Normal Text for body paragraphs. Apply bold where appropriate. Change the mode to Suggesting and make 2 edits. Add 2 comments. Take a screenshot showing comments and suggesting mode active.
2
Google Sheets task: Build your Job Application Tracker with these columns: Company, Role, Date Applied, Platform Used, Current Status, Next Follow-up Date, Result. Add at least 5 rows of real or planned applications. Add a COUNTA formula. Add a SUM or COUNTIF formula for one other column. Freeze Row 1.
3
Check version history on your Doc (File, then Version history, then See version history) and verify that all your versions are saved. Take a screenshot showing the history panel open.
4
Complete the Lesson 7 Workbook and add this lesson's 5 prompts to your Prompt Library.

7What Did You Create?

A Professional Documentation and Tracking System

End on the transformation

You now know how to create documents that look like they came from a professional office environment. You know how to collaborate inside a live document without sending files back and forth by email. You know how to build a spreadsheet that does the calculating for you.

These are the exact skills that appear in remote job descriptions under "Google Workspace," "G Suite proficiency," and "collaborative document management." You just built your evidence that you can do them.

Next lesson is the final one in Module 2: Google Meet and Professional Video Communication. Then we move into Module 3, which is where the AI work really begins. Keep going.

Google Doc created with Heading structure, body text, and comments
Suggesting mode used and demonstrated
Version history checked and screenshot taken
Google Sheets tracker built with at least 5 rows and working formulas
Header row frozen in the spreadsheet

WWorkbook

Lesson 7 Student Workbook

✏️

Instructions Complete all 4 parts of this workbook. Your Google Doc and Google Sheets files are separate deliverables and should be saved in your Module 2 folder in Google Drive.

📄 Part A: Google Docs Reflection

What is the difference between Editing mode and Suggesting mode in Google Docs?

When would you use Suggesting mode instead of Editing mode? Give a specific example from VA work.

What shortcut do you use to add a comment in Google Docs? What is the benefit of using comments rather than editing text directly?

📊 Part B: Google Sheets Formulas

Write the formula you would use to count how many applications are in your tracker (assume data starts in A2 and goes down).

Formula:

Write an IF formula that puts "Follow up" if the Status column (E2) says "Applied" and "Done" if anything else.

Formula:

What does freezing a row do in Google Sheets? How do you do it?

🤝 Part C: Collaboration Skills

A client shares a Google Doc with you and asks for your feedback. What is the professional way to give feedback? Describe the process step by step.

Think about: what mode to use, how to add comments, how to communicate when you are done.

💬 Part D: Reflection

What is one thing about Google Docs or Sheets you did not know before this lesson that surprised you?

How will you use a Google Sheets tracker in your own work or job search from now on?

TTask

Build Your Professional Doc and Tracker

⏱️

Time: 40 to 55 minutes Output: A formatted Google Doc with commenting and suggesting, and a Google Sheets tracker with formulas, both saved in your Module 2 Drive folder.

Part 1: Create Your Google Doc

1
Go to drive.google.com. Open your Module 2 folder. Click New then Google Docs. Name the file "2026-10 VA Services Overview v1."
2
At the top of the document, type your heading. Highlight it and apply Heading 1 from the style dropdown (currently shows "Normal text"). Type: Virtual Assistant Services Overview
3
Press Enter twice. Type Introduction and apply Heading 2. Below it, type at least 2 sentences describing what a virtual assistant does.
4
Add a second Heading 2 section called Services Offered with a short bulleted list of 3 to 5 VA services (email management, calendar scheduling, data entry, etc.).
5
Add a third Heading 2 section called How to Get Started with 2 to 3 sentences on your onboarding process.
6
Click the mode dropdown in the top right (currently says "Editing"). Switch to Suggesting. Make 2 edits anywhere in the document. You will see them appear as coloured suggestions. Switch back to Editing mode.
7
Highlight a sentence, right-click and choose Comment (or press Ctrl+Alt+M). Add a comment that says "Review this section before sharing externally." Do this on a second sentence too. Take a screenshot showing both comments visible.

Part 2: Build Your Google Sheets Tracker

1
In your Module 2 folder, click New then Google Sheets. Name it "2026-10 Job Application Tracker v1."
2
In Row 1, type these headers one per column: Company | Role | Date Applied | Platform | Status | Follow-up Date | Result. Then select all of Row 1, make the text Bold, and change the background fill colour to dark blue or dark green using the paint bucket icon.
3
Freeze Row 1: Go to View, then Freeze, then 1 row. Scroll down and confirm the header stays visible.
4
Enter at least 5 rows of job applications (real or planned). Fill in Company, Role, Date Applied, Platform, and Status for each. Use "Applied," "Interview," "Rejected," or "Offer Received" as Status values.
5
In cell A8 (or below your last entry), type Total Applications: In the cell next to it, type =COUNTA(A2:A7). Confirm it counts your entries correctly.
6
In the Result column (G2), type this formula: =IF(E2="Offer Received","SUCCESS",IF(E2="Rejected","Rejected","Pending")). Then drag the formula down to apply it to all rows using the small blue square at the bottom-right of the cell.
7
Take a screenshot of your completed tracker showing the formulas working and the frozen header row visible.

Part 3: Check Version History

1
Go back to your Google Doc. Click File, then Version history, then See version history.
2
In the right panel, you will see all saved versions with timestamps. Click the one labeled "Today" to expand it and see each autosave. Your name appears next to changes you made.
3
Click Name this version at the top of the panel. Name it "Lesson 7 Original." This creates a named checkpoint you can always return to.
4
Take a screenshot of the version history panel open with your named version visible.

📄

Documents Built. Spreadsheet Functional.

You now produce professional documents and working trackers. These two files go directly into your VA portfolio as evidence of Google Workspace proficiency.

AIPrompts

Lesson 7 Prompt Library

📖

Add to your Prompt Library Google Doc Open your "My AI Prompt Library" document, add the heading "Lesson 7: Google Docs and Sheets for Professionals," and paste all five prompts below it.

Google Docs and Sheets AI Prompts

Prompt 1: Draft a professional document from scratch

"I need to create a professional Google Doc for [describe the purpose, e.g. a client onboarding guide, a project proposal, a services overview]. The audience is [describe who will read it]. The document should cover: [list 3 to 5 key sections or topics]. Please write the full document with Heading 1 for the title, Heading 2 for each section, and clear body text for each section. Keep the tone [professional/warm/formal] and the total length around [word count] words."

Use this whenever you need a polished Google Doc quickly. Paste the output directly into your Doc, then apply the correct heading styles manually.

Prompt 2: Edit and improve an existing document

"Here is a section of a Google Doc I am working on: [paste your text]. Please improve it by: making the language more professional and concise, fixing any grammar or spelling issues, making sure each paragraph flows into the next, and suggesting any missing information that would strengthen this section. Keep all the key points I have written. Show me the improved version."

Paste this entire prompt including your draft text. Copy the improved output back into your Google Doc in Suggesting mode so you can review the changes.

Prompt 3: Design a Google Sheets tracker for my needs

"I need to build a Google Sheets tracker for [describe what you are tracking, e.g. client deliverables, social media content, weekly tasks, invoices]. The tracker needs to show me [describe what information matters, e.g. what is done vs. pending, what is due this week, totals by category]. Please give me: the exact column headers I should use in Row 1, a description of what goes in each column, and 2 to 3 useful Google Sheets formulas I should add to make the tracker calculate automatically."

This creates a blueprint for any spreadsheet. Once you have the column layout, building it in Sheets takes 10 minutes.

Prompt 4: Explain a Google Sheets formula

"I am working in Google Sheets and I need help with a formula. Here is what I am trying to do: [describe the calculation or logic in plain English, e.g. 'I want to count how many rows in column E say the word Applied', or 'I want to add up column C only if column D says Yes']. Please write the exact formula for me, explain how it works in simple language, and tell me which cell to put it in. I am a beginner so please be clear."

Use this any time you are stuck on a formula. Describing what you want in plain English is often faster than trying to Google the formula name yourself.

Prompt 5: Write meeting notes in Google Doc format

"I attended a meeting about [describe the meeting: topic, who was there, what was discussed]. Here are my rough notes from the meeting: [paste your raw notes, even if they are messy]. Please turn these into a clean, professional meeting notes document formatted for Google Docs. Include: Meeting Title and Date at the top, a short Summary paragraph, an Attendees section, a Key Discussion Points section with bullet points, and an Action Items section with each task, the person responsible, and the deadline."

Being the person who sends clean, readable meeting notes after every call is a habit that makes you unforgettable as a professional. Use this prompt after every important meeting.