Making the difference between absolute, relative and structured references in Excel is a fundamental skill. Read More
Excel essentials — Absolute, relative and structured references
Posted on
Excel essentials — Keyboard shortcuts
Posted on
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
Excel essentials — The Interface And Its Customization
Posted on
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
Excel — The essential skills for the regular user
Posted on
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
Getting all records that meet a criteria with the =AGGREGATE() function
Posted on
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
Tips on large number of SUMIFS slowing down the spreadsheet
Posted on
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
Finding similar items in Excel based on their properties
Posted on
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
(Wrap-up) The gas money splitting tool
Posted on
The final touches to the calculator are being put in order for it to be a finished product. Read More
=CHOOSE() from a list of values in Excel
Posted on
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
Excel =LOOKUP() with conditions
Posted on
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