Skip to content

Already a Client? Get support in 5 minutes or less. CONTACT SUPPORT NOW!

Each week, you'll receive two practical, bite-sized tips. One to help you get more out of Microsoft 365, and one to strengthen your online security. Each tip comes in a short, easy-to-follow video, carefully selected by the Endsight team to help you work more efficiently and stay protected.

We often include a bonus tip too. These extras might feature AI tips, clips from recent webinars, or leadership advice from our Founder and CEO.

Tip of the Week: Excel XLOOKUP, iPhone Safety, and AI Memory

3 September, 2026

Table of Contents

Monthly Cybersecurity Fundamentals Training
  • How converting an Excel range into a table makes XLOOKUP update automatically.
  • Why default iPhone settings could be exposing your banking activity.
  • How Computer History gives ChatGPT and Codex memory of your desktop activity.

Microsoft

If you're running XLOOKUP against a plain data range in Excel, you're doing more work than you need to. This week's tip breaks down why converting that range into a table with Ctrl+T changes everything, click through references instead of manual absolute cells, and calculated columns that fill down and update themselves the moment you add new rows. Watch the video to see the range version break on a real example, then the table version fix it instantly.

Title: Why Tables Are BETTER Than Ranges in Excel" → "Why Tables Are Better than Ranges in Excel

Viewing Time: under 5 minutes


 

Check out Chris Menard:
https://www.youtube.com/@ChrisMenardTraining

Cybersecurity

 Your banking apps hold some of your most sensitive information, and a few default iPhone settings leave real mobile banking security gaps. This week's tip covers five quick fixes: automatically deleting verification code texts, turning off text message forwarding to other devices, hiding notification previews for banking alerts, requiring Face ID for banking apps specifically, and locking wallet access when your phone is locked. None of it takes more than a few minutes. 

Title: Do Not Open Your Bank App Before Changing These 5 Settings

Viewing Time: under 5 minutes

 

Check Out Trevor Nace: https://www.youtube.com/@TrevorNace 
 

AI

ChatGPT and Codex just added a new memory feature called Computer History that changes how much context your AI agent has about your work. Turning it on in the macOS desktop app builds a timeline from your clicks, typing, and app switches, no screen or audio recording involved, so your agent can answer questions like what document you were just in without you repeating yourself. You control which apps and sites it can see, and can review or delete anything it has captured. Watch the video to see it pull up a recent Google Doc and summarize an entire morning of work from memory alone.

If this is something you ever wondered about, we get questions like these all the time during AI Office Hours. Register now for our next session on September 10th: https://www.endsight.net/development/webinar

Title: Computer History in ChatGPT

Viewing Time: about 3 minutes

 

Check out OpenAI: https://www.youtube.com/@OpenAI
Monthly Cybersecurity Fundamentals Training
Cybersecurity Office Hours

Resources

Previous Tip of the Weeks

Not sure if you should subscribe or not? Check out some samples to see if this newsletter is right for you!

This Week
Tip of the Week: Better slides, location services, AI design

10/08/2026

Tip of the Week: Better slides, location services, AI design

This week: how to audit location services on your phone, a smarter way to build AI-generated slide..

Read More
Last Week's
Tip of the Week: Windows Taskbar, New Scams, Microsoft 365 Copilot

10/01/2026

Tip of the Week: Windows Taskbar, New Scams, Microsoft 365 Copilot

Windows 11 now lets you move the taskbar, social engineering is spanning more channels, and..

Read More
Two Week's Ago
Tip of the Week: Is ChatGPT safe? Plus Teams and Prompting Techniques

09/24/2026

Tip of the Week: Is ChatGPT safe? Plus Teams and Prompting Techniques

Is ChatGPT safe to use at work? This week covers what happens to your AI chats, 12 Microsoft Teams..

Read More

0 Comment

Sort by:

Aaron Kreps

Aaron Kreps

Aaron is a Customer Marketing Specialist at Endsight, focused on helping clients stay informed about the latest in IT and cybersecurity. He creates content, webinars, and resources to support clients and any organization in making confident technology decisions. With a clear and client-centric approach, Aaron ensures Endsight’s expertise is easily accessible and actionable.

Subscribe to 365 Tip of the Week

Subscribe now and start getting a little better every week! No charge. No spam. Unsubscribe anytime.