Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (2024)

Table of Contents
How to add, manage and delete account in new Outlook How to save Outlook email message as PDF: single, multiple, with attachments How to print Outlook contacts How to print calendar from Outlook in desired date range and style How to print emails and attachments in Outlook How to change time zone in Outlook: classic, new app and web How to forward or redirect email from Outlook automatically Outlook rules not working automatically: errors and fixes How to create email rules in new Outlook and Outlook 365 online Outlook rules with examples: how to create, edit and remove Outlook conditional formatting: color-code or highlight emails, calendar and tasks How to schedule send in new Outlook and web app How to create an email template in new Outlook and web app How to create timeline for Excel pivot tables and charts How to make pivot charts in Excel How to use Copilot in Excel with examples Copilot in Outlook: how to get, enable and use XLOOKUP vs INDEX MATCH in Excel: which is better and faster? XLOOKUP vs VLOOKUP in Excel: differences and advantages Excel XLOOKUP with multiple criteria Chat GPT for Outlook email writing How to create an email group (contact group) in Outlook Block Outlook emails: from certain countries, with specific words How to repeat the last action in Excel with shortcut or command How to redo in Excel: comprehensive guide How to block email sender in Outlook and manage blocked list How to insert emoji and smiley in Outlook Excel Quick Analysis tool with examples How to use Power Query in Excel – practical examples Power Query in Excel tutorial: how to get, use and auto-refresh References

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (1)

Jun

5

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (2)

May

29

How to save Outlook email message as PDF: single, multiple, with attachments

Ever stumbled upon an email in Outlook that's too good to just sit in your inbox? Maybe it's a crucial work contract, a cherished recipe from grandma, or a funny meme from a friend. Whatever it is, get ready to discover the super easy technique to convert that email into a PDF. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (3)

May

22

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (4)

May

15

How to print calendar from Outlook in desired date range and style

First and foremost, Outlook is designed for managing schedules digitally. But sometimes it's necessary to have a hard copy of your planned events for those moments when you're away from the screen. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (5)

May

8

How to print emails and attachments in Outlook

Printing emails in Microsoft Outlook is a simple task once you know the steps. This comprehensive guide will help you navigate the Outlook interface with ease, select the right print settings and bring a message to life on paper. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (6)

May

1

How to change time zone in Outlook: classic, new app and web

Time zones can be a source of confusion and frustration, especially when managing a busy schedule across different regions. Whether you're a frequent traveler or working with international teams, adjusting the time zone in Outlook is essential to keep your schedule in sync. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (7)

Apr

22

How to forward or redirect email from Outlook automatically

Balancing multiple email accounts can often feel like juggling countless tasks simultaneously. But what if you could direct all your Outlook mail, perhaps to your trusty Gmail account? That's exactly what we're about to explore in this article. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (9)

Apr

10

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (10)

Apr

3

Outlook rules with examples: how to create, edit and remove

Imagine your Outlook as a tidy room where important emails are prioritized, distractions are filtered out and everything is neatly sorted into its rightful place. That's what Outlook rules can do for you. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (11)

Mar

27

Outlook conditional formatting: color-code or highlight emails, calendar and tasks

As your inboxes are overflowing with never-ending streams of emails and calendars are packed with numerous appointments, it's easy to feel swamped. However, there's a helpful tool in Microsoft Outlook called conditional formatting. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (12)

Mar

20

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (13)

Mar

13

How to create an email template in new Outlook and web app

The new Outlook and its accompanying web version have made many tasks easier. They also provide a simpler way to create and use email templates. But, like many other cool features, this one is tucked away from immediate view. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (14)

Mar

6

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (15)

Feb

28

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (16)

Feb

14

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (17)

Jan

31

Copilot in Outlook: how to get, enable and use

Are you feeling overwhelmed by the never-ending flood of emails? Enter Copilot in Outlook – an AI-powered virtual assistant that helps you manage your emails more efficiently and effectively. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (18)

Jan

24

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (19)

Jan

17

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (20)

Jan

9

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (21)

Dec

19

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (22)

Dec

13

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (23)

Dec

6

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (24)

Nov

29

How to repeat the last action in Excel with shortcut or command

Picture this: you've just performed some useful task in your worksheet, such as typing in numbers or formatting cells. Now, here's the exciting part - you can easily do that exact same thing with a simple keyboard shortcut. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (25)

Nov

22

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (26)

Nov

15

How to block email sender in Outlook and manage blocked list

If you're getting unwanted emails from certain people, a good way to stop them is by blocking those irrelevant and annoying senders. This helps to get rid of harmful messages and keeps your inbox clutter-free. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (27)

Nov

7

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 →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (28)

Nov

1

Excel Quick Analysis tool with examples

Microsoft Excel is a powerful spreadsheet application that can handle various types of data, but sometimes, you need to quickly get insights from your without diving deep into complex functions and formulas. That's where the Quick Analysis tool comes into play. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (29)

Oct

18

How to use Power Query in Excel – practical examples

In the previous article, we laid the groundwork by introducing the basics of Power Query. Now, it’s time to put it to use in real-world scenarios. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (30)

Oct

12

Power Query in Excel tutorial: how to get, use and auto-refresh

Here's the conundrum - how can we import, transform, and analyze data in Excel without spending hours on manual manipulations? The solution is Power Query, an invaluable tool for any data analyst, saving hours of time, reducing manual errors, and transforming an unruly informational chaos into a harmonious symphony of insights. Continue reading →

Tutorials, videos, useful tips for Excel, Outlook and Google Sheets (2024)

References

Top Articles
Latest Posts
Article information

Author: Dong Thiel

Last Updated:

Views: 6296

Rating: 4.9 / 5 (79 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Dong Thiel

Birthday: 2001-07-14

Address: 2865 Kasha Unions, West Corrinne, AK 05708-1071

Phone: +3512198379449

Job: Design Planner

Hobby: Graffiti, Foreign language learning, Gambling, Metalworking, Rowing, Sculling, Sewing

Introduction: My name is Dong Thiel, I am a brainy, happy, tasty, lively, splendid, talented, cooperative person who loves writing and wants to share my knowledge and understanding with you.