Page 16 of 29 · 695 articles
The correlation coefficient (a value between -1 and +1) tells you how strongly two variables are related to each other. We can use the CORREL function or the Analysis Toolpak add-in in Excel to find the correlation coefficient between two variables.
You can use Excel's Find and Replace feature to quickly find specific text and replace it with other text. You can use Excel's Go To Special feature to quickly select all cells with formulas notes conditional formatting constants data validation etc.
The powerful SUMIF function in Excel sums cells based on one criteria. This page contains many easy to follow SUMIF examples.
This page teaches you how to create a running total (cumulative sum) in Excel. A running total changes each time new data is added to a list.
The XMATCH function in Excel enhances the MATCH function by adding new features making it ideal for finding the position of items within arrays or cell ranges. This guide will detail how to use XMATCH through practical examples and will highlight its advantages over MATCH.
The data form in Excel allows you to add edit and delete records (rows) and display only those records that meet certain criteria. Especially when you have wide rows and you want to avoid repeated scrolling to the right and left the data form can be useful.
The MOD function in Excel gives the remainder of a division. You can use the MOD (Modulus) function to determine whether a number is divisible by another number or to check if a number is even or odd.
Learn how to work with dates and times in Excel VBA. The following macro gets the year of a date. To declare a date use the Dim statement. To initialize a date use the DateValue function.
To find the maximum value in Excel use the MAX function. To find the cell address of the maximum value in a column use MAX MATCH and ADDRESS.
The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program.
This example teaches you how to insert a calculated field or calculated item in a pivot table in Excel.
Learn how to create ActiveX controls such as command buttons text boxes list boxes etc. To create an ActiveX control in Excel VBA execute the following steps.
This tutorial will guide you through the process of alphabetizing in Excel. While sorting data alphabetically in Excel is easy certain situations may require more advanced techniques to achieve the desired alphabetical order.
Counting with Or criteria in Excel can be tricky. This article shows several easy to follow examples.
Excel functions such as SUM COUNT LARGE and MAX don't work if a range includes errors. However you can easily use the AGGREGATE function to fix this.
Below we will look at a program in Excel VBA that creates a pattern.
Below we will look at a program in Excel VBA that creates a User Defined Function. Excel has a large collection of functions. In most situations those functions are sufficient to get the job done. If not you can create your own function called User Defined Function or custom Excel function. You can access a User Defined Function just like any other Excel function.
The MsgBox function in Excel VBA can return a result while a simple MsgBox cannot.
The 'subscript out of range' error in Excel VBA occurs when you refer to a nonexistent collection member or a nonexistent array element.
A circular reference in Excel occurs when a formula directly or indirectly refers to its own cell. This is not possible. Let's start simple.
Flash fill is a great Excel tool. Learn how to use flash fill to automatically extract data combine data and much more.
This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel. The following tax rates apply to individuals who are residents of Australia.
A gauge chart (or speedometer chart) combines a Doughnut chart and a Pie chart in a single chart. If you are in a hurry simply download the Excel file.
By default UDF's (User Defined Functions) in Excel VBA are not volatile. They are only recalculated when any of the function's arguments change. A volatile function will be recalculated whenever calculation occurs in any cells on the worksheet. Let's take a look at an easy example to explain this a bit more.