Tuesday, February 25, 2014

Tips to Convert PDF Document to Image Files (jpeg,png,gif)

You might have seen users many times converting a PDF document to an image file; however, do you really understand the reason behind it? At times, the entire PDF document might not work or you just need a few images from the PDF document; in such cases, it is good to perform such conversion. Now, it comes to a solution that could provide a successful and accurate conversion. The post provides you various ways for converting PDF document to image files along with the steps to perform to accomplish the task; go through the following.

Adobe Acrobat Pro
  • Launch Adobe Acrobat Pro
  • Open PDF document in Adobe Acrobat.
  • In the menu, click 'File'; from the displayed list, click 'Save as'.
  • In the appeared dialog box, specify a name for your document, and then choose JPEG, JPEG2000, TIFF, or PNG in the 'Save as type'.
  • Click 'Save'

The image of the selected type will be saved at the desired location on your computer. Note that the free version of Acrobat will not convert the document.
Google Docs
  • Open Google Docs; enter your account credentials to log in.
  • Click the Upload button represented by an arrow next to 'Create'.
  • An Upload Settings window will appear; select all the checkboxes to convert the PDF file to a document that can be edited.
  • Click the 'Start Upload' button.
  • In the opened file, click Google's File menu (note that this File menu is not the one available in main menu bar.)
  • Select 'Download as', and then select 'Microsoft Word'. Your PDF will be saved as a .docx Word file.

You are now done with a successful conversion using Google Docs.
Preview on Mac
  • On Mac, launch preview. In the menu, click 'File', click 'Open', and then browse to the target PDF file to open it.
  • Locate the document that has to be converted to an image. Know that only current page will be exported by Preview.
  • In the menu, click 'File', and then click 'Export' to export the page.
  • Apply setting for graphics format. A Save window will appear, and then set the location for file.
  • Go to the 'Format' menu; select the format that you want.
  • You can now adjust the quality of Output. You will be provided with a few options, such as resolution and compression quality. The options depend on the selected format. You can set the options as per your requirements.
  • Click 'Save' button. Your document is now saved.

Photoshop on Mac
  • In the Finder, select unopened PDF file. Select it by clicking just once; make sure that you do not open the file.
  • Go to the menu, click 'File', and then select 'Open With >'. With this, you will be provided with various applications to open the PDF file.
  • Select a photo editing application that is installed on your computer.
  • Select Images by clicking the associated radio button.
  • Select a picture that has to be imported.
  • Click 'OK'. When the file opens, you can save, edit, or crop it, depending on your requirement.

Note that you can use Photoshop on PC also.
Screenshots or Snipping Tool

If you are, for some reason, not able to use any of the above methods, you can try taking a snapshot on your Mac. On the other hand, on Windows, it is good to use inbuilt Snipping Tool for converting a PDF document to JPG image file. However, there is no assurance of top class quality, but it is assured that you will get a JPG image as a result.

You can capture the Screenshot on Mac as follows:
  • Press “Command + Shift + 4″ using keyboard, it will activate the screenshot function.
  • When a small cursor appears instead of mouse cursor, drag the cursor to any location around PDF that is to be captured. The screenshot will be captured and saved on the desktop. Its name will be specified according to time and date when it was created.

Use Snipping Tool on Windows as follows:
  • Go to Programs, and then Accessories. Look for the Snipping Tool, and once found, open it. You can also use Windows search bar to open the tool.
  • When the tool is opened, click the arrow that is visible next to 'New'.
  • Select the type of snip that you find better from dropdown, such as full-screen, rectangular, etc.
  • Drag the cursor to any location around the PDF that has to be captured. You will see a new window with the selection.

However, it is important to let you know that you can convert the PDF document to JPG images with the above steps.
Therefore, you are now aware of all the methods that will offer an effective PDF to image file conversion. Make sure to carry out the task attentively.
READ MORE - Tips to Convert PDF Document to Image Files (jpeg,png,gif)

Thursday, February 20, 2014

Things you Need to be Careful about while Installing Multiple Versions of MS Word on a Single Computer

All of you must be familiar with Microsoft Office Word (or MS Word) as a word processor from Microsoft. In fact, MS Word is one of the prominent components of MS Office suite, which not only is used at corporate level, but typical home users use it as well for their personal and professional works. Today, since different versions MS Word (i.e. MS Word 2013, 2010, 2007, 2003, and a few earlier versions) are available, people upgrade to a newer version whenever it is available to them.

However, people do have more than one version of MS Word (i.e. multiple versions of MS Office) installed on their computer. It may sound awkward, but yes, it is true that you too may need to install multiple versions of MS Word on your computer. Do you wonder why? Well, suppose you prepare your college assignment on MS Word 2007, which you have to submit to your tutor via email. Likewise, some students may create their assignment on MS Word 2010, whereas one or more may use Office 2003. After all students are done submitting the assignment to the tutor, he must have at least MS Word 2010 installed on his computer so as to open them. This is because a Word document created in a later version (let’s say word 2007) can be opened in an earlier version (let’s say Word 2003) In case he has Word 2003; he will have to install Word 2007 or 2010 as well.

Is it Feasible?
Do you wonder how it is feasible to install multiple versions of MS Word simultaneously on a single computer? Well, even though it is feasible, even Microsoft does not recommend going for it, especially on computers having Terminal Services enabled.

Tip 1: Disable Terminal Services if you need to install multiple versions of MS word (or MS Office) on a single computer.

