Microsoft 365 Tip of the Week

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

Written by Aaron Kreps | Nov 5, 2026, 6:00:01 PM
  • 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