In this video we talk more about pivot table and the options that this tool has for us.
Tag: Microsoft Excel
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.
Designing your pivot Table for reporting
In this video we talk about how we can design and customize the pivot table in order to have a report of main table in Microsoft Excel
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.
Basic of Pivot Table in Excel
Pivot table is one the most useful tools of Microsoft Excel for getting quick and easy report. In this video we talk about how we can create and generate sample report by using pivot table in Excel.
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.
Excel combo chart
When you want to compare two variables by using Excel charts, if those two variable have same measuring index then we can plot them in one charts. However, if those variables has different measurements, like one being money amount and one being quantity, then we need to use combo box which enables us to have two different measurement units in one chart.
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.