The Microsoft Excel T function returns the text referred to by a value. The T function is a built-in function in Excel that is categorized as a String/TextFunction. It can be used as a worksheet function in Excel
In this video we described how to use T function in different situations
Tag: Microsoft Excel
EXACT Function in Excel
The EXACT function compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document. In this video we described how to use EXACT function in different situations.
Dashboard in Microsoft Excel
Dashboard is one of the best way to have data status under control. We use dashboard to control the status of situations in time line and to report them to management. In this video we show how to develop a simple management dashboard in Excel
TEXTJOIN function in Excel
The Excel TEXTJOIN function concatenates (joins) values with a given delimiter. Unlike the CONCAT function, TEXTJOIN allows you to supply a range of cells, and has a setting to ignore empty values.
In this video we described how to use TEXTJOIN function in different situations.
Create simple pivot Chart
In this video we show how to create a Pivot Chart in excel. which is very simple and can immediately done by using pivot table.
REPT Function in Excel
The Microsoft Excel REPT function returns a repeated text value a specified number of times. This function is categorized as a String/Text Function.
In this video we described how to use REPT function in different situations.
Field setting in Pivot Table Excel
In this video we take look at fields setting in pivot table of Microsoft Excel and introduce you the tools in this setting
NUMBERVALUE function in Excel
The Microsoft Excel NUMBERVALUE function converts a text value to a number by specifying the decimal and group separators. The NUMBERVALUEfunction is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in ExcelIn this video we described how to use NUMBERVALUE function in different situations.
Calculated fields in Pivot Table
In this video we talk about the calculated fields in Microsoft Excel pivotTable and seeing its advantages
TEXT Function in Excel
The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It’s useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.. This function is categorized as a String/Text Function.
In this video we described how to use TEXT function in different situations.