Popo Cat - Software, News, How to tutorials

When you have a lot of data to review in an Excel file it can be tedious finding duplicate values. Today we will look at how to easily identify duplicate values with Conditional Formatting.

With the Excel document open highlight the section of the document to search for duplicate entries.

On The Ribbon click under the Home Tab is selected.

In the Styles section click on Conditional Formatting \ Highlight Cells Rules \ Duplicate Values.

This opens up the Duplicate Values dialog box where you can select how to format the cells with duplicate data.

Now you will be able to easily find the cells that contain the duplicate data so you can change the values or delete them.

This is a quick and easy tip to help make sure important spreadsheets contain correct information.

Microsoft’s decision to change the default file format in Office 2007 for some of its most popular Office programs has caused some confusion and controversy, especially shortly after introduction. Back then no one was able to open the docx, xlsx or pptx file formats if they would not have Microsoft Office installed. This changed quickly as Microsoft released the Office 2007 compatibility suite for previous installments of Microsoft Office. Users without Microsoft Office were able to work with the new formats in Open Office or use online converters to convert them to traditional Office documents.

The Google Docs team on the other hand was reserved and did not add support for these file formats until now. Today, they announced that they finally added support for both the docx (that is for Microsoft Word 2007 documents) and xlsx (Microsoft Excel 2007 spreadsheets) format in Google Docs.

Support in this case means that users can upload files with the docx and xlsx extension to Google Docs. The size limitations are 500 Kilobytes for docx documents and 1 Megabyte for xlsx spreadsheets.

The document can then be edited in Google Docs just like any other document. There is however no option to save documents to a local computer system in the docx or xlsx format yet. Google Docs will automatically convert the documents to doc or xls format.

One of the worst experiences for dealing with documents is its corrupt file and unrecoverable result. Combining damaged docx2txt and corrupt xlsx2csv, let’s repair corrupt Word and Excel files immediately and perfectly. They radically change the Microsoft experience, maximize file management and save much time.

Damaged docx2txt
This is a GUI version. As the name demonstrated, it will extract text from damaged/corrupted Word 2007 files where Word 2007 fails. It open those destroyed files with .txt format. Select open in the menu, open the corrupt one, the content corrupted is open on the .txt file. If you want to save it, it’s also very easy. Click the save in file menu, you can also rename it and save in your destination place. Isn’t sound so easy? See the brilliant management as below. Download Damaged docx2txt>>

Corrupt xlsx2csv
Similarly, this corrupt xlsx2csv owns the same functions with the above corrupt Word processor. This one is specially used in the Excel spreadsheet field. The command line unzipping program is used when dealing with corrupt Excel spreadsheets. In fact, the operation is quite same with the damaged docx2txt. Differently, the final file is saved as .csv format.

What’s more needs pay attention to is, both the programs need .NET Framework 2.0 or higher, and they are only supportive on Microsoft Word 2007 and Excel 2007 files.

Many users who want to extract non-textual data from a pdf document help themselves by creating a screenshot of that data to embed it into their documents. While most pdf readers are nowadays capable of copying text from pdf documents they usually do lack the ability to copy more complex data like tables or drawings from these documents.

Enter PDF to Excel and PDF to Word, two online services created by the same developer that convert pdf documents in microsoft word or microsoft excel documents. Both products are available online and simple to use. Three steps are required to convert the pdf document. The user needs to select a pdf document from the local computer system, pick a output format and enter an email address where the converted pdf document should be send to.

The conversion comes close to the original. Some parts might need some fine tuning but the overall look and feel of the pdf document has been carried over and probably more important than that the data in the tables looks exactly like that in the pdf document.

PDF to Excel and PDF to Word are two helpful online services for users who have to convert pdf documents into Word or Excel format.

If you find interesting or important data in a table on a website it might be helpful to import it into Excel. Today we will look at how to import data from a table on a website into Excel which will allow you to organize and add to reports.

Open Excel 2007 and under the Data tab select Get External Data and From Web.

Data From Web

This will open up the New Query window where you enter in the URL of the site you want to get data from. There will be yellow arrow icons next to the table data that can be imported, click the areas of the data you want to import which turns the box to a green checkmark. After you have what you want selected click on the Import button.

Next choose the cell where you want the data to appear in the spreadsheet and click OK

The data will begin to be retrieved from the site, the amount of time it takes will depend on the amount of data you selected. Now you can organize the data how you like for presentation.