How to use Excel
October 11, 2024Array in Excel VBA
An array is a group of variables. In Excel VBA you can refer to a specific variable (element) of an array by using the array name and the index number.
Library
Page 3 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 3/29
How to use Excel
October 11, 2024Separate Strings in Excel
To separate strings in Excel use RIGHT LEN FIND and LEFT. If you're not a formula hero use Flash Fill to split text strings in Excel.
How to use Excel
October 11, 2024How to use the Excel IFS function
Use the IFS function in Excel 2016 or later when you have multiple conditions to meet. The IFS function returns a value corresponding to the first TRUE condition.
How to use Excel
October 11, 2024ANOVA test in Excel
This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel. A single factor or one-way ANOVA is used to test the null hypothesis that the means of several populations are all equal.
How to use Excel
October 11, 2024Group Pivot Table Items in Excel
This example teaches you how to group pivot table items in Excel. Learn how to group products and how to group dates by quarters.
How to use Excel
October 11, 2024Compare Two Columns in Excel
To compare two columns use IF ISERROR and MATCH in Excel. You can display the duplicates or the unique values.
How to use Excel
October 11, 2024Complex Calculations in Excel VBA
Below we will look at a program in Excel VBA that calculates any term Tk and summation of terms up to N.
How to use Excel
October 11, 2024Create an Invoice in Excel
This article describes how to create a simple invoice in Excel. Our invoice template is 3 columns wide.
How to use Excel
October 11, 2024Pivot Chart in Excel
A pivot chart is the visual representation of a pivot table in Excel. Pivot charts and pivot tables are connected with each other.
How to use Excel
October 11, 2024Write Data to a Text File using Excel VBA
Below we will look at a program in Excel VBA that writes an Excel range to a CSV (comma-separated-value) text file.
How to use Excel
October 11, 2024SUBSTITUTE vs REPLACE - Excel Formulas
If you know the text to be replaced use the SUBSTITUTE function in Excel. If you know the position of the text to be replaced use the REPLACE function.
How to use Excel
October 11, 2024Area Chart in Excel
An area chart is a line chart with the areas below the lines filled with colors. Use a stacked area chart to display the contribution of each value to a total over time. To create an area chart in Excel execute the following steps.
How to use Excel
October 11, 2024How to AutoFill in Excel
Use AutoFill in Excel to automatically fill a series of cells. This page contains many easy to follow AutoFill examples. The sky is the limit!
How to use Excel
October 11, 2024Multicolumn Combo Box in Excel VBA
Below we will look at a program in Excel VBA which creates a Userform that contains a multicolumn combo box.
How to use Excel
October 11, 2024Create a Gantt Chart in Excel
Excel does not offer Gantt as a chart type but it's easy to create a Gantt chart by customizing the stacked bar chart type. Below you can find our Gantt chart data.
How to use Excel
October 11, 2024Superscript and Subscript in Excel
It's easy to format a character as superscript (slightly above the baseline) or subscript (slightly below the baseline) in Excel.
How to use Excel
October 11, 2024How to Line Break in Excel
You can insert a line break in Excel by pressing Alt + Enter. When concatenating strings use CHAR(10) to insert a line break.
How to use Excel
October 11, 2024View Multiple Worksheets in Excel
If you want to view multiple Excel worksheets at the same time execute the following steps.
Glossary
October 11, 2024If Cell is Blank in Excel - Formula and Conditional Formatting
Use the IF function and an empty string in Excel to check if a cell is blank. Use IF and ISBLANK to produce the exact same result.
How to use Excel
October 11, 2024Multi-level Pivot Table in Excel
You can drag more than one field to an area in a pivot table. We'll look at an example of multiple row fields multiple value fields and multiple report filter fields.
How to use Excel
October 11, 2024Comparison Operators - Equal to Greater than Less than in Excel
Use comparison operators in Excel to check if two values are equal to each other if one value is greater than another value if one value is less than another value etc.
How to use Excel
October 11, 2024How to Multiply in Excel - Easy Formulas
To multiply numbers in Excel use the asterisk symbol (*) or the PRODUCT function. Learn how to multiply columns and how to multiply a column by a constant.
How to use Excel
October 11, 2024How to use SUMPRODUCT in Excel
To calculate the sum of the products of corresponding numbers in one or more ranges use Excel's powerful SUMPRODUCT function.
How to use Excel
October 11, 2024Cm to inches in Excel (Easy Converter)
1 cm = 0.3937 inch and 1 inch = 2.54 cm. Use a simple formula the CONVERT function or download our free unit converter to convert from cm to inches or vice versa.