# Excelfunctions.net how to use exel, tips & tricks excel

### Excel Functions and Formulas

**Details: ****Excel** provides us with many Built-In Functions, that are designed to perform specific calculations. These are listed in the 'Formulas' menu of the **Excel** ribbon (see below) . This website provides information and examples of each of the Built-In Functions and also shows you how to combine these functions with each other, and with the

› Verified *1 days ago*

› Url: https://www.excelfunctions.net/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Functions List

**Details: ****Excel** provides a large number of built-in functions that can be used to perform specific calculations or to return information about your spreadsheet data. These functions are organised into categories (text, logical, math, etc.) to help you to locate the function you need from the **Excel** menu.

› Verified *6 days ago*

› Url: https://www.excelfunctions.net/excel-functions-list.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel CELL Function

**Details: **The **Excel** CELL function returns information about a given cell. This can be information in relation to the contents, formatting or location of the cell. The syntax of the function is: CELL( info_type, reference) where the arguments are as follows: info_type-

› Verified *5 days ago*

› Url: https://www.excelfunctions.net/excel-cell-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Accounting

**Details: ****Excel** Accounting. **Excel** is perfectly designed to organize financial data into traditional accountancy tables. **Excel** also provides several functions that are designed to perform common accountancy and financial analysis calculations. Therefore, if you have a small business, **Excel** may be all you need to maintain full records of your accounts.

› Verified *2 days ago*

› Url: https://www.excelfunctions.net/excel-accounting.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Addition Formula

**Details: **The **Excel** addition formula in cell A1 of the above spreadsheet on the right adds together the contents of cells B1, B2 and B3 (which contain the values 2, 7 and 1). Again, the formula returns the value 10. The **Excel** Sum Function. Instead of using the + operator, you can use the **Excel** Sum Function to perform addition in **Excel**. The syntax of this

› Verified *8 days ago*

› Url: https://www.excelfunctions.net/excel-addition-formula.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel BASE Function

**Details: **The **Excel** Base function converts a number into a supplied base (radix), and returns a text representation of the calculated value. Note: the Base function was only introduced in **Excel** 2013 and so is not available in earlier versions of **Excel**. The syntax of the Base function is:

› Verified *5 days ago*

› Url: https://www.excelfunctions.net/excel-base-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Split a String in Excel

**Details: **The **Excel** Mid function returns a specified number of characters from the middle of a supplied text string, beginning at a specified character.. In the example below, the Mid function returns 3 characters from the middle of the string "test string", starting from character number 6:

› Verified *7 days ago*

› Url: https://www.excelfunctions.net/split-string-in-excel.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel ACOS Function

**Details: **The **Excel** ACOS function calculates the arccosine (i.e. the inverse cosine) of a given number, and returns an angle, in radians, between 0 and π. The syntax of the function is: ACOS ( number ) Where the number argument is the value, between -1 and +1, for which you want to calculate the arccosine.

› Verified *5 days ago*

› Url: https://www.excelfunctions.net/excel-acos-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel ERF Function

**Details: **Occurs in older versions of **Excel** (**Excel** 2007 or earlier), if one or both of the supplied arguments are negative. #VALUE!-Occurs if one or both of the supplied arguments are non-numeric. Return to the **Excel** Engineering Functions Page Return to the List of All Built-In **Excel** Functions.

› Verified *4 days ago*

› Url: https://www.excelfunctions.net/excel-erf-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel TEXT Function

**Details: **The **Excel** Text function converts a supplied numeric value into text, in a user-specified format. The syntax of the function is: TEXT( value, format_text) Where the function arguments are: value-A numeric value, that you want to be converted into text. format_text-

› Verified *5 days ago*

› Url: https://www.excelfunctions.net/excel-text-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Information Functions

**Details: **This page lists the current, built-in **Excel** Information Functions. These functions provide information about the content, formatting and location of cells in an **Excel** spreadsheet. In the tables below, the **Excel** Information functions have been grouped into categories, to help you to find the function you need.

› Verified *3 days ago*

› Url: https://www.excelfunctions.net/excel-information-functions.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel 2019 New Functions

