Kevin Stratvert Newsletter: Win $50k, Stop Using VLOOKUP, UiPath on Mac, and More!

Published 22 days ago • 1 min read

The Big Game is next weekend, and you have a chance to win $50,000 in Base44's Big Game Challenge - check out the video, where Elizabeth will show you how to enter (and watch the end to get Kevin's thoughts on the prize money)

And don't miss out on our newest videos, as well as our Windows hacks below, in our weekly tips and tricks.

Win $50,000 in the Base44 Big Game Challenge!

This year’s Big Game just got a lot more interesting! 🏈

Base44 is hosting an open no-code app challenge with $50,000 in prizes, and the best part? Anyone can enter — no coding required.

Stop Using VLOOKUP for Reports (This Excel Workflow Is Better)

If your Excel reports keep breaking every time you add new data, the problem probably isn’t Excel; it’s how the report is built.

VLOOKUP and XLOOKUP aren’t bad formulas, but they’re the wrong tool for recurring reports. Copying formulas down duplicates data, slows your file, and makes reports harder to maintain.

UiPath on macOS: Automate Your Mac with Studio Web

UiPath is often thought of as a Windows-only RPA platform, but that’s no longer the full story. This video explores how UiPath Studio Web can be used on macOS to build real, practical automations directly from a web browser with the help of UiPath Assistant for Mac.

5 Windows Tricks You Probably Didn't Know

Cookies + Windows = Sweet productivity.

1) Press Windows + Shift + S, and you can record your screen with audio

2) Press Windows + C, and that opens up an AI co-pilot, and you can now ask

the AI questions, try "Does the Kevin Cookie company make the best cookies?"

3) Press Windows + ,H and you can type by speaking (that way, you can use both hands for eating cookies)

4) In Paint, click on the co-creator icon and you can generate art by describing it

5) Using the Snipping Tool, you can take a screenshot and then extract the text

from the image, by clicking on the Text Actions button

Check out Kevin's Demo

https://kevinstratvert.com/

Unsubscribe

Kevin Stratvert Newsletter: New Gemini Features, Small Business Tips & Tricks, and More!

Google is rolling out some major updates this year — and in our newest video, we break down five of the most powerful new Gemini features inside Chrome that you’ll actually use. If you’re a small business owner, content creator, or anyone who writes emails, proposals, or posts all day long… you’ll also want to see what Grammarly just released. Their newest AI tools are seriously impressive. Our favorite? Reader Reactions — it predicts how your audience might respond to your writing before you...

about 13 hours ago • 1 min read

Kevin Stratvert Newsletter: Photo Transfer, Clean Your Inbox, ChatGPT Tip, Google Sites and More!

Still trying to figure out how to transfer all of your holiday vacation photos from your Android to your PC? Kevin's got you covered in this week's featured video. Learn how to clean up your inbox and destress your day without using email rules. And learn more about the ultimate AI meeting assistant, Granola. Also, check out our latest video on how to build a website with Google Sites. And go Incagnito with us in ChatGPT in our weekly tips and tricks! How to Transfer Photos from Android to...

8 days ago • 1 min read

Kevin Stratvert Newsletter: Lip Sync, Outlook, Ultimate AI Meeting Assistant, and More!

Watch Kevin create a cookie commercial using AI to generate perfect lip-syncing! Be warned, you may want to order some cookies after watching. Need the ultimate AI meeting assistant that goes way beyond the basics? Our tutorial on Granola, shows how you can take your meetings to the next level. And check out how to create a signature in the newest version of Outlook, including using Copilot to make an eye-popping visual. Plus, see Kevin's latest trick about why shutting down your PC doesn't...

15 days ago • 2 min read