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: Remove blank rows in Excel, spot scams, and Copilot

5 November, 2026

Table of Contents

Monthly Cybersecurity Fundamentals Training
  • Why blank rows and columns break sorting and pivot tables, plus three fixes.
  • How QVR helps your team catch impersonation attempts.
  • How Copilot’s new accounting skills handle reconciliation inside Excel.

Microsoft

Blank columns and rows look harmless in a spreadsheet, but they quietly break sorting, filtering, and pivot tables. This video walks through three ways to find and remove them, starting with Go To Special and ending with Power Query, which is the one to use if you keep receiving messy exports. A few minutes well spent if you work with downloaded data.

Title: Delete Blank Columns in Excel: 3 Easy Ways

Viewing Time: under 5 minutes


 

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

Cybersecurity

Impersonation has gotten convincing enough that a quick glance at an email from your boss or a text from your bank is no longer enough. This one-minute podcast lays out QVR, a three-step habit for any unexpected request: question whether the sender is who they claim to be, verify it through a trusted channel, and report it if something feels off. Short enough to send to your whole team.

Title: QVR: Question, Verify, & Report

Viewing Time: under 2 minutes

 

Check out Cybercrime Radio: https://www.youtube.com/@CybercrimeRadio  

AI

Reconciliation is now built into Copilot. It matches transactions across the ledger and the bank statement, flags exceptions, and keeps calculations tied to their sources so the numbers can be verified. The demo also shows the workbook turned into an interactive canvas that updates on its own when the data changes. Worth a look before the next month-end close.

Title: New accounting skills in Copilot in Excel

Viewing Time: about 1 minute

 

Check out Microsoft Copilot: https://www.youtube.com/@Microsoft.Copilot
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!

Today
Tip of the Week: Remove blank rows in Excel, spot scams, and Copilot

11/05/2026

Tip of the Week: Remove blank rows in Excel, spot scams, and Copilot

Learn how to remove blank rows in Excel, use the QVR method to spot impersonation scams, and see..

Read More
Last Week's
Tip of the Week: PowerPoint, PHP patch management, and AI docs

10/29/2026

Tip of the Week: PowerPoint, PHP patch management, and AI docs

A critical PHP vulnerability put most of the web at risk, and AI is shrinking the window to..

Read More
Two Week's Ago
Tip of the Week! Windows 11 Taskbar Tips and AI Privacy

10/22/2026

Tip of the Week! Windows 11 Taskbar Tips and AI Privacy

Customize your Windows 11 taskbar, keep company data out of AI tools, and set up recurring team..

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.