**Details: ****Excel** 2019 New Functions Microsoft have introduced the following new built-in functions in **Excel** 2019. Note that these functions have been available in Microsoft's subscription service, Office 365, since 2016.

› Verified *Just Now*

› Url: https://www.excelfunctions.net/excel-2019-new-functions.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel IF Function

**Details: **Nesting the **Excel** If Function. The If function is frequently 'nested' in **Excel**. I.e. the value_if_true or the value_if_false argument takes the form of a further call to the If function (see Example 3 above). **Excel** 2003 allows up to 7 levels of nested If functions, but more recent versions of **Excel** …

› Verified *3 days ago*

› Url: https://www.excelfunctions.net/excel-if-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Math Functions

**Details: **The **Excel** Math Functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios. Note that further math-related **Excel** functions are also provided in the **Excel** Statistical Functions and **Excel** Engineering Functions categories.

› Verified *6 days ago*

› Url: https://www.excelfunctions.net/excel-math-functions.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel CONVERT Function

**Details: **The **Excel** CONVERT function converts a number from one unit type (e.g. Yards) to another unit type (e.g. Meters). The function is new to **Excel** 2007, so is not available in earlier versions of **Excel**. The syntax of the function is:

› Verified *8 days ago*

› Url: https://www.excelfunctions.net/excel-convert-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Date and Time Functions

**Details: **This page lists the built-in **Excel** Date and Time Functions. If you are not familiar with the way that **Excel** stores dates and times as numeric values, you may find it useful to read the **Excel** Dates and Times page, before working with dates and times in **Excel**.. The functions listed below are grouped into categories, to help you to find the function you need.

› Verified *5 days ago*

› Url: https://www.excelfunctions.net/excel-date-and-time-functions.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Array Formulas

**Details: **Further **Excel** Array Formula Examples. For a further examples of an **Excel** Array Formula, see the examples in the **Excel** Frequency Function or the **Excel** Trend Function pages. If you want to learn more about **Excel** Array Formulas, there is an in-depth guide with further examples on …

› Verified *6 days ago*

› Url: https://www.excelfunctions.net/excel-array-formulas.html Go Now ^{}

› Get more: GuideGo Now ^{}

### Excel SEARCH Function

**Details: **The **Excel** SEARCH function returns the position of a specified character or sub-string within a supplied text string. The function is not case-sensitive. If you want to perform a case-sensitive search, use the **Excel** Find function instead. The syntax of the Search function is: Where the function arguments are: The character or sub-string that you

› Verified *7 days ago*

› Url: https://www.excelfunctions.net/excel-search-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Text Functions

**Details: **This page lists all of the built-in **Excel** Text Functions. The functions have been grouped by category, to help you to find the function you need. Each function link provides a full description of the function, with examples of use and common errors.

› Verified *6 days ago*

› Url: https://www.excelfunctions.net/excel-text-functions.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Tips and Tricks

**Details: **This page describes 8 cool **Excel** tips and tricks (including some of the most useful **Excel** keyboard shortcuts), that will help you to work more effectively and efficiently in **Excel**.. If you spend just a few minutes learning these tips and tricks, you can, in the long …

› Verified *6 days ago*

› Url: https://www.excelfunctions.net/excel-tips.html Go Now ^{}

› Get more: Tips and tricksGo Now ^{}

### Excel Keyboard Shortcuts

**Details: **For examples, see the **Excel** Copy & Paste page. Ctrl + Z-Undo the last action. Selecting Cells. Ctrl + [Left Mouse Button]-Selects multiple cells. I.e. to select more than one cell (or range), first use the mouse to select on the first cell (or range), then press the CTRL key …

› Verified *Just Now*

› Url: https://www.excelfunctions.net/excel-keyboard-shortcuts.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Calculate Date Difference in Excel

**Details: **The **Excel** Yearfrac Function calculates the number of years between two supplied dates. The result is returned as a decimal value. **Excel** Yearfrac Function Example. Cell B3 of the following spreadsheet shows the **Excel** Yearfrac function, used to calculate the …

› Verified *Just Now*

› Url: https://www.excelfunctions.net/date-difference-in-excel.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel DOLLAR Function

**Details: **The **Excel** Dollar function rounds a supplied number to a specified number of decimal places and then converts this into a text string with a currency format. The currency format used is the format that is set as the default on your computer. The syntax of the **Excel** Dollar function is: Where the function arguments are as follows: The number to be

› Verified *7 days ago*

› Url: https://www.excelfunctions.net/excel-dollar-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The Excel DGET Function

**Details: **The **Excel** Database Functions are designed to assist you when working with an **Excel** database. A database typically takes the form of a large table of data, where each row in the table stores an individual record. Each column in the spreadsheet table stores a different field …

› Verified *5 days ago*

› Url: https://www.excelfunctions.net/excel-dget-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel MMULT Function

**Details: **The **Excel** MMULT function calculates the matrix product of two arrays (representing matrices). The syntax of the function is: MMULT ( array1, array2 ) where array1 and array2 are arrays of numeric values representing matrices, and where the number of columns in …

› Verified *6 days ago*

› Url: https://www.excelfunctions.net/excel-mmult-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Multiplication in Excel

**Details: **The simplest way to perform multiplication in **Excel** is to type in the = sign, followed by two or more numbers, separated by the * operator. For example, to multiply the numbers 4, 3 and 10, type the following into any **Excel** cell: which returns the result 120. As with all **Excel** formulas, instead of typing numbers directly into the formula, you

› Verified *9 days ago*

› Url: https://www.excelfunctions.net/multiplication-in-excel.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel PEARSON Function

**Details: **The **Excel** Pearson function calculates the Pearson Product-Moment Correlation Coefficient for two sets of values. The syntax of the function is: PEARSON ( array1, array2 ) Where array1 is a set of independent variables and array2 is a set of dependent variables. These …

› Verified *8 days ago*

› Url: https://www.excelfunctions.net/excel-pearson-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Copy And Paste

**Details: **Paste Special. Normally when you perform an **Excel** copy and paste, all information from the copied cell(s) is pasted into the new cell(s). This includes any formulas or other cell contents, and the cell formatting. However, sometimes you might want to only paste one part of the original copied cells, (e.g. just the cell values or just the cell formatting) into the new range.

› Verified *2 days ago*

› Url: https://www.excelfunctions.net/excel-copy-paste.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel KURT Function

**Details: **In **Excel** 2007 and later versions of **Excel**, the Kurt function can accept up to 255 number arguments, but in **Excel** 2003, the function can only accept up to 30 number arguments. Kurt Function Examples. Column A of the above spreadsheet on the right shows an array of data, alongside the associated data distribution chart.

› Verified *5 days ago*

› Url: https://www.excelfunctions.net/excel-kurt-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The Excel FV Function

**Details: ****Excel** FV Function Examples. The following spreadsheets show the **Excel** FV function, used to calculate the future value of two different investments. Example 1. In the following spreadsheet, the **Excel** Fv function is used to calculate the future value of an investment of $1,000 per month for a period of 5 years.

› Verified *3 days ago*

› Url: https://www.excelfunctions.net/excel-fv-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The Excel FORECAST.ETS Function

**Details: **The **Excel** Forecast.Ets function uses an exponential smoothing algorithm to predict a future value on a timeline, based on a series of existing values. The syntax of the function is: FORECAST.ETS ( target_date, values, timeline, [seasonality], [data completion], [aggregation] ) Where the function arguments are: target_date.

› Verified *3 days ago*

› Url: https://www.excelfunctions.net/excel-forecast-ets-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Calculate Time Difference in Excel

