MS Excel Tip: How to Paste Column Widths

February 28th, 2009 There are millions of Microsoft Office Excel spreadsheets users who rarely care to  look for the best side of it, I mean hacks.  There are a wide range of functions performed on Microsoft Excel from calculations to analyzing data to integrating information, the list continues. With a fluent interface rich data visualization, and PivotTable views MS Excel is now easier to use.

October 28th, 2005 I wanted to manipulate dates in Microsoft Excel - the result is a sum of date, a fixed number of days and a variable no of day(s) from a second column. I couldn't find much documentation in Microsoft Excel to help me.

March 12th, 2009 The line of a text is a big headache sometimes. If you work with text based documents, you will probably know the utility of a linebreak or a word-wrap.

June 21st, 2006 While Microsoft developers are scrambling to patch a security hole in Excel, a hacker has now posted code that exploits a second vulnerability in the popular spreadsheet software. Microsoft says that criminals are not yet using this code in attacks, but the software could be used to run unauthorised programs on a PC, according to Marc Maiffret, chief hacking officer at security software vendor eEye Digital Security.

May 24th, 2007 Overview There are two good choices for reading & writing Microsoft Excel Spreadsheet files from Java, in a platform independent way, - jexcelapi and Jakarta POI (HSSF). Both of them provide nice interface to access Excel data structure and even generate new spreadsheet.

May 19th, 2005 My friend is making a large document in Microsoft Excel 20 or so columns. He found that he was forced to go back everytime to the top of the document to figure out what the column represents.

May 19th, 2009 At times you need to reuse the table with tabulated data from PDF format. Simply, you can't work on the PDF tables as you can do with Microsoft Excel.

February 25th, 2009 Microsoft confesses again. Though there is nothing to be ashamed of MS.

August 24th, 2009 After our series of top 10 hacks and tricks to better your experience with Microsoft Office - Word, Excel, Powerpoint and Outlook,  we decided to provide you the best hacks and tricks for Microsoft Office tools. The office programs like word processor, spreadsheets, presentation and email are most frequently used applications than any other application on computer.

May 20th, 2009 Microsoft Works comes with most of the windows based PC's for free. It is a basically an entry level office or home productivity software suite that  includes word processor, spreadsheet and database.

May 26th, 2007 Sometimes you need to have database column names with space or other non-standard characters. The standard procedure is to escape them with backtick (`) character.

August 30th, 2008 Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL. Use mdbtools utilities as described below: mdb-tables displays the list of tables in MS Access mdb-scheme export the MS Access schema to MySQL database.

July 5th, 2007 I tested several file compression programs like zip, gzip, arj, bzip2, jar etc for compressing big files. The corpus constituted 5 POI generated Microsoft Excel documents totaling 298.8 MB.

September 4th, 2006 Last week was an interesting one as hot debate raged over Joel Spolsky's article on enterprise language, Hani rightly bashed copious logging of open source software and my article on hacking attempts from Caltech topped the list of most read articles. We released Anaconda, a beautiful 3 column WordPress theme and version 3 of Translator Plugin Pro for WordPress.

June 6th, 2006 Google released a limited test version of Web-based spreadsheet program to make it simple to edit and share lists and data online. It comes barely months after Google bought a small Silicon Valley company called Upstartle, creators of a Web-based word-processing program called Writely.