Google adds powerful new functions for more advanced analysis in Sheets

Google has announced 11 new functions in Sheets that it says will provide you with more efficient functions, and help with more advanced analysis. 

The new functions will be available to all Google Workspace customers, legacy G Suite Basic and Business customers, and users with personal Google Accounts. All functions can be inserted using the function autocomplete after pressing the equal symbol, using the insert menu, or the function dropdown in the toolbar. 

Below are the newly-added functions in Google Sheets:

• EPOCHTODATE: Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC. 
• MARGINOFERROR: Calculates the amount of random sampling error given a range of values and a confidence level. 
• TOROW: Transforms an array or range of cells into a single row. 
• TOCOL: Transforms an array or range of cells into a single column. 
• CHOOSEROWS: Creates a new array from the selected rows in the existing range. 
• CHOOSECOLS: Creates a new array from the selected columns in the existing range. 
• WRAPROWS: Wraps the provided row or column of cells by rows after a specified number of elements to form a new array. 
• WRAPCOLS: Wraps the provided row or column of cells by columns after a specified number of elements to form a new array. 
• VSTACK: Appends ranges vertically and in sequence to return a larger array. 
• HSTACK: Appends ranges horizontally and in sequence to return a larger array. 
• LET: Assigns name with the value_expression results and returns the result of the formula_expression. The formula_expression can use the names defined in the scope of the LET function. The value_expressions are evaluated only once in the LET function even if the following value_expressions or the formula_expression use them multiple times.

In a blog post, Google said that these new functions provide new functionality in the form of:

• Powerful new ways to manipulate and work with arrays using TOROW, TOCOL, WRAPROWS, WRAPCOLS, CHOOSEROWS, CHOOSECOLS, VSTACK, and HSTACK. 
• Converting Unix EPOCH dates to readable formats without the need for manual calculations using EPOCHTODATE. 
• More efficient and simpler to read complex formulas that use LET to assign names to calculation results.