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

Data Analysis

  • Move chart to a separate worksheet in Excel
  • Conditional Formatting Rules in Excel
  • How to calculate average last N values in a table in Excel
  • Remove Duplicates Example in Excel
  • How To Create Pareto Chart in Excel

References

  • Lookup entire row in Excel
  • Excel Advanced Lookup using Index and Match Functions
  • Perform case-sensitive Lookup in Excel
  • How to get first row number in range in Excel
  • How to use Excel MATCH Function

Data Validations

  • Excel Data validation date in next 30 days
  • Excel Data validation require unique number
  • Excel Data validation don’t exceed total
  • Excel Data validation must not contain
  • Excel Data validation exists in list

Tag: AVERAGEA function

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

by

What is AVERAGEA function in Excel? AVERAGEA function is one of Statistical functions in Microsoft Excel that calculates the average (arithmetic mean) of the values in the list of arguments. Syntax of AVERAGEA function AVERAGEA(value1, [value2], …) The AVERAGEA function syntax has the following arguments: Value1, value2, …    Value1 is required, subsequent values are optional. 1 to …

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

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

Date Time

  • Add days exclude certain days of week in Excel
  • Get fiscal year from date in Excel
  • How to Calculate Age in Excel
  • Check If Two Dates are same month in Excel
  • Add months to date in Excel

Grouping

  • Group times into unequal buckets in Excel
  • Map inputs to arbitrary values in Excel
  • Group times into 3 hour buckets in Excel
  • Group numbers with VLOOKUP in Excel
  • Group numbers at uneven intervals in Excel

General

  • How to fill cell ranges with random number from fixed set of options in Excel
  • How to calculate profit margin percentage in Excel
  • How to calculate percent change in Excel
  • Count cells that contain errors in Excel
  • How to Delete Cells, Row and Rows in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning