__Abbreviate name and words*__ Placeholder |

__Add business days to a date__ Date - Add or Subtract |

__Add business days to a date changing the days of the weekend__ Date - Add or Subtract |

__Add business days to a date excluding public holidays__ Date - Add or Subtract |

__Add days to a date excluding weekends and changing the days of the weekend*__ Placeholder |

__Add days to a date excluding weekends and public holidays*__ Placeholder |

__Add days to a date excluding weekends*__ Placeholder |

__Add days to a date including weekends__ Date - Add or Subtract |

__Add days to a date not landing on a weekend__ Date - Add or Subtract |

__Add decimal hours to time*__ Placeholder |

__Add decimal minutes to time*__ Placeholder |

__Add decimal seconds to time*__ Placeholder |

__Add hours to a time__ Time - Add or Subtract |

__Add minutes to a time__ Time - Add or Subtract |

__Add months to a date__ Date - Add or Subtract |

__Add seconds to a time__ Time - Add or Subtract |

__Add weeks to a date__ Date - Add or Subtract |

__Add working days to a date changing the days of the weekend*__ Placeholder |

__Add working days to a date excluding public holidays*__ Placeholder |

__Add working days to a date*__ Placeholder |

__Add years to a date__ Date - Add or Subtract |

__Average cells__ Number - Average |

__Average cells after subtraction__ Number - Average |

__Average cells ignoring duplicates__ Number - Average |

__Average cells ignoring zeros__ Number - Average |

__Average cells in a table when a column meets multiple conditions__ Number - Average |

__Average cells that are not errors__ Number - Average |

__Average cells that are not hidden__ Number - Average |

__Average cells using the n largest numbers__ Number - Average |

__Average cells using the n last numbers__ Number - Average |

__Average cells using the n smallest numbers__ Number - Average |

__Average cells using weighted average__ Number - Average |

__Convert a date string to a date value__ Date - Convert |

__Convert a number into currency format__ Number - Convert |

__Convert a number into words__ Number - Convert |

__Convert a word into numbers__ Text - Convert |

__Convert column letter to column number__ Other - Other |

__Convert column number to column letter__ Other - Other |

__Convert decimal hours to time__ Time - Convert |

__Convert decimal minutes to time__ Time - Convert |

__Convert decimal seconds to time__ Time - Convert |

__Convert hours to time*__ Placeholder |

__Convert minutes to time*__ Placeholder |

__Convert numbers to text__ Text - Convert |

__Convert seconds to time*__ Placeholder |

__Convert time to hours__ Time - Convert |

__Convert time to minutes__ Time - Convert |

__Convert time to seconds__ Time - Convert |

__Convert time to time zone__ Time - Convert |

__Count cells equal to 2 values__ Counting - Equal To |

__Count cells equal to 3 or more values__ Counting - Equal To |

__Count cells equal to one of many__ Counting - Equal To |

__Count cells equal to this or that__ Counting - Equal To |

__Count cells in a table when a column is greater than a value__ Counting - Table |

__Count cells in a table when a column is less than a value__ Counting - Table |

__Count cells in a table when a column is unique with 1 condition__ Counting - Are |

__Count cells in a table when a column meets 1 condition__ Counting - Table |

__Count cells in a table when a column meets multiple conditions__ Counting - Table |

__Count cells not equal to 2 values__ Counting - Not Equal To |

__Count cells not equal to 3 or more values__ Counting - Not Equal To |

__Count cells not equal to a value__ Counting - Not Equal To |

__Count cells not equal to one of many__ Counting - Not Equal To |

__Count cells that are blank__ Counting - Equal To |

__Count cells that are dates__ Counting - Equal To |

__Count cells that are dates and either x or y__ Counting - Contain |

__Count cells that are dates and equal to a value__ Counting - Contain |

__Count cells that are dates and in a particular month__ Counting - Contain |

__Count cells that are dates and in a particular year__ Counting - Contain |

__Count cells that are dates and not between 2 dates__ Counting - Contain |

__Count cells that are dates and not equal to a value__ Counting - Contain |

__Count cells that are dates and unique__ Counting - Contain |

__Count cells that are dates between 2 dates__ Counting - Contain |

__Count cells that are dates by day of week__ Counting - Other |

__Count cells that are errors__ Counting - Contain |

