Microsoft Excel is a tool almost everyone is familiar with these days. And electronic spreadsheets are used in one way or another by nearly everyone who works with a computer. However, I believe most people are unaware of the full potential of this tool.
I’ve never considered myself a spreadsheet guru, even though I knew the basic formulas, performed many calculations myself, and often used complex tables at work to track budgets and other tasks. Still, I always considered myself an intermediate user in terms of proficiency.
Occasionally, though, I faced tasks that required processing large amounts of data, often in rather complex ways. That’s when I started digging through various articles to find methods for building more sophisticated calculations. I began working more and more with the concept of arrays in spreadsheets. At some point, I noticed that many of the examples and solutions I found frequently referred to the same author—or even directly cited his book titled Ctrl+Shift+Enter: Mastering Excel Array Formulas. The author? Mike “ExcelIsFun” Girvin. He runs a popular YouTube channel where he explains the intricacies of working with MS Excel. The channel bears his pseudonym, ExcelIsFun.
As for the book, it’s a refined collection of his materials, compiled into articles focusing on one specific topic: array formulas.
Read more
