Excel formulas, page 8
Excel Advanced Filter - how to create and use
Excel Filter provides a variety of filtering options for text, numbers, and dates. The inbuilt filters can handle many scenarios. Many, but not all! When a regular AutoFilter can't do what you want, use the Advanced Filter and configure the criteria exactly suited to your needs. Continue reading
Excel SUMPRODUCT function with formula examples
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
Excel SUBTOTAL function with formula examples
The tutorial explains the specificities of Excel SUBTOTAL function and shows how to use Subtotal formulas to summarize data in visible cells. Continue reading
How to add, use and remove Subtotals in Excel
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
How to calculate CAGR (compound annual growth rate) in Excel - formula examples
The tutorial explains the basics of the Compound Annual Growth Rate and provides a few formulas to calculate CAGR in Excel. Continue reading
Use the new Excel IFS function instead of nested IF
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
How to clear formatting in Excel
Manually changing cell color, font, borders, alignment and other formatting options is tiresome and time-consuming. Luckily, Microsoft Excel provides a couple of quick and simple ways to clear formatting in a worksheet. Continue reading
Format Painter and other ways to copy formatting in Excel
Microsoft Excel has an amazingly simple way to copy formatting, which is often overlooked or underestimated. This tutorial shows the most efficient ways to use Excel Format Painter, Fill Handle and Paste Special to copy formatting to a selected cell, range, entire column or row. Continue reading
Custom Excel number format
Custom number formatting in Excel is a very powerful tool, and once you learn how to use it property, your options are almost unlimited. This tutorial explains the basics of the Excel number format and provides the detailed guidance to create custom formatting. Continue reading
How to format cells in Excel (number, text, scientific notation, etc.)
When it comes to formatting cells in Excel, most users know how to apply basic text and numeric formats. But do you know how to display the required number of decimal places or a certain currency symbol, and how to apply just the right scientific notation or accounting number format? Continue reading
How to count words in Excel
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
How to count characters in Excel: total or only specific characters in a cell / range
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
How to use LEN function in Excel to count characters in a cell
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
How to split text string in Excel by comma, space, character or mask
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
Excel Cumulative Sum - easy way to calculate running total
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
How to use AutoSum in Excel
Did you know that Excel SUM is the function that people read about most? No wonder they decided to add a special button to the Excel ribbon that inserts the SUM function automatically. So, if you wanted to know "What is AutoSum in Excel?" you already got the answer. Continue reading
How to concatenate text in Excel using the TEXTJOIN and CONCAT functions
Learn about two Excel techniques to concatenate strings using the brand new TEXTJOIN and CONCAT functions. Continue reading
Excel SUM formula to total a column, rows or only visible cells
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
Excel SWITCH function - the compact form of nested IF statement
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
How to get a list of unique and distinct values in Excel
If you want to get a list of unique values in a column, this tutorial offers a number of formulas and will teach you how to tweak them for different datasets. You will also learn how to quickly get a distinct list using Excel's Advanced Filter, and how to extract unique rows with Duplicate Remover. Continue reading