Excel functions, page 6
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
Video: How to compare two columns in Excel
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
Excel Sum formula examples - how 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
Video: How to change text case in Excel
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
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 count unique values in Excel
In this tutorial, you will learn how to count unique values in Excel with formulas, and how to get an automatic count of distinct values in a pivot table. We will also discuss a number of formula examples for counting unique names, texts, numbers, cased-sensitive unique values, and more. Continue reading
Excel COUNT and COUNTA functions to count cells
This short tutorial explains the basics of the Excel COUNT and COUNTA functions and shows a few examples of using a count formula in Excel. You will also learn how to use the COUNTIF and COUNTIFS functions to count cells that meet one or more criteria. Continue reading
How to find duplicates in Excel: identify, highlight, count, filter, and more
The tutorial explains how to search for duplicates in Excel. You will learn a few formulas to identify duplicate values or find duplicate rows with or without first occurrences. You will also learn how to count instances of each duplicate record individually and find the total number of dupes in a column, how to filter duplicates, and more. Continue reading
How to copy formula in Excel: down a column, without changing references, etc.
In this tutorial, you will learn a few different ways of copying formulas in Excel: how to copy formula down a column, to all of the selected cells, copy a formula exactly without changing cell references or formatting, and more. Continue reading
How to hide and lock formulas in Excel
This tutorial shows how to hide formulas in Excel so they do not show up in the formula bar. Also, you will learn how to quickly lock a selected formula or all formulas in a worksheet to protect them from being deleted or overwritten by other users. Continue reading
How to show formulas in Excel
In this short tutorial, you will learn an easy way to show formulas in Excel 2016, 2013, 2010 and older versions. Also, you will learn how to print formulas and why sometimes Excel shows a formula, not result, in a cell. Continue reading
How to make formulas in Excel
The tutorial explains how to write formulas in Excel, beginning with very simple ones. You will learn how to create a formula in Excel using constants, cell references and defined names. Also, you will see how to make formulas using … Continue reading
Microsoft Excel formulas with examples
Can Microsoft Excel formulas be easy to learn? Yep! This tutorial explains the very basics of Excel formulas for beginners, with detailed steps on how to write and use them. It also provides a number of advanced formula examples for experienced users. You will be amazed how simple creating formulas in Excel actually is. Continue reading
Circular reference in Excel - how to check, find, enable, or remove
This short tutorial explains the basics of Excel circular reference and why you should beware of using them. You will also learn how to check, find and remove circular references in Excel worksheets, and if none of the above is an option, how to enable and use circular formulas. Continue reading
3-D reference in Excel: reference the same cell or range in multiple worksheets
This short tutorial explains the essence of Excel 3-D reference and shows how you can calculate multiple worksheets with a single 3-D formula. Continue reading
How to create external reference in Excel to refer to another sheet or workbook
This short tutorial explains the basics of an external reference in Excel, and shows how to reference another sheet and workbook in your formulas. Continue reading
Why use dollar sign ($) in Excel formulas - absolute and relative cell references
When writing an Excel formula, $ sign in cell references confuses many users. But the explanation is very simple. The dollar sign in an Excel cell reference serves just one purpose - it tells Excel whether to change or not to change the reference when the formula is copied to other cells. And this short tutorial provides full details about this great feature. Continue reading
Using REPLACE and SUBSTITUTE functions in Excel - formula examples
The tutorial explains the Excel REPLACE and SUBSTITUTE functions with examples of uses. See how to use the REPLACE function with text strings, numbers and dates, and how to nest several REPLACE or SUBSTITUTE functions within one formula. Continue reading
Excel FIND and SEARCH functions with formula examples
The tutorial explains the syntax of the Excel FIND and SEARCH functions and provides formula examples of advanced non-trivial uses. Continue reading
Calculating moving average in Excel
In this short tutorial, you will learn how to quickly calculate a simple moving average in Excel, what functions to use to get moving average for the last N days, weeks, months or years, and how to add a moving average trendline to an Excel chart. Continue reading
