With any software, the more you use it, the more hacks and shortcuts you discover, and never a truer word has been said when ...

You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.

You can do a mail merge in Microsoft Word and Excel to create personalized documents for many recipients at once.