'Excel 2010 has no drag and drop functionality' my friend declared.
He sulked....4 Months of suffering ....no solution…
I checked his computer. True. there is no drag and drop functionality.
I checked my computer; Drag and drop are available… I thought it must be some excel setting.
So, I Googled.
The answer lies in a small tweak.
File > Options > Advanced
Enable fill handle and cell drag-and-drop: Ensure the box is checked. Take a look at this Picture here the Box is not checked. So Check It....That's the Solution
Problem? I Google. I Solve.
Four months of suffering Vs. Instant solution the difference is ….a friend called
Forecasting is an Art,Science,Social studies,Maths and more !
From www.Forexmillion.com
Use of trends can make forecasting easy ! And God's gift to corporate mankind can make it easier !( Well, I 'am referring to Excel) However, the trend line in excel does not display the values it holds. Computing the values on excel is an extremely confusing stuff . You need to use innumerable formulae in excel to arrive at the values. Just to make the job easy, here I present a way to do it. I have also attached an excel file link in the presentation. You can download the same and use it. Alternatively you can download it from my BOX: Trendlines.XLS Computing trendline values in excel
Every now and then, I encounter a requirement for reverse Computations .... I have this year sales and growth.. What is last year sale?
Though they are simple, instantaneously getting the answer is difficult for me!
So, I created a file for myself.. Here, I am sharing the file with you. I have given reverse computation formula for commonly used Sales metrics like sales achievement, targets, growths, CAGR etc. Click to Download
Please do not hesitate to add more. Write to me. I will post the same in your name....
If you are to present the four parameters say Brands, Growth, Market Share and Sales, on a graph to understand dynamics of the market,
A 'Bubble Chart' can easily show these four parameters on a single graph
We know X and Y Axis can show two data points. The third one is the size of the point in the form of a Bubble and The forth one is Color to distinguish between data points.
So, in a Bubble chart, 4 Parameters can be shown
Parameter 1: Brands can be shown in Color
Parameter 2: Growth can be shown on X-Axis
Parameter 3: Market Share can be shown on Y-Axis
Parameter 4: Sales can be shown as the Size of a bubble
Bubble Chart Example: You can download the Template from Link given below
One can easily create Bubble charts using excel.
However, when you are plotting multiple series of data points (Here in the example quoted above, it is the Region), you need to pain strikingly input each data point on the chart.
To make things easier, create a template and use the template every time.
I have created one such template for you.
Next time when are to create a bubble chart, just use the template!
You can download the excel file @Downloads It's a DO..CO..MO.. stuff (Download, Copy , Modify )
That’s the promise of Tableau…and indeed it lives up to its promise…. Tableau Public puts all spreadsheets to shame with its brilliant capabilities… If you are in to serious analytics … Tableau public is a must! Watch the Video…. Download the PowerPoint…Click the links…. Watch the Videos…. Learn… Get amazed …..and amaze others….. It’s truly…. Data in. Brilliance Out.
The most uncomfortable situation for a sales manager is to predict next month sales with near accuracy. The paradox is that he is always confident and comfortable in predicting sales after two years… Conversely in Mathematics, It’s just the other way round. Unless it’s MathemaTRICKS!
You come across this incongruity every now and then in the domain of sales. The use of Trendline is one of the good methodologies to forecast sales with a fair degree of certainty.
That's why it a prerequisite to understanding trend lines to learn to forecast. Here is a PowerPoint presentation for you to understand better.
The easiest way to create trend lines without much ado is to use God’s gift to the corporate citizen, "The spreadsheets". I used excel for this.
Do not hesitate to click the link and download the PowerPoint. Copy it, Use it, Distribute it.
After recovering from the awe-inspiring presentation, the immediate question that strikes the mind of a data geek is ....can I use my own data for similar data calisthenics?
The answer is Yes!
Hans Rosling uses software called Gapminder conceptualized by him. This was bought by Google. It is available as free desktop download that can be used even without Internet connection. http://www.gapminder.org/desktop/
This original Gap Minder has fixed data sets and these cannot be edited.
So what’s the alternative ? Google showed the alternative…called Motion Chart! In addition ,there is another free Option… So, now we have two free Options
Motion Chart by Google (it’s a Google Gadget for Google Docs)
Trend Compass by Epic Systems.
now a day you can use Tableau Public also
Other Options include the use of crystal Xcelsius or even Excel. However, both these options need skills of high order! For the time being let’s limit ourselves with free and easy options. Before trying to use the software, it’s worth while to read the one page basics and play around with the outcome. One page basics and Guide http://www.gapminder.org/GapminderMedia/wp-uploads/tutorial/Gapminder_World_Guide.pdf
Here is a video to watch
Here is the Motion chart I have created with GDP and Population of BRIC-TM countries. Play with the data to understand the use of motion Chart. If the motion Chart does not open on the website,Click the link Motion Chart Link to go to the Google doc and open "Gadget1"on the left bottom of your screen. Now that you know basics of Gap Minder, use the alternative free option from Google. Follow the steps given below
Go to Google docs and open a spreadsheet (You need to log in with a Google account)
The most vital part of Motion chart is preparation of spreadsheet
Create the spreadsheet with your data
The data you want to show as a bubble should be in the first column (e.g.: Countries, States, Territories Etc.)
The year should be in the second column
The data to compare should be in next columns
Once the data is in place, go to insert and add gadget
Select Motion chart Gadget
Bang! your Motion chart is ready!
Play!
You can publish your work by copying the HTML code for your blog or company site…or else have an Internet connection while presenting the data
Ted is a non-profit organization devoted to ideas worth spreading. Ted's mission is spreading Ideas! It's indeed a feast out there on TED website http://www.ted.com/
This add-in is called “ ASAP Utilities”.Its absolutely free and used by 2 million users across the world. what you need to do is download the a ~10 MB tool and Install it on your computer.
The install procedure is very simple.
It automatically opens Microsoft Excel and loads the add-in. You will see an additional item in your menu bar called “ASAP Utilities”
“ASAP Utilities is a powerful Excel add-in that fills the gaps in Excel and automates frequently used tasks. Since 1999 it has grown to become probably one of the world's most popular add-ins for MS Excel.”
They are right in saying so…
Why ?
They are good number of tasks that are repeatedly done in excel and takes huge time. With ASAP Utilities you can accomplish them just with a click of a button or may be few clicks.Look at some examples.
Eg 1: You have 20 sheets of data. You need to create an index page with links to all the sheets.In normal excel , it is a time consuming process to create a link to each page. Here it is just a click of a button.
Eg 2: To delete all hidden or empty rows and columns, in the normal excel you need to unhide the rows select them and delete. Here it is again just a click of a button.
Eg 3: Sort the continents of a column based on the colour of the cells, font of the cells is an impossible feat to accomplish in excel . Here it is just a click of a button.
