How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Excel Functions Tutorials
We hope that you will enjoy our Excel Functions tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own Excel Functions tutorial to our site. Thank 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!
Excel Countif and Sumif
Great Excel function tutorial covering Count, CountIf, Sum, SumIf, and SumProduct.
This tutorial teaches you how to insert the Vlookup function in Excel.
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.
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.
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.
Adding Numbers using Autosum
Autosum feature is used to make summing operation as fast as possible. I presented a few ways you can use Autosum.
This tutorial teaches you how to conditionally sum a range using the Sumif function.
Excel Date & Time Functions
Dates and times are stored as numbers in Excel and count the number of days since January 1st, 1900.
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.
Excel Absolute & Relative Reference
Cell references in Excel are very important. With the help of easy examples we show you the difference between the different type of references in Excel.
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.
The DAverage function in Excel is used to calculate the average of values in database based on entered criteria.
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
Create an Excel Football League Table
Create an Excel football league table to automatically find the leaue position of teams based on results throughout a season. Enter the results and watch the league position change.
Total Tutorials in Category: 178