Use Excel ABS and TRUNC to Fix Financial Modeling Errors

Underrated Excel functions like ABS, TRUNC, and REPT solve common spreadsheet challenges fast. Create simple in-cell visual ...
How-To Geek on MSN

I use this overlooked Excel function to turn my boring worksheets into lightweight apps

Combining IMAGE with a handful of familiar Excel features unlocked interactive tools I never expected to build.
MUO on MSN

SUM is good, SUBTOTAL is great, but this Excel function beats them both

Your reports should remain stable even when your data gets messy. AGGREGATE is the only function that survives both filtered ...
note

Solving the Issue Where Added Dropdown Options Don't Appear in Excel Using Tables and INDIRECT: 3 Steps to Reduce Updates from 10 Times a Month to Zero

“I added a new account title to the expense report sheet, but it’s not showing up in the dropdown.” I received this message from the accounting team at my client site three years ago. I had indeed ...
note

[Excel Macro] Automating the organization of accumulated photos with macros

A large number of image files in a folder. Manually pasting them into Excel one by one, resizing them to the perfect size, and neatly placing them in the center of the cells... And, to be able to ...