How-To Geek on MSN

Your Excel file is secretly sharing more than you think. Here's how to check

Excel's Document Inspector reveals hidden and personal content, while a few manual checks can catch what it misses.
Geeky Gadgets

How to use Excel FILES a secret, powerful hidden function

The guide provides insight into how to use the hidden “FILES” function in Excel, a legacy macro function that lists all files in a specified folder. MyOnlineTrainingHub takes you through how to enable ...
MUO on MSN

7 Excel tools that are more useful than learning another formula

Before you learn another formula, check the ribbon.

Automating Excel VBA File Renaming with Dir and Name: 3 Steps to Reduce 200 Voucher PDF Renames from 2 Hours to 5 Minutes per Month

Have you ever seen a folder filled with 200 files named "Scan_0001.pdf"?There was a sticky note on the monitor of K, who ...

I deciphered the 'mysterious formula' in an inherited Excel file with Gemini and even managed to fix it

There is a formula in an Excel file I inherited from my predecessor that I don't understand. I'm afraid to edit it because it ...
Geeky Gadgets

Excel File Sharing Secrets & Management Features to Collaborate Smarter

Have you ever sent an Excel file to a colleague, only to realize they couldn’t open it because of compatibility issues? Or perhaps you’ve spent hours perfecting a spreadsheet, only to see its ...
Ars Technica

An easy way to copy multiple file names & sizes into Excel

I have a bunch of DVDs, each filled with dozens of files. I want to create a list of the contents of these discs and put it into a spreadsheet. I want to list the file name, type and size. So far I ...
ZDNet

How to use ChatGPT to write Excel formulas

Figuring out how to write the perfect Excel formula to achieve the desired result can be a challenge, especially when you have a lot of data on a spreadsheet and need an intricate formula beyond ...