Question about Microsoft Excel for PC

1 Answer

Excel Database Hi friends, I am actually preparing to purchase a Point of Sale System but I've just finished entering all my stock barcodes, with the unit cost, selling price, mark up percentage etc etc.. Now i'm going to validate that all my data entry is correct. Is there any way to fast query my database and see in a form format that the price and description is correct for the barcode that is being scanned. I tried using the ctrl find but it seems very troublesome. anyone know of any short cuts that enables a more clear presentation. I tried using Data form and den clicking on criteria, but if i accidentally changed the data, it instantly changes it. would anyone be able to advise a better method to check all e prices?

Posted by on

1 Answer

  • 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

I would suggest to protect the sheet first off all. Make sure you write your password down so you won't lose it. Second, try to sort your data A-->Z it'll make your job much easier.

Posted on Feb 21, 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:

1 Answer

What software can I purchase so I may make barcodes with a Voyager Honeywell scanner.


Microsoft Excel can print bar-code labels. I did this for my office for our stock room and they work with every bar-code reader I've used so far.

Apr 22, 2011 | Honeywell MS9540 Voyager Hand Held Scanner...

Tip

How to REFUND, VOID, ERROR CORRECT on a cash register


Most cash registers are similar in operation when it comes to removing items from a sale (or after one).


ERROR CORRECT, or ERR CORR, or EC will remove the last product you entered during a sale. You simply press it straight after the item button to reverse that item back into stock.


VOID (infinity symbol on Sharp), or VD is used to remove any item from a sale e.g if you have entered four items in a sale, you can remove the first item by pressing VOID, then the item button.


REFUND, or RF, or RFND is your friend. It can be used to reverse any item at any time during, or after a sale. Just press REFUND then the item to reverse it back into stock. Then finish with a payment type e.g CASH if you are refunding cash back to the customer.

-------------------------------------------------------------------------------------------------------------------------- Need a cash register manual?
Sharp, Casio, JCM, Samsung, Sam4s, Olivetti, Royal, Omron, Sanyo, Towa, Geller, Uniwell, Javelin

Available here:
http://the-checkout-tech.com/cashregisters.php

on May 19, 2010 | Computers & Internet

1 Answer

Hi. By the grace of Almighty it is hoped that you and your family members would be in good health. I need a link to download a multiple sheets Excel Workbook to manage our daily sale, inventory and...


Here are your links Sales
http://www.brothersoft.com/sales-management-report-spreadsheets-for-excel-366701.html
Inventory
http://www.brothersoft.com/downloads/inventory-spreadsheet.html
Purchase
http://www.spreadsheet123.com/ExcelTemplates/purchase-order-template.html

Jun 26, 2010 | Microsoft Office Excel 2003 for PC

3 Answers

Export the data from excel to tally


  1. make a sale entry in tally
  2. Export the voucher from tally in xml format (this is to give u how the xml looks)
  3. Open the excel file where all the data is ther.
  4. open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility
  5. in the XML which we did in step two, copy the data from "<TALLYMESSAGE xmlns:UDF="TallyUDF">" till the </TALLYMESSAGE>
  6. Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher.
  7. create the mail merge.
  8. copy the data what you got in word file to a note pad and name it as sample.
  9. open again the step 2 - copy data from " <ENVELOPE> to <REQUESTDATA>" and paste in the begining of the notepad sample
  10. go the end of the notepad sample and copy the data from first file -"step 2" from " </REQUESTDATA> to </ENVELOPE>" and save the file
  11. Open tally
  12. go to import vocuhers
  13. specify the path of the notepad sample and yes ur data got imported.

Apr 21, 2010 | Microsoft Windows XP Professional

1 Answer

Scanning is extremly slow


What interface? If it is a USB interface the scanner sends the numbers the same as if you had entered them on the keyboard. If you do just enter the barcode (need to know format actually sent to application) numbers does it also respond slow?
Plug the scanner into another PC/laptop, open notepad and scan a barcode, does it scan fast?
The POS application, if it is windows, open notepad and scan the barcode, does it scan faster.
It is likely the POS application that is responding slow.

For the POS applicaton:
- Is scan database local or on the network.
- Have you maintained the scan database? Re-index, compacting, etc

Apr 13, 2010 | HHP 3800g Handheld Barcode Scanner

1 Answer

STOCK REGISTER


Ur answer is simple.
Just keep a common database on internet for all stores & create website (ASP or PHP) or web based application(like Vb.Net or VB) much preferred.
.
so any sales occurs, it would be reflected across all stores,
so you can calculate total sales & remaining stock any any time and sort it or aggregiate it daily, weekly & montly..

Nov 27, 2008 | Computers & Internet

2 Answers

Move to next cell in excel


In Excel 2003 Offline help, i see this helpful note:

Change which cell is selected next When you press ENTER to finish working in a cell, Microsoft Excel moves you to an adjacent cell or leaves you in the current cell.
  1. On the Tools menu, click Options, and then click the Edit tab.
  2. To move to an adjacent cell, select the Move selection after Enter check box, and then select a direction in the Direction box. To stay in the current cell, clear the check box
for our Symbol scanner we are using this apparently is not working, but it might for you!

Nov 14, 2008 | Symbol LS2208 Handheld

1 Answer

DOS Programme to txt file


Assuming that you are not able to export the data from the
original point of sale application, which is obviously the
best choice...

1)
Try to open the file(s) with Microsoft Excel (make sure that all of Excel's input conversion filters have been installed and enabled).

Most database files are organized as a set of (nested)
two dimensional data tables, which can be individually
imported into Excel as spread sheets.

Excel is very good at detecting and converting database tables.
Other spread sheets such as Lotus 123, or Quatro pro may also
be able to do this.

2) Microsoft Access may also be capable of importing
and converting the entire database.

3) Heavy duty data-base modeling suites, such as ER-Win
by Computer Associates (CA) may also be able to import
and export the database.

4) If the files are in the open *.dbf format, then I have the binary
file specifications, which can be used to decipher the files.

5) The files may also be simple tables, which are TAB, SPACE,
or COMMA (etc.) delimited, and you should be able to recover
these with a simple notepad editor or uuedit.

6) Most DOS programs (not all) can also be run under Windows
XP, using the command prompt:

START ==> All programs ==> Accessories ==>
Command Prompt.

========================================
Most importantly, we need to know the name of the application
that created the files, or see a sample of the file, to give you
further advice.

Martin

May 07, 2008 | Computers & Internet

5 Answers

Excel


If you don't have MS Office, then you will have to purchase either the Excel component as a stand alone but you would be better off with the whole MSOffice as it contains your Word processor, Database, Excel, Powerpoint presentation software and in the 2003 version also Publisher.

It is not too badly priced anymore, but if you cant afford it then you may be able to borrow a copy whilst you are doing your course from a friend, but you will have to uninstall it afterwards.

Oct 26, 2007 | Excel (SS8SATAS5128400R)

1 Answer

Enter function


Hi Lee,

 

It can be done by programming the scanning the 'Send Enter Key' barcode twice, from the owners manual.

 

eg

 

Scan the barcodes -

 

Send All Data, Send Enter Key, Send Enter Key, Save

 

Oct 17, 2007 | Symbol LS 4278 Barcode Scanner

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

56 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18375 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...