SkyDrive provides the excel survey feature which allows you to create online surveys and analyze results using the free Excel Web App or Excel on your desktop. You can display the survey results by embedding the excel in a web page. ExcelMashup.com allows you show a workbook directly in your website. It also lets you easily sort, filter, and interact with the workbook as in Web Excel with powerful Javascript API. We will create a sample survey and save result data to database using ASP.NET MVC and Entity Framework.
Category: MS Office Tips
MS office word excel tips
How to Remove Line Numbers in Excel Column
It explains how you can remove line numbers and get proper data in a excel column. Suppose you have data in following format in A column:
1. First Data
2. Second Data
3. Third Data
4. Fourth Data
5. Fifth Data
You have to remove line numbers and get content in another column. See following screen-shot:
Convert MS Word document or Excel sheet to images (JPEG)
Someone asked me how MS Word document can be converted into JPEG images. It was very interesting practical question because It can’t be done using Save As.. option. One way is to use Print Screen, paste it in paint and remove unnecessary stuff. But, for this, the whole page should come in screen else we need to merge two screenshots. It is too complex process. On googling, I found there is no direct way to do this. There are 3rd party tools. but, I want to do this in easy steps. At last, I got solution using Microsoft Office OneNote.
Selection tips for MS Word
This article explains the selection tips to simplify the common tasks in MSWord.
1. Select multiple areas that aren’t next to each other: Generally, it is required to copy multiple portions of document. It is not convenient to copy one by one and paste it. We can do it in single attempt.