__Count cells that are hidden__ Counting - Other |

__Count cells that are not blank__ Counting - Not Equal To |

__Count cells that are not dates__ Counting - Not Equal To |

__Count cells that are not errors__ Counting - Not Equal To |

__Count cells that are not hidden__ Counting - Not Equal To |

__Count cells that are not numbers__ Counting - Contain |

__Count cells that are not text__ Counting - Not Equal To |

__Count cells that are not text or numbers__ Counting - Contain |

__Count cells that are numbers__ Counting - Contain |

__Count cells that are numbers and either x or y__ Counting - Contain |

__Count cells that are numbers and equal to a value__ Counting - Contain |

__Count cells that are numbers and even__ Counting - Contain |

__Count cells that are numbers and greater than a value__ Counting - Contain |

__Count cells that are numbers and less than a value__ Counting - Contain |

__Count cells that are numbers and negative__ Counting - Contain |

__Count cells that are numbers and not equal to a value__ Counting - Contain |

__Count cells that are numbers and not equal to either x or y__ Counting - Contain |

__Count cells that are numbers and odd__ Counting - Are |

__Count cells that are numbers and positive__ Counting - Contain |

__Count cells that are numbers and unique__ Counting - Are |

__Count cells that are numbers in a range__ Counting - Other |

__Count cells that are numbers with leading zeros__ Counting - Other |

__Count cells that are text__ Counting - Are |

__Count cells that are text and begin with__ Counting - Contain |

__Count cells that are text and contain either x or y__ Counting - Contain |

__Count cells that are text and contain specific text__ Counting - Other |

__Count cells that are text and contain specific text case sensitive__ Counting - Other |

__Count cells that are text and do not begin with__ Counting - Contain |

__Count cells that are text and do not end with__ Counting - Contain |

__Count cells that are text and either x or y__ |

__Count cells that are text and end with__ |

__Count cells that are text and equal to a value__ Counting - Contain |

__Count cells that are text and equal to a value case sensitive__ Counting - Contain |

__Count cells that are text and n characters long__ Counting - Contain |

__Count cells that are text and not equal to a value__ |

__Count cells that are text and over n characters long__ Counting - Other |

__Count cells that are text and unique__ Counting - Are |

__Count cells that are visible__ |

__Count cells with formatting__ Counting - Conditional |

__Count cells with shading__ Counting - Conditional |

__Count differences between 2 cell ranges__ Counting - Conditional |

__Count occurrences in entire workbook__ Counting - Other |

__Count or sum variance__ Counting - Other |

__Count substring occurrences__ Counting - Other |

__Count times in a particular range__ Counting - Other |

__Count total characters in range__ Counting - Other |

__Count total matches in 2 ranges__ Counting - Other |

__Count unique dates__ Counting - Other |

__Count unique numbers__ Counting - Other |

__Count unique numbers with 1 condition__ Counting - Other |

__Count unique text strings__ Counting - Other |

__Count unique text strings with 1 condition__ Counting - Other |

__Count unique values__ Counting - Other |

__Count visible cells__ Counting - Other |

__Count visible columns__ Counting - Other |

__Count visible rows__ Counting - Other |

__Count visible rows in a filtered column__ Counting - Other |

__Count visible rows with 1 condition__ Counting - Other |

__Count visible rows with multiple conditions__ Counting - Other |

__Count whole numbers only__ Counting - Other |

__Filter cells based on dates__ Filtering - Filtering |

__Filter cells based on either condition__ Filtering - Filtering |

__Filter cells based on multiple conditions__ Filtering - Filtering |

__Filter cells based on text__ Filtering - Filtering |

__Filter cells using array formulas__ Filtering - Filtering |

__Find a matching value__ Lookup - Find |

__Find a matching value case sensitive__ Lookup - Find |

__Find a matching value cross reference__ Lookup - Find |

__Find a matching value in any column__ Lookup - Find |

__Find a matching value in first column__ Lookup - Find |

__Find a partial match__ Lookup - Find |

__Find a particular occurrence__ Lookup - Find |

__Find the cell address of the largest number__ Other - Other |

__Find the closest match__ Lookup - Find |

__Find the largest number__ Lookup - Find |

__Find the largest number excluding zero__ Lookup - Find |

__Find the largest number with 1 condition__ Lookup - Find |

