-

-

Riya :

I have problem that I cannot remove the color in a cell in

a excel workbook even if I have given the Fill color

option as no color. So Please help me….

Reyleon :

The color in the cell was effecting due to the conditional

formatting and it is not due to the Fill color Option . So

you can just go through the following process

-

Hey john please help me, In my excel I cannot able to drag the Print

area pointers and cannot drag the formulas from one cells to other

cells . So it took me so much time to finish the simple tasks . Please

do something to use my time properly

John it is happening due to the option what you deactivated while

using the excel

Ok, now I will show you how to activate it so that you can use the

formula drag option

Just follow the procedure…………………

Thank You so much Reyleon….. Its Working……..

-

Paul :

Reyleon :

Paul :

Reyleon :

1. Go to Insert Tab.

2. Click Hyperlink Option – One dialog box will open.

3. For the documents in excel use the option “ Place in this

Document and select the document”. 4. For the documents outside the work book or excel you can use

the option “ Look in” where you can give the address of the file

which you want to be linked.

-

-

Yes I got the workings thanks but can you tell me another way so that I can protect my excel workbook with a password to allow only authorized access

The excel workbook can be protected for the encryption of data, if you activated the encryption password in your excel workings, No user can open your excel workbook without that password But we should be careful that if we forget the password we will not be able to recover the data from the excel workbook So lets see how to activate the option

Now your Excel workbook will be encrypted and every user requires password to open the excel workbook One more benefit by learning this option is that same procedure can be used for micro soft access, word and powerpoint.

Thanks for the information……. Reyleon……….

-

Fedrick :

Hai Reyleon

I want to know how to avoid formatting options for

particular cells in excel workbook, I want to give access

to users only for particular necessary cells and should

denied the access for the unnecessary cells

Is there any option like that in excel so that we can give

access only to the right people at the right place.

Reyleon :

Yes that option is available, we can use the protect sheet

option to give access to some extent in a excel workbook

to a particular user with a password protection

Now come lets understand the procedure for the

protection of excel workbook

We will split the procedure in two phases for the purpose

of convenience

Phase – 1

1. Go to the work sheet which we want to be protected and select all the

cells in the work sheet

2. Give a right click on the sheet then select the “Format Cells “ Option then one dialog box will get open which shows different tabs like

Number, Alignment, Font etc ….

3. Select the Protection tab and uncheck the Locked and Hidden options

4. Now select cells which we wanted to be protected and give right click

and select format cells option and go to the protection tab and check

the Locked and Hidden Options

5. One phase of the procedure completed, Up to now there will be no

impact on the excel worksheet, what we are going to do in the next

phase is the important thing which will help us to satisfy our requirement.

Phase – 2

1. Go to the Review Tab and select Protect sheet option and dialog box will

be opened

2. Check the “Protect worksheet and contents of locked cells” option

3. After that in “Allow all users of this worksheet to” option check the Select Unlocked cells and format cells option

4. In this list, We can find some other options also, which we can use for the

different purposes, but please try on your own for gaining knowledge .

Fedrick: Now I think I can provide restricted access to my users of my

data sheet

Thanks for the favour Reyleon

Reyleon: Ok no problem if any other things wants to know I will be

always ready to help you

-

Samuel :

Hai reyleon can you please help me how to use add ins in the excel workbook for the purpose of analysis like Regression Analysis, equation solving etc

Reyleon :

Yes I will help you to know how to activate the ADD

INS Options in excel so that you can use the analysis tools

for the purpose of analysis

Just follow the below mentioned procedure………….

Procedure :

-

Rock :

Hai Reyleon I wanted to know how to use pivot table and V lookup

options in excel, Please help me to use those options available in Excel

Reyleon:

Yes I will tell you the easy way to use those options so that you will

feel it is very easy

Earlier we will be using traditional tables formats and sorting formats

for the analysis of the data

But now we have one option called pivot table which can be used for

the purpose of data analysis in different patterns

There are many advantages for pivot table but the very good advantage

of pivot table is one single data can be viewed in different ways which

gives inter relationship among different figures in the data

For example Region wise sales along with employee wise details can

be reported in one Pivot Table along with sold stock details

Once if you understand how to insert the Pivot table you will

definitely understand how to use Pivot table in different ways

Rock :

Ooh then please let me know the procedure to insert the Pivot

Table

Reyleon :

Its very easy Rock just follow the below procedure

1. First select the data which we want to be use as source of the pivot table

2. The format of the Source data table is very important because the generation of different types of pivot tables will depend on the Source data table only

3. Then go to the Insert Tab and select the Pivot table option and in that once again select the Pivot table option

4. Now Create pivot table dialog box will be opened, Now we should check the select a table or range and give reference of source of data table as table/Range

5. Now we can place the pivot table in the same work sheet or different work sheet, it will be helpful if we create pivot table in separate work sheet so select the New worksheet option and Click OK

6. Now we will get the Pivot table in new sheet and two

new tabs will be added at the top of the excel worksheets as “Options” and “Design”

7. On the right side of the new worksheet we will get one

table as “PIVOT TABLE FIELD LIST” for the selection of different options as columns and rows of tables.

Now we have finished the procedure of how to insert

Pivot table, Is this ok for you Rock

Rock :

Its so good to know about the Pivot table it will reduce my working

time to great extent but can you please explain me about that Pivot

table field list so that I will get more clear idea about options to be

used in the pivot table

Reyleon:

Yes of course

Now if you see that Pivot table field list it will consists of different

fields which needs to be selected as columns and rows of the table

For the purpose of field selection we need to drag the fields to the

below available one of the four options which are

Report filter – Which can be used as advanced filter for the data

analysis

Column Labels – Which will become as columns of the pivot table

Row Labels – Which will become as Rows of the pivot table

Values – Which are calculation part & Numerical part of the pivot

table, it can projected as Sum, Average, Count etc through value field

settings option.

Rock :

Thanks for the valuable Information Reyleon

This pivot table option in Excel will be helpful for my future data analysis

which will reduce my time for preparation of reports so that I can invest

that time in analyzing those reports

Reyleon :

OK but you should know two things while using the Pivot table

1. For the source data table , Each and every column needs to be labeled

with different names – Otherwise we cannot insert pivot table – So be

careful while preparing the source table

2. Selection of data from the source data table needs to be made properly

– Otherwise we will end up with analyzing wrong data or incomplete data.

So I think you will get good experience with Pivot table option in excel and

if you need any other help please don’t hesitate to contact me

Rock :

Definitely

Thank you So much……………………….

-

Hai reyleon can you please tell me how to activate the

grid lines in Excel workbook because I am not able to

work without gridlines in excel and I am not able to

activate the gridlines in my excel worksheet

Its very simple Adam

Go to the View Tab and check the Gridlines Option

which will be visible in the view tab so that you can

activate the gridlines in your excel worksheet

Thanks for the Information

I need one more help from you

Please tell me I will help you

I was frustrated by seeing the same background color

for the excel work sheet from 3 years so I want to

know whether any option available so that I can change the background color of excel

Yes of course we can do that

Click the office button on the left side of the

worksheet and select the Excel options. Then one

dialog box will be opened, so select the “Popular” option in the left side list and you will find “color Scheme” option and you can change the color as

Blue, Black & Sliver with the help drop down list

option

But good color will be Blue color so please try to use

the Blue color as the standard color for all the Microsoft Software

Thank you so much for the information

OK ………….. No problem…………….. Please call

me…………… When you want any help regarding the

Excel……….

THANK YOU FOR YOUR VALUABLE

TIME