• Clean up messy Excel data in seconds with 5 handy functions.
• Learn how SIM swapping works (and how to protect your phone number).
• Bonus tip: Use Microsoft Word + ChatGPT to transcribe and summarize meetings.

In this week’s 365 Tip of the Week newsletter, we’re sharing a few quick videos to help you boost productivity and stay secure. And yes—there’s a bonus AI tip you won’t want to miss! But first, let’s start with everyone’s favorite love-it-or-hate-it Microsoft Office tool: Excel.

Microsoft 365

Working in Excel is already a chore—but cleaning up messy data? That’s next-level frustrating. Thankfully, Excel has built-in functions that can turn hours of work into just a few seconds. In this quick tutorial, you’ll learn 5 simple formulas that will make your data cleanup a breeze.

YouTube Video Description: Tired of fixing messy text entries in Excel? In this tutorial, you'll learn 5 essential Excel text functions to clean and organize your data efficiently: PROPER, UPPER, LOWER, CONCAT, and TRIM. 

Cybersecurity

While Excel helps tidy up your data, hackers are out there trying to steal it. One method you might not know about is SIM swapping—a clever scam that lets attackers hijack your phone and break into your accounts. It’s quick, it’s sneaky, but preventable.

YouTube Video Description: SIM swapping is a dangerous scam that can give cybercriminals access to your phone, accounts and personal data. In this video, we explain how SIM swapping works and the simple steps you can take to stay protected. 
 

AI

Here’s a clever classroom example that shows how to skip manual notetaking. In this video, a teacher provides feedback to a student, uses Microsoft Word to transcribe it, and then relies on ChatGPT to generate a clear summary. While it’s set in an educational context, the same approach works just as well for meetings, interviews, or any scenario where capturing key points quickly is essential.

YouTube Video Description:  Here's the easiest way to transcribe audio and video in MS Word! Imagine saving hours on feedback while giving your students exactly what they need to succeed. In this lesson, I’ll reveal how to transcribe audio and video effortlessly with MS Word, and transform it into clear, actionable summaries using ChatGPT