The spreadsheets of my life
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
An overview of the essential skills in Excel that a regular user should have in order to be able to work with spreadsheets quickly & efficiently — a beginning of a series. 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
It is not uncommon to face large amounts of data that need to be aggregated across myriad cells in Excel. If you have to =SUMIFS() through big ranges, you might spend too much time waiting for the calculations to finish. Better data structure and focus on efficiency might help you out of this situation. Read More
You can find similar items in Excel based on their underlying properties. Running shoes are used to show how to approach the problem and construct an array formula that gets the job done. Read More
The final touches to the calculator are being put in order for it to be a finished product. 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