Excel tutorials, functions and advanced formula examples

Case-sensitive SUMIF and SUMIFS in Excel and Google Sheets

The SUMIF and SUMIFS functions available in Microsoft Excel and Google Sheets are case-insensitive by nature. To conditionally sum cells treating lowercase and uppercase letters as different characters, you'll have to come up with something else. Continue reading

How to group columns in Excel

If you feel overwhelmed or confused about the extensive content of your worksheet, you can organize the columns in groups to easily hide and show different parts of your sheet, so that only the relevant information is visible. Continue reading

All Google Docs & Google Sheets limits you need to know

This blog post is a collection of the most important existing Google Docs and Google Sheets limits you need to know so everything loads and works like clockwork. Continue reading

How to find sum of largest N numbers in Excel

In some situations, you may need to sum specific numbers in a range, say top 3, 5, 10 or n. That might be a challenge because Excel has no inbuilt function for this. But as always, there is nothing that would prevent you from constructing your own formulas :) Continue reading

Version history in Google Sheets: see edit history & restore any version

Google Sheets has many beneficial features. Saving your spreadsheets automatically while keeping records of all changes made in the file is one of them. You can access those records, look through them and restore any version anytime. Continue reading

Merge two Google sheets: update cells, add related columns & non-matching rows

Did you know that when you merge 2 Google sheets you can not only update records in one column but also pull whole related columns and even non-matching rows? Today I will show you how it's done with VLOOKUP, INDEX/MATCH, QUERY functions and the Merge Sheets add-on. Continue reading

SUMIF multiple columns with one or several criteria in Excel

Doing a conditional sum in Excel is a piece of cake as long as all the values to be totaled are in one column. Summing multiple columns is a problem because both the SUMIF and SUMIFS functions require the sum range and criteria ranges to be equally sized. Continue reading

How to make a heat map in Excel with or without numbers

Microsoft Excel has a number of inbuilt features to create graphs. Regrettably, a heat map is not on board. Luckily, there is a quick and simple way to create a heat map in Excel with conditional formatting. Continue reading

Mail Merge formatting issues in Word: causes and fixes

Using Word's Mail Merge to automate the creation of a document from an Excel worksheet may present lots of challenges. Our troubleshooting tips will help you fix typical formatting problems. Continue reading

Merge two Google sheets: lookup, match and update records

Today's blog post features all ways to merge 2 Google Sheets. You will use VLOOKUP, INDEX/MATCH, QUERY and Merge Sheets add-on to update cells in one sheet from records from another one based on matches in common columns. Continue reading

How to number columns in Excel and convert column letter to number

The tutorial talks about how to return a column number in Excel using formulas and how to number columns automatically. Continue reading

War in Ukraine. Here’s what we are doing to make our projects safe.

Europe. Ukraine. War. No one could ever imagine that these words would be actual in 2022. Imagine that someone would pursue geopolitical goals using weapons against peaceful cities. Against the whole country. Against the whole nation that has every right to life, freedom and independence. Continue reading

How to convert column number to letter in Excel

When building complex formulas in Excel, you may sometimes need to get a column letter of a specific cell or from a given number. This can be done in two ways: by using inbuilt functions or your own one. Continue reading

Using ISERROR with VLOOKUP in Excel

VLOOKUP is one of the most confusing Excel functions plagued with many issues. Using VLOOKUP with ISERROR can help you catch all possible errors and handle them in a way most appropriate to your situation. Continue reading

How to highlight duplicates in Google Sheets

There are different ways to deal with duplicates in Google spreadsheets. But highlighting them is the best way to spot them instantly. Here you'll learn how to color duplicate cells, columns, and rows while ignoring or taking their first occurrences into account. Continue reading

Mail Merge in Outlook - send personalized bulk email

Whenever you need to send personalized emails to multiple recipients, mail merge is a real time-saver. It works great for sending out business updates, season's greetings, and the like, so that every recipient gets a personal email with their own information, without knowing who else this message has been sent to. Continue reading

How to find and remove duplicates in Google Sheets

Looking for a way to find duplicates in Google Sheets? How about 7 ways? :) Delete, highlight, count duplicates. Use formulas, conditional formatting or formula-free tools. Come pick your poison and deal with duplicates for good :) Continue reading

How to use ISERROR function in Excel

When you write a formula that Excel does not understand or cannot calculate, it draws your attention to the problem by showing an error message. The ISERROR function can help you catch errors and provide an alternative when an error is found. Continue reading

Excel split screen - view different parts of a sheet at once

When working with large datasets, it can be helpful to see a few areas of the same worksheet at a time to compare different subsets of data. This can be done by using Excel's Split Screen feature. Continue reading

How to open Excel files in separate windows and multiple instances

Having spreadsheets in two different windows makes many Excel tasks easier. One of the possible solutions is viewing workbooks side by side, but this eats a lot of space and isn't always the best option. Continue reading

Ukraine flag War in Ukraine! To support Ukraine and save lives please visit this page.