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

Excel GROUPBY function to group rows and aggregate values

Microsoft Excel has always been great for sorting through lots of data and making sense of it. But now, there's a simple way to do it all with just a formula. Introducing the GROUPBY function – a handy and efficient tool to group and aggregate data without leaving the comfort of your formula bar. Continue reading

How to add, manage and delete account in new Outlook

As users make the switch to the new Outlook app, they're greeted with a refreshed interface that emphasizes modern design and ease of use. Whether you're adding a work account or consolidating personal emails, the new Outlook app caters to your needs with its intuitive and user-friendly approach. Continue reading

How to print Outlook contacts

Microsoft Outlook offers great convenience in organizing contacts digitally, but sometimes you might need a paper copy. This guide will walk through the simple steps to transform your virtual network into a neatly organized tangible list. Continue reading

How to create email rules in new Outlook and Outlook 365 online

If you've become accustomed to using rules to manage your email flow in classic Outlook, you'll be pleased to know that the new Outlook also includes this feature. Despite some differences in the setup process and a slightly reduced set of options, you can still create rules to automate the sorting of your emails and keep a tidy inbox. Continue reading

How to schedule send in new Outlook and web app

Imagine that you are working late at night, inspired by a brilliant idea, and you write the perfect email. But hold on, it's already past midnight, and sending it now might get lost in the morning rush. What if you could make sure the message lands in the recipient's inbox exactly when they are most receptive? This is the power of scheduled email sending. Continue reading

How to create timeline for Excel pivot tables and charts

You've got your data organized in a pivot table and are ready to dig in, but there is a catch – it has a time element. Maybe it's sales figures over months or project deadlines scattered throughout the year. How do you make sense of it all without drowning in numbers? The answer is timelines! Continue reading

How to make pivot charts in Excel

If you've ever felt overwhelmed by a large and cluttered spreadsheet, you're not alone. Fortunately, Excel pivot charts provide an easy way to create stunning visualizations of your data. Pivot charts are like magic: they let you summarize, analyze and explore your data with just a few clicks. Continue reading

How to use Copilot in Excel with examples

In the world of spreadsheet software, Excel has long reigned as the go-to tool for crunching numbers and analyzing data. But what of you had a smart assistant helping you navigate Excel's vast capabilities, giving you expert advice and quick insights. Continue reading

XLOOKUP vs INDEX MATCH in Excel: which is better and faster?

One of the most common tasks in Excel is to look up values in a table based on some criteria. In the past, Excel users relied on the VLOOKUP function for this job. However, it had its fair share of limitations, leading savvy Excel enthusiasts to craft a more resilient solution using the INDEX MATCH combination. Continue reading

XLOOKUP vs VLOOKUP in Excel: differences and advantages

If you work with Excel, you probably know how useful the VLOOKUP function is. But did you know that there is a newer and more powerful function called XLOOKUP that can do even more? In this tutorial, we will compare these two functions and see how they differ in syntax, functionality and performance. Continue reading

Excel XLOOKUP with multiple criteria

In Excel, there's this awesome function called XLOOKUP, which makes it really easy to find specific values in your tables. And guess what? It doesn't just look for one thing, it can also search using different conditions, so you can get exactly what you need from your data. Continue reading

Chat GPT for Outlook email writing

In today's professional world where people rely on email communication for various purposes, email writing is a vital skill. Whether you are sending a proposal, follow-up, meeting invite, or thank-you note, you want to make sure your message is clear, concise, and courteous. Continue reading

How to create an email group (contact group) in Outlook

Ever wish there was a better way to keep in touch with your favorite people? Outlook email groups can facilitate your communication with work pals, project partners, or your weekend squad. Just create a group, add your contacts, and boom – you're ready to send emails with a single click. Continue reading

Block Outlook emails: from certain countries, with specific words

In the modern digital era, our inboxes are essential hubs for both work and personal communications. Unfortunately, they often become cluttered with unwanted messages from unknown senders, annoying newsletters, unwelcome solicitations, or even potential phishing attempts. To safeguard yourself from online threats and scams, it's important to keep these suspicious messages out of your inbox. Continue reading

How to redo in Excel: comprehensive guide

As you work on complex spreadsheets in Excel, you may find yourself making changes, undoing them, and sometimes needing to re-apply your actions again. The Redo function is a handy feature that allows you to reverse the effects of an "undo" and restore your spreadsheet to a specific point in time. Continue reading

How to insert emoji and smiley in Outlook

In today's digital age, online communication has evolved far beyond mere words. We've found creative ways to express our emotions, humor, and personality by using small images known as "emojis" or "smileys". Microsoft Outlook has adapted to this trend, letting us incorporate emojis into emails. Continue reading