# Excel tutorials, functions and advanced formula examples, page 16

## How to create a chart (graph) in Excel and save it as template

The tutorial explains the Excel charts basics and provides the detailed guidance on how tou will also learn how to combine two chart types, save a graph as chart template, change the default chart type, resize and move the graph. Continue reading

## Ultimate Suite compatible with Excel 2016 is out

The worldwide release of Office 2016 caused a lot of buzz among Microsoft users. So have we been moving full steam ahead to announce Ultimate Suite support for the latest version of Excel. 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

## How to use Find and Replace in Excel most efficiently

In this tutorial, you will learn how to use Find and Replace in Excel to search for specific data in a worksheet or workbook and what you can do with those cells after finding them. We will also explore the advanced features of Excel search such as wildcards, finding cells with formulas or specified formatting, find and replace in all open workbooks and more. 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

## How to calculate weighted average in Excel

The tutorial demonstrates two easy ways to calculate weighted average in Excel - by using the SUM or SUMPRODUCT function. Continue reading

## Consolidate data in Excel and merge multiple sheets into one worksheet

The tutorial demonstrates different ways to combine sheets in Excel depending on what result you are after – consolidate data from multiple worksheets, combine several sheets by copying their data, or merge two Excel spreadsheets into one by the key column. Continue reading

## How to calculate average (mean) in Excel - AVERAGE, AVERAGEIF, AVERAGEIFS formula examples

The tutorial demonstrates how to calculate average in Excel for numeric values and for cells with other data types. You will also learn how to use the AVERAGEIF and AVERAGEIFS functions to average cells that meet certain criteria. Continue reading

## How to compare two columns in Excel for matches and differences

The tutorial demonstrates a number of techniques to compare and match two or more columns in Excel with formulas, conditional formatting and the specialized wizard. Continue reading

Be sure to read this review if you actively use the Tasks option in Outlook, but still think it needs to support clear hierarchical structure. See how you can manage multiple Outlook tasks and deadlines with the Tasklist add-in. Continue reading

## Most useful Excel functions with formula examples

This page can be your entry point to learning Microsoft Excel functions. It lists the most essential text, math, statistical, logical and other functions along with formula examples and links to related resources. Continue reading

## How to round numbers in Excel - ROUND, ROUNDUP, ROUNDDOWN and other functions

The tutorial explains the uses of ROUND, ROUNDUP, ROUNDDOWN, FLOOR, CEILING, MROUND and other Excel rounding functions and provides formula examples to round decimal numbers to integers or to a certain number of decimal places, extract a fractional part, round to nearest 5, 10 or 100, and more. Continue reading

## How to merge cells in Excel without losing data

The tutorial demonstrates different techniques to quickly merge two cells in Excel and combine multiple cells without losing data in Excel 2016, 2013, 2010 and lower. Continue reading

## CONCATENATE in Excel: combine text strings, cells and columns

In this tutorial, you will learn various ways to concatenate text strings, cells, ranges, columns and rows in Excel using the CONCATENATE function and "&" operator. Continue reading

## How to generate random numbers in Excel - RAND and RANDBETWEEN functions

The tutorial explains the specificities of the Excel random number generator algorithm and demonstrates how to use RAND and RANDBETWEEN functions in Excel to generate random numbers, dates, passwords and other text strings. Continue reading

## How to convert time to decimal number, hours, minutes or seconds in Excel

The tutorial demonstrates different ways to convert time to decimal in Excel. You will find a variety of formulas to change time to hours, minutes or seconds as well as convert text to time and vice versa. Continue reading

## How to calculate time in Excel - time difference, adding / subtracting times

The tutorial explains different ways to calculate times in Excel and demonstrates several methods of adding times and calculating time difference. You will learn a few useful formulas to sum times and add hours, minutes or seconds to a given time. Continue reading

## Excel time format & how to use NOW and TIME functions to insert time

In this tutorial, you will learn the specificities of Excel time format as well as how to add a timestamp using shortcuts or insert updatable current time using the NOW function. You will also learn how to apply special Excel time functions to get hours, minutes or seconds from a time stamp. Continue reading

60+ professional tools for Excel