by Ilker | Jun 2, 2023 | Blog, Excel Formulas, Excel Tips & Tricks
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...
by Ilker | Nov 22, 2022 | Excel Formulas
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...
by Ilker | Nov 21, 2022 | Excel Formulas
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...
by Ilker | Nov 7, 2022 | Excel Formulas
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...
by Ilker | Nov 2, 2022 | Excel Formulas
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....
by Ilker | Aug 18, 2022 | Excel Formulas
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...
by Ilker | Aug 17, 2022 | Excel Formulas
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...
by Ilker | Apr 12, 2022 | Excel Formulas
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...
by Ilker | Mar 8, 2022 | Excel Formulas
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...