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

Data Analysis

  • How to create Gauge Chart in Excel
  • Number and Text Filters Examples in Excel
  • Excel Bar Chart
  • Reverse List in Excel
  • Add Outline to Data in Excel

References

  • Merge tables with VLOOKUP in Excel
  • Approximate match with multiple criteria in Excel
  • Last row number in range
  • How to get last row in numeric data in Excel
  • How to use Excel ROWS Function

Data Validations

  • Excel Data validation date in next 30 days
  • Excel Data validation require unique number
  • Excel Data validation exists in list
  • Excel Data validation must contain specific text
  • Excel Data validation date in specific year

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.

Use of INT and TRUNC function in Excel

by

This example illustrates two functions to chop off decimals in Excel. The INT and the TRUNC function. Int The INT (Integer) function rounds a number down to the nearest integer. Conclusion: the INT function only chops off decimals from positive numbers. Trunc Truncate a number to a given precision. The TRUNC (Truncate) function always chops off decimals. The TRUNC function can keep …

Continue Reading

Excel MROUND, CEILING and FLOOR function examples

by

Find Nearest Multiple in Excel This example illustrates three functions to round numbers to a multiple of x in Excel. The MROUND, CEILING and the FLOOR function. Mround 1. For example, round a number to the nearest multiple of 10. 2. For example, round a number to the nearest multiple of 5. Ceiling The same as MROUND but rounds up. Floor The same as …

Continue Reading

Even and Odd function in Excel

by

This example illustrates the EVEN and the ODD function in Excel. It also shows you how to determine if a number is even or odd. Even 1. Rounds a positive number up to the nearest even integer. 2. Rounds a negative number down to the nearest even integer. Odd 1. Rounds a positive number up to the nearest odd integer. …

Continue Reading

Excel ABS function Example

by

The ABS function in Excel returns the absolute value of a number. In other words: the ABS function removes the minus sign (-) from a negative number, making it positive. 1. For example, the ABS function in cell B1 below returns the absolute value of a negative number. The ABS function has no effect on 0 (zero) or positive …

Continue Reading

SUMIF function in Excel

by

The powerful SUMIF function in Excel sums cells based on one criteria. This page contains many easy to follow SUMIF examples. Numbers 1. The SUMIF function below (two arguments) sums values in the range A1:A5 that are less than or equal to 10. 2. The following SUMIF function gives the exact same result. It uses the & operator to …

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

  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel
  • Complete List of Excel Logical Functions, References and Examples
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • TRUE function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • How to calculate months between dates in Excel
  • How to calculate Day of the Year in Excel
  • Convert date to Julian format in Excel
  • Calculate expiration date in Excel
  • How to get Weekdays, Working days between Two Dates in Excel

Grouping

  • Group times into unequal buckets in Excel
  • Map inputs to arbitrary values in Excel
  • Map text to numbers in Excel
  • Running count group by n size in Excel
  • Categorize text with keywords in Excel

General

  • How to fill cell ranges with random number from fixed set of options in Excel
  • How to Delete Cells, Row and Rows in Excel
  • Count cells that do not contain many strings in Excel
  • Split Cell Content Using Text to Columns in Excel
  • Sum by group in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning