Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Create Frequency Distribution in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Excel Line Chart
  • Excel Frequency Function Example
  • Conditional Formatting New Rule with Formulas in Excel

References

  • Count rows that contain specific values in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel ROW Function
  • Extract data with helper column in Excel
  • How to use Excel OFFSET function

Data Validations

  • Excel Data validation unique values only
  • Excel Data validation only dates between
  • Excel Data validation no punctuation
  • Data validation must not exist in list
  • Excel Data validation allow uppercase only

Tag: Formulas and Functions

How To Calculate Square Root in Excel

by

The square root of a number is a value that, when multiplied by itself, gives the number. The SQRT function in Excel returns the square root of a number. 1. First, to square a number, multiply the number by itself. For example, 4 * 4 = 16 or 4^2 = 16. Note: to insert a caret ^ symbol, press SHIFT + …

Continue Reading

Calculating Percentages in Excel

by

Percentage simply means ‘out of 100′, so 72% is ’72 out of 100’ and 4% is ‘4 out of 100’, etc. Enter a Percentage Percentage of Total Increase by Percentage Percentage Change Calculating percentages in Excel is easy. Enter a Percentage To enter a percentage in Excel, execute the following steps. 1. First, enter a decimal number. …

Continue Reading

Understanding Named Range, Named Constant, Name Manager in Excel Formulas

by

By using names  you can make your formulas much easier to understand and maintain i.e to update, audit, and manage. You can define a name for a cell range, function, constant, or table. Name: A word or string of characters in Excel that represents a cell, range of cells, formula, or constant value. Named Range …

Continue Reading

Dynamic Named Range in Excel

by

A dynamic named range expands automatically when you add a value to the range. 1. For example, select the range A1:A4 and name it Prices. 2. Calculate the sum. 3. When you add a value to the range, Excel does not update the sum. To expand the named range automatically when you add a value to the range, execute the following …

Continue Reading

Understanding Various Paste Options in Excel

by

This example illustrates the various paste options (Paste, Values, Formulas, Formatting, Paste Special) in Excel . Cell B5 below contains the SUM function which calculates the sum of the range B2:B4. Furthermore, we changed the background color of this cell to yellow and added borders. Paste The Paste option pastes everything. 1. Select cell B5, right click, …

Continue Reading

How To Multiply Numbers in Excel

by

Learn how to multiply columns and how to multiply a column by a constant. To multiply numbers in Excel, use the asterisk symbol (*) or the PRODUCT function. 1. The formula below multiplies numbers in a cell. Simply use the asterisk symbol (*) as the multiplication operator. Don’t forget, always start a formula with an equal sign …

Continue Reading

How to calculate project complete percentage in Excel

by

To calculate the percentage complete for a project with a list of tasks, you can use a simple formula based on the COUNTA function. Formula =COUNTA(range1)/COUNTA(range2) Explanation In the example shown, the formula in F6 is: =COUNTA(C5:C11)/COUNTA(B5:B11) How this formula works At the core, this formula simply divides tasks complete by the total task count: …

Continue Reading

How to calculate percent variance in Excel

by

You can calculate a percent variance by subtracting the original number from the new number, then dividing that result by the original. For example, if the baseline number is 100, and the new number is 110: =(110-100)/100 This formula can be used to calculate things like variance between this year and last year, variance between …

Continue Reading

How to get amount with percentage in Excel

by

If you have a total and a percentage that presents some amount of the total, you can calculate the amount represented by the percentage with a simple formula that multiples the total by the percentage. Formula = total * percent Explanation In the example, the active cell contains this formula: =C6*D6 To calculate the amount, …

Continue Reading

How to get original number from percent change in Excel

by

To calculate the original number based on current value and known percentage change, you can use a simple formula that divides the current value by the percent plus 1. Formula =current/(percent+1) Explanation In the example, the active cell contains this formula: =C6/(B6+1) In this case, Excel first calculates the result of B6 + 1, then divides C6 by the …

Continue Reading

How to get original price from percentage discount in Excel

by

If you have a discounted price and know the discount percentage, you can calculate the original price with a simple formula that divides the discounted price by the result of 1 minus the discount percentage. See example below: Formula =price/(1-discount) Explanation How the formula works In the example, the active cell contains this formula: =C6/(1-D6) …

Continue Reading

How to calculate percent change in Excel

by

If you need to calculate the percentage change between two values in Excel, you can use a formula that divides the change itself by the “old” value. A classic example would be to calculate the percentage between sales last month and sales this month. Formula =(new_value-old_value)/old_value Explanation In the example, the active cell contains this …

Continue Reading

How to calculate percentage discount in Excel

by

If you have a discounted price and an original price, and you want to know the discount as a percentage, you can calculate the percentage discount using a formula that divides the discounted price by the original price and then subtracts the result from one. Formula = 1-(discount_price/original_price) Explanation In the example, the active cell …

Continue Reading

Posts navigation

  • Previous
  • 1
  • 2

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • SWITCH function example in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • Excel If, Nested If, And/Or Criteria Examples

Date Time

  • Convert Excel time to decimal hours in Excel
  • Add years to date in Excel
  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • Get work hours between dates custom schedule in Excel
  • Get project midpoint in Excel

Grouping

  • Group numbers at uneven intervals in Excel
  • How to randomly assign people to groups in Excel
  • Group times into unequal buckets in Excel
  • Map text to numbers in Excel
  • How to randomly assign data to groups in Excel

General

  • Count cells less than in Excel
  • Check if multiple cells have same value in Excel
  • How to choose page/paper size in Excel before Printing
  • Basic numeric sort formula in Excel
  • How to get amount with percentage in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning