How To Define a name in Microsoft Excel, How to check the spellings and Use of Format Printer

3 Steps to make your excel reporting work easy, faster, effective, and error-free.

A lot of functions over Microsoft Excel make your work easy fast and interesting. We are covering three functions step-wise. The given below three functions are very useful and almost all excel users can use these functions on daily basis. Follow the steps one by one and feel how easy steps can make your work fast and interesting.

A - Define the name of your table

B - F7 for spelling check

C - Format Printer

Follow The Three Steps .....

Step - 1

A - Define A Name Of Your Table Or Data

Explanation:

“Define a name of your table or data” means you can assign a name of your data. Let suppose every day we use excel and make difficult reports using formulas VLookup, Hlookup, Sum etc. A lot of formulas in excel where we select data to get the correct output. in order to make your work easy and fast we can assign a name of all data. After assigning a name we don't need to select any data and table. Instead of data we can write a assigned name and done it faster. For more clarification you can see the below examples :

Example :

=VLOOKUP(C3,C3:E10,2,0

=HLOOKUP(C3,A1:E120,2,0

=SUM(A1:E10)

Always we required data for reporting purpose. All above examples need data or a data range. But we can make it easy by assigned a name of the table. Like C3:E10 we can assigned a name suppose ABCD.  The below table can provide the clear picture about how to assign a name of your table.

Now we can see the red highlighted field changes. In the first figure the data table is normal without any name, but in second figure it shows ABCD, we have assigned a name of out data table and we can use it as required. You can assign any name as you like After assigned a name we don't need to to select any table, instead of your data range you can write this name to get the output faster. Now see the example below.

Example : 1-A

=SUM(ABCD)

Once you assigned the name of your table you don't need to select any data or data range, your new data range will be assigned name.

Suggestion: In order to get batter understanding you must prepare the same table and use the same formula and practices again and again to make you doubt clear.

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

Step - 2

B - F7 for spelling check

F7 is a key on your keyboard. During work with excel sheet all users want to check the spelling to make report correct. The easiest way to check spellings we can press only F7 function key from the keyboards. You don't need to select any data, only press F7, the system will start automatically to check all spellings. You will get two option "Ignore" or "Change" if you have any mistake in your data.

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

 Step - 2

 C - Format Printer

Format printer is another very important function of excel. If you know how to work this small icon you can make your work easy and faster. Format printer main work is to provide formatting.

Let suppose we have a table with proper formatting and we want to make it a new table. With the help of format printer we can provide the same formatting (same text, color combination of text, same font size, same back ground).

Follow the path >> First select the already design table>>> go to Home >>>> Click Format Printer Red highlighted in the given below picture >>>> leave the cursor where you want to apply the format.

Short cut key: Alt + H + F + P

My recommendation to follow the steps and make your doubt clear.

Please comment for more excel query or any suggestions.
Thanks for your time...