YouTube on MSN

Make Excel formulas dynamic with the hash sign

Learn Dynamic Arrays with the Hash Operator in Excel In Excel, the hash (#) sign references dynamic arrays, which automatically adjust as data is added or removed. Dynamic arrays let formulas return ...
How-To Geek on MSN

These 5 Linux command-line tools let you work with Excel spreadsheets from the terminal

Filtering, querying, visualizing, and editing: these tools do the lot.
xenospectrum

Excel Tests Lists and Arrays That Store Multiple Values in a Single Cell

Microsoft has announced lists and in-cell arrays for Excel's Beta channel. Here is how they differ from dynamic arrays, where ...

Microsoft cells out, crams multiple values into Excel boxes

Microsoft has ended 40 years of single-occupancy for Excel cells and is now allowing multiple values to inhabit the same home ...

Master Internal Rate of Return (IRR) Calculations in Excel and Google Sheets

Discover Excel and Google Sheets, including certain functions like IRR, XIRR, and MIRR, and how they can help you calculate ...