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

Data Analysis

  • Reverse List in Excel
  • How to Create Column Chart in Excel
  • Data Series in Excel
  • How to count table columns in Excel
  • Number and Text Filters Examples in Excel

References

  • How to get first column number in range in Excel
  • Perform case-sensitive Lookup in Excel
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to get last row in numeric data in Excel
  • Count rows with at least n matching values

Data Validations

  • Excel Data validation whole percentage only
  • Excel Data validation must begin with
  • Excel Data validation unique values only
  • Excel Data validation don’t exceed total
  • Excel Data validation must contain specific text

Category: Math and Trig Functions

Excel Math & Trig functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.

Change negative numbers to positive in Excel

by

To change negative numbers to positive and leave positive numbers along (i.e. get absolute values) use the built-in ABS function. See illustration below: Formula =ABS(number) Explanation In the example shown the formula in C6 is: =ABS(B6) How this formula works The ABS function is fully automatic. All you need to do is supply a number …

Continue Reading

Cash denomination calculator in Excel

by

To calculate required currency denominations, given a specific amount, you can build a currency calculation table as shown in the example. This solution uses the INT and SUMPRODUCT functions. Formula =INT((amount-SUMPRODUCT(denoms,counts))/currentdenom) Explanation In the example show, the formula in D5 is: =INT(($B5-SUMPRODUCT($C$4:C$4,$C5:C5))/D$4) How this formula works To start off, the formula in C5 is: =INT($B5/C$4) This formula divides …

Continue Reading

Calculate a ratio from two numbers in Excel

by

To generate the ratio of two numbers to each other (e.g. 4:3, 16:9, etc.), you can do using division, the GCD function, and concatenation. In the formula  of the formula below num1 represents the first number (the antecedent) and num2 represents the second number (the consequent). Formula =num1/GCD(num1,num2)&”:”&num2/GCD(num1,num2) Explanation In the example, the active cell contains this …

Continue Reading

Convert feet and inches to inches in Excel

by

To convert a measurement in feet and inches to inches only (i.e. 4’5″ to 53) you can use a formula based on several functions, including LEFT, FIND, MID, and SUBSTITUTE. See illustration below: Formula =LEFT(B5,FIND(“‘”,B5)-1)*12+SUBSTITUTE (MID(B5,FIND(“‘”,B5)+1,LEN(B5)),””””,””) Explanation In the example shown, the formula in D5 is: =LEFT(B5,FIND(“‘”,B5)-1)*12+SUBSTITUTE (MID(B5,FIND(“‘”,B5)+1,LEN(B5)),””””,””) How this formula works In the first …

Continue Reading

Convert inches to feet and inches in Excel

by

To convert a measurement in inches to inches and feet (i.e. 53 to 4′ 5″) you can use a formula based on the INT and MOD functions. See illustration below: Formula =INT(A1/12)&”‘ “&MOD(A1)&”””” Explanation In the example shown, the formula in D5 is: =INT(B5/12)&”‘ “&MOD(B5,12)&”””” How this formula works This formula converts a numeric value …

Continue Reading

Posts navigation

  • Previous
  • 1
  • 2
  • 3
  • 4

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: Description, Usage, Syntax, Examples and Explanation
  • IF with wildcards in Excel
  • How to return blank in place of #DIV/0! error in Excel
  • Excel If, Nested If, And/Or Criteria Examples
  • How to use Excel AND Function

Date Time

  • How to get number of days, weeks, months or years between two dates in Excel
  • Count birthdays by month in Excel
  • Calculate years between dates in Excel
  • Get first day of previous month in Excel
  • Convert text to date in Excel

Grouping

  • Map text to numbers in Excel
  • How to randomly assign people to groups in Excel
  • If cell contains one of many things in Excel
  • Map inputs to arbitrary values in Excel
  • Running count group by n size in Excel

General

  • AutoRecover file that was never saved in Excel
  • Index and match on multiple columns in Excel
  • How to calculate percent of students absent in Excel
  • How to Insert Cells, Row and Rows in Excel
  • How to test a range for numbers in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning