How to Unpivot Data with New Excel Functions

How to Unpivot Data with New Excel Functions

Unpivoting data is a common task when working with spreadsheets, as it involves transforming data from a wide format to a long format, making it easier to analyze and visualize. With the introduction of new functions in Excel, the process of unpivoting data has become...

Excel TEXTAFTER Function

Excel TEXTAFTER Function

The TEXTAFTER function is a Text function that returns part after a given character or string. In this guide, we’re going to show you how to use the TEXTAFTER function and go over some tips and error-handling methods. Supported versions Excel 365 (Office Insider Beta...

Excel TEXTBEFORE Function

Excel TEXTBEFORE Function

The TEXTBEFORE function is a Text function that returns part before a given character or string. In this guide, we’re going to show you how to use the TEXTBEFORE function and go over some tips and error-handling methods. Supported versions Excel 365 (Office Insider...

Excel TEXTSPLIT Function

Excel TEXTSPLIT Function

The TEXTSPLIT function is a Text function that returns an array of substrings split by a given delimiter. If you use the function itself, Excel spills the substrings into multiple cells as a regular dynamic array. In this guide, we’re going to show you how to use the...

Excel VALUE Function

Excel VALUE Function

The VALUE function is a Text function that converts a text string in a recognized format (i.e., a number, date, or time format) into a numeric value. In this guide, we’re going to show you how to use the VALUE function and go over some tips and error-handling methods....

Excel DEGREES Function

Excel DEGREES Function

In Excel, The DEGREES function is a Math & Trigonometry function that converts radians into degrees. In this guide, we’re going to show you how to use the DEGREES function and go over some tips and error handling methods. Supported versions All versions Syntax...

Excel RADIANS Function

Excel RADIANS Function

In Excel, The RADIANS is a Math & Trigonometry function that converts degrees into radians. In this guide, we’re going to show you how to use the RADIANS function and go over some tips and error handling methods. Supported versions All versions Syntax [box...

Excel TREND Function

Excel TREND Function

TREND The TREND function is a Statistical function that can return values along a linear trend line through a given set of dependent and, optionally, independent values. In this guide, we’re going to show you how to use the TREND function and go over some tips and...

Excel FORECAST.ETS.STAT Function

Excel FORECAST.ETS.STAT Function

The FORECAST.ETS.STAT function is a Statistical function that returns a statistical information based on time series forecasting. This function can be used with FORECAST.ETS function to see the statistical values of forecasting. In this guide, we’re going to show you...