__Find the largest number with multiple conditions__ Lookup - Find |

__Find the last entry in a column__ Lookup - Find |

__Find the n largest numbers__ Lookup - Find |

__Find the n smallest numbers__ Lookup - Find |

__Find the nth largest number__ Lookup - Find |

__Find the nth largest number with 1 condition__ Lookup - Find |

__Find the nth match__ Lookup - Find |

__Find the nth smallest number__ Lookup - Find |

__Find the nth smallest number with 1 condition__ Lookup - Find |

__Find the position of the active worksheet in the workbook__ Other - Other |

__Find the row of the largest number__ Other - Other |

__Find the smallest number__ Lookup - Find |

__Find the smallest number excluding zero__ Lookup - Find |

__Find the smallest number with 1 condition__ Lookup - Find |

__Find the smallest number with multiple conditions__ Lookup - Find |

__Find the unique values in a range__ Lookup - Find |

__Multiply numbers and sum__ Summing - Other |

__Number of business days between 2 dates__ Date - Number of Days |

__Number of business days in a particular month__ Date - Number of Days |

__Number of business days in a particular year__ Date - Number of Days |

__Number of business days left in the current month__ Date - Number of Days |

__Number of business days left in the current year__ Date - Number of Days |

__Number of business days that have passed in the current month__ Date - Number of Days |

__Number of business days that have passed in the current year__ Date - Number of Days |

__Number of business days*__ Date - Number of Days |

__Number of days between 2 dates__ Date - Number of Days |

__Number of days between 2 dates excluding weekends__ Date - Number of Days |

__Number of days between 2 dates ignoring months and years__ Date - Number of Days |

__Number of days between 2 dates ignoring years__ Date - Number of Days |

__Number of days in a particular month__ Date - Number of Days |

__Number of days in a particular year__ Date - Number of Days |

__Number of days left in the current month__ Date - Number of Days |

__Number of days left in the current year__ Date - Number of Days |

__Number of days months years from a date__ Date - Number of Days |

__Number of days that have passed in the current month__ Date - Number of Days |

__Number of days that have passed in the current year__ Date - Number of Days |

__Number of Mondays between 2 dates__ Date - Number of Days |

__Number of months and days between 2 dates__ Date - Number of Months |

__Number of months between 2 dates__ Date - Number of Months |

__Number of months between 2 dates ignoring days and years__ Date - Number of Months |

__Number of months weeks days between 2 dates__ Date - Number of Months |

__Number of occurrences of a particular day of the week__ Date - Number of |

__Number of weekend days between 2 dates__ Date - Number of Days |

__Number of weekend days in a particular month__ Date - Number of Days |

__Number of weekend days in a particular year__ Date - Number of Days |

__Number of weekend days*__ Placeholder |

__Number of weeks and days between 2 dates__ Date - Number of Weeks |

__Number of weeks between 2 dates__ Date - Number of Weeks |

__Number of working days between 2 dates*__ Placeholder |

__Number of working days in a particular month*__ Placeholder |

__Number of working days in a particular year*__ Placeholder |

__Number of working days left in the current month*__ Placeholder |

__Number of working days left in the current year*__ Placeholder |

__Number of working days that have passed in the current month*__ Placeholder |

__Number of working days that have passed in the current year*__ Placeholder |

__Number of working days*__ Placeholder |

__Number of working hours between 2 dates__ Time - Number of Hours |

__Number of working hours between 2 times__ Time - Number of Hours |

__Number of years and days between 2 dates__ Date - Number of Years |

__Number of years between 2 dates__ Date - Number of Years |

__Number of years months days between 2 dates__ Date - Number of Years |

__Number of years months days from a date__ Date - Number of Years |

__Only allow a certain number of characters*__ Placeholder |

__Only allow characters in uppercase*__ Placeholder |

__Only allow dates in a particular range*__ Placeholder |

__Only allow dates in a particular year__ Data Validation - Only allow |

__Only allow dates in the current year__ Data Validation - Only allow |

__Only allow dates in the next 30 days__ Data Validation - Only allow |

__Only allow dates that are weekdays*__ Placeholder |

__Only allow dates that are weekends__ Data Validation - Only allow |

__Only allow dates*__ Placeholder |

__Only allow entries in a particular format*__ Placeholder |