What should be the Installation Order?
Well, in case you want to go for installing multiple versions of MS Word simultaneously on a single computer, you must follow the following order of installation:

Office 2003 > Office 2007 > Office 2010 >Office 2013

According to the aforementioned order of installation, you need to install earlier version before a later one, as this is the order in which ‘registry keys’, ‘shared programs’, ‘file name extensions’, and other settings are managed for each version of the MS Office and programs.

Tip 2: In case you uninstall one of the Office suites, you will have to reinstall remaining ones to work in an intended way.

Issues with Multiple versions of MS Word
In case you have MS Word 2007 and 2003 installed on your computer, you might have experienced that Word 2007 takes a bit longer time to open. This is because Word 2007 has to auto-register itself on that particular computer. Well, you can increase its launching speed by skipping the so-called auto-registration process. However, you must be careful while doing this, as it may cause Word functioning incorrectly. In this regard, you need to follow the steps discussed underneath:

Tip: By following these steps, you can certainly skip the auto-registration process. However, any glitch during this task may cause failure of registry. Thus, make sure you back up the registry before initiating the steps to modify it.

  • With MS Word Exited, click Start menu and type regedit in the Search box, and then hit the Enter key.
    • (In Windows XP, click Start menu > Run window and proceed.)
  • Type administrator password if you are prompted.
  • In the folder than opens, locate the following registry sub key:
    • “HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Options”
  • With the registry sub key selected, point to Edit > New > DWORD Value
  • Type NoReReg and hit the Enter key.
  • Now, right click NoReReg and choose Modify.
  • Type 1 in the Value Data box and click OK.
  • Go to File menu and select Exit to end up registry editing.

Windows Installer Message in MS Word
Windows Installer starts automatically when you run MS Word 2007, in case of multiple versions of MS Word are installed on your computer. Besides, a message, stating Windows Installer is preparing also appears before Word 2007 is launched. If you click Cancel, the installer is exited, and Word starts.
Do you know why Windows Installer appears? Well, it appears when the version of Word you launch is not the registered one.
READ MORE - Things you Need to be Careful about while Installing Multiple Versions of MS Word on a Single Computer

Friday, February 14, 2014

Conditional Formatting in Excel: How to Change the Background Color of Cells Based on Values in the Cell

Conditional formatting in MS Excel allows you to apply different formatting options on one cell or more cells with certain specified conditions. It is very helpful to identify the differences in a wide range of values at a glance. This feature in Excel gives you the ability to color rows, hide duplicate, hide errors and highlight items.

This article explains that how you can change the background color of cells according to their values.

Example: You have a spreadsheet of average marks obtained by students in a exam and you want to figure out overall performance quickly, then you can color each cell of average marks according to cell's value. It is the easiest way to see at a glance relevant marks.

I am just taking few names of students and their marks in particular subjects randomly.

In above example Overall Average is the average marks of students in their exam and you want to color background of these cells on the basis of their marks. So that you can easily figure out who is failed, who has got good grade and who has got excellent grade.

I will color each cell's background of Overall Average marks depending on a scale. Let me decide the scale...

  • If a student has scored average marks between 0 and 40 then he/she is failed and color will be Red.
  • If a student has scored average marks between 40 and 60 then color will be Blue and it is average grade.
  • If a student has scored average marks between 60 and 80 then color will be Yellow and it is good grade.
  • If a student has scored average marks between 80 and 100 then color will be Green and it is excellent grade.

You can choose colors according to your benchmark. I have chosen it randomly to make the differences between each range of overall average marks.

To do this, follow these steps:

1. Select all the cell that you want to apply this formatting; I have selected B8 to G8.
Select > B8 to G8

2. Now go at the top of screen and select Home tab. Now click Conditional Formatting on the ribbon and select Manage Rules.
Home > Conditional Formatting > Manage Rules

3. Now you will see the pop window of Conditional Formatting Rules Manager.
4. Now click on New Rule to set color of cells red for marks between 0 and 40.
Conditional Formatting Rules Manager > New Rule

5. Now you will see New Formatting Rule window. In the pop-up window of Select Rule Type section, choose the second one “Format only cells that contain”.
New Formatting Rule > Select Rule Type > Format only cells that contain

6. In Edit the Rule Description section select Cell Value in first drop down box, between in second drop down box, type 0 in third drop down box and 40 in the last drop down box.
Format only cells with: > Cell Value > between > 0 > 40

7. Now click on Format and you will see a pop-up window of Format Cells.

8. Now click on Fill tab and choose the red color from the drop-down menu of Color section and click on OK.
Format Cells > Fill > Color > Red > OK

When you will click on OK in previous step then you get return back to New Formatting Rule window and preview box of Format will shows color red. Now click on OK.

10. Now you will get back return to Conditional Formatting Rules Manager window.

11. You are done with first rule, if Cell value is between 0 and 40 then
color will be Red.
12. Now click on New Rule and make second rule of cell value between 40 and 60 (color will be blue). To do these just follow all methods that you had done before. When you are done with second rule then Conditional Formatting Rules Manager window will look like this.

13. Now do the same thing to set your rest of the rules. When you are done with all your rules then Conditional Formatting Rules Manager window will look like this.

14. Click on OK and your Overall Averages cell will look like this.
In above sheet you can easily figure out who has failed (red color) and who has scored good grade (green color) at a glance. These steps are applicable on MS Excel 2007 and 2010.
READ MORE - Conditional Formatting in Excel: How to Change the Background Color of Cells Based on Values in the Cell
Related Posts Plugin for WordPress, Blogger...