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

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

How to create dynamic Outlook email templates for the current user

Let's say, you have a really nice template, and your teammates would be happy to use it in their correspondence, but you're stuck on making this template dynamic. The problem is that each of your colleagues would like to get a different image, an individual attachment, and some specific text added to the template every time they use it. Continue reading

Debug user defined functions

As you already know how to create UDFs (and, I hope, you’ve also tried applying them in your Excel), let’s dig a bit deeper and see what can be done in case your user defined function is not working. Continue reading

Converting CSV to Excel: problems and solutions

The name CSV (comma separated values) implies the use of comma to separate data fields. But that is in theory. In practice, many so-called CSV files separate data using other characters such as semicolon or tabs. The lack of standard spawns various problems with CSV to Excel conversions. Continue reading

Excel Data Validation using regular expressions

When it comes to restricting user input in Excel worksheets, Data Validation is indispensable. It can do anything you can possibly imagine. What if I want to allow entering only valid email addresses or strings that match a specific pattern? Alas, that's not possible. Regex you say? Hmm… that might work! Continue reading