How to use Excel
October 11, 2024How to use the Excel PMT function
The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate. This page contains many easy to follow PMT examples.
Library
Page 5 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 5/29
How to use Excel
October 11, 2024Round to Nearest Multiple in Excel
This example illustrates three functions to round numbers to a multiple of x in Excel. MROUND CEILING and FLOOR.
How to use Excel
October 11, 2024Path and FullName Property in Excel VBA
The Path property in Excel VBA returns the complete saved path to the workbook (Excel file). The FullName property in Excel VBA returns the complete saved path including the name of the workbook.
How to use Excel
October 11, 2024Insert Page Numbers in Excel
This example teaches you how to insert page numbers in Excel. On the View tab in the Workbook Views group click Page Layout to switch to Page Layout view.
How to use Excel
October 11, 2024Currency Converter in Excel VBA
Below we will look at a program in Excel VBA which creates a Userform that converts any amount from one currency into another.
How to use Excel
October 11, 2024Last Day of the Month in Excel - EOMONTH function
To get the date of the last day of the month in Excel use the EOMONTH (End of Month) function.
How to use Excel
October 11, 2024Select Entire Rows and Columns in Excel VBA
This example teaches you how to select entire rows and columns in Excel VBA. Are you ready?
How to use Excel
October 11, 2024How to Filter Data in Excel
Filter your Excel data to only display records that meet certain criteria. This is page 1 of 10 in our comprehensive filtering course. Click any single cell inside a data set. On the Data tab in the Sort & Filter group click Filter.
How to use Excel
October 11, 2024Paste Special Shortcuts in Excel
Use the shortcut Ctrl + Alt + V to display the Paste Special dialog box in Excel. Next press an underlined letter to paste formulas values formatting etc.
How to use Excel
October 11, 2024Formula Bar in Excel
The formula bar in Excel displays the value or formula of the active cell. You can use the formula bar to enter or edit formulas. The formula bar is located below the ribbon and above the worksheet area.
How to use Excel
October 11, 2024Dynamic Array Formulas in Excel
Dynamic array formulas entered into a single cell fill multiple cells. This behavior in Excel 365/2021 is called spilling.
How to use Excel
October 11, 2024How to use the Excel ADDRESS function
The ADDRESS function in Excel creates a cell reference as text based on a given row and column number. By default the ADDRESS function creates an absolute reference.
How to use Excel
October 11, 2024Thermometer Chart in Excel
This example teaches you how to create a thermometer chart in Excel. A thermometer chart shows you how much of a goal has been achieved.
How to use Excel
October 11, 2024Today's Date in Excel
To enter today's date in Excel use the TODAY function. To enter the current date and time use the NOW function. To enter the current date and time as a static value use keyboard shortcuts.
How to use Excel
October 11, 2024Add a Trendline in Excel
This example teaches you how to add a trendline to a chart in Excel. First select the chart. Next click the + button on the right side of the chart click the arrow next to Trendline and then click More Options.
How to use Excel
October 11, 2024How to use TEXTSPLIT in Excel
Use the TEXTSPLIT function in Excel 365 to split text into rows or columns using delimiters. This guide teaches you how to use the TEXTSPLIT function starting with simple text splits and moving on to more advanced formulas.
How to use Excel
October 11, 2024Instr Function in Excel VBA
Use Instr in Excel VBA to find the position of a substring in a string. The Instr function is quite versatile.
Glossary
October 11, 2024CAGR formula in Excel
There's no CAGR function in Excel. However simply use the RRI function in Excel to calculate the compound annual growth rate (CAGR) of an investment over a period of years.
How to use Excel
October 11, 2024Solver in Excel
Excel includes a tool called Solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.
How to use Excel
October 11, 2024How to use the Excel COUNTIF function
The powerful COUNTIF function in Excel counts cells based on one criteria. This page contains many easy to follow COUNTIF examples.
How to use Excel
October 11, 2024Separate Strings in Excel VBA
Below we will look at a program in Excel VBA that separates strings.
How to use Excel
October 10, 2024Function Keys in Excel
Function keys in Excel allow you to do things with your keyboard instead of your mouse to increase your speed.
How to use Excel
October 10, 2024Prime Number Checker in Excel VBA
Below we will look at a program in Excel VBA that checks whether a number is a prime number or not.
How to use Excel
October 10, 2024Substring in Excel
There's no SUBSTRING function in Excel. Use MID LEFT RIGHT FIND LEN SUBSTITUTE REPT TRIM and MAX in Excel to extract substrings.