Excel Life Hacks That 'Experts' Don't Know

I watched my experienced finance colleague struggle with Excel for a whole hour. He's an Excel guru, has been working with it for 20 years. But when I saw how he was typing formulas, I couldn't help but show him a couple of simple tricks that blew his mind.
It was a problem of ignorance—ignorance of features that have been in Excel for years, saving hours of work, but which no one ever talks about.
That's why I'm writing this article, to gather the best life hacks and save precious seconds of your life.



The modern projects on the optimization and the automation of many business processes, assume, as a rule, that the first step will be the analysis of the large amount of the client’s documents. The purpose of it is the modelling the business processes “as-is” in a very tight schedule. The list of the analyzed documents includes normative legal acts, industry standards, SCRUM user stories, regulations, technical specifications and other corporate documents.