__Only allow numbers in a particular range*__ Placeholder |

__Only allow numbers that are whole numbers__ Data Validation - Only allow |

__Only allow numbers*__ Placeholder |

__Only allow percentages that are whole numbers__ Data Validation - Only allow |

__Only allow percentages*__ Placeholder |

__Only allow text in uppercase*__ Placeholder |

__Only allow text*__ Placeholder |

__Only allow times*__ Placeholder |

__Only allow unique values no duplicates*__ Placeholder |

__Only allow values from a predefined list*__ Placeholder |

__Only allow values that are not in a predefined list__ Data Validation - Only allow |

__Only allow values whose sum is restricted*__ Placeholder |

__Only allow yes or no*__ Placeholder |

__Remove last n characters__ Text - Remove |

__Remove one word__ Text - Remove |

__Remove unwanted characters__ Text - Remove |

__Replace one character with another__ Text - Replace |

__Replace one word with another__ Text - Replace |

__Replace text by matching__ Text - Replace |

__Replace text by position__ Text - Replace |

__Return a date from a date string__ Date - Display |

__Return a date in a particular format__ Date - Display |

__Return a date in US date format__ Date - Display |

__Return a list of non blank items__ Other - Other |

__Return a list of unique values__ Other - Other |

__Return a list of unique values ignoring blanks__ Other - Other |

__Return a number reduced by 10 percent__ Number - Return |

__Return a persons age in years__ Date - Display |

__Return a persons age in years months days__ Date - Display |

__Return a substring__ Text - Return |

__Return an array of worksheet names__ Other - Other |

__Return every fourth entry in a list__ Text - Return |

__Return numbers to the nearest fraction__ Number - Display |

__Return random characters__ Text - Display |

__Return random numbers between 1 and 25__ Number - Display |

__Return the 3rd Monday in a month__ Date - Display |

__Return the acronym from a text string__ Text - Return |

__Return the business days__ Date - Display |

__Return the current date__ Date - Display |

__Return the current date and time__ Date - Display |

__Return the current day__ Date - Display |

__Return the current month__ Date - Display |

__Return the current quarter__ Date - Display |

__Return the current time__ Time - Display |

__Return the current year__ Date - Display |

__Return the date from a date and time__ Date - Display |

__Return the date from a date string__ Date - Display |

__Return the date of the Monday in the current week__ Date - Display |

__Return the date of the Monday in the next week__ Date - Display |

__Return the date of the Monday in the previous week__ Date - Display |

__Return the day from a date__ Date - Return |

__Return the day name__ Date - Display |

__Return the decimal part of a number__ Number - Return |

__Return the digits in reverse order__ Number - Return |

__Return the first business day of the year__ Date - First |

__Return the first day of the current month__ Date - First |

__Return the first day of the next month__ Date - First |

__Return the first day of the previous month__ Date - First |

__Return the first letter of each word__ Text - Return |

__Return the first Monday of the current month__ Date - First |

__Return the first Monday of the next month__ Date - First |

__Return the first Monday of the previous month__ Date - First |

__Return the first name from a full name__ Text - Return |

__Return the first weekday of the month__ Date - First |

__Return the first weekday of the year__ Date - First |

__Return the first word__ Text - Return |

__Return the integer part of a number__ Number - Return |

__Return the last business day of the year__ Date - Last |

__Return the last day of the current month__ Date - Last |

__Return the last day of the current quarter__ Date - Last |

__Return the last day of the next month__ Date - Last |

__Return the last day of the previous month__ Date - Last |

__Return the last Monday of the current month__ Date - Last |

__Return the last Monday of the next month__ Date - Last |

__Return the last Monday of the previous month__ Date - Last |

__Return the last name from a full name__ Text - Return |

__Return the last weekday of the month__ Date - Last |

__Return the last weekday of the year__ Date - Last |

__Return the last word__ Text - Return |

__Return the longest string in a column__ Text - Return |

__Return the middle name from a full name__ Text - Return |

__Return the month from a date__ Date - Return |

__Return the most frequently occurring word__ Text - Return |

__Return the next business day__ Date - Return |

__Return the next friday__ Date - Return |

__Return the next Monday__ Date - Return |

__Return the next working day__ Date - Return |

__Return the non blank items in a list__ Other - Other |

