Excellency
Home Resources & Guides Services Contact Us
HomeResources & GuidesServicesContact Us
Excellency
Because good enough, isn't.

ALL - DATE/TIME - LOGICAL - LOOKUP/REFERENCE - MATH/TRIG - STATISTICAL - TEXT

Function categories and their descriptions listed here are the those given by Microsoft which you can find listed HERE or in your personal version of Excel!

The FREQUENCY function

Returns a frequency distribution as a vertical array

Read More
StatisticalMatthew Di MinnoFebruary 28, 2020Comment
The FIND function

Finds one text value within another (case-sensitive)

Read More
TextMatthew Di MinnoFebruary 27, 2020Comment
The EXACT function

Checks to see if two text values are identical

Read More
TextMatthew Di MinnoFebruary 26, 2020Comment
The EOMONTH function

Returns the serial number of the last day of the month before or after a specified number of months

Read More
Date and TimeMatthew Di MinnoFebruary 25, 2020Comment
The EDATE function

Returns the serial number of the date that is the indicated number of months before or after the start date

Read More
Date and TimeMatthew Di MinnoFebruary 24, 2020Comment
The DAYS function

Returns the number of days between two dates

Read More
Date and TimeMatthew Di MinnoFebruary 23, 2020Comment
The DAY function

Converts a serial number to a day of the month

Read More
Date and TimeMatthew Di MinnoFebruary 22, 2020Comment
The DATEVALUE function

Converts a date in the form of text to a serial number

Read More
Date and TimeMatthew Di MinnoFebruary 21, 2020Comment
The DATE function

Returns the serial number of a particular date

Read More
Date and TimeMatthew Di MinnoFebruary 20, 2020Comment
The COUNTIFS function

Counts the number of cells within a range that meet multiple criteria

Read More
StatisticalMatthew Di MinnoFebruary 19, 2020Comment
The COUNTBLANK function

Counts the number of blank cells within a range

Read More
StatisticalMatthew Di MinnoFebruary 18, 2020Comment
The COUNTA function

Counts how many values are in the list of arguments

Read More
StatisticalMatthew Di MinnoFebruary 17, 2020Comment
The COUNT function

Counts how many numbers are in the list of arguments

Read More
StatisticalMatthew Di MinnoFebruary 16, 2020Comment
The CONCAT function

Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.

Read More
TextMatthew Di MinnoFebruary 15, 2020Comment
The COLUMNS function

Returns the number of columns in a reference

Read More
Lookup and referenceMatthew Di MinnoFebruary 14, 2020Comment
The COLUMN function

Returns the column number of a reference

Read More
Lookup and referenceMatthew Di MinnoFebruary 13, 2020Comment
The AVERAGEIFS function

Returns the average (arithmetic mean) of all cells that meet multiple criteria.

Read More
StatisticalMatthew Di MinnoFebruary 12, 2020Comment
The AVERAGEA function

Returns the average of its arguments, including numbers, text, and logical values

Read More
StatisticalMatthew Di MinnoFebruary 11, 2020Comment
The AVERAGE function

Returns the average of its arguments

Read More
StatisticalMatthew Di MinnoFebruary 10, 2020Comment
The AND function

Returns TRUE if all of its arguments are TRUE

Read More
LogicalMatthew Di MinnoFebruary 9, 2020Comment
Newer

Excellency

Home - Resources & Guides - Services - Contact Us

matthew@excellency.ca
Hours