Excel | Windows Reference

Save as PDF & XPS files in Microsoft Office 2007

Nov 042009

If you are using Office 2007 then there is some good news for you. If you want to save your documents as PDFs or as XPS files (XML Paper Specification) then there is an addon available from Microsoft that can help you. Simply download and install the addons and that should do it for you.

These addons should work on Access,Excel, Infopath, OneNote, Powerpoint, Publisher, Visio and Word 2007.

Incoming search terms:

How to extract/list Unique values in a column in Microsoft Excel

MS Office 6 Responses »

Feb 062009

There are times when you have hundreds of thousands of values in a column in an Excel sheet or a CSV file with more than one occurence and you will need to extract a list of unique values from it. Sounds like a daunting task??? Not really, with a few clicks you can extract unique values from a column in an Excel sheet.

Incoming search terms:

excel 2003 unique values (62)
extract unique values excel (49)
excel list unique values in column (43)
excel 2010 unique values (38)
extracting unique values in excel (36)
excel 2003 distinct values in a column (34)
excel extract unique values (34)
excel extract unique values from column (30)
how to extract unique distinct values from a column (29)
extract unique values in excel (28)

Go-oo Office suite – Free Faster OpenOffice for Ms Office

Free Utilities 1 Response »

Dec 172008

After a 3 week long holiday and a near 2 week recovery period , its time to come back to the world of windows.

If you are looking for a free alternative for Microsoft Office Suite and not wanting to go for the most famous alternative openoffice.org for the known reasons of being slow and bloated then its time to turn up to Go-oo. Go-oo is a free cross-platform Office suite created by Novell as a variant of the opensource openoffice.org Office suite from Sun Microsystems.
Continue reading »

Incoming search terms:

go-oo office suite (2)
go-oo Office (1)
go-oo open office on windows 8 (1)
go-oo org evolution for windows (1)
open office GO OO (1)
vba windows explorer reference (1)
www windowsreference com svg (1)
www windowsreference com wordperfect (1)

How to open Office 2007 Documents in Office 2000/2003/XP

MS Office No Responses »

Feb 022008

If you want to open documents created by office 2007 in Office 2000/2003/XP you just need to install Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats.

By installing the Compatibility Pack in addition to Microsoft Office 2000, Office XP, or Office 2003, you will be able to open, edit, and save files using the file formats new to Word, Excel, and PowerPoint 2007. The Compatibility Pack can also be used in conjunction with the Microsoft Office Word Viewer 2003, Excel Viewer 2003, and PowerPoint Viewer 2003 to view files saved in these new formats.