Tutorials for Excel, Outlook and Google Sheets

How to create a newsletter in new Outlook and web

Sending a newsletter is a simple way to stay in touch with clients, colleagues, or community members. With the new Outlook app and Outlook on the web, you can now create and send well-structured updates, reports, and other internal communications right where you already work, without any extra tools. Continue reading

How to put emoji in Excel cells, formulas, charts

We've got used to expressing our emotions in online communications with emojis and smileys. But do you know that you can add them to your spreadsheets as well? In Excel, emojis work like text characters, which means you can insert them into cells, copy and paste them, and even use in formulas. Continue reading

How to add and schedule a Teams meeting in Outlook

Microsoft Outlook and Teams work closely together, giving you a simple way to set up online meetings without jumping between the apps. That said, the steps vary depending on which Outlook version you are using, and at times certain settings or glitches can cause the Teams option to disappear. Continue reading

How to create HTML email template in Outlook

Creating an HTML email template in Outlook lets you reuse well-designed messages without starting from scratch every time. It helps keep essential elements, such as logos, buttons, legal text and signature blocks, consistent across all your emails. Continue reading

How to lookup and return multiple matches in Excel

Finding a single match in Excel is easy with VLOOKUP or XLOOKUP. The challenge comes when you need to pull all matching values, not just the first one. To accomplish the task in pre-dynamic Excel, you had to rely on several nested functions working together, which was quite complex and far from beginner-friendly. Continue reading

Excel PERCENTOF function to calculate percentage of total

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

Filter emails in Gmail: create and manage rules

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

How to create Excel progress bar based on checkboxes

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

How to add a checkbox in Excel 365 and use in formulas

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

How to repair Outlook PST / OST data files and app (365 - 2013)

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

How to request read receipt and delivery confirmation in Outlook

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

How to update email signature in Outlook

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

How to send an email newsletter in Gmail

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