🦸‍♂️ Supercharge your Excel formulas in 2 minutes or less

Hello folks,

Ready to stay ahead of the game with AI, automation, and no-code?

I found this awesome Excel hack that will make you 10x faster - stay tuned!

In this issue:

• 📕 Learn Something: Use ChatGPT to create formulas in Excel

• 💥 Trending Tool: Automate your meeting notes with Fireflies

• 🎓 More Tutorials and Apps: Presentations, emails, and beyond

• 🙃 Something Fun: Get out of work

Let’s get right into it…

📕 LEARN SOMETHING
Use ChatGPT to create formulas in Excel

Formulas in Excel can get pretty annoying, especially when you need to remember how to use SUBSTRING or INDEX MATCH!

Even worse, you inherit someone else’s workbook and not even the most well-versed Excel aficionado can understand what they’re doing 🤢

Well, ChatGPT and other LLM’s can make this 10x easier for you. Here are a few ways you can use it to help with your Excel formulas:

🧮 1) Create formulas

You can use ChatGPT to create Excel formulas for you - all it takes is a well-worded prompt…

Pro tip: always provide examples of what you want the output to look like; the more the better

🧠 2) Understand formulas

Imagine you get handed a workbook with formulas that have nested IF statements and complex math, yuck! Just use ChatGPT to explain it for you.

Pro tip: you can even ask ChatGPT to create a logic table to fully help you understand and interpret complex formulas

💥 TRENDING TOOL
Automate your meeting notes with Fireflies

A new AI-based tool just flew in (pun intended).

Fireflies.ai combines LLMs and voice-to-text to help you transcribe, summarize, search, and analyze voice conversations.

If you’re the designated note-taker for your team, this can be a real productivity game-changer!

Specifically, Fireflies helps you:

• Transcribe meetings real-time

• Summarize, search, and ask questions about your meeting (for example, ask “what are the key next steps” after a strategy meeting)

• Analyze meeting using conversational intelligence, a fancy way of saying that the tool can track speaker talk time, sentiments, etc.

• Integrate and extend, with third-party apps and APIs

There are alternatives like Otter.ai that boosts itself as being more “real-time” - only time will tell which one of these tools succeeds.

🎓 MORE TUTORIALS AND APPS

Tutorials

• ChatGPT and Powerpoint - Creating content for a deck is easy, but you can also instruct ChatGPT to create real PPT slides for you by generating VBA code that builds slides from scratch

• Gmail apps directly in your email - Google Appsheet lets you create no-code apps that interact with your emails, for free - you can create dynamic emails without knowing how to code

• Automate files in OneDrive - Microsoft just released new connectors for Power Automate Desktop; one of them allows you to perform operations with files in OneDrive For Business

Apps

• Pitch your idea - Create a pitch deck in 3 minutes with your voice

• Kick resume - Generate a cover letter in seconds with AI

• Zapier - Automate any task by connecting apps with no-code

• Nuvo - Build powerful data pipelines with no-code

• Reclaim - Automate your scheduling with AI

• Focusmate - Virtual co-working for being more productive

🙃 SOMETHING FUN
Get out of work

Need an excuse to get out of work or a task? ChatGPT to the rescue!

ℹ️ ABOUT US

The Intelligent Worker helps you how to be more productive at work with AI, automation, no-code, and other technologies.

We like real, practical, and tangible use-cases and hate hand-wavy, theoretical, and abstract concepts that don’t drive real-world outcomes.

Our mission is to empower individuals, boost their productivity, and future-proof their careers.