How to use Excel
October 9, 2024Excel Functions
Discover how functions in Excel help you save time. If you are new to functions in Excel we recommend you to read our introduction to formulas and functions first.
Library
Page 14 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 14/29
How to use Excel
October 9, 2024Two-way Lookup in Excel
To lookup a value in a two-dimensional range use INDEX and MATCH in Excel. Below you can find the sales of different ice cream flavors in each month.
How to use Excel
October 9, 2024Center on Page in Excel
To center a range of cells on a printed page in Excel automatically execute the following steps.
How to use Excel
October 9, 2024Delete Blank Rows in Excel
To delete blank rows in Excel use Go To Special Blanks. You can also use the COUNTA function and a filter to remove empty rows.
How to use Excel
October 9, 2024Reject Invalid Dates in Excel
This example teaches you how to use data validation in Excel to reject invalid dates.
How to use Excel
October 9, 2024Test a Selection in Excel VBA
This program in Excel VBA uses the Count property IsNumeric function IsEmpty function and Intersect method to test a selection.
How to use Excel
October 9, 2024Automated Invoice in Excel
This article describes how to automate the generation of invoices in Excel. If you are in a hurry simply download the Excel file.
How to use Excel
October 9, 2024How to use the Excel AVERAGE function
The AVERAGE function in Excel calculates the average (arithmetic mean) of a group of numbers. The AVERAGE function ignores logical values empty cells and cells that contain text.
How to use Excel
October 9, 2024How 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
October 9, 2024Ribbon 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.
How to use Excel
October 9, 2024Macro Errors in Excel (Easy VBA)
This chapter teaches you how to deal with macro errors in Excel. First let's create some errors.
How to use Excel
October 9, 2024Count 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 Excel
October 9, 2024How 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.
How to use Excel
October 9, 2024Text Functions in Excel
Excel has many functions to offer when it comes to manipulating text strings.
How to use Excel
October 9, 2024How 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.
How to use Excel
October 9, 2024Count 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 use Excel
October 9, 2024How 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.
How to use Excel
October 9, 2024Most 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.
How to use Excel
October 9, 2024Custom 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.
How to use Excel
October 9, 2024Loop 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 use Excel
October 9, 2024How 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.
How to use Excel
October 9, 2024Create 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.
How to use Excel
October 9, 2024Array Function in Excel VBA
The Array function in Excel VBA can be used to quickly and easily initialize an array.
How to use Excel
October 9, 2024Run 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.