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

How to share files securely with OneDrive

There are a few different ways to share documents on OneDrive, and you may be asking yourself which is the best one. For the most part, the answer depends on the situation and your ultimate goals. But I can show you the most secure way. Continue reading

How to share OneDrive files and folders

Like most other online storages, OneDrive was designed with collaboration in mind, and they strived to make the sharing process easy and intuitive. However, there are some caveats to take notice of, especially when adding and syncing shared files to your computer. Continue reading

How to remove table formatting in Excel

By default, Excel tables are equipped with a number of great features including predefined table styles. In some situations, however, you may want to remove formatting keeping all other functionality of a table. This tutorial will teach you how to quickly do that. Continue reading

Excel LAMBDA function: how to write and use

Until recently, user-defined functions were the prerogative of programmers. The introduction of the LAMBDA function has made them available for everyone. With this wonderful addition to Excel's toolbox, we no longer need VBA skills to create our own custom functions. Continue reading

How to create a meeting template in Outlook

An engaging and informative invitation is an important part of running a successful meeting, and a well-crafted template can save you enormous time on the job. This article looks at how to quickly create meeting templates in Outlook, preset any fields, add input boxes, drop-down menus, and more! Continue reading

Outlook Quick Steps: how to create and use

When doing the same things day in and day out, most irritating is the necessary do it from scratch every time. What would you say if instead of tedious multi-step processes you could accomplish your email routines with a button click? It is what Outlook Quick Steps are all about. Continue reading

How to remove duplicates in Excel cell

When it concerns removing duplicate cells or rows, Microsoft Excel offers a number of different options. But when it comes to removing duplicate text within a given cell, Excel provides… nothing. Well, if there is no inbuilt function we need, let's go write our own one. Continue reading