Showing posts with label Office. Show all posts
Showing posts with label Office. Show all posts

Monday 5 July 2010

Office web apps

Playing around with office web apps today. Very pleasing move from Microsoft which doesn't require that you purchase a desktop license to use office web apps. Yes, the personal edition is FREE, like free beer!. Although Microsoft Office desktop edition software leads the industry by far from it’s competitors, Microsoft’s cloud strategy was still a bit behind Google and IBM. With the public release of Office web apps, MS has definitely poked it’s nose in. We will have to wait and watch as to how people react to it to make it a success. I personally feel it will add a lot of value to the already successful Office suite and it’s definitely well posed to take on Google docs!

Three things i love about Microsoft Office Web Apps.

1] Usable from hotmail, integration with sky drive (25 GB online storage). More to follow soon with the ability to attach web app documents (Word web app, Excel web app, Powerpoint web app,OneNote web app)

2] Multiuser collaboration. 

3] Tested and ready for Google chrome browser (so, it sucks less, ahem, well atleast not as much as IE 6,7 and 8).

Some links to dig further.

1.Microsoft Office Web Apps -  http://office.microsoft.com/en-gb/web-apps/office-web-apps-overview-FX101903123.aspx

2.Developers catch the action here - http://blogs.msdn.com/b/officewebapps/

Sunday 11 October 2009

Excel Pivot Tables

Pivot Tables are an interactive table that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. They can sort, count, and total the data, and are available in a variety of spread sheet programs. One advantage of this feature in Excel is that it allows you to rearrange, hide, and display different category fields within the Pivot Table to provide alternate views of the data. Read on to find out how to create your own pivot table in Excel.Found this neat article which illustrates 3 examples.

Sunday 27 September 2009

Microsoft Excel Web Queries

Pulling data from an external website to an Excel spread sheet can be easy with Excel Web Queries. Web Queries fetches html tables from the web page that you specify and lets you select the ones containing data you want to put into your worksheet.

Web scraping without writing c0de that is!!

More Illustrations Here