Excel tutorials, functions and advanced formula examples

Aug
28

How to calculate average in Excel: AVERAGE, AVERAGEIF and AVERAGEIFS functions

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

Aug
27

Wanted: Excel users seeking to mitigate spreadsheet risk

Learn about ExcelAnalyzer - a great tool for checking your spreadsheet data and eliminating spreadsheet risk. Continue reading

Aug
26

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

Aug
25

Use Outlook Tasks and still feel disorganized? Try the Tasklist add-in

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

Aug
12

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

Aug
6

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

Jul
22

Merge two or more 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

Jul
15

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

Jul
8

Excel random number generator - 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

Jul
1

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

Older posts →