Search results

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.

Hi, I have calculated 6 months moving avg for the years 2007 to 2011 as follows. Months Sales 6 Months Moving average 2007 Jan 6802 #N/A Feb 5063 #N/A Mar 7533 #N/A Apr 10999 #N/A May 5889 #N/A Jun 10408 7782.333333 Jul 10111 8333.833333 Aug 6685 8604.166667 Sep 5878 8328.333333 Oct...

I have already gone through the above link. I dont know how to proceed further? Sorry if my question sounds stupid. I am not savvy in excel, just started learning recently.

Can anyone provide me sample spreadsheet regarding the same?

Hi, Thank u very much for the reply. I have already arranged the data in pivot table and applied conditional formatting too. My manager does not seems to be happy with pivot table :( Is there any other efficient way?? I want to flag the growth rate like +30%, -30%

Can anyone suggest me how can I calcluate the 6 months moving avearge for unit sales volume data for different categories of products?

Hi, I have huge datbase containing yearwise, countrywise, product and sub product wise sales unit volume data. I need to generate a report in excel which produce the following outcomes, What are my top ten countries for each category of products? What are my top unit volume movers and where...