Print in Excel/How to Print in Excel 2010/

Print in Excel

How to Print in Excel 2010

We will teach you how to print in Excel 2010 as below

Option 1 : You can also press CTRL+P.

Option 2 : The steps as below

Steps 1 : Open your database in Excel, Select the sheet you want to work with

Steps 2 : On The File tab, Click Print

Example :

How to use the VLOOKUP Function with Example in excel 2010

How to use the Vlookup in excel  2010, Please follow as below

·         Vlookup(lookup_value, table_array,col_index_num, [range_lookup])

-          Value : The value to search for in the first column of the table

-          Table : Two or more columns of data that is sorted in ascending order.

-          Index number : The column number in table from which the matching value must be returned . The first column is 1

-          Approximate match : Optional . Enter False to find an excat match. Enter TRUE to find an approximate match

If this parameter is omitted, TRUE is the default

This is example :

                               

      Example 1 : You want to find  “Quantity” with ID “004”

                 =VLOOKUP(C2,$B$6:$F$10,4,0)

Example 2 : You want to find  “Total cost” with ID “004”

             =VLOOKUP(C2,$B$6:$F$10,5,0)

Remove duplicate excel 2010

Remove duplicate excel 2010

How to remove duplicate in excel 2010. Please follow the steps as follow

Steps 1 : Open your database in Excel, Select the sheet you want to work with

Steps 2 : Select the data that you want to check for duplicates

Steps  3 : On the Data tab. Click Remove Duplicates

Steps 4 : Leave all check boxes checked and click OK

Translate Worksheet in Excel 2010

Translate Worksheet in Excel 2010

How to translate worksheet in Excel 2010, Please follow the steps as below :

In Ms Excel 2010 you can quickly translate cell into different language

Steps 1 : Select the conten wich you want to translate to a different language

Steps 2 : Choose Review tab --> translation

Steps 3 :  It will open the  pane from wich you can select the language to which you need to translate

Steps 4 : Click on Insert to apply translation changes

Email Workbooks MS Excel 2010/ Excel 2010 Sending a worksheet as an e-mail attachment

How to send a email workbooks to anyone in Ms Excel 2010.

We  will teach you by steps as below :

Steps 1 : Start the Microsoft Excel 2010

Steps 2 : Open the file you would like to send

 Steps 3 : Choose File --> Save and Send

It saves the document first and then emails

Steps 4 : Click on Send using E-mail . Ms Outlook will open with the file as attachment in the New Email Window.

Now you can send  mail to anyone with valid email address

Thanks you

How to change the Size of cells in Excel 2010,2013

How to change the Size of cells in Excel 2010,2013

Change the Size in a cell in Excel 2010,2013

This lesson we teach you how to change the Size in a cell in Excel 2010

Please Follow the steps as below :

Steps 1 : select the text that you wish to change the Size for

Steps 2 : Select the Home tab in the toolbar at the top of the screen and click the Size that you want to use.

In this example, we are choosing “14” as the new Size for the cell.

Change the font in a cell in Excel 2010

Change the font in a cell in Excel 2010

MS Excel 2010 : Change the font in a cell 

This lesson we teach you how to change the font in a cell in Excel 2010

Please Follow the steps as below :

Steps 1 : select the text that you wish to change the font for

Steps 2 : Select the Home tab in the toolbar at the top of the screen and click the font that you want to use.

In this example, we are choosing Times New Roman as the new font for the cell.

Thank you !