Recent content by Tanu

Hi guys, Can u please tell me how to create an alert in excel which pops up automatically every year to remind us that something needs to be renewed for exapmle licence

Thank u. Can u brief little further on correlation pls? How it works? Why it is important to calculate statistically significant correlation? How to interprete it?

pls someone reply me, its bit urgent...tks a lot

Can anyone help me to find out statistically significant correlation in sales volume growth between countries, between different types of products with the GDP or industrial growth, etc. It wud be great if u could provide me sample spreadsheet. Thanks

No no, Please see the below pasted data... Country (All) Column Labels Q1 Q2 Q3 Q4 Country Sales(units) Growth % Sales(units) Growth % Sales(units) Growth % Sales(units) Growth % AAAA 2007 1776 3089 2741 4513 2008 3783 113.01% 2013 -34.83% 4521 64.94% 4840 7.25% 2009 2357...

Hello, I want to hihglight growth %( more than 30 green clour, less than 30% red clounr etc) data contained in pivot table. I tried applying conditional formatting by selecting only growth % cells. But the problem I'm facing here is wen I filter out and select some other country to have a look...

Can u also answer my question Is there are any possibily for predecting the 2011 ( Q2 to 4) and 2012 data??

Thanks a lot :)

Hello, I have database showing sales growth rate(%) of different countries for different categories of products. How can I colour code in which country which products are selling fast? I need to filter out top 5 countries accroding to their growth rate as well as product category and need to...

Hello, Can anyone suggest me the efiicient way for forecasting the sales for current year( Quarterly) based on the last year data.