May
29
Gmail Mail Merge: Choosing the best mail merge tools
Find the best mail merge software for Gmail. Compare YAMM, GMass, and Easy Mail Merge on sending limits, data privacy, and document automation. Continue reading
Tutorials for Excel, Outlook and Google Sheets
May
26
How to send Outlook email on behalf of someone (delegate access)
Microsoft Outlook has plenty of useful features hidden away in menus that seem determined to never be found. One of them is the ability to send emails on behalf of another person or shared mailbox. If this is your first time trying it, don't worry, the process is pretty simple. Continue reading
May
21
Excel REGEXTEST function to match and validate text patterns
Checking whether a text string matches a specific format in Excel can sometimes require multiple nested functions and complicated logic. REGEXTEST simplifies this process by using regular expressions to test patterns directly. Continue reading
May
19
Flagged emails not showing in Outlook folders and To-Do list (causes and fixes)
When flagged emails stop appearing in your Inbox, Tasks list, or To Do view, it can feel like your follow-ups have vanished. In reality, Outlook is likely filtering or displaying them differently. This article explains why flagged messages may not be shown and how to get them back into view. Continue reading
May
14
How to find and view flagged emails in Outlook
Flagging emails in Outlook is easy. Remembering where they end up? Not always. If you are wondering where all those carefully flagged messages actually are, Outlook gives you plenty of ways to bring them back into view. Continue reading
May
12
How to use REGEXEXTRACT in Excel with formula examples
Excel has plenty of useful text functions, but sometimes they still can't handle complex extraction tasks. When standard functions are not flexible enough, REGEXEXTRACT comes to the rescue. Continue reading
May
7
Excel REGEXREPLACE function with formula examples
Some Excel tasks are simple. Others involve cleaning up text that looks like it survived a storm. If you often work with messy imported data or inconsistent strings, the REGEXREPLACE function can save a lot of formula gymnastics. Continue reading
May
5
How to flag emails in Outlook for follow-up manually or automatically
Not every message needs a reply or action right away, but some definitely need a reminder. Flagging is a simple way to mark important emails and come back to them at the right time. Continue reading
May
1
How to find & remove duplicates in Google Sheets: check, count, and filter
Don't let duplicates ruin your analysis. Discover how to identify every repeat, count occurrences, filter out copies, and remove duplicates in Google Sheets using the most effective formulas and tools. Continue reading
Apr
30
Change font to sentence case in Excel with formulas and VBA
Cleaning up text in Excel sheets isn't always as simple as it should be. Especially, when all you want is a normal-looking sentence and not a mix of uppercase and lowercase chaos. Although there is no built-in function for sentence case in Excel, a properly written formula or macro can take care of it in seconds. Continue reading
Apr
28
How to create professional Outlook signature with examples
While many online email signature generators offer polished templates, few let you export signatures to Outlook for free. The good news is that you don't need them. With just a little time and effort, you can create a clean, professional email signature directly in Outlook, complete with your contact details, photo or company logo, and clickable social media icons. Continue reading
Apr
22
How to clean data in Excel with practical examples
Messy data happens to everyone. One minute you're working with a neat list, and the next you're staring at extra spaces, inconsistent formatting, and mystery characters. The good news? Excel gives you plenty of ways to clean things up, you just need to know where to look :) Continue reading
Apr
16
Excel case functions: UPPER, LOWER, PROPER with formula examples
Text in Excel has a funny way of getting out of control. One column is ALL CAPS, another is all lowercase, and somewhere in the middle is a mix that is neither here nor there. If your data looks like it can't decide on a writing style, Excel's case functions are here to bring a little order and sanity back :) Continue reading
Apr
14
How to create task from email in Outlook
Some emails are just messages. Others are really tasks in disguise. We've all read one, thought "I'll handle this later", and then… completely forgotten about it. Instead of letting them pile up, you can turn such messages into actionable to-do items and track them alongside your other tasks. Continue reading
Apr
9
Excel CLEAN function to remove nonprinting characters and line breaks
Sometimes Excel data looks perfectly normal, until a simple task turns into a head-scratcher. You import some data into your worksheet, everything looks fine… and then suddenly your formulas stop working, searches fail, and nothing matches. Welcome to the world of nonprintable characters. Continue reading
Apr
7
How to add HTML signature to Gmail
HTML is the secret to a professional, consistent Gmail signature. But since Gmail's editor doesn't support raw code, how do you actually use it? Grab our free HTML templates and follow this guide to bypass the WYSIWYG limitations and build a signature that looks perfect on any device. Continue reading
Apr
7
How to add tasks to Outlook calendar
You may have the most detailed task list in the world, but if your calendar is already full, when exactly are you planning to do it all? If your Outlook tasks and calendar feel like two separate worlds that rarely talk to each other, it might be time to introduce them. Continue reading
Apr
2
How to assign a task in Outlook and track progress
Have you ever sent an email that says "Can you take care of this?" and then wondered a few days later if anything actually happened? Obviously, emails are easy to ignore, especially when they look like everything else in the inbox. Assigning a task can add structure to the chaos. Continue reading
Mar
31
Excel MAP function with formula examples
Instead of copying formulas across multiple rows and columns, the MAP function lets you process entire arrays in one go. In this article, you'll learn how it works, when to use it, and how to build practical formulas step by step. Continue reading
Mar
31
How to add an image, logo, and link to your Gmail signature
Even though the Gmail signature editor looks simple, it's not so easy to align images and text or add clickable social media icons. You need a few expert tips to get it right. Follow this guide to learn the best ways to design a professional email signature. Continue reading
Mar
26
How to attach Outlook email to another message
There are times when forwarding an email the usual way is not enough. When accuracy is important, you may wish to share the original message exactly as it was received, with all formatting, headers and attachments intact. Continue reading
Mar
24
How to expand Excel formula to all rows and entire columns
Excel formulas often start in a single cell, but your data rarely stays that small. As your dataset grows, manually copying formulas can quickly turn into a tedious task, not to mention how easy it is to make mistakes. Continue reading
Mar
23
How to add a signature in Gmail
Want to add an email signature in Gmail, edit or remove it? Make it possible to switch between several signatures or set up an auto signature for replies and forwards? You will find all the basics of working with Gmail signatures in this tutorial, from initial setup to editing and removing signatures. Continue reading
Mar
17
Excel TRIMRANGE function to remove empty rows and columns from range
When working with continuously updating datasets in Excel, it's common to reference ranges that contain extra blank rows or columns. These empty cells usually don't break formulas, but they can produce messy results, such as zeros or errors for empty rows, or unnecessary blank space in summary tables and reports. Continue reading
Mar
11
How to send secure encrypted email in Outlook
Email is how most of us communicate these days, at work and at home. Many messages include sensitive details like contracts, financial information, or private conversations. And even if you are not sending top-secret data, you probably still want your emails to stay private. Continue reading
Mar
5
Using BYCOL function in Excel with formula examples
If you ever find yourself writing the same formula for multiple columns, BYCOL can save you time and effort. Instead of copying, adjusting references, and making sure nothing gets accidentally overwritten, BYCOL just takes the entire range and runs the calculation for each column automatically. Continue reading
Mar
3
How to digitally sign an email in Outlook
When you send an important email, you want the recipient to know it truly came from you and hasn't been changed along the way. That's exactly what a digitally signed email does. Continue reading
Feb
27
Google Sheets dropdown: create, use, edit and remove
Want to create a dropdown list in Google Sheets? Make it possible to select multiple items in one cell? Or maybe apply them to an entire column and create a dynamic list that syncs across spreadsheets? This tutorial walks you through every detail: from initial setup to advanced customization with colors and calendar pickers. Continue reading
Feb
26
How to get an S/MIME certificate and configure it in Outlook
When it comes to sending secure messages in Outlook, most instructions begin with: click the Encrypt or Sign button on the ribbon. But those buttons don't work by themselves. Before you can use them, you need a valid S/MIME certificate installed correctly on your computer. Continue reading
Feb
24
How to use BYROW function in Excel with formula examples
When working with large datasets in Excel, you often hit the same question: "How do I apply this calculation to every row in a range without copying formulas down?". BYROW is made for exactly that. Continue reading