Calculating how much each value contributes to a total is something many Excel users do every day. In older versions, this usually meant creating your own formula that divided a part by the whole. The PERCENTOF function gives you a quick and direct way to return that percentage without building a formula manually. Continue reading
For a long time, the new Outlook app and Outlook online only provided simple text snippets through the My Templates add-in. Those worked fine as quick phrases for repetitive emails, but they fell short whenever you needed a complete, formatted ready-to-send message with attachments. That gap is finally filled. Continue reading
If you're tired of that old photo in your Outlook profile or still have the default initials, it's time for an update. Your profile picture is more than just an image - it's how people see you in their inbox. Continue reading
Want to know how to sort your inbox automatically? Learn how to use Gmail rules to organize your messages effortlessly. This complete guide covers everything you need to know about Gmail filters – from creating, editing, and sharing rules to advanced tricks for managing spam, sorting by date, and organizing unread messages. Continue reading
If you've already used Excel checkboxes to track project milestones, a progress bar is the perfect next step. It gives you a clear visual snapshot of how close you are to reaching a goal. In Excel, you can easily create a progress bar using conditional formatting or charts, no coding required. Continue reading
There are many possible reasons why Outlook might start misbehaving. This guide will help you identify and troubleshoot the problem. We'll start with quick and simple steps that address the most common causes, then move on to a few deeper fixes if the issue persists. Continue reading
Whenever you want to create a to-do list or project tracker, attendance sheet or review checklist, there is one small element you'll definitely need – a checkbox. In modern versions of Excel, adding checkboxes is much simpler than you might think, and you can set it up in under a minute. Continue reading
When Outlook stops responding, freezes at startup, or displays errors when opening your mailbox, the issue might be with the application itself or with the data file where Outlook stores all your emails, contacts, calendar entries, and other data. This guide explains how to repair both the Outlook app and its data files to restore normal performance without losing your data. Continue reading
When you send an important email, it's natural to wonder whether it reached the recipient and if they've read it. Outlook offers two tracking options that let you find out what happened after you hit the Send button: delivery notifications, which confirm that your message reached the recipient's mailbox and read receipts, which indicate that the message was opened. Continue reading
Even a well-written message can feel incomplete if the signature is outdated. If something about your job or contact details has changed, or you just want a more polished design, it's worth giving it a quick refresh. Updating your signature in Outlook only takes a few minutes. Continue reading
You open Outlook, type in the Search box, and… nothing. No results, even though you're sure the email is there. The issue might come from something as simple as a wrong filter setting or as complex as a broken index. Continue reading
Can't find Gmail's "High Priority" button? You're not alone! Read this article to learn how to send urgent emails, use Importance Markers, organize with colored stars and labels, and automate everything with filters. Continue reading
Want to delight your readers with a beautiful newsletter, but don't know how to make it? Learn how to partner with AI to create your newsletter content, generate and edit the perfect HTML code, paste it into Gmail, and launch your campaign. Continue reading
It happens to everyone: you open Outlook and, buried among dozens of messages, there are a few you haven't looked at yet. Managing those unopened emails doesn't have to be a guessing game. Continue reading
Not sure which method is best for sending your newsletter? This article covers all the options for mass sending, from the simple BCC method to the powerful Easy Mail Merge add-on. Plus, you'll learn how to boost reader engagement by scheduling your emails to send at the perfect time. Continue reading
Sorting through a busy mailbox can easily eat up a whole morning, but finding the right email in Outlook doesn't have to. Scrolling endlessly isn't the strategy. Continue reading
Ever wondered how small businesses create those beautiful newsletters? You can do it too! Learn all the ways to make an email newsletter in Gmail: customize built-in layouts, design templates using Google Docs, build with custom HTML, and even embed your Canva designs. Continue reading
Managing a crowded inbox can feel like trying to find a specific book in a messy library – things are there, but not where you expect them. Fortunately, Outlook provides a few easy ways to organize both your emails and folders. Continue reading
When you feel overwhelmed or limited in Outlook, you can change its default view to make it more convenient for your work. Outlook gives you plenty of flexibility to arrange your emails, calendar, and tasks however you like, so everything feels easy and natural to use. Continue reading
Is your Gmail inbox out of control? Learn how to use the archive function in Gmail to declutter your workspace without the risk of deleting important messages. This guide covers everything from finding your archived emails to setting up automatic filters, helping you create an organized inbox. Continue reading
If you often communicate with multiple people on various projects, keeping track of who said what can be a real challenge. Outlook's conversation mode can ease the pain. Instead of scrolling through long mail chains scattered in different folders, you can view the entire conversation in one place. Continue reading
If you spend a lot of time in Outlook, the way you navigate between your mailboxes and folders can either slow you down or help you breeze through tasks. As simple and straightforward as the Outlook Folder pane looks, it does have a few handy settings tucked away. Continue reading
Tired of getting lost in hundred-page reports? This guide shows you how to create, use and edit an outline, add and manage headings to navigate through your data efortlessly! Continue reading
With Outlook stationery, you can customize your emails using a variety of backgrounds, patterns, and fonts to reflect your unique style or brand. Sometimes, though, someone else's designs can carry over into your replies when you least expect it. Knowing how to set up and remove them helps you keep your emails looking just right on every occasion. Continue reading
When using Outlook on your desktop computer, web browser, or mobile app, you may have noticed your Inbox split into two tabs: Focused and Other. This feature, called Focused Inbox, is designed to help you prioritize emails, but not everyone finds it useful. Continue reading
Constant password prompts in Outlook can wear down even the most patient users. There may be several reasons for it, including outdated credentials, incorrect settings, or problems with your mail server. Continue reading
When you set up an account in Outlook, you specify an account password, so Outlook can access your mailbox and retrieve the messages. If you later change your credentials with the email service provider, you also need to update the password stored in the Outlook app. Continue reading
Want to create professional HTML email templates for Gmail? This guide covers four easy methods to cut through the noise in a crowded inbox with beautifully designed emails. Continue reading
The Reading Pane is one of those Outlook features that can quietly shape how you navigate your inbox each day. While it might seem like just another part of the screen, the way you use or don't use it can make a real difference in how quickly and effectively you get through your messages. Continue reading
Nobody likes clicking a link and landing in the wrong browser. Using system's default is a logical and user-friendly behavior that makes perfect sense. That's how Microsoft Outlook worked for years. But starting in 2023, things changed. Some versions of Outlook began opening web links in Microsoft Edge, ignoring your browser preferences. Continue reading