Tutorials, videos, useful tips for Excel, Outlook and Google Sheets

Data Bars in Excel - how to add and customize

To compare different categories of data in your worksheet, you can make a chart. To visually compare numbers in your cells, colored bars inside cells are a lot more useful. Excel can show bars along with cell values or display only the bars and hide the numbers. Continue reading

Excel IMAGE function: quick way to insert picture in cell

Microsoft Excel users have inserted pictures into worksheets for years, but that required quite a lot of effort and patience. Now, that's finally over with. With the newly introduced IMAGE function, you can insert a picture in a cell with a simple formula, move, copy, resize, sort and filter cells with images just like normal cells. 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

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

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 simple way to find duplicates in Google Sheets? How about 7 ways? :) That's all you need for numerous use cases :) I will show you how to use formula-free tools (no coding — promise!), conditional formatting and a few easy functions for avid formula fans. 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