Design your tables in MS Excel 2007

This is a simple tip for MS Excel 2007. When using Outlook 2007/Word 2007 and working on a Table we get the “Design” menu which is very handy to make our tables look beautiful. When working with MS Excel 2007 I couldn’t find this feature (Design Menu for Table) until yesterday. It suddenly struck me that in Excel though everything appears to a “Table”, they are not and we need to explicitly create a “Table”. That’s it, feature found! Steps to follow: Just select the cells you are interested in,…

Prepaid Microsoft Office 2007

WOW, writing the above headline made me wonder how far software has come from the time you bought it from guys with coat and suit, to online, to free and now to rental. And what better product to signify this, other than MS Office. I read in news that Microsoft India has announced MS Office 2007 in Prepaid model – which for me essentially resembles a rental/subscription model, as software always has been prepaid in the true sense. May be MS didn’t want to use either subscription or rental words,…

Office 2007 Viewers

Many times you might have got stuck not being able to open a Word/Excel/PowerPoint file because MS Office is not available on that machine. Though OpenOffice/Office Suites in Linux can open MS Office documents, it doesn’t work perfectly with all documents. Microsoft has for long provided for free, viewers for these formats. These viewers can be downloaded from Microsoft.com website and allow you to open, view and print the documents without requiring you to have full-blown (paid) MS Office in the machine. The viewers now support the new Office 2007…

PowerPoint 2007 doesn’t have Summary Slide Feature

One of the common things you want to do after you created all your content slides in a presentation is to put an Agenda slide or TOC (Table of Contents) slide. This was easy using the Summary Slide button in Microsoft PowerPoint 2003 as shown below. For reasons best known to Microsoft, this feature to have a summary slide automatically generated is not available in PowerPoint 2007. This MS Knowledge base article confirms this behaviour, and it suggests a tedious manual process of copyring each slide title and pasting it to…

Tech Mela 2007 – Day 2

Microsoft Performance Point Server (PPS) by Abhishek Srivatsa (Microsoft India): I had little understanding on this product, so decided to start with this. The session gave me some overview on the product and on how it helps to collect and model data with its built-in tools. It uses SQL Server 2005 Enterprise for its own Meta-Data and Cubes, but the actual data can come from any source (RDBMS). End users can enter data easily through Excel and don’t need InfoPath (it is not supported now). PPS needs WSS or Sharepoint…