__Return the nth business day of the year__ Date - Return |

__Return the nth day of the year__ Date - Return |

__Return the nth word__ Text - Return |

__Return the number corresponding to a given month__ Date - Display |

__Return the number equivalent for a number written as text__ Text - Return |

__Return the number from a number and text__ Text - Return |

__Return the percentage change__ Number - Display |

__Return the previous friday__ Date - Return |

__Return the previous Monday__ Date - Return |

__Return the second word__ Text - Return |

__Return the shortest string in a column__ Text - Return |

__Return the text converted to sentence case__ Text - Return |

__Return the time elapsed between 2 times__ Time - Display |

__Return the time from a date and time__ Time - Display |

__Return the time rounded to the nearest 15 minutes__ Time - Display |

__Return the value from the cell above__ Text - Return |

__Return the week number of the current date__ Date - Return |

__Return the word equivalent for a numerical number__ Text - Return |

__Return the words in reverse order__ Text - Return |

__Return the workbook name from a full path__ Other - Other |

__Return the working hours between 2 dates__ Time - Display |

__Return the working hours between 2 times__ Time - Display |

__Return the year from a date__ Date - Return |

__Return two strings joined together__ Text - Display |

__Round a number down__ Number - Round |

__Round a number down to the nearest 100__ Number - Round |

__Round a number down to the nearest 5__ Number - Round |

__Round a number down to the nearest multiple__ Number - Round |

__Round a number to n significant figures__ Number - Round |

__Round a number up__ Number - Round |

__Round a number up to the nearest 100__ Number - Round |

__Round a number up to the nearest 5__ Number - Round |

__Round a number up to the nearest multiple__ Number - Round |

__Shade cells between 2 dates__ Formatting - Shade all |

__Shade cells between 2 numbers__ Formatting - Shade all |

__Shade cells in a particular row__ Formatting - Shade all |

__Shade cells in alternate rows__ Formatting - Shade all |

__Shade cells that are blank__ Formatting - Shade all |

__Shade cells that are dates__ |

__Shade cells that are dates and business days__ Formatting - Shade all |

__Shade cells that are dates and greater than a value__ Formatting - Shade all |

__Shade cells that are dates and less than a value__ Formatting - Shade all |

__Shade cells that are dates and weekdays__ Formatting - Shade all |

__Shade cells that are dates and weekends__ Formatting - Shade all |

__Shade cells that are dates in the next n days__ Formatting - Shade all |

__Shade cells that are errors__ Formatting - Shade all |

__Shade cells that are not errors__ Formatting - Shade all |

__Shade cells that are not numbers__ Formatting - Shade all |

__Shade cells that are not text__ Formatting - Shade all |

__Shade cells that are numbers__ Formatting - Shade all |

__Shade cells that are numbers and even__ Formatting - Shade all |

__Shade cells that are numbers and greater than a value__ Formatting - Shade all |

__Shade cells that are numbers and less than a value__ Formatting - Shade all |

__Shade cells that are numbers and negative__ Formatting - Shade all |

__Shade cells that are numbers and odd__ Formatting - Shade all |

__Shade cells that are numbers and positive__ Formatting - Shade all |

__Shade cells that are text__ Formatting - Shade all |

__Shade cells that are text and do not contain specific text__ Formatting - Shade all |

__Shade cells with dates equal to a value__ Formatting - Shade all |

__Shade cells with duplicate rows__ Formatting - Shade all |

__Shade cells with duplicate values__ Formatting - Shade all |

__Shade cells with formatting__ Formatting - Shade all |

__Shade items in a list that appear in a sub list__ Formatting - Shade all |

__Shade positive changes__ Formatting - Shade all |

__Sort into a random order__ Other - Other |

__Sort using a custom list__ Other - Other |

__Sort using one column__ Other - Other |

__Sort using two columns__ Other - Other |

__Subtract business days from a date__ Date - Add or Subtract |

__Subtract business days from a date changing the days of the weekend__ Date - Add or Subtract |

__Subtract business days from a date excluding public holidays__ Date - Add or Subtract |

__Subtract days from a date__ Date - Add or Subtract |

__Subtract hours from a time__ Date - Add or Subtract |

__Subtract minutes from a time__ Date - Add or Subtract |

__Subtract months from a date__ Date - Add or Subtract |

