Question about Microsoft Excel for PC

1 Answer

Exel Hi I want to set up a stock control spread sheet for stock on hand, and be able to add goods recieved and minus goods taken. For the goods taken and goods recieved i would like to be able to enter them each time in the same cells and have it add or take away from the stock on hand and then reset so i can put the next value in the same cell. I also would like to have the stock taken linked to certian projects and it be able to do a count and report eeach year so i know what goes out and to which project. Am i expecting too much ? thank you

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 2,794 Answers

That might be too much for a spreadsheet to do. It's easy to set one up to show what you have on hand and what you took out. The links to certain projects, I would need more details about.

A better way to do it is to use Quickbooks. That way you have a history of who purchased a particular item as well as when you replenished it. Then you can generate a spreadsheet from Quickbooks as well. You can have your invoicing, receivables, and payables as well in one program.

Posted on Nov 08, 2008

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:

1 Answer

How do I add more inventory in restaurant pro express


In the OPTIONS screen, click ADMINISTRATIVE, then INVENTORY MAINTENANCE. After looking up the item you wish to change, click the INSTANT PO button in the lower right corner. Enter a description such as "INV ADJ" and hit ENTER. Enter amount of adjustment, not amount in stock. If you need to deduct, enter amount of deduction followed by the minus sign (-) then ENTER. Your IN STOCK amount should update immediately.
sysadmin@ccybernet.com
Feel free to email me with more details if need be.

May 12, 2014 | Pc America Restaurant Pro Express

1 Answer

How i can use polish in exel 2003


Hi,
If you you using XP: 1) click Start menu,-> All Programs-> Microsoft Office->Microsoft Office Tools->Microsoft Office 2003 Language Settings. 2) Select Polish in available language and click Add. 3) Under the choose the language that defines default behavior in Mircrosoft Office applications,choose Polish.

Feb 10, 2011 | Microsoft Office Excel 2003 for PC

1 Answer

HOW TO TRANSFER TALLY ACCOUNTS DATA TO EXEL SHEET


HI,

Please follow below step

Step 1. Open Tally

Step 2. Open Report Which is you want Transfer in Excel.

Step 3. Press CTRL With E (Ctrl+e) from keyboad

Step 4. Select Sharped Sheet or Excel

Step 5. After type location for file save like this D:/your folder name/

Step 6. After You type file name with xls. like this sales.xls

thanking you

davevipul197

Dec 19, 2010 | Computers & Internet

2 Answers

Exel files slowly open


Hi Sahil,

This can be difficult to resolve on the first pass because there is so many things to consider. I have no idea what your experience with excel or computer maintenance is. All my training in industry has told me is go for the "low hanging fruit" first (try the easiest stuff first).
1) When did you last defrag your computer. That can be a fast easy fix. I don't know what your operating system is but you may have a defrag program included as part of the system.
2) How much memory do you have installed and if you have added some did it match what you had installed because memory will run as fast as the slowest stick installed.
3) Any other programs running in the background? My antivirous program is scheduled to scann at specific times when I would normally not be trying to be productive with my favorite programs. I have all the memory installed that I can and if my antivirous program is running and I try to do something else my system tempts me to persue fishing instead of computing just so I could use my machine as a anchor.
4) Do you have an infection of malware to contend with? When has the last time been that you scanned your system for system leaches.
5) was there a specific time that the software slowed down and if so what was done to the system at that time. Can it be undone?
6) Are you the only person on the machine?
7) Just how slow is slow? My machine takes 2 sec to load excel - 5 sec to load a spread sheet that I have been collecting data on stocks for 3 years but is a rocket processing the data and developing the individual graphs that is responding to the macros commands.
So is your expectations of the program realistic?
Investigate your issue and try to reason out what could be going on. Collect more data about your system so I can better guess from wayover here.
Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}
Evenif this is not what you wanted to hear please don't forget to rate the answer. I can always learn from your opinion of the service provided.
Thanks
Glad to be of assistance


Oct 21, 2008 | Microsoft Excel for PC

2 Answers

LOOK UP AND ALLOCATE


Hi,
Could you write the column names from both the sheets seprately, and one data eg. that you need. It would be easier to understand the problem.


Thanks
Proton

Oct 17, 2008 | Microsoft Excel for PC

1 Answer

Need a formula for excel


select CONDITIONAL FORMATING in Format

select FORMULA IS , CELL VALUE = > < (condition)

after this select Format

font style , COLOR

SEE IT WILL WORK CHANGE OF COLOURS ........

Oct 10, 2008 | Microsoft Excel for PC

1 Answer

Regarding exel problem


hi

first try to remove .
go to conrol panel , add remove program then remove your office ...... then install again.

Mar 21, 2008 | Microsoft Excel for PC

2 Answers

Problem with columns


In Excel 03, I went to Help, typed in "column" and they had a "add or delete columns" topic. Did seem to answer your question. Very modestly submitted. I ain't no expert, just nosy.

Jan 26, 2008 | Microsoft Excel for PC

1 Answer

Exel 2003


You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (!) to the cell reference. In the following example, the AVERAGE worksheet function calculates the average value for the range C1:C10 on the worksheet named Marketing in the same workbook.

default.aspx?assetid=za010939481033 Refers to the worksheet named Marketing default.aspx?assetid=za010939491033 Refers to the range of cells between C1 and C10, inclusively
  1. Click the cell in which you want to enter the formula.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) default.aspx?assetid=za060515351033, type = (equal sign).
  3. Click the tab for the worksheet to be referenced.
  4. Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

5 Answers

Formula required


at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

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

Related Topics:

68 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18330 Answers

Prashant M
Prashant M

Level 3 Expert

2259 Answers

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

Answer questions

Manuals & User Guides

Loading...