Subscribe
Tutorial search

Excel Tutorials


We hope that you will enjoy our Excel tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own Excel tutorial to our site. Thank you !

Sort by:
Create an Excel Football League Table
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.
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:
Highlight Birthdays Due this Month in Excel
Highlight Birthdays Due this Month in Excel
Keep track of birthdays using Excel to automatically format the birthdays due this month. Never miss a birthday again.
Difficulty:
How To: Protect Your Excel Spreadsheet From Unauthorized Changes (Excel 2007)
How To: Protect Your Excel Spreadsheet From Unauthorized Changes (Excel 2007)
If you work with a team of people using Excel, you may want to protect your Excel Spreadsheet from changes. Adding a password in order for people to make changes does just that.
Difficulty:
And Function
And Function
Learn to use the And Function in Excel. The And Function is used to display True or False depending on certain conditions.
Difficulty:
Excel VBA Loop
Excel VBA Loop
The Excel VBA Loop (or For Next loop) is a very useful programming statement which is often used in Excel VBA. First we will look at an easy example of how to loop through a one-dimensional range. You can also loop through a two-dimensional range using a Double Loop. In a similar way you can use three loops (a triple loop) to loop trough two-dimensional ranges on different Excel Worksheets. Besides For Next loops, there are other loops in Excel VBA, such as Do While Loops and For Each Next Loops.
Difficulty:
Excel VBA Array
Excel VBA Array
An Excel VBA Array is a group of variables. You can refer to a specific variable (element) of an Array by using the Array name and the index fnumber. This tutorial explains how to declare and initialize a one-dimensional and two-dimensional Array, how to Redim an Array and how to find the size of an Array.
Difficulty:
Char Function
Char Function
Got ASCII?? Learn to use the Char Function in Excel.
Difficulty:
Get the Weekday as Text in Excel VBA
Get the Weekday as Text in Excel VBA
A few methods to get the weekday of a date as text, using vba and standard functions.
Difficulty:
Excel VBA Range
Excel VBA Range
This tutorial explains the properties and methods of the very important Excel VBA Range object.
Difficulty:
Abs function
Abs function
This tutorial will review the Abs function. The Abs function returns the absolute value of a number.
Difficulty:
Excel VBA Userform
Excel VBA Userform
This tutorial teaches you how to create an Excel VBA Userform (also known as a dialog box). You can download the Userform as well.
Difficulty:
FV function
FV function
The Excel FV function stands for Future Value and returns the future value of an investment based on a given interest rate and a schedule of constant payments.
Difficulty:
DAYS360 Function
DAYS360 Function
The DAYS360 function is used to calculate the number of days between two dates. It is based on a 360 day calendar.
Difficulty:
Total Tutorials in Category: 585