How to Create Gantt chart in Microsoft Excel

A Gantt chart is used for representation of a project with a graphic picture to be completed within an absolute time. It is a broad overview of a proj...

How to Create a Graph in Microsoft Excel

In this article we will learn about how we can make a graph in Microsoft Excel. Charts are used to convert the numeric data in a graphical format, ...

Concatenate Formula in Microsoft Excel

In this article, we’ll learn about CONCATENATE function in MS-Excel. It is a text function which is used to merge two or more text strings from dif...

How to Calculate the Compound Annual Growth Rate "CAGR" in Microsoft Excel 2010

Compound annual growth rate (CAGR) is a business and investment term that provides a constant rate of return over the time. It can be thought of as th...

ANOVA Single Factor in Microsoft Excel

ANOVA- single factor in Microsoft excel is used for analyzing inconsistencies in analytic tools. This tool means more than two independent groups are ...

Using Named Ranges for Picture Lookup in Microsoft Excel 2010

If you want a formula that will return picture based on the lookup value, you can use a combination of INDEX& MATCH functions in Named ranges to g...

Pivot Table Report - Grouping the Date Field by Days, Months, Quarters and Years in Microsoft Excel 2010

To create a pivot table report – grouping the date field by days, months, quarters and years, let us first create a pivot table report. Let us ta...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube