Posted on Leave a comment

TRIM , CLEAN Function in Excel

The Microsoft Excel TRIM function returns a text value without leading, trailing and unnecessary spaces between words in a string. The TRIM function is a built-in function in Excel that is categorized as a String/Text Function.
In this video we described how to use TRIM function and its difference with CLEAN function.

Posted on Leave a comment

LEN function in Excel

LEN function is useful when you want to find the number of characters in the text. Gives the number of characters in given text string including spaces. This function is categorized as a String/Text Function.

In this video we described how to use LEN function in different situations.

Posted on Leave a comment

DOLLAR formula in Excel

The DOLLAR function, one of the TEXT functions, converts a number to text using currency format, with the decimals rounded to the number of places you specify. DOLLAR uses the $#,##0.00_);($#,##0.00) number format, although the currency symbol that is applied depends on your local language settings.

In this video we described how to use DOLLAR function in different situations.

 

Posted on Leave a comment

LEFT , RIGHT , MID , Functions in Excel

LEFT, RIGHT and MID functions extract a substring from a string. We can specify how many characters to be extracted. This functions are categorized as a String/Text Function.

In this video we described how to use LEFT , RIGHT and MID functions in different situations.

 

 

Posted on Leave a comment

Conditional Formatting Fundamental

In this video we introduce an important tool of excel named as conditional formatting which is a very great tool for data analyzing and showing the data in meaningful way. By using this tool, we are able to set different colors or icons for different range of values or based on some predefined conditions, we can change colors or icon of specific cells.

 

 

Posted on Leave a comment

SEARCH , FIND Function in Excel

The Microsoft Excel SEARCH and FIND functions returns the location of a substring in a string. The only difference between these two functions is that FIND is case-sensitive, but SEARCH is NOT. SEARCH and FIND functions are built-in functions in Excel that are categorized as String/Text Functions.
In this video we describe these functions in details and explain the difference between them with examples. For more videos like this, please subscribe us.

Posted on Leave a comment

CONCAT and CONCATENATE Function in Excel

The Microsoft Excel CONCAT function allows you to join 2 or more strings together. It was released in Excel 2016 and replaces the CONCATENATE function. The CONCAT function is categorized as a String/Text Function.
In this video we describe how to use this function in different situations.

Posted on Leave a comment

Using filter option and slicer in Excel table

In this video we talk how we can filter data in Excel. Specially, in Excel tables by using slicers options. Slicers are useful tool in excel that enable you filtering data by just clicking at current values in an box. Which can be very helpful when you have lots of data and want to filter them easily

Posted on Leave a comment

Creating New Excel Table Style

In this video, we talk how to using table style and creating one for ourselves. With Table style, we can show data with more properly to other users, specially when you have a lots of data, showing them more efficiently would be one of main concerns of understanding and analyzing data