Search for...
Light Dark Auto
Workspace Essentials Posts
|
Gemini
| #134

Google Gemini: Your Spreadsheet Assistant

(you can filter previous issues by application!)

Your wish, my command (kinda)

I’m known for being pretty detail-oriented at work so my manager tasked me with creating a Budget Management spreadsheet for 2024 (no good deed goes unpunished 😞).

Here’s the prompt I used to kick things off in Google Bard:

Prompt for your reference

My manager just asked me to create a budget management spreadsheet for our team of 4.
Basically we need to update our budget forecasts for each quarter, and ideally whenever one of us provides an input for a quarter, that input is taken out from the total budget pool.
Create a table that helps me with this

And here’s what Bard gave me:

I obviously had to make some edits to the final output in Google Sheets but as you can see, Google Bard helped a lot with the initial heavy lifting!

Bonus tip for ex-Excel users (pun intended)

The next time you find yourself thinking, “Man I wish Google Sheets included a specific Excel function”

You can prompt Bard with something like this:

Prompt for your reference

Is there a =XLOOKUP function equivalent in Google Sheets?
If so, please give me an example and teach me how to use it properly

Google Bard will even give you a step-by-step walkthrough on how to use said formula:

What interesting use case have you tried?

I’m always looking for ways to improve so give me anonymous feedback here 📝

Want someone to be more productive? Let them subscribe here 😉

Thanks for being a subscriber, and have a great day!