The spreadsheets of my life
Dealing with complicated tasks requires good understanding of the basics. The category is meant to shed some light on the building blocks that are used to tackle spreadsheet challenges.
The sooner you start using keyboard shortcuts in Excel, the better. I will focus on the combinations that I believe are the most widely applicable regardless of industry or experience level. Read More
The Excel interface is something every user, regardless of their level, should understand well. Those are the most fundamental pieces of information you should keep in mind. Read More
Sometimes you need to get only some of the data rows in Excel that match certain criteria (or more than one). One of the ways to do that is by using the often neglected =AGGREGATE() function. Read More
The =CHOOSE() function allows you to define a list and pinpoint a single entry from it to be returned as a result. Since list elements can be both values and references, this solution can be applied in various situations. Read More
The =LOOKUP() function in Excel can return value from a vector that sits against an exact/approximate match in another one. Flexibility can be added in the formula by employing a condition whether some vector elements to be used or not. Read More
Combining the =INDEX() and =MATCH() functions is a way to save on time and possibly some document performance. In this post the simplest use of the functions is used to extract data from a two-dimensional table. Read More