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.
Basic of Charts in Microsoft Excel
In this video we talk about how can make a chart in Excel and what are the main properties of charts in Excel. Creating a chart is one of the main tools for data analyzing and Excel simple and beautiful charts are one its most well known advantages of this software
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.
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.
Excel Table advantages for writing formula
In this video we talked about why using Excel tables give us great advantage in writing formulas and makes function handling more convention and efficient