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

Data Analysis

  • How to add Trendline to a chart in Excel
  • Conditional Formatting Data bars Examples in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • How To Compare Two Lists in Excel

References

  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel VLOOKUP Function
  • How to use Excel MMULT Function
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • Left Lookup in Excel

Data Validations

  • How To Create Drop-down List in Excel
  • Excel Data validation no punctuation
  • Excel Data validation date in specific year
  • Excel Data validation with conditional list
  • Excel Data validation require unique number

Tag: DEVSQ function

DEVSQ function: Description, Usage, Syntax, Examples and Explanation

by

What is DEVSQ function in Excel? DEVSQ function is one of Statistical functions in Microsoft Excel that returns the sum of squares of deviations of data points from their sample mean. Syntax of DEVSQ function DEVSQ(number1, [number2], …) The DEVSQ function syntax has the following arguments: Number1, number2, …    Number1 is required, subsequent numbers are optional. 1 …

Continue Reading

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

  • How to use IFS function in Excel
  • How to use Excel FALSE Function
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • IF, AND, OR and NOT Functions Examples in Excel
  • Excel If, Nested If, And/Or Criteria Examples

Date Time

  • Find Last Day of the Month in Excel
  • Add workdays to date custom weekends in Excel
  • How to join date and text together in Excel
  • How to Calculate Age in Excel
  • Add months to date in Excel

Grouping

  • Group numbers with VLOOKUP in Excel
  • Categorize text with keywords in Excel
  • Map inputs to arbitrary values in Excel
  • Group times into unequal buckets in Excel
  • Group numbers at uneven intervals in Excel

General

  • Delete Blank Rows at Once in Excel
  • With vs Without Array Formula in Excel
  • Convert column letter to number in Excel
  • Lock Cells in a Worksheet Excel
  • Find, Select, Replace and Go To Special in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning