Categories
AcademyRisks
Risks
Array functions belong to the past
Long ago, Excel was not as clever and advanced as it is today, and the so-called array functions are an inheritance of this past. However, most people don’t know about them, and don’t understand them. This is perhaps because of the different nature or the strange method to activate these formulas (CTRL-SHIFT ENTER instead of just ENTER).
Hiding information in Excel
Hiding information in Excel is risky. Hidden information can be altered by a user, without him even realizing what he’s doing, resulting in potential negative results.