__Subtract seconds from a time__ Date - Add or Subtract |

__Subtract weeks from a date__ Date - Add or Subtract |

__Subtract years from a date__ Date - Add or Subtract |

__Sum across worksheets__ Summing - Other |

__Sum across worksheets with 1 condition__ Summing - Other |

__Sum all the individual digits of a number__ Summing - Other |

__Sum by group__ Summing - Other |

__Sum by month__ Summing - Other |

__Sum by year__ |

__Sum cells in a table when a column contains n characters__ Summing - Table |

__Sum cells in a table when a column does not contain a value__ Summing - Table |

__Sum cells in a table when a column is either x or y__ Summing - Table |

__Sum cells in a table when a column is equal to 2 values__ Summing - Table |

__Sum cells in a table when a column is equal to 3 or more values__ Summing - Table |

__Sum cells in a table when a column is equal to a value__ Summing - Table |

__Sum cells in a table when a column is equal to a value case sensitive__ Summing - Table |

__Sum cells in a table when a column is not blank__ Summing - Table |

__Sum cells in a table when a column is text__ Summing - Table |

__Sum cells in a table when a column is text and begins with__ Summing - Table |

__Sum cells in a table when a column is text and ends with__ Summing - Table |

__Sum cells in a table when a column meets 1 condition__ Summing - Table |

__Sum cells in a table when a column meets multiple conditions__ Summing - Table |

__Sum cells that are not errors__ Summing - Other |

__Sum cells that are not hidden__ Summing - Other |

__Sum cells that are numbers__ Summing - Other |

__Sum cells that are numbers after multiplying__ Summing - Other |

__Sum cells that are numbers and even__ Summing - Other |

__Sum cells that are numbers and greater than a value__ Summing - Other |

__Sum cells that are numbers and less than a value__ Summing - Other |

__Sum cells that are numbers and negative__ Summing - Other |

__Sum cells that are numbers and odd__ Summing - Other |

__Sum cells that are numbers and positive__ Summing - Other |

__Sum cells that are numbers and unique__ Summing - Other |

__Sum cells that are numbers in a range__ Summing - Other |

__Sum cells using array formula__ Summing - Other |

__Sum cells with formatting__ Summing - Other |

__Sum cells with OR criteria__ Summing - Other |

__Sum cells with shading__ Summing - Other |

__Sum comma delimited numbers__ Summing - Other |

__Sum entire column__ Summing - Other |

__Sum entire row__ Summing - Other |

__Sum every n cells in a column__ Summing - Other |

__Sum every n cells in a range__ Summing - Other |

__Sum every n cells in a row__ Summing - Other |

__Sum numbers__ Summing - Other |

__Sum running total__ Summing - Other |

__Sum the last n numbers__ Summing - Other |

__Sum the n largest numbers__ Summing - Other |

__Sum the n smallest numbers__ Summing - Other |

__Sum visible rows in a filtered column__ Summing - Other |

__Sum visible rows with 1 condition__ Summing - Other |

__Sum visible rows with multiple conditions__ Summing - Other |

__Sum whole numbers only__ Summing - Other |

__Test if a cell begins with x y or z__ Conditional - If |

__Test if a cell contains 1 text string__ Conditional - If |

__Test if a cell contains 2 text strings__ Conditional - If |

__Test if a cell equals 1 value__ Conditional - If |

__Test if a cell equals this__ Conditional - If |

__Test if a cell equals this and another cells equals that__ Conditional - If |

__Test if a cell equals this or that__ Conditional - If |

__Test if a cell equals x y or z__ Conditional - If |

__Test if a cell is between 2 dates__ Date - Test |

__Test if a cell is between 2 numbers__ Number - Test |

__Test if a cell is blank__ Conditional - If |

__Test if a cell is greater than 1 value__ Conditional - If |

__Test if a cell is less than 1 value__ Conditional - If |

__Test if a cell is not blank__ Conditional - If |

__Test if a month has 30 days__ Date - Test |

__Test if a month has 31 days__ Date - Test |

__Test if a year is a leap year__ Date - Test |

__Test if not blank multiple cells__ Conditional - If |

__Test if this and that*__ Conditional - If |

__Test if this or that*__ Conditional - If |

__Test if with wildcards__ Conditional - If |