Posted on Leave a comment

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

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

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.

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

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.

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

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

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.