Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Use SUMPRODUCT in Excel: Syntax, Conditions and Weighted Average

SUMPRODUCT is one of the most useful functions in Excel, and one of the least understood. At its simplest, it multiplies the matching items of two or more lists and adds up the results, which is exactly what you need to calculate total revenue from units and prices in one cell. Used with conditions, it

Standard

How to Make a Line Graph in Excel: Step by Step With Multiple Lines and Trendline

A line graph connects data points with a line, so it shows how a value changes over time. It is the best choice for trends, such as monthly sales, website visitors, temperature or the price of a share. Excel can draw one in a few clicks, and with a little formatting it looks clean enough

Standard

How to Use IFERROR in Excel: Hide Errors and Return Clean Results

IFERROR is an Excel function that checks a formula and, if the formula returns an error, gives you another value instead. It turns ugly results such as #DIV/0! and #N/A into a clean zero, a blank cell or a short message such as Not found. It is one of the most used functions in real

Standard

How to Use LEFT, RIGHT and MID in Excel: Extract Text With Formulas

The LEFT, RIGHT and MID functions take a piece of text out of a cell. LEFT takes characters from the start, RIGHT takes them from the end, and MID takes them from the middle. They are the basic tools for cleaning data: splitting a product code, getting a country code from a phone number, finding