Categories
How To Guides

Getting started with Google Drive

For using the Google Drive you are required to have a Google Account. Making an account in Google is absolutely free and signing up is very easy and simple. For creating a Google account you are required to enter some information which includes name, brith place and your location. By creating a Google account, your Gmail email address and Google+ profile will automatically be created.

Creating a Google Account:

  • For creating a Google account you need to go to www.google.com. Now you need to locate and select Sign in button in the top right corner of the page.
  • Now you need to click on Create an account.
  • After this a sign-up form will appear. You need to follow the directions and enter the required information.
  • Now you are required to enter your phone number. Google will send verification code to your phone that you will use complete sign up process.
  • Now you need to enter the verification code which is sent to your phone and then click Verify.
  • Now a personal information page will appear. You are required to follow the irections and enter your information which includes your birth date and gender.
  • Now review the Google’s Terms of Service and Privacy Policy and then click I agree.
  • Now you account has been created.

Accessing Google Drive:

Once you have set up your Google account, you can access Google Drive by going to http://drive.google.com in your web browser.

You can also access Google Drive from any Google page by selecting grid icon near the top right corner and after that clicking Drive.

Google Drive interface

Your Google Drive will be empty at the start but as you begin to upload and create the files you will require to know how to view, manage as well as organize them in the interface.

Categories
How To Guides

Introduction to Formulas in MS Excel

In MS Excel one of the most powerful features is the ability to calculate numerical information by using formulas. Excel is capable of adding, subtracting, multiplying and dividing operations. In this tutorial we will learn how to use cell references to create simple formulas.

Mathematical operators:

MS Excel uses the standard operators for the formulas asterick (*) for multiplication, forward slash (/) for division, plus sign (+)for addition, minus sign (-) for subtraction and caret (^) for exponents. All of the excel formulas are required to begin with an equals sign (=).

Cell References:

usually numbers are used for creating an Excel formulas like =2+2 or =4*4. But you can also use cell addresses for creating a formula. This is called making a cell reference. Using the cell reference will ensure that your formulas are accurate because you can modify the value of referenced cells without rewriting the formula.

Creating a Formula:

For creating a formula follow these simple steps.

  • First of all you need to select the cell that will contain the formula.
  • Now type the equals sign (=). Notice how it is shown in both the cell and formula bar.
  • Now type the cell address of the ceel you need to reference first in the formula. You will notice that a blue border will appear around the referenced cell.
  • Type the mathematical operator you need to use.
  • Now type the cell address of the cell you need to reference second in the formula. A red border will appear around the referenced cell.
  • Now press Enter on your keyboard and the formula will be calculated and the value will be displayed in the cell.
Categories
Photoshop

Using The Clone Stamp Tool in Adobe Photoshop

Adobe Photoshop is a handy and most widely used image editing application which will let you add some amazing and breathtaking effects. One of the most amazing tools which are included in Adobe Photoshop is Clone Stamp Tool. The Clone Stamp Tool is used for pixel to pixel cloning in Photoshop. This tool is different from Healing Brush Tool as it will not blend the target area automatically. The Clone Stamp Tool can also be used for removing any portion from the image.You can also learn about How to Rasterize Text on Photoshop. In order to use Clone Stamp Tool you need to follow these steps.

  • 1st of all you need to select Clone Stamp Tool and after that you are required to position the cursor over the area which you need to clone.
  • Now in the next step you are required to press Alt key for defining the clone source.
  • Now you need to position the cursor over the area where you are required to paint the cloned pixel and after this you need to start painting.
  • When you will be painting you will notice that a cross hair follows the pixels which you are cloning.
  • Now you need to select Window>Clone Source for opening the Clone Source panel. This little panel will allow you to save multiple clone sources for referring to while you are working.
  • You can also scale, preview and rotate the clone source.
  • In order to work with the Clone Source interactive panel you are required to follow these steps.
  • If the Clone Source Panel is hidden you can select Window>Clone Source.
  • Alt-Click on the image for recording the 1st clone source.
  • Click on the 2nd Clone Source icon from the top of the Clone Source panel.
  • Alt-Click on the page for defining the 2nd clone source.
  • Now you need to enter any numbers which you want in Offset X & Y, W & H.
  • Now select the Show Overlay check box to see a preview of the clone source.