For years, I solved complex spreadsheet problems the same way: adding helper columns, stacking increasingly nested formulas, and, when things became especially tangled, resorting to Excel’s VBA macros ...

JavaScript’s reduce is one of the most useful array methods that should be in a developer’s arsenal. Introduced in ES5, it’s somewhat similar to for…each and map methods that are used with arrays, but ...

With new support for named functions, LAMBDA and helper functions, spreadsheet calculations — especially with arrays — may be more efficient and elegant. Image: Andy Wolber/TechRepublic. In August ...