How to use DATEDIF in Excel
The DATEDIF function in Excel calculates the number of days months or years between two dates. The DATEDIF function has 3 arguments.
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 14/22
October 9, 2024
Ribbon in Excel
Excel selects the ribbon's Home tab when you open it. Learn how to use the ribbon. The tabs on the ribbon are: File Home Insert Page layout Formulas Data Review View and Help.
Macro Errors in Excel (Easy VBA)
This chapter teaches you how to deal with macro errors in Excel. First let's create some errors.
Count Characters in Excel
Use the LEN function to count characters in Excel. Use LEN and SUBSTITUTE to count specific characters in Excel.
How to use the Excel IFNA function
Use the IFNA function in Excel to replace a #N/A error with a friendly message. The IFNA function only catches #N/A errors.
Text Functions in Excel
Excel has many functions to offer when it comes to manipulating text strings.
How to use the Excel FIND function
Use the FIND function in Excel to find the position of a substring in a string. The FIND function is case-sensitive.
Count Words in Excel
Use TRIM LEN SUBSTITUTE and SUMPRODUCT in Excel to count words. First let's count the total number of words in a cell or range of cells.
How to Add the Developer Tab in Excel
Turn on the Developer tab in Excel if you want to create a macro export and import XML files or insert controls. To add the Developer tab to the ribbon execute the following steps.
Most Used Functions in Excel
Let's check out the 10 most used Excel functions. Visit our section about functions for detailed explanations and more awesome functions.
Custom Number Format in Excel
Excel has many built-in formats that you can use: Currency Accounting Date Time Percentage etc. If you cannot find the right format you can create a custom number format.
Loop through Entire Column in Excel VBA
Below we will look at a program in Excel VBA that loops through the entire first column and colors all values that are lower than a certain value.
How to FORECAST in Excel
The FORECAST (or FORECAST.LINEAR) function in Excel predicts a future value along a linear trend. The FORECAST.ETS function in Excel predicts a future value using Exponential Triple Smoothing which takes into account seasonality.
Create a Line Chart in Excel
Line charts are used to display trends over time. Use a line chart if you have text labels dates or a few numeric labels on the horizontal axis. Use Scatter with Straight Lines to show scientific XY data. To create a line chart in Excel execute the following steps.
Array Function in Excel VBA
The Array function in Excel VBA can be used to quickly and easily initialize an array.
Run Code from a Module in Excel VBA
As a beginner to Excel VBA you might find it difficult to decide where to put your VBA code. The Create a Macro chapter illustrates how to run code by clicking on a command button. This example teaches you how to run code from a module.
How to Move Columns in Excel
To move columns in Excel use the shift key or use Insert Cut Cells. You can also change the order of all columns in one magic move.
Icon Sets in Excel
Icon Sets in Excel make it very easy to visualize values in a range of cells. Each icon represents a range of values.
Array Formulas in Excel
This chapter helps you understand array formulas in Excel. Single cell array formulas perform multiple calculations in one cell.
How to use the Excel RANK function
The RANK function in Excel returns the rank of a number in a list of numbers. Use RANK.AVG to return the average rank if more than one number has the same rank.
How to Create Tables in Excel
Master Excel tables and analyze your data quickly and easily. Learn how to create a table sort a table filter a table and much more.
Pivot Tables in Excel
Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large detailed data set.
How to Merge Excel Files
To merge Excel files into one use the 'Move or Copy' feature. If you need to merge many Excel files consider using VBA to automate the process.
Histogram in Excel
This example teaches you how to make a histogram in Excel. You can use the Analysis Toolpak or the Histogram chart type. First enter the bin numbers (upper levels).