Create External References in Excel
An external reference in Excel is a reference to a cell or range of cells in another workbook. Below you can find the workbooks of three divisions (North Mid and South).
How to use Excel
Learn how to use Excel like a pro with easy-to-follow tutorials and tips — spreadsheets, charts, pivot tables, and macros.
ROWS: 506UPDATED: OCT 2024SECTION: 01 · PAGE 3/22
October 11, 2024
Strikethrough Text in Excel (Easy Shortcut)
This example teaches you how to apply strikethrough formatting in Excel. You can still read text with a strikethrough effect.
Array 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.
Separate 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 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.
ANOVA 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.
Group 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.
Compare Two Columns in Excel
To compare two columns use IF ISERROR and MATCH in Excel. You can display the duplicates or the unique values.
Complex 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.
Create an Invoice in Excel
This article describes how to create a simple invoice in Excel. Our invoice template is 3 columns wide.
Pivot 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.
Write 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.
SUBSTITUTE 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.
Area 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 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!
Multicolumn 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.
Create 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.
Superscript 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 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.
View Multiple Worksheets in Excel
If you want to view multiple Excel worksheets at the same time execute the following steps.
Multi-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.
Comparison 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 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 SUMPRODUCT in Excel
To calculate the sum of the products of corresponding numbers in one or more ranges use Excel's powerful SUMPRODUCT function.