Search Results

In this tutorial we tackle a complex lookup problem – how to return the header based on criteria in a matrix. I offer my solution using INDEX and SUMPRODUCT. We also cover alternative approaches proposed by the Excel community, including an interesting TEXTJOIN solution that is able to handle multiple match results.

Don’t use ChatGPT without making these very important customizations. These settings will take your ChatGPT responses from generic to incredibly accurate.

Master the Powerful Features of Google Sheets from data collection, automation to proper data analysis and visualization. This course will teach you everything you need to know about Google Sheets. Plus you’ll benefit from our EXCLUSIVE bonuses.

This is the list of the most useful Excel Functions you need to know in 2021. There are the new functions available in Excel for Microsoft 365 and also on Excel for the web (available for free).

What can Google Sheets do and should I learn it? This was a question I asked myself some time ago. I noticed more companies were switching to Google Sheets specially because of the events of 2020. In this post I talk about what Google Sheets can do.

This is a simple but advanced Pivot Table technique in Excel. If you’d like to create a Pivot Table based on multiple sheets or tables, you can easily do that by defining the relationship between the tables from the data tab. It just takes one click.