Question about Microsoft Office Excel 2003 for PC

2 Answers

Excel oquestion how to find the no of employees born in different months using functions in excel?

Posted by on

  • lakshman_bbm Feb 19, 2009

    how to remove the excel security password

×

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 67 Answers

There are some password unlock programs but there is another way to do it. On the excel sheet you can't edit certain cells if it is protected. What you need to do is open the protected sheet, go to edit on the menu bar and select all. Then open a new excel worksheet and go to edit again and paste it. Now you have the same exact sheet without the password protection. All you need to do is adjust the visual aspect of the sheet.

Posted on Feb 20, 2009

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

How to remove the excel file security pass word


solution explain tel plz

Posted on Feb 19, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

What is the function of Microsoft excel?


Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

I want an formula in excel to find out number of days present per month an perticular worker


Hello this is Baris,
Can you tell me more about this employee. Are you creating an excel spreadsheet to keep record of his days. Are you just getting the numbers from an outside source like a schedule.

To be able to give you an answer I will assume that you have the info already in the same spreadsheet.

Lets say Column A is the days of the month.
Column B is the information column like the hours that the employee worked. If the month has 31 days this is what you need to do.
Click on the cell B32 and type the formula
=count(B1:B31) and press enter. This will count the number off cells which have a value in it in that month.

If you provide me more info we may come up with a better solution. Hope this helps :)

Sep 24, 2009 | Microsoft Excel for PC

1 Answer

How to sende information from a sheet to another?


You can link to the original sheet or copy and paste - Linking might be easier as you only have 10. - Can you not use worksheets rather than excel. If you want to make it more autonomous you can index or look up the first sheet so any changes you make will be reflected back in your employee sheets.

May 26, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

How to calculate the difference of two dates by year, month and day using the formula in excel?


To calculate the difference in Years use =Year(c,r)-Year(c,r)
To calculate the difference in Months use =Month(c,r)-Month(c,r)
To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates

Mar 15, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

I have a year planner in excel in which first row consist of month jan,feb.... and in the second row days are there like 1, 2,3..... and on the very first column name of employees is there so my task is to...


There is always multiple solutions, but here is one...

Add a row (that can be hidden later if you want) where you have the full date (01/01/09). For this example it will be row "C." Then use Conditional Formatting with the function:

=weekday(C$2,2)>5.

See if this helps.

Jan 03, 2009 | Microsoft Excel for PC

1 Answer

Highlight weekend in the year planner


The easiest way of doing this is by inserting another row with Days
Can be MTWT etc, and you can set conditional formatting for any cell beginning with "S" into a colour/ variation of your choice.

Jan 03, 2009 | Microsoft Excel for PC

1 Answer

To highligh weekend in the year planner


The easiest way of doing this is by inserting another row with Days
Can be MTWT etc, and you can set conditional formatting for any cell beginning with "S" into a colour/ variation of your choice.

Jan 03, 2009 | Microsoft Excel for PC

1 Answer

Formula for Date


Make that column fixed and give the variable date and value 26/Month of year/year

That is the logic Can you do that

Fixya?

Mar 21, 2008 | Microsoft Excel for PC

1 Answer

Functions


The eomoth function returns the last day of the month.
Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

eomonth (1/2/08, 1) will return 31. The number of days in the month.

eomonth (1/2/08, 2) will return 59, The number of days in the month plus the next month (February)

Mar 06, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Excel 2003 for PC Logo

145 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...