How To Use 3D-reference In Excel

A 3D-reference in Excel refers to the same cell or range on multiple worksheets.

How To Use Aggregate Function (WS) In Excel

Excel functions such as SUM, COUNT, LARGE and MAX don’t work if a range includes errors.

How To Use AverageIf function In Excel

The AVERAGEIF function in Excel calculates the average of cells that meet one criteria.

How to Use Circular Reference In Excel

A formula in a cell that directly or indirectly refers to its own cell is called a circular reference.

How to use EXACT function Compare Text In Excel

This example shows two ways to compare text in Excel. One is case-sensitive and one is case-insensitive.

How to Use VLOOKUP function find Closest Match In Excel

To find the closest match to a target value in a data column, use the INDEX, MATCH, ABS and the MIN function in Excel.

How to Calculate Compound Annual Growth Rate in Excel

Compound annual growth rate (CAGR) is the rate of return that would be required for an investment to grow from its beginning balance to its ending balance, assuming the profits were reinvested at the end of each year of the investment’s lifespan.

How to Count the Number of Cells that Contain Specific Text

Let’s say you want to ensure that a column contains text, not numbers. Or, perhapsyou want to find all orders that correspond to a specific salesperson. If you have no concern for upper- or lowercase text, there are several ways to check if a cell contains text.

Usually with the IF function you test a cell for a complete match, but in this example we need a partial match on text.

How to Use Two-column Lookup in Excel

If you want to look up a value in a table using one criteria, it’s simple. You can use a plain VLOOKUP formula. But if you want to use more than one criteria, what can you do? There are lots of ways using several Excel functions such as VLOOKUP, LOOKUP, MATCH, INDEX, etc. In this blog post, I’ll show you a few of those ways.

How to Remove Spaces in Excel

Sometimes, when you copy data from other locations and pasted them at Excel worksheet, there may be some extra spaces leaving at front or the end of strings in cells. It is time-consuming to delete the spaces one by one for making data looks tidy. Here this tutorial introduces the smart and easy ways help you to quickly remove leading and trailing spaces.

How To Use Calculate Age TODAY function In Excel

To calculate the age of a person in Excel, use the DATEDIF function and the TODAY function.

How to Use Forecast and Trend in excel

If you have historical time-based data, you can use it to create a forecast. When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. A forecast can help you predict things like future sales, inventory requirements, or consumer trends.

How to use Index Match in Excel

Quickly learn all you need to know about INDEX & MATCH to get a quick start.

How to use the AVERAGE function in Excel

Finding averages is often required when working with spreadsheets.

It’s a rather basic task—but Excel can do all sorts of great things with averages.

How to use Today's Date With Worksheet in Excel

Let’s say that you want to easily enter the current date and time while making a time log of activities.