Excel’s Hidden N Function Lets You Add Comments Inside Formulas

Embed Excel formula comments directly into your math using the N and REPT functions to keep your spreadsheet documentation ...
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

I stopped rebuilding the same Excel pivot every week after learning this one trick

My reports update themselves now.
PC World

Meet DATEDIF(), Excel’s secret Date & Time function that’s still handy

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000, which is the only version that explains how this function works.