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.
Tag: spreadsheet
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.
Change pivot table data source
In this video we talk more about pivot table and the options that this tool has for us.
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.
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
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.