Tutorials for Excel, Outlook and Google Sheets

Google Sheets IMPORTRANGE: The Complete Guide

Tired of endless copy-pasting between Google Sheets? Learn to master the IMPORTRANGE function and create live, auto-updating data connections. This comprehensive guide provides step-by-step examples for combining, filtering, and troubleshooting your data, saving you hours of manual work. Continue reading

How to recover a deleted draft in Gmail

Gmail's automatic draft saving is incredibly helpful, but what happens when a crucial draft vanishes? Unlike regular deleted emails, drafts often disappear without a trace. This guide provides five effective ways to recover a deleted draft in Gmail, from quick undo options to leveraging secondary devices. Continue reading

How to edit or delete templates in Gmail

Tired of rewriting the same emails? Gmail templates can save you hours, but what happens when they need updates or cleanup? Discover the quickest way to edit, delete, and even recover templates (yes, it’s possible!) in just a few clicks. Continue reading

Outlook email attachment size limit and how to increase it

Email attachments are a convenient way to share files quickly, but size limits can get in the way, especially when you're sending large images, detailed reports, or presentation decks. Understanding these limits and knowing how to work around them can help you avoid errors and get your files where they need to go. Continue reading

How to create and use multiple signatures in Gmail

Need different email signatures for internal teams, clients, or quick replies? Gmail lets you create multiple signatures effortlessly and even set default options per account. This guide provides step-by-step instructions on how to create, change, delete, and switch between them. Continue reading

How to export emails from Outlook – all or specific messages

Exporting emails from Outlook can be helpful for a variety of tasks. No matter your reason – decluttering your inbox, archiving important communications, or preparing for a platform switch – Outlook gives you the tools to create secure backups, filter precisely what you need, and even transform your messages into a spreadsheet-friendly format for deeper analysis. Continue reading

How to automatically download images in Outlook

When you receive an email in Microsoft Outlook that contains images, they're often blocked by default for security and privacy reasons. While this is helpful for protecting your data, it can get frustrating, especially if you receive dozens of emails from your partners or clients containing pictures you need to view. Continue reading

How to permanently delete emails from Outlook

When you delete an Outlook email using the standard method, it moves to the Deleted Items folder rather than being immediately erased. This means it still takes up space and can be recovered until the folder is emptied. If you want to remove emails permanently, Outlook offers several options. Continue reading

How to clean up Outlook mailbox to free up space

Outlook provides quite generous storage space, allowing you to manage emails, attachments, and other data. But if you have been using Outlook for years without cleaning up your mailbox, the storage might be full. Big mailboxes are slower to open and search, making it harder to find important messages. Continue reading

How to mass delete emails in Outlook

If your Outlook inbox is cluttered with unwanted messages, mass deleting emails can help you clean up quickly while keeping important ones intact. This article primarily focuses on the new Outlook and web app, which offer several efficient tools for bulk deletion, while also providing tips for the classic desktop application. Continue reading

How to enable templates in Gmail

If you find yourself typing the same email over and over, Gmail templates will be a huge time-saver. Instead of manually copying and pasting text, you can create templates and send them in just a few clicks. But before you can use them, you need to enable templates in Gmail. Continue reading

How to VLOOKUP and XLOOKUP in Excel with Copilot

With Excel Copilot, creating VLOOKUP and XLOOKUP formulas is as easy as explaining your task in plain language. This guide walks you through using Copilot in both the desktop Excel app and in browser to perform quick, accurate lookups – no advanced formula skills needed! Continue reading

How to share email templates in Gmail

Looking for a way to share Gmail templates with your team? Gmail doesn't have a built-in option, but there are 4 workarounds. From simple copy-pasting to using powerful extensions, this guide will walk you through them all. Continue reading