Welcome!
This page contains the templates, formulas, and tools I use in my YouTube tutorials.
Everything here is free to copy and modify for your own projects.
You'll find:
• Google Sheets templates
• Useful formulas
• ChatGPT prompts
• Study tools
<hr>
Start here:
• <a href="https://docs.google.com/spreadsheets/d/1tQ48hV3O0A_8DDYf2C8InJQu6y7dS6avZKY-Na5lZkc/edit?usp=sharing">Google Sheets Everyday Use Cases</a>
• <a href="https://docs.google.com/spreadsheets/d/1edWuI6V8SmDc0OqCCBQn8CDY6apJlyOkJnRReu9Q1hk/edit?usp=sharing">Monthly Financial Tasks</a>
How to use the templates:
1. Open the Google Sheet link
2. Click File → Make a copy
3. Save it to your Google Drive
![[Screenshot 2026-03-10 at 13.37.00.png]]
---
<div id="mc_embed_signup"><form action="https://zheniavasilievdesign.us4.list-manage.com/subscribe/post?u=78f3dea3b7aa1c33329e26193&id=1c48d8db33&f_id=00fbdaedf0" method="post" target="_blank" novalidate><h2 id="subscribe">Join the newsletter.</h2><p>New templates are released occasionally.
Join 10+ readers learning practical Google Sheets tips!</p><div style="margin-bottom:12px;"><label for="mce-EMAIL">Email Address <span style="color:red;">*</span></label><br><input type="email" name="EMAIL" id="mce-EMAIL" required style="width:100%;max-width:420px;padding:8px;"></div><div style="margin-bottom:12px;"><label for="mce-FNAME">First Name</label><br><input type="text" name="FNAME" id="mce-FNAME" style="width:100%;max-width:420px;padding:8px;"></div><div style="position:absolute;left:-5000px;" aria-hidden="true"><input type="text" name="b_78f3dea3b7aa1c33329e26193_1c48d8db33" tabindex="-1" value=""></div><button type="submit" style="padding:10px 18px;background:#2563eb;color:white;border:none;border-radius:6px;cursor:pointer;">Subscribe</button></form></div>
<hr>
#### Google Sheets Templates
<table>
<thead style="background-color:#E6E6E6;">
<tr>
<th>Template</th>
<th>What it does</th>
<th>Template</th>
<th>Video</th>
</tr>
</thead>
<tbody>
<tr>
<td>Google Sheets Everyday Use Cases</td>
<td>Examples of practical ways to use Google Sheets for daily tasks like tracking, organizing information, and simple automation.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1tQ48hV3O0A_8DDYf2C8InJQu6y7dS6avZKY-Na5lZkc/edit?usp=sharing">Open template</a></td>
<td><a href="#">Watch video</a></td>
</tr>
<tr>
<td>Shopping</td>
<td>A simple shopping list that helps organize items, quantities, and planning before going to the store.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1NRFECEFqYz5QKaLXTxLYXRD2SUP_5GhPJJch0wElD5g/edit?usp=sharing">Open template</a></td>
<td><a href="https://www.youtube.com/watch?v=pJ7Ttc3LF-k&t=1s">Watch video</a></td>
</tr>
<tr>
<td>Spanish Vocabulary Capture</td>
<td>A structured sheet for collecting and organizing Spanish vocabulary while studying or reading.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1R2LLjZ1XpdgtonjdfQnlIwkwN4vVKXGwuoaVAgID-_Y/edit?usp=sharing">Open template</a></td>
<td><a href="https://www.youtube.com/watch?v=StAvvjM84I0&t=2s">Watch video</a></td>
</tr>
<tr>
<td>Simple Currency Converter</td>
<td>A Google Sheets setup that converts currencies automatically using live exchange rates.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1vwgwkMQ-YwkjkTypP0ickn6-XZhghNdxq2Gqa0NIivY/edit?usp=sharing">Open template</a></td>
<td><a href="https://www.youtube.com/watch?v=6LyskSgpLP8">Watch video</a></td>
</tr>
<tr>
<td>Simple Dropdown</td>
<td>An example sheet showing how to create and use dropdown lists for cleaner data entry.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1tsLRWGtwPPTpQBs8bNgUJCmOd2ydClwrWzWj3SXz-ck/edit?usp=sharing">Open template</a></td>
<td><a href="https://www.youtube.com/watch?v=K6sSntSzroU">Watch video</a></td>
</tr>
<tr>
<td>Monthly Financial Tasks</td>
<td>A checklist-style sheet for tracking recurring monthly financial tasks and staying organized.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1edWuI6V8SmDc0OqCCBQn8CDY6apJlyOkJnRReu9Q1hk/edit?usp=sharing">Open template</a></td>
<td><a href="https://youtu.be/jE5FEwN12RI">Watch video</a></td>
</tr>
</tbody>
</table>
<hr>
#### ChatGPT prompts
> [!note]- Vocabulary Table Generator
>
> **Role:**
> You are a Spanish language assistant.
> \**Task:**
> Take a provided list of Spanish words or phrases and generate a tabular vocabulary reference.
> \**Context:**
> \- The user will provide a list of Spanish words/phrases.
> \- If the number of words is over 100, you must break the response into chunks of 100 rows at a time, to avoid output overload.
> \- Each entry in the table should show the word/phrase alongside a natural, contextually correct Spanish example sentence.
> \- The word/phrase does not need to appear in the exact same form — it can be adapted (e.g., verbs in different conjugations, nouns with pluralisation, etc.) as long as the usage is natural.
> \**Output:**
> \- A two-column table with the following headers:
> - **Word/Phrase**
> - **Example Sentence (Spanish)**
> \- Maintain a clean table format (Markdown style), not plain CSV text.
> \- Output in 100-row chunks until the list is fully covered.
#### Anki Code Snippets
> [!note]- Creating Grid of Four Images in Your Anki Card
> Check our [YouTube video explainer!](https://www.youtube.com/watch?v=nxv0RU8uISs)
>
In your Card Template (Front or Back):
> \<div class="image-grid">
> \<img src="{{Image1}}">
> \<img src="{{Image2}}">
> \<img src="{{Image3}}">
> \<img src="{{Image4}}">
> \</div>
>
> Then in the Styling section:
>
> .image-grid {
> display: grid;
> grid-template-columns: 1fr 1fr;
> gap: 10px;
> max-width: 400px;
> }
>
> .image-grid img {
> width: 100%;
> height: auto;
> }
>
> Then your note type just needs fields like:
> Image1
> Image2
> Image3
> Image4
#### Google Sheets Formulas
**Conditional Formatting for Highighting Duplicates**
Check our [YouTube video explainer! (link upcoming)]()
```text
=AND($A2<>"out", LEN(TRIM($J2))>0,
COUNTIFS(
ARRAYFORMULA(TRIM(LOWER($J$2:$J$2198))),
TRIM(LOWER($J2)),
$A$2:$A$2198,"<>out")>1)
```