Subscribe
Tutorial search

Excel Function Tutorials


Sort by:
3 Special Excel Functions to Amaze You
3 Special Excel Functions to Amaze You
Want to up your Microsoft Excel game? This article will show you how to master three functions that will bring your skillset to the next and make you an Excel Wizard!
Difficulty:
Excel Countif and Sumif
Excel Countif and Sumif
Great Excel function tutorial covering Count, CountIf, Sum, SumIf, and SumProduct.
Difficulty:
Excel Vlookup
Excel Vlookup
This tutorial teaches you how to insert the Vlookup function in Excel.
Difficulty:
Offset Function
Offset Function
The OFFSET function in Excel has a wide variety of capabilities. It can be thought of as similar to the VLOOKUP and HLOOKUP functions, but with additional flexibility.
Difficulty:
Median Function in Excel
Median Function in Excel
The median is widely used in statistics where might be seen as a better indication of central tendency than arithmetic mean.
Difficulty:
Excel formulas and functions.
Excel formulas and functions.
A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
Difficulty:
Excel Sumif
Excel Sumif
This tutorial teaches you how to conditionally sum a range using the Sumif function.
Difficulty:
Excel Date & Time Functions
Excel Date & Time Functions
Dates and times are stored as numbers in Excel and count the number of days since January 1st, 1900.
Difficulty:
Excel VBA Function and Sub
Excel VBA Function and Sub
The difference between a function and a sub in Excel VBA is that a function can return a value and a sub cannot. Functions and subs become very useful as program size increases.
Difficulty:
Lookup in a Column to the Left in Excel
Lookup in a Column to the Left in Excel
Lookup data in a column to the left in Excel. The Vlookup function cannot look to the left in Excel. Index and Match can be used to lookup data from any column.
Difficulty:
Excel Vlookup
Excel Vlookup
The Vlookup function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column of the table.
Difficulty:
DAVERAGE Function
DAVERAGE Function
The DAverage function in Excel is used to calculate the average of values in database based on entered criteria.
Difficulty:
MMult Function
MMult Function
The MMULT function in Excel is used for matrix multiplication. It takes as inputs two arrays or matrices and outputs the matrix product of the two
Difficulty:
SUMPRODUCT
SUMPRODUCT
The SUMPRODUCT function in Excel is a useful tool when you are working with large datasets or multiple arrays.
Difficulty:
Array Formulas in Excel
Array Formulas in Excel
Arrays in Microsoft Excel are not a single function, but actually a variety of different formulas that you can use to simplify your work with arrays.
Difficulty:
Search Term(s) (1): function