Excel tutorials, functions and advanced formula examples

Add text to Google Sheets cells at a certain position: at the beginning/end, before/after characters

This tutorial will teach you how to add text in Google Sheets at the same position of all cells at once: at the beginning, at the end, after the N-th character, before or after particular characters. 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

How to create and format tables in Outlook email templates

In this article, you’ll see how to create, modify and fill Outlook tables and use them as templates for your emails. Continue reading

Excel spill range explained

Spilling is one of the new features introduced in Excel 365 as part of the dynamic arrays functionality. Understanding the spill range concept is the focus of this tutorial. Continue reading

How to create fillable Outlook email templates from datasets

Learn how to create and use fillable email templates in Outlook and populate dynamic fields of your message on a fly when pasting the templates. Continue reading

Implicit intersection and @ operator in Excel 365 and older versions

You have the feeling you know everything about your Excel workbooks, and then a @ character appears from nowhere in the beginning of your formulas. What does this mean? And how does it work precisely? Continue reading

Video: how to split cells with names in Google Sheets

Come take a look at our Split Names add-on for Google Sheets. It's much more powerful than the standard Split text to columns tool for it separates first, middle and last names, and recognizes more than 80 titles and 40 post-nominals in any name combinations. 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

Excel: prevent text from spilling over into next cells

When entering a long text in a cell, you may notice that sometimes it spills out into adjacent columns and at times gets hidden behind the neighboring cells. How does Excel determine what to do and how do you stop words from overflowing into next cells? Continue reading

Video: how to change case in Google Sheets

When it comes to changing cases in Google Sheets, formulas are hardly the best option. Come take a look at a small utility that changes cases in your entire selection on the fly. 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

How to use PV function in Excel to calculate present value

Weather you are thinking about buying an insurance annuity or putting some money in a saving account, you are wondering - is that a good deal? To know it for sure, you need to find the present value of an investment. For this, Microsoft Excel provides the PV function. Continue reading

How to calculate present value of annuity in Excel: formula and calculator

If offered a choice to receive a certain sum of money right now or defer the payment into the future, which would you choose? For most of us, taking money now is a natural instinct. In the financial world, this is explained by the time value of money concept. Continue reading

How to change case in Google Sheets: UPPER, lower, Capitalize Each Word, Sentence case, tOGGLE

Changing text case in Google Sheets may seem an intricate task as there is no such option in the standard menu. Even so, the task is very much resolvable. In this blog post, I share different ways to capitalize your words or turn them into lowercase, uppercase, and sentence case. Continue reading

How to make and use Excel data entry form

When it comes to inputting information in Excel spreadsheets, most people do it the traditional way - cell by cell, row by row. To make the process more use-friendly and less time-consuming, you can use a special data entry form. Continue reading

WHAT TO ENTER macro – the most useful helper in Shared Email Templates

Let’s continue exploring Shared Email Templates and get acquainted with its best macro - WHAT TO ENTER. You’ll see how to set it up to make your Outlook routine correspondence quicker and easier. Continue reading

Video: how to enable formulas built by the Combine Sheets add-on

If you're about to pull data from multiple Google sheets into one using our Combine Sheets add-on, you will most likely try to get the result as a formula to keep it in-sync with the original tables. This video features 2 important steps you have to take before that formula starts working for you. 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

Video: how to pull data from other Google sheets into one table

Today's video features the easiest way to combine numerous Google sheets into one. Combine Sheets add-on brings data from different documents and common columns together, keeps your formatting, and automatically supplies the resulting table with the up-to-date info from the source sheets. Continue reading

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30