The tutorial demonstrates a few quick and easy ways to trim spaces in Excel – leading, trailing, and excess spaces between words. Continue reading
There is no special function to calculate age in Excel, however there exist a few different ways to convert date of birth to age. This tutorial will explain the advantages and drawbacks of each way, shows how make a perfect age calculation formula in Excel and tweak it for solving some specific tasks. Continue reading
Learn different ways you can combine unique values or sum numbers that refer to the same record in Excel Continue reading
In our previous article, we discussed different aspects of Excel Advanced Filter and how to use it to filter rows with AND as well as OR logic. Now that you know the basics, let's have a look at more complex criteria range examples that may prove helpful for your work. Continue reading
Excel SUMPRODUCT is a remarkably versatile function with many uses. The aim of this tutorial is to reveal the full power of SUMPRODUCT and teach you how to compare arrays in a clever and elegant way, conditionally sum or count cells with multiple criteria, get a weighted average, and more. Continue reading
The tutorial explains the specificities of Excel SUBTOTAL function and shows how to use Subtotal formulas to summarize data in visible cells. Continue reading
Worksheets with a lot of data can often look cluttered and difficult to comprehend. Luckily, Microsoft Excel provides a powerful Subtotal feature that lets you quickly summarize different groups of data and create an outline for your worksheets. Continue reading
The tutorial explains the basics of the Compound Annual Growth Rate and provides a few formulas to calculate CAGR in Excel. Continue reading
From this short tutorial you'll learn about the new IFS function and see how it simplifies writing nested IF in Excel. You'll also find its syntax and a couple of use cases with examples... Continue reading
Excel doesn't provide any function or built-in tool for counting the number of words in a cell or range. Luckily, we can combine serval functions within a formula to get the desired result. In this tutorial, you will find a few useful formulas to count total or specific words in a cell or range. Continue reading
The tutorial explains how to count characters in Excel. You will learn the formulas to get the total character count in a range, and count only specific characters in a cell or in several cells. Continue reading
Are you looking for an Excel formula to count characters in a cell? If so, then you have certainly landed up on the right page. This short tutorial will teach you how you can use the LEN function to count characters in Excel, with or without spaces. Continue reading
See three simple ways you can find and remove duplicates in Excel: use standard functions, Conditional Formatting, or a special add-in. Continue reading
Splitting text from one cell into several cells is the task all Excel users are dealing with once in a while. Today, we are going to take an in-depth look at how you can break strings into different elements using formulas and the Split Text feature. Continue reading
This short tutorial shows how a usual Excel Sum formula with a clever use of absolute and relative cell references can quickly calculate a running total in your worksheet. Continue reading
Learn about two Excel techniques to concatenate strings using the brand new TEXTJOIN and CONCAT functions. Continue reading
There are quite a few ways you can find matches and differences between columns. We suggest trying one of three reliable methods described in this video any time you need to compare columns in the same or in different sheets. Continue reading
The tutorial shows the most effective ways to use Excel's AutoSum feature and write your own Sum formulas to total a column, rows or selected range. You will also learn how to sum only visible cells, calculate running total and find out why your Sum formula is not working. Continue reading
In this video you’ll learn several ways you can change case of your records in Excel spreadsheets. We’ll look at a special tool that allows you to capitalize the first character in each cell or update the selected values to uppercase, lowercase, or proper case; we’ll learn the standard Excel functions we can use, and see how we can employ Flash Fill in Excel. Continue reading
This article introduces you to the Excel SWITCH function, describes its syntax and provides a couple of use cases to illustrate how you can simplify writing nested IFs in Excel. Continue reading