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

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

Excel #SPILL! error - causes and fixes

Just imagine this: you upgraded to Microsoft Office 365 with the latest Excel updates and for some reason the tried and tested formulas you've been using for years have suddenly stopped working. Whatever you do, you are now getting a #SPILL error. Does anyone know what it means? Continue reading

Using NPER function in Excel with formula examples

When building corporate funds, financial analysts often wish to know how long it will take to reach the desired corpus. When applying for a loan, you may want to find out how many payments are required to repay it in full. For such tasks, Excel provides the NPER function. Continue reading

Using LET function in Excel with formula examples

If you work with lengthy formulas in Excel, then you are certainly familiar with the idea of named ranges that make complex formulas easier to read. And now, Microsoft is making a step further and allows assigning names to calculations and values directly in a formula. Continue reading

How to find and fix broken links in Excel

Excel cells may often link to other workbooks to pull relevant information from there. When a source workbook gets deleted, relocated, or damaged, external references to that file break down and your formulas start returning errors. Obviously, to fix the formulas, you need to find broken links. Continue reading