Posted on Leave a comment

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.

Posted on Leave a comment

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.

Posted on Leave a comment

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.

 

Posted on Leave a comment

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.

Posted on Leave a comment

FIXED function in Excel

The Microsoft Excel FIXED function returns a text representation of a number rounded to a specified number of decimal places. This function is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the FIXED function can be entered as part of a formula in a cell of a worksheet.

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

Posted on Leave a comment

slicer , timeline slicer and refreshing data in Pivot Table

In this video we show that how to use slicer for filtering data, and how we can use timeline slicer

Posted on Leave a comment

UPPER , LOWER , PROPER functions in Excel

The Microsoft Excel UPPER, LOWER and PROPER functions converts capital and lower-case letters to each other in the way we need. UPPER function capitalizes all the letters in a word and LOWER function do exactly opposite of UPPER and converts all the letters in a word to lower-case. The PROPER function capitalizes all the first letters in each word and converts rest of the letters to lower-case.
These functions is categorized as a String/Text Functions. they can be used as a worksheet function (WS) in Excel. As a worksheet function, these functions can be entered as part of a formula in a cell of a worksheet.
In this video we described how to use UPPER, LOWER and PROPER functions in different situations.