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 ...

JavaScript’s arrays can hold heterogeneous types, change size on the fly, and readily insert or remove elements. Traditional methods like slice, splice, and push/pop do this by operating on the array ...

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 ...