**Details: **Clicking on the dialog box launcher in the 'Number' grouping, on the Home tab of the **Excel** ribbon (see right above).; or. Using the keyboard shortcut Ctrl + 1 (i.e. press the Ctrl key and while holding this down press 1).; Ensure the Number tab of the 'Format Cells' dialog box is selected.; From the Category: list, select the option Time. (If you want a time other than the default, you can

› Verified *Just Now*

› Url: https://www.excelfunctions.net/time-difference-in-excel.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The Excel MINIFS Function

**Details: **The Minifs function was first introduced in **Excel** 2019 and so is not available in earlier versions of **Excel**. **Excel** Minifs Function Examples. The spreadsheet below shows the quarterly sales figures for 3 sales representatives. The Minifs function can be used to find the minimum sales …

› Verified *7 days ago*

› Url: https://www.excelfunctions.net/excel-minifs-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Calculate a Percentage of a Number in Excel

**Details: **If you want to calculate a percentage of a number in **Excel**, simply multiply the percentage value by the number that you want the percentage of. For example, if you want to calculate 20% of 500, multiply 20% by 500. I.e. type the following formula into any **Excel** cell: =20%*500. - which gives the result 100. Note that the % operator tells **Excel**

› Verified *6 days ago*

› Url: https://www.excelfunctions.net/percentage-of-number.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Compound Interest Formula in Excel

**Details: **The **Excel** compound interest formula in cell B4 of the above spreadsheet on the right once again calculates the future value of $100, invested for 5 years with an annual interest rate of 4%. However, in this example, the interest is paid monthly. This formula returns the result 122.0996594.. I.e. the future value of the investment (rounded to 2 decimal places) is $122.10.

› Verified *1 days ago*

› Url: https://www.excelfunctions.net/compound-interest-formula.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### The Excel COUNTIF Function

**Details: **The **Excel** Countif function returns the number of cells within a supplied range, that satisfy a given criteria. The syntax of the function is: COUNTIF ( range, criteria ) where the function arguments are as follows: range. -. The range of cells that should be tested against the supplied criteria and counted if the criteria is satisfied. criteria.

› Verified *8 days ago*

› Url: https://www.excelfunctions.net/excel-countif-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel STDEVA Function

**Details: **The **Excel** Stdeva function is very similar to the **Excel** Stdev function, in that both functions calculate the sample standard deviation of a supplied set of values. The difference between these two functions applies when an array of values, containing text or logical values is supplied to the function. In this case, the Stdev function ignores the

› Verified *7 days ago*

› Url: https://www.excelfunctions.net/excel-stdeva-function.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Convert Number to Text

**Details: **The quickest way to convert an **Excel** number to text is to insert an apostrophe in front of the number (see right above). The apostrophe will not be displayed in the cell, but it will tell **Excel** to treat the contents of the cell as text. This is also a useful way to force **Excel** to display leading zeros on numbers such as telephone numbers.

› Verified *8 days ago*

› Url: https://www.excelfunctions.net/convert-number-to-text.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Annuity Analysis in Excel

**Details: ****Excel** Cash Flow Functions. On this page, we consider the built-in **Excel** functions that are used to analyse a series of constant periodic cash flows for which interest is calculated and compounded periodically. A brief description, along with a simple example, is provided for each of the listed functions. However a link is also provided, which

› Verified *2 days ago*

› Url: https://www.excelfunctions.net/annuity-analysis.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Apply an Excel Date Format

**Details: **How to Apply a Standard **Excel** Date Format. In recent versions of **Excel** (**Excel** 2007 and later) a selection of standard formats, including some date formats, are available via the drop-down box in the 'Number' grouping on the Home tab of the ribbon (see below).

› Verified *3 days ago*

› Url: https://www.excelfunctions.net/excel-date-format.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Calculate a Percentage Increase in Excel

**Details: **The % operator tells **Excel** to divide the preceding number by 100. Therefore, the value 20% in the above calculation is evaluated as 0.2; The brackets are essential in the calculation. As with any **Excel** formula, the percentage increase calculation can use values that are stored in your spreadspeed, instead of actual numbers. This is shown below.

› Verified *5 days ago*

› Url: https://www.excelfunctions.net/percentage-increase.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### VBA Functions List

**Details: **VBA provides a large number of built-in functions that can be used in your code. The most popular built-in VBA functions are listed below. Select a function name to …

› Verified *9 days ago*

› Url: https://www.excelfunctions.net/vba-functions.html Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Top Categories

### Recently Searched

› Formula to add check marks in excel

› Convert excel to kmz to online

› Blazor open excel workbook onclick

› Embed onedrive excel file in powerpoint

### Trending Searches

› How to use the sumif function

› How to use the countif function

› How to use the excel time function

› How to merge data tables in excel

› How to fix a circular reference error

› Mathematical formulas in excel