Category Excel

Reducing the Size of Excel File

Someone in the past asked me to help reduce the size of her excel file. It’s over 100mb and killing her storage space. I did a few adjustments and it went down to 1mb. 100-fold decrease in size. 1. Remove…

Use Lookup, Not Nested If

The IF formula is a useful function and often used. A simple binary outcome, TRUE or FALSE, 1 or 0. But because it’s so commonly used that most abused it in the form of NESTED IF. You saw it before.…

Macros from Beginners to Experts

One of the ways to truly maximize the power of the MS Office Suite is through macros. A macro is basically a set of instructions to perform specific task. I set macros in Word, Powerpoint, but where it truly shines…