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

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

CONCAT function in Excel to join text strings

Traditionally, string concatenation in Excel is done with the help of the CONCATENATE function or the ampersand symbol. In modern Excel, these old-school methods give way to CONCAT - a newer and improved function to combine text from multiple cells into one cell. Continue reading

How to add text or character to every cell in Excel

When working with text data in Excel, you may sometimes need to add the same text to existing cells to make things clearer. For example, you might want to put some prefix at the beginning of each cell, insert a special symbol at the end, or place certain text before a formula. Continue reading

How to remove characters/text from string in Excel

In this tutorial, we will look at the most common cases of removing characters in Excel. Want to delete specific text from multiple cells? Or maybe strip the first or last character in a string? Or perhaps remove only a specific occurrence of a given character? Whatever your task is, you will find more than one solution for it! Continue reading

How to share files securely with OneDrive

There are a few different ways to share documents on OneDrive, and you may be asking yourself which is the best one. For the most part, the answer depends on the situation and your ultimate goals. But I can show you the most secure way. Continue reading

How to share OneDrive files and folders

Like most other online storages, OneDrive was designed with collaboration in mind, and they strived to make the sharing process easy and intuitive. However, there are some caveats to take notice of, especially when adding and syncing shared files to your computer. Continue reading

How to remove table formatting in Excel

By default, Excel tables are equipped with a number of great features including predefined table styles. In some situations, however, you may want to remove formatting keeping all other functionality of a table. This tutorial will teach you how to quickly do that. Continue reading

Excel LAMBDA function: how to write and use

Until recently, user-defined functions were the prerogative of programmers. The introduction of the LAMBDA function has made them available for everyone. With this wonderful addition to Excel's toolbox, we no longer need VBA skills to create our own custom functions. Continue reading

How to create a meeting template in Outlook

An engaging and informative invitation is an important part of running a successful meeting, and a well-crafted template can save you enormous time on the job. This article looks at how to quickly create meeting templates in Outlook, preset any fields, add input boxes, drop-down menus, and more! Continue reading

Outlook Quick Steps: how to create and use

When doing the same things day in and day out, most irritating is the necessary do it from scratch every time. What would you say if instead of tedious multi-step processes you could accomplish your email routines with a button click? It is what Outlook Quick Steps are all about. Continue reading