How to use Excel
October 9, 2024Protect a Workbook in Excel
This example teaches you how to protect the workbook structure in Excel.
Library
Page 12 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 12/29
How to use Excel
October 9, 2024Array Manipulation Functions in Excel
Use the new array manipulation functions in Excel 365 to quickly combine shape and resize arrays.
How to use Excel
October 9, 2024Wildcards in Excel
Excel has 3 wildcards. A question mark (?) matches exactly one character. An asterisk (*) matches zero or more characters. And a tilde (~).
How to use Excel
October 9, 2024Product Codes in Excel
Use data validation to only allow the input of specific product codes. For example only allow codes that are 4 characters long start with a C etc.
How to use Excel
October 9, 2024Shortest Path Problem in Excel
Use the solver in Excel to find the shortest path from node S to node T in an undirected network. Points in a network are called nodes (S A B C D E and T). Lines in a network are called arcs (SA SB SC AC etc).
How to use Excel
October 9, 2024Dynamic Range in Excel VBA
Below we will look at a program in Excel VBA that colors the maximum value of a dynamic range.
How to use Excel
October 9, 2024Read Data from a Text File using Excel VBA
Below we will look at a program in Excel VBA that reads data from a text file. This file contains some geographical coordinates we want to import into Excel.
How to use Excel
October 9, 2024Type Mismatch Error in Excel VBA
The type mismatch error in Excel VBA occurs when you try to assign a value to a variable that isn't of the correct type.
How to use Excel
October 9, 2024Scatter Plot in Excel
Use a scatter plot (XY chart) to show scientific XY data. Scatter plots are often used to find out if there's a relationship between variables X and Y.
How to use Excel
October 9, 2024Mod Operator in Excel VBA
The Mod operator in Excel VBA gives the remainder of a division. This page starts with some simple examples.
How to use Excel
October 9, 2024What-If Analysis in Excel
What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. The following example helps you master what-if analysis quickly and easily.
How to use Excel
October 9, 2024Events in Excel VBA
Events are actions performed by users which trigger Excel VBA to execute code.
How to use Excel
October 9, 2024Reverse Strings in Excel VBA
Below we will look at a program in Excel VBA that can reverse strings.
How to use Excel
October 9, 2024Frequency Distribution in Excel
Did you know that you can use pivot tables to easily create a frequency distribution in Excel? You can also use the Analysis Toolpak to create a histogram.
How to use Excel
October 9, 2024Regression Analysis in Excel
This example teaches you how to run a linear regression analysis in Excel and how to interpret the Summary Output.
How to use Excel
October 9, 2024List of Holidays in Excel
This example teaches you how to get the date of a holiday for any year (2024 2025 etc). If you are in a hurry simply download the Excel file.
How to use Excel
October 9, 2024Capital Investment in Excel
Use the solver in Excel to find the combination of capital investments that maximizes the total profit.
How to use Excel
October 9, 2024Quick Access Toolbar in Excel
If you use an Excel command frequently you can add it to the Quick Access Toolbar. By default the Quick Access Toolbar contains four commands: AutoSave Save Undo and Redo.
How to use Excel
October 9, 2024Sum Every nth Row in Excel
This example shows you how to create an array formula that sums every nth row in Excel. We will show it for n = 3 but you can do this for any number.
Glossary
October 9, 2024Percent Change Formula in Excel
The percent change formula is frequently used in Excel. First let's understand the formula. Next let's calculate the monthly and total percent change over a period of time.
How to use Excel
October 9, 2024Cell References in Excel
Cell references in Excel are very important. Understand the difference between relative absolute and mixed reference and you are on your way to success.
How to use Excel
October 9, 2024Prevent Duplicate Entries in Excel
To prevent duplicate values from being entered into Excel use data validation and the COUNTIF function.
How to use Excel
October 9, 2024Print Titles in Excel
You can specify rows and columns in Excel that will be printed on each printed page. This can make your printed copy easier to read. To print titles execute the following steps.
How to use Excel
October 9, 2024Loop through Defined Range in Excel VBA (For Each Cell in Range)
Below we will look at a program in Excel VBA that loops through a defined range. For example when we want to square the numbers in the